|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Login Failure with Linked ServerHi,
I have both NT authentication on the two servers, and I'm getting the following error when I try to execute the statement: select * from Main1a.GondorMain.dbo.bds Error Message: Server: Msg 18452, Level 14, State 1, Line 1 Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Any system SPROC that I could check to verify what's causing the error? Any help is appreciated! -Lawrence Hi
Have you checked to see if you have a login on the remote server and that you are not impersonating a different login? John Show quote "Lawrence" wrote: > Hi, > I have both NT authentication on the two servers, and I'm getting the > following error when I try to execute the statement: > > select * from Main1a.GondorMain.dbo.bds > > Error Message: > Server: Msg 18452, Level 14, State 1, Line 1 > Login failed for user '(null)'. Reason: Not associated with a trusted SQL > Server connection. > > Any system SPROC that I could check to verify what's causing the error? > > Any help is appreciated! > -Lawrence Hi,
I can definitely login with my windows credentials on the remote, same for the server I'm running the select. Does the linked server uses a different login? How do I check the logins match up? More help is appreciated -Lawrence Show quote "John Bell" wrote: > Hi > > Have you checked to see if you have a login on the remote server and that > you are not impersonating a different login? > > John > > > > "Lawrence" wrote: > > > Hi, > > I have both NT authentication on the two servers, and I'm getting the > > following error when I try to execute the statement: > > > > select * from Main1a.GondorMain.dbo.bds > > > > Error Message: > > Server: Msg 18452, Level 14, State 1, Line 1 > > Login failed for user '(null)'. Reason: Not associated with a trusted SQL > > Server connection. > > > > Any system SPROC that I could check to verify what's causing the error? > > > > Any help is appreciated! > > -Lawrence Just to clarify, I would like all my database connection to use windows
authentication, so I simply ran --> sp_addlinkedserver 'Main1a' and when I ran the simple select statment (below), I am getting "Login Failed for user '(null)'" so not sure where the inpersonation would take place. select * from Main1a.GondorMain.dbo.bds -Lawrence Show quote "Lawrence" wrote: > Hi, > I can definitely login with my windows credentials on the remote, same for > the server I'm running the select. Does the linked server uses a different > login? How do I check the logins match up? > > More help is appreciated > -Lawrence > > "John Bell" wrote: > > > Hi > > > > Have you checked to see if you have a login on the remote server and that > > you are not impersonating a different login? > > > > John > > > > > > > > "Lawrence" wrote: > > > > > Hi, > > > I have both NT authentication on the two servers, and I'm getting the > > > following error when I try to execute the statement: > > > > > > select * from Main1a.GondorMain.dbo.bds > > > > > > Error Message: > > > Server: Msg 18452, Level 14, State 1, Line 1 > > > Login failed for user '(null)'. Reason: Not associated with a trusted SQL > > > Server connection. > > > > > > Any system SPROC that I could check to verify what's causing the error? > > > > > > Any help is appreciated! > > > -Lawrence Hi
If you can log into the remote server (with Query Analyser) with windows authentication then you should be ok. You can see the impersonation in the linked server properties in Enterprise Manager, but you have not set up any if you have only called sp_addlinkedserver. You don't give the version of SQL Server you are using, this was a SQL 7 issue http://support.microsoft.com/default.aspx?scid=kb;en-us;247641 John Show quote "Lawrence" wrote: > Just to clarify, I would like all my database connection to use windows > authentication, so I simply ran --> sp_addlinkedserver 'Main1a' and when I > ran the simple select statment (below), I am getting "Login Failed for user > '(null)'" so not sure where the inpersonation would take place. > > select * from Main1a.GondorMain.dbo.bds > > -Lawrence > > "Lawrence" wrote: > > > Hi, > > I can definitely login with my windows credentials on the remote, same for > > the server I'm running the select. Does the linked server uses a different > > login? How do I check the logins match up? > > > > More help is appreciated > > -Lawrence > > > > "John Bell" wrote: > > > > > Hi > > > > > > Have you checked to see if you have a login on the remote server and that > > > you are not impersonating a different login? > > > > > > John > > > > > > > > > > > > "Lawrence" wrote: > > > > > > > Hi, > > > > I have both NT authentication on the two servers, and I'm getting the > > > > following error when I try to execute the statement: > > > > > > > > select * from Main1a.GondorMain.dbo.bds > > > > > > > > Error Message: > > > > Server: Msg 18452, Level 14, State 1, Line 1 > > > > Login failed for user '(null)'. Reason: Not associated with a trusted SQL > > > > Server connection. > > > > > > > > Any system SPROC that I could check to verify what's causing the error? > > > > > > > > Any help is appreciated! > > > > -Lawrence  
Other interesting topics
|
|||||||||||||||||||||||
