I'm pretty new to web development. I've created a SQL Database and Website in Visual Studio. On my server I created a virtual directory and copied all the files for my website to the location that the virtual directory points to. I set the Directory to utilize ASP2 under the ASP tab.
What permissions do I need to set?
For SQL I enabled TCP/IP, Named Pipes, and Shared Memory. I attached the database via SQL Management Studio. I created a user for my database called testuser. I selected all role members.
Which role members must I have selected? Where do I set the users password?
Anyways to continue, I try to open the site and get:
Cannot open database "DADATABASE" requested by the login. The login failed. Login failed for user 'testuser'.
I modified the Visual Studio default connection string to: <add name="ConnectionString" connectionString="Data Source=127.0.0.1;Database=DADATABAS ...
Go to the complete details ...