c# - Access Denied While Connecting to local SQL database in Visual Studio 2010 -


this code:

console.writeline("before connect"); sqlconnection myconnection = new sqlconnection(@"server=.\sqlexpress;attachdbfilename=|datadirectory|database.mdf;database=database;trusted_connection=yes;"); try {     myconnection.open();     console.writeline("after connect"); } catch (exception e) {     console.writeline(e.tostring()); } 

and reason, giving me error:

a first chance exception of type 'system.data.sqlclient.sqlexception' occurred in system.data.dll system.data.sqlclient.sqlexception: directory lookup file "c:\users\joe\documents\visual studio 2010\projects\fileio\fileio\bin\debug\database.mdf" failed operating system error 5(access denied.).

does know how fix this?

--->> "access denied."

fix folder/file access permissions:

1) determine identity code running as.

2) make sure identity has appropriate access folder , file.


Comments