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 |
|
ekveda
Starting Member
4 Posts |
 Posted - 2007-06-04 : 01:56:53
|
| Hi all,The issue is bit rusty as I have not been able to track the root cause.Few sites use asp pages to connect to database using the IP address which works for 2-3 hours and suddenly starts saying Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Restarting the server solves the problem for another couple of hours and then same thing happens. No task running at this event occurs.One thing to note is that the issue is resolved when using the server name instead of IP address.Any hep will be greatly appreciated.Keep smiling......... |
|
|
ekveda
Starting Member
4 Posts |
Posted - 2007-06-04 : 04:26:18
|
| Someone pls help |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-04 : 23:06:10
|
| Which protocol do you use on client site? Named pipes or tcp/ip? |
|
|
|
ekveda
Starting Member
4 Posts |
Posted - 2007-06-08 : 06:03:13
|
| both named and tcp/ip...when this issue happesn normal asp pages and html pages are working fine...even I can connect to database server using Enterprise manager....... which suggest 1433 is working...juts the asp pages which connect to database server using IP address doesn't work...if conn string is changed to server name it starts working fine,,, |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-08 : 13:25:08
|
| Did you specify port number along with ip address in connection string? |
|
|
|
|
|
|
Database connectivity using IP address