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
Post a Comment