Problem COnnecting Remote Database Server thru Enterprise Manager
Hello Guys,
I have just put up an Webserver with SQL Server 2000. Everything is working fine on the remote machine Thru TS .. i can do every administrative things .. But i m facing problem to connect my remote databse server thru the Enterprise Manager .. It Gives me Cant Connect Database Server " Connection Failiure " when i try to connect my remote database server thru Ip address ,.. Please some one help me out to make connecting database server thru Enterprise Manager ..
Thanks
On your workstation, use the client network utility to set up an alias to your remote server.
Assuming you are using tcp/ip, port 1433 needs to be open through the server firewall.
i did the same thing but problem still persists ,,, am i forgetting something else ..
Can you ping that host?
Can you telnet to port 1433 on that host?
How is the auth on the remote SQLServer (sql or windows integrated)?
Authorisation is both SQL and Windows ..
I can ping the host .. and the sql port is 1433.. can connect using localhost but cant from remote locations
I know that the port is 1433, but can you telnet to that port from the other computer?
nope i cant telnet on port 1433 .. how can i open the closed ports
So it seems a firewall-like problem, check if THE TWO machines are running some firewall or port blocking software.
Actually, I've now hit this problem a few times now, usually when installing MSDE or 2000 SE on Windows 2003. The problem is around security for the slammer worm, and a dll called DBNETLIB.dll. When this file is out of date, Server 2003 and perhaps SP2 on XP (I've had a similar experience with XP SP2) will actually disable the TCP/IP protocol for SQL Server to limit an attack. The link below will take you to a fix that will examine your install of SQL Server, then apply appropriate updates. This will update the DBNETLIB.DLL which is responsible for managing the TCP/IP protocol for SQL Server. Most people will assume that installing SP3a will fix this issue, unfortunately, it does not, and I found it is ok so install this critical update after SP3a.
This should definitely solve your issue, knowledge on this topic is surprisingly limited, I have to think that many more people have been hit by this one.
Hi peeps,
I can't connect my webpages written in ASP.net C# which is in the webserver IIS to a remote SQL Server. I keep getting the error message "server not found or access denied". Do we have the prob? Thanks peeps.