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

Popular posts from this blog

objective c - Change font of selected text in UITextView -

php - Accessing POST data in Facebook cavas app -

c# - Getting control value when switching a view as part of a multiview -