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 |
|
sravi22
Starting Member
1 Post |
 Posted - 2012-05-19 : 03:32:40
|
| Hi,One of my client having MS SQL Server 2000 and their application wants to access the database remotely. we have configured IP address to access SQL server remotely using SQL Management studio, and tried yesterday i can able to connect from remotely. Yesterday they were restarted the server after that i could not able to connect from remotely. Could you please give me solution to access the server remotely.Thank you.Ravi |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-05-19 : 12:23:44
|
| Have you done a : a) ping test b) telnet test c) are the services started d)can you connect from the server where the SQL Server is based?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
ovc
Starting Member
35 Posts |
Posted - 2012-05-19 : 12:27:50
|
| as jack said. does it work localy?If yes check Firewall issues using from the remote location ping on the ip and telnet on the port.Is it a namded instance? If yes make sure that the sql server browser is running and the port for it is also open. |
|
|
|
|
|
|
MSSQL Server 2K unable to connect remotely