InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 22:11:38 GMT20http://www.sqlservercentral.com/Forums/Topic1396194-169-1.aspxThis article helped mehttp://msdn.microsoft.com/en-us/library/aa905162(SQL.80).aspxTue, 18 Dec 2012 21:26:42 GMThandkothttp://www.sqlservercentral.com/Forums/Topic1396194-169-1.aspx[quote][b]anthony.green (12/18/2012)[/b][hr]Have you set up the correct SPN's[/quote]That could be it. Not sure what is SPN ... but from the looks of this http://technet.microsoft.com/en-us/library/bb735885.aspxthis may very well be the reason. I did not do any SPN configuration on my account. Thanks!Tue, 18 Dec 2012 13:39:30 GMTMSSQL_NOOBhttp://www.sqlservercentral.com/Forums/Topic1396194-169-1.aspxIt's an existing LinkedServer. When I right click, Script to New Query Editor Window, I get the following: ***server name changed for obvious reasons ***[quote]/****** Object: LinkedServer [ABC] Script Date: 12/18/2012 14:29:56 ******/EXEC master.dbo.sp_addlinkedserver @server = N'ABC', @srvproduct=N'SQL Server' /* For security reasons the linked server remote logins password is changed with ######## */EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ABC',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULLGOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'collation compatible', @optvalue=N'false'GOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'data access', @optvalue=N'true'GOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'dist', @optvalue=N'false'GOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'pub', @optvalue=N'false'GOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'rpc', @optvalue=N'true'GOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'rpc out', @optvalue=N'true'GOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'sub', @optvalue=N'false'GOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'connect timeout', @optvalue=N'0'GOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'collation name', @optvalue=nullGOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'lazy schema validation', @optvalue=N'false'GOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'query timeout', @optvalue=N'0'GOEXEC master.dbo.sp_serveroption @server=N'ABC', @optname=N'use remote collation', @optvalue=N'true'GO[/quote]I have SysAdmin rights to both databases with my domain account. I am wondering if the domain account is the reason.Tue, 18 Dec 2012 13:33:06 GMTMSSQL_NOOBhttp://www.sqlservercentral.com/Forums/Topic1396194-169-1.aspxHave you set up the correct SPN'sTue, 18 Dec 2012 04:06:14 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1396194-169-1.aspxshow the script to create linked serversTue, 18 Dec 2012 04:04:21 GMThandkothttp://www.sqlservercentral.com/Forums/Topic1396194-169-1.aspxMSSQL Server A: MSSQL2000 - set to Windows Authentication modeMSSQL Server B: MSSQL2000 - set to SQL Server & Windows Authentication mode.My client machine: running MS SSMS2008My domain login: SysAdmin privileges on both machines.Linked Servers connection from Server A to Server BWhen I issue commandSELECT * FROM SERVERB.DBNAME.DBO.TABLENAMEI get the following error:Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.Why is that? Is it because Server A is only set to Windows Authentication mode??Thu, 13 Dec 2012 07:42:30 GMTMSSQL_NOOB