Linked server question - 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 2008 Forums

SQL Server Administration (2008)

Linked server question

Author

Topic

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2012-04-17 : 10:32:38

I have been trying to create a linked server on my sql box at work.

time and time again it just doesnt work.

but i tried on another box and it works.

they both have allow remote connections enabled.

both have same external ip address.

is there anything else i can check?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-17 : 14:00:22

you need to give more details on that

Are both the boxes having same version on SQL Server?
any other changes in configuration?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2012-04-17 : 15:13:10

the sql box that the linked server is working on is 2008

and the other that is not working on is 2005

not quiet sure what version i am trying to connect to.

what other information would you need?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-17 : 16:21:20

well...then there should be something to do with provider in SQL 2005. It might worth checking which version you're trying to connect to

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2012-04-17 : 17:11:10

ok thank you

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2012-04-18 : 04:15:52

the version i am trying to connect to is 2005

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-19 : 00:56:54

whats the exact error message?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2012-04-19 : 07:23:03

error below

but i am able to create on my 2008 box

TITLE: Microsoft SQL Server Management Studio
------------------------------

"The linked server has been created but failed a connection test. Do you want to keep the linked server?"

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Named Pipes Provider: Could not open a connection to SQL Server [53].
OLE DB provider "SQLNCLI" for linked server "xx.xx.xx.xxx" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "xx.xx.xx.xxx" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1406&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

------------------------------
BUTTONS:

&Yes
&No
------------------------------

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-19 : 08:58:12

are servers in same domain?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2012-04-19 : 09:05:35

Hello visakh

Yes they are both on same domain.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-19 : 14:46:11

so i assume you're using same credentials to connect to both? is it windows login you're using?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2012-04-19 : 17:15:08

Yes both the same.

But login is a sql server user login that has been set up by vendor.

Thank you very much for replying all this time. :)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-20 : 15:24:19

so is the same sql login configured in both servers?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2012-04-20 : 17:59:37

yes I have used the same credentials on both linked
server setups.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources