stored procedure accessing another sql server

[brench1]

I have a stored procedure on SQL Server Standard Edition trying to access a table on a second SQL Server (which is Personal Edition). I use the fully qualified path (server.database.dbo.object_name) but am getting error 18452 (login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection).

I have authentication set to 'SQL Server and Windows' on the Security tab under Properties for both servers.

Anyone have any suggestions?

TIA.


Brad

 

[checkai]

I believe that you have to set up the two db's to be linked so that they are able to communicated to one another.

dlc

 

[brench1]

how do I set up the two db's to be linked?

 

[checkai]

under SQL Server EM there is a security folder that you can select Linked Servers. There is where you choose the server to link to and assign it a name.

dlc

 

[brench1]

Oh, I misunderstood. I had already linked the two servers. I thought you meant there was something more I needed to do to link the databases themselves.

By the way, I can connect from the Personal Edition server to the Standard Edition server, but I get the error when going the other way.