linkeds server issue from sql2000 to sql 2012

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 2012 Forums

Transact-SQL (2012)

linkeds server issue from sql2000 to sql 2012

Author

Topic

kond.mohan
Posting Yak Master

213 Posts

Posted - 2015-02-03 : 03:27:22

Hi

i need to fetch the data from sql server 2000 to Sql server 2012
while creating linked server below error is getting.

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 "SQLNCLI11" for linked server "RCMS" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "RCMS" returned message "A network-related or
instance-specific error has occurred while establishing a connection to SQL Server.
Server is not found or not accessible. Check if instance name is correct and if
SQL Server is configured to allow remote connections. For more information see
SQL Server Books Online.". (Microsoft SQL Server, Error: 53)

if anyone knows the solution pls guide me on the same

mohan

sz1
Aged Yak Warrior

555 Posts

Posted - 2015-02-03 : 07:12:24

Have you got allow remote connections enabled of the instance you are trying to connect to?
Right click instance in object explorer - connections - remote server connections, tick allow remote connections to this server.

We are the creators of our own reality!

kond.mohan
Posting Yak Master

213 Posts

Posted - 2015-02-03 : 23:39:32

i checked sql server2000 instance
Remote connections Options is enabled for this instance.

any other cases....

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2015-02-04 : 03:00:06

are you able to ping the server on which SQL 2000 instance is installed?

Javeed Ahmed
https://www.linkedin.com/pub/javeed-ahmed/25/5b/95

sz1
Aged Yak Warrior

555 Posts

Posted - 2015-02-04 : 04:38:37

What permissions do you have on both instances?

We are the creators of our own reality!

kond.mohan
Posting Yak Master

213 Posts

Posted - 2015-02-05 : 06:05:59

We are able ping the server successfully.

and we have SYSADMIN permissions on the both instances

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources