Link Server Issue - 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

Other SQL Server Topics (2005)

Link Server Issue

Author

Topic

xcret25
Starting Member

2 Posts

Posted - 2011-08-23 : 00:00:13

Hi...I have an issue. My computer using SQL 2005. and i want to create Link Server to Server that using SQL 2008. But the case is, in the server there are SQL 2005 and SQL 2008 installed. when i create the link server, the link server always connect to SQL 2005 by default. how to connect to the SQL 2008? thx

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-23 : 00:05:12

use full instance name

Youserver\sql2008instance

in linked server definition

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

xcret25
Starting Member

2 Posts

Posted - 2011-08-23 : 01:30:59

Can you give an example?

I want to execute the store procedure like this
exec [(10.10.148.5)/SQL2008].itp.[dbo].[GetRouteEvent] 'B9543WP', 49, '8/16/2011 08:10:00','8/16/2011 08:15:00'

But [(10.10.148.5)/SQL2008] is error.

10.10.148.5 is my remote connection server.

Can you help me?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2011-08-23 : 01:36:47

Use instance name in your linked server definition, not while executing proc. You need to execute the proc using linked server name. e.g.

exec LinkedServerName.itp.dbo.[GetRouteEvent] 'B9543WP', 49, '8/16/2011 08:10:00','8/16/2011 08:15:00'

Harsh Athalye
http://www.letsgeek.net/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-23 : 02:06:07

and no need of () around ip

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

Bogdi
Starting Member

3 Posts

Posted - 2011-10-25 : 16:42:30

Hi, ihave a question about linked servers.
Why if i run "select * from linked_server.master.dbo.syslogins"
i get ROLLBACK TRANSACTION in SQL Profiler?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-26 : 01:02:18

do you have any logon triggers enabled in your db?

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

Bogdi
Starting Member

3 Posts

Posted - 2011-10-26 : 12:01:42

No, i don't have any logon trigger.

Bogdi
Starting Member

3 Posts

Posted - 2011-10-26 : 12:28:00

I get the result of the select but I get the message ROLLBACK TRANSACTION.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources