asp.net - How to deploy an asp site with SQL Server database -
i have site sql server database , having trouble deploying iis. page in iis cannot access db, can see page cannot login because database not accessible...
i can access database when site runs debug visual studio.
i guess security problem.
how work?
thanks,
the normal approach switch sql server "windows/integrated authentication" "sql authentication". sql authentication allows create sql login, can specify in connection string like:
data source=myserver;initial catalog=mydb;user id=myuser;password=***;
virtually hosting providers use method.
Comments
Post a Comment