Reputation: 603
I am working on asp.net C#.When i use visual studio 2010 web development server everythnig is working fine, but when i try to host my app on IIS server, the connectivity with the database is not properly maintained. e.g it says that the database is a read only database, whereas i m able to edit/insert whn i host the same app on web development server. I m using mssql server s database. my connection string is
"Data Source=.\\SQLEXPRESS; AttachDbFilename=|DataDirectory|\\MyDatabase.mdf;Integrated Security=True;User Instance=True"
plz help.
Upvotes: 2
Views: 388
Reputation: 2804
Have you checked the database directory is writeable by the appropriate user accounts, Network Service, etc, depending on the OS you're using?
Upvotes: 1