error 18452, Login failed for user Reason: Not associated with a trusted SQL Server connection.
Hi all,
I have two servers running windows 2003 and both having sql server 2000.
I want to establish a linked server between all of them.
i created them . but now when accessing the data from those server the following error is being displayed
Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user 'manoj'. Reason: Not associated with a trusted SQL Server connection.
i have enabled mixed mode authentication.even then its not displaying the intended result.please respond is urgent.
thanks.
Change the authantication mode to Mix Mode from Windows Only mode for Sql Server.
-
Enter SQL Enterprise Manager.
-
Find your server name in the tree on the left.
-
Right mouse click on the server name and select properties.
-
Click the Security folder. You should now see the screen below with "Windows Only" set as the default authentication.
-
Check SQL Server and Windows as the Authentication.
-
Click OK.
-
Click Yes to restart SQL.
I hope your problem will be solved.
Regards.
Kam Trivedi
TORONTO
I have same Problem.... with error message Displayed below, I tried above steps but no luck....
icrosoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'XXXXXX' as 'NT AUTHORITY\SYSTEM' (trusted) [Microsoft SQL-DMO (ODBC SQLState: 28000)] Error 18452: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Starting maintenance plan 'DB Maintenance Plan4' on 11/2/2005 9:00:02 PM [1] Database YYYYYY: Transaction Log Backup...
Destination: [D:\Log\YYYYYY\YYYYY_tlog_200511022100.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[Microsoft SQL-DMO (ODBC SQLState: 28000)] Error 18452: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
[2] Database YYYYYY: Delete Old Backup Files...
1 file(s) deleted.
Deleting old text reports... 1 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan4' on 11/2/2005 9:00:03 PM SQLMAINT.EXE Process Exit Code: 0 (Success)
GUI solution:
On the server you run a job:
1. Select linked server - properties.
2. Select security page.
3. Select 'Be made using the security context:'
enter remote user and password below.
--
SQL solution:
exec sp_addlinkedsrvlogin 'LinkedServer', false, NULL, <remote user>, <remote password>
