Friday, February 10, 2012

can not login my database when published to IIS

hi,

i am tring to use the 'xcopy' way to deploy my web site, this is the connection string i am using:

"Data Source=.\SQLEXPRESS;INITIAL CATALOG=;AttachDbFilename='|DataDirectory|\HotStage.mdf';Integrated Security=True;User Instance=True"

it works when in debug mode, but after i depoly it to my XP's IIS, it can not login the database, the error message is :

Cannot Login to the default user database. Login Failed. Login Failed for user xxx\ASPNET

'xxx' is my computer.

i think this problem is cause of improper setting of security, but i really do not know how to set it in this situation, because the database is attached to the db system dynamically.

plz someone help, thx

when you use userinstance in sql server express, once the applicaiton is connected to the database you can not connect to the database using SSMO Express. If you donot want to use userinstance change the connection string . "AttachDbFilename='|DataDirectory|\HotStage.mdf' " this is the part where u are attaching the db in connection string. change it if not needed

refer :

http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx

Madhu

|||

hi,

yes, after i remove the 'User Instanct' clause, and did some permission adjustment, i do connected to my database.

but now i have another strange problem... it says my database is read-only

i have set that folder to hava 'write' permission in IIS.

any idea about this?

No comments:

Post a Comment