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 |
|
tsavola
Starting Member
2 Posts |
 Posted - 2004-05-31 : 03:11:01
|
| I'm having a problem with a SQL 7 installation where our application can only connect (DSN-less) using the server name but not the IP address or locahost (these return the access denied error). Performance using the server name is terribly bad compared to another database that can be connected to via IP address. Any ideas what might be happening? |
|
|
Kristen
Test
22859 Posts |
|
|
tsavola
Starting Member
2 Posts |
Posted - 2004-06-01 : 11:12:51
|
I think that's where I got my connection strings from originially!  We were able to resolve this automagically -- rebooting the server showed us that the admin had disabled one of the IIS accounts. Once that was enabled our IP address connections were restored. |
 |
|
|
|
|
|
Can only connect using server name but SLOW!