I have a SQL 2000 and a SQL 6.5 server that need to be able to issue RPCs to each other.
I have followed the following steps on each:
1)Create a suitable SQL login for all remote logins to use
2)Added the other server under Client Network utility (using Named Pipes)
3)Added the other server as a remote server and configured SQL to map all remote logins to newly created one above.
Now, I'm trying to test RPC connectivity by enterring XXX...sp_who only I get an error informing that the server isn't configured for remote logins, even though it clearly is!!!
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…