My application works properly with development area (VS 2005) , When I created virtual directory and call using browser (IE 7.0) , error occurs exacly the same below
ERROR:
Cannot open user default database. Login failed.
Login failed for user 'CBOZLAGAN\ASPNET'.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details:System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'CBOZLAGAN\ASPNET'.
Source Error:
Line 4932: this.Adapter.SelectCommand.Parameters[2].Value = ((int)(PROFIL));Line 4933: neuron.KULLANICI_TANIMLARIDataTable dataTable = new neuron.KULLANICI_TANIMLARIDataTable();Line 4934: this.Adapter.Fill(dataTable);Line 4935: return dataTable;Line 4936: }
Connection String is below
"Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\neuron2007_AJAX\\App_Data\\neuron_Data.MDF;Integrated Security=True;User Instance=True";
How can I solve this problem?
Thanks
Did you grant the ASPNET user account permission for the database?
Jeff
|||Are you publishing to a remote server and are you publishing a copy of the local database that you are connecting to in that connection string?
Did you grant the correct permissions for Integrated Security?
|||
Yes BRCK231\ASPNET has rights below
- db_datareader
- db_datawriter
But connection is done with user BORINTERNAL\CBOZLAGAN for BRCK231\SQLEXPRESS sqlexpress 2005 server
|||Is the website set up (via IIS) to accept anonymous connections? If not, please give that a try.
Mark
|||
Did you figure it out yet?
No comments:
Post a Comment