Linked server issues - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Linked server issues

Author

Topic

shocker-z
Starting Member

1 Post

Posted - 2009-11-13 : 11:24:54

Hi,

I've spent 5 hours on a clients server trying to get this linked server to work MSSQL Express to MSSQL standard both 2005.

ServerA (SQL Express 2005)
ServerB (SQL Standard 2005) (running on port 9050) (can connect and authenticate fine from SQL Management Studio)

First of all I create a link by right clicking "Linked Servers" on ServerA and clicking to create a new linked server. I then select the "Server type" as being "SQL Server". I Enter the server name and port in this case: ServerB,9050

When I click OK I get the following error:

- - - - - - - - - - - - - - -
"The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?"

Additional information
An exception occurred while establishing a Transact-SQL statement or batch.
(Microsoft.sqlserver.Express.ConnectionInfo)

The OLE DB provider "SQLNCLI" for linked server "ServerB,9050" reported an error Authentication failed.

Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "ServerB, 9050". (Microsoft SQL Server, Error: 7399)
- - - - - - - - - - - - - - -

So this is obviously expected as the other server (serverB) is also on another domain so windows authentication wont work.

So i go about changing the security. I put a check in "Be made using this security context", Enter my remote SQL user and password. Click OK and i receive the following error:

- - - - - - - - - - - - - - -
"The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?"

Additional information
An exception occurred while establishing a Transact-SQL statement or batch.
(Microsoft.sqlserver.Express.ConnectionInfo)
TCP Provider: A socket operation encounted a dead network
(Microsoft SQL Server, Error: 10050)
- - - - - - - - - - - - - - -

Now i dont get how it's suddenly giving me a message like the server doesnt exist when specifying a username and passowrd?

Regards
Liam Wheldon

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources