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 |
|
sqlvijay
Starting Member
16 Posts |
 Posted - 2008-12-06 : 06:32:49
|
| HI GUYS, I AM NEW TO SQL SERVER. I AM WORKING IN SQL SREVER 2000 ON WINDOWS SERVER 2003. SINCE IT IS THE PRODUCTION DATABASE,SOME OF THE JOBS HAVE FAILED DUE TO THE BELOW ERROR IN LINKED SERVER. SQL SERVER DOES NOT EXIST OR ACCESS DENIED. PLEASE ANYBODY CAN TELL ME,HOW TO VIEW THE IP OF THE LIKED SEREVR IN THE SQL SERVER 2000 DATABASE ?AND HOW TO PING THE LINKED SERVER.THANKS IN ADVANCE,VIJAY |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-06 : 09:11:30
|
| Find those linked server inside jobs and see if they are working properly. You can get lists with sp_linkedservers and test with sp_testlinkedserver. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-07 : 05:27:44
|
| http://msdn.microsoft.com/en-us/library/ms189809.aspx |
|
|
|
|
|
|
HOW TO PING THE LINKED SEREVR