querying remote server

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I need help querying a remote server. The syntax is server_name.db_name..table_name. The problem is this particular server is registered locally by it's ip address and the query analyzer won't let me reference the server via it's ip address. HELP!! Thanks, Del

-- Anonymous, July 08, 1999

Answers

Del,

As far as I can tell, you will need to properly register the server using sp_addserver and configure it for remote data access. Sorry.

Eric

-- Anonymous, July 13, 1999


Del,

Since you say, "Feel free to post for others to reference. :) ," I will post it. Thank you.

Eric

====================== Eric,

Actually, a friend and I figured out what needed to be done. There is a utility that comes with SQL Server called the Client Network Utility. You use this to map an ip to a name. You then reference this name when registering a server. Then the name can be referenced from within a query.

It's pretty cool, but definitely overlooked or taken for granted by many a SQL Server pro, because it's not covered in ANY book I've found and only one person out of 5 that responded to my posts knew about it.

Just for future reference and thanks for the response. Feel free to post for others to reference. :)

Del

-- Anonymous, July 15, 1999


Moderation questions? read the FAQ