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.
| Author |
Topic |
|
dowens
Yak Posting Veteran
82 Posts |
 Posted - 2005-09-08 : 09:44:56
|
| Receiving Login failed error. Why am I receiving the error?I've created a view for user use, see below.I created a link between two sql serversused following command: sp_addlinkedserver 'SQLTEST', 'SQL Server'Both servers use windows authentication.I have identical logons on both servers.ERROR = Server: Msg 18452, Level 14, State 1, Line 3Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.Running query via Query Analyzer.CREATE VIEW dbo.MemberTest ASSELECTtbl_Members.MBRLNAME AS LastName, tbl_Members.MBRFNAME AS FirstName, tbl_Members.DOB AS DateOfBirth,tbl_Members.LOB AS LineOfBusinessFROM SQLTEST.fl1st.dbo.tbl_Members AS tbl_MembersUNION ALLSELECTdbo.MemberImages.memberno, dbo.MemberImages.scandate, dbo.MemberImages.BoxNumber, dbo.MemberImages.create_user, dbo.MemberImages.create_date, dbo.MemberImages.modify_user, dbo.MemberImages.modify_date, dbo.MemberImages.o_hostno, dbo.MemberImages.o_instno, dbo.MemberImages.o_procno, dbo.MemberImages.o_hostid, dbo.MemberImages.o_typeid, dbo.MemberImages.o_revid, dbo.MemberImages.o_objid, dbo.MemberImages.o_rowid, dbo.MemberImages.arc_lob, dbo.MemberImages.doctype, dbo.MemberImages.[ID]FROM WHSQL.Optix.dbo.MemberImages LEFT OUTER JOIN tbl_Members.MBRID ON dbo.MemberImages.memberno = tbl_Members.MBRID LEFT OUTER JOIN dbo.ClaimsRestriction ON dbo.MemberImages.arc_lob = dbo.ClaimsRestriction.LineOfBusiness AND dbo.ClaimsRestriction.DBLogin = SYSTEM_USERWHERE (dbo.MemberImages.arc_lob IS NULL) OR (dbo.MemberImages.arc_lob = dbo.ClaimsRestriction.LineOfBusiness) |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
|
|
|
|
|
|
|
Link Server Login failed