I have a new website that I need help with what I think are permissions. I receive this error when my remote app tries to access the database.
System.Data.SqlClient.SqlException (0x80131904): CREATE DATABASE permission denied in database ‘master’. Cannot attach the file ‘C:\\inetpub\\wwwroot\\App_Data\\aspnetdb.mdf’ as database ‘aspnetdb.mdf’.
The database is the typical aspnetdb.
The login passes Membership.ValidateUser(Username, Password) but not when the following is called. The open command gives me the error.
connectionString = “data source=WINDOWSSPELL\SQLEXPRESS;Integrated Security=true;AttachDBFilename = |DataDirectory|aspnetdb.mdf”;
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
(the above string is escaped)
I only want people that are VERY experience with SQL/IIS and Server 2008 R2. You will be required to login to my desktop to access my Remote Desktop Connection to the server.
I will have a program that will interact with the server and give the server response.
For an experience person, this should not take you long.
I will select someone VERY soon and not wait for the bidding to end. Please tell me what you can do and your experience when you respond.
Thanks.
