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 |
|
jesus4u
Posting Yak Master
204 Posts |
 Posted - 2003-04-02 : 09:19:00
|
| I had to reinstall IIS because out of nowhere I was getting a Server Application Error on my local Win2000 Prof box when trying to connect to a SQL2000 database in the webbrowser using ASP.Now the previous error is gone but now the SQL permissions do not allow the IUSR account to access the database. I have checked all the permissions in SQL and all appears to be ok.Now what? I still get a login error in the browser for SQL!!!!!!!! |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2003-04-02 : 09:25:43
|
| Is the SQL2000 database on the same box as IIS? I have noticed that when SQL and IIS are on the same box, weird things happen when it comes to connectivity. Also, instead of the IUSR account, can you use a network account? I think there might be some issues when using a local user account.***************************************Death must absolutely come to enemies of the code! |
 |
|
|
jesus4u
Posting Yak Master
204 Posts |
Posted - 2003-04-02 : 09:26:47
|
quote:
Is the SQL2000 database on the same box as IIS? I have noticed that when SQL and IIS are on the same box, weird things happen when it comes to connectivity. Also, instead of the IUSR account, can you use a network account? I think there might be some issues when using a local user account.***************************************Death must absolutely come to enemies of the code!
yes they are on the same box and have been for over 2 years! So why is it different now? |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2003-04-02 : 09:44:35
|
maybe describe the network. location of iis / role in domain / etc.most likely you need to manually resyncronize the iuser/iwam passwords check what iis knows them as with Dim IIsObjectSet IIsObject = GetObject ("IIS://localhost/w3svc")WScript.Echo "According to the metabase, the anonymous credentials are:"WScript.Echo " AnonymousUserName = " & IIsObject.Get("AnonymousUserName")WScript.Echo " AnonymousUserPass = " & IIsObject.Get("AnonymousUserPass")WScript.Echo " WAMUserName = " & IIsObject.Get("WAMUserName")WScript.Echo " WAMUserPass = " & IIsObject.Get("WAMUserPass")Set IIsObject = Nothingsaved as getpass.vbsVoted best SQL forum nickname...."Tutorial-D" |
|
|
|
jesus4u
Posting Yak Master
204 Posts |
Posted - 2003-04-02 : 09:47:29
|
| I fixed it! I think I was selecting my IUSR for my machine name from the Network domain account so when I selected from my machine it works!Go figure!!! |
|
|
|
|
|
|
IIS Giving me a Headache