Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mooreb
Starting Member
2 Posts |
 Posted - 2006-06-05 : 14:58:29
|
| I'm trying to move my classic ASP web application to windows authentication instead of using a SQL Server login, because I don't want to pass the user id and password in my connection string. The connection string below will connect to my DB on SQL Server 2005 but certain pages that query the DB take forever to load:"Provider=SQLOLEDB.1;Data Source=xxx.xxx.x.xx;Initial Catalog=xxx;Integrated Security=SSPI;Network Library=dbmssocn;"But when I use the SQL Server Login, like the one below, those pages load fine: Provider=SQLOLEDB;Data Source= xxx.xxx.x.xx;Initial Catalog=xxx;User ID=xxxxxx;Password=xxxxxxx;Connect Timeout=15;Network Library=dbmssocn;"Also, I'm not running IIS using a domain account, because my web servers site outside of the domain. So I set up identical local user accounts on the web servers and on the SQL Server. And I created a SQL Server login for the local account and gave it the database role db_owner.Could those certain pages be taken so long to load because there is something wrong with my connection string or is it a problem with using the identical local user accounts for the windows authentication?I would appreciate any help! Thanks in advance. |
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-06-05 : 21:45:21
|
| "Also, I'm not running IIS using a domain account, because my web servers site outside of the domain." So, how does the webserver connect to the SQL Server? You need to make sure that although they may have the same name in both server, the system ID of each user is different and thus, will trigger OS authentication protocols. In the SQL Server, add the web local user (you assigned in the Web IIS) into the OS group that you allow (not sure if power user or custom user group). This way, the IIS can get passthrough the SQL Server OS authentication.May the Almighty God bless us all! |
 |
|
|
mooreb
Starting Member
2 Posts |
Posted - 2006-06-06 : 10:53:51
|
| The web servers are in a DMZ and have access to the SQL Server through a firewall. On the SQL Server I did as you suggested and added the local web user to the Power Users group but I still have the same problem. I wonder if I need to add the local web user to a SQLServer2005* group? |
|
|
|
|
|
|
|
|
Windows Authentication Connection Problem