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.
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 Yes to restart SQL.
I hope your problem will be solved.
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  Database YYYYYY: Transaction Log Backup...
** 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.
 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)
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.
exec sp_addlinkedsrvlogin 'LinkedServer', false, NULL, <remote user>, <remote password>
How did you create this db user 'manoj', is it mapping to a trusted NT login? This is security issue, please post your question to security forum
Try this if you are trying to link them with the login's current security context:
To use delegation, all servers that you are connecting to must be running Microsoft® Windows® 2000, with Kerberos support enabled, and you must be using Microsoft Active Directory™, the directory service for Windows 2000. The following options in Active Directory must be specified as follows in order for delegation to work:
· The Account is sensitive and cannot be delegated check box must not be selected for the user requesting delegation.
· The Account is trusted for delegation check box must be selected for the service account of SQL Server.
· The Computer is trusted for delegation check box must be selected for the server running an instance of Microsoft SQL Server™.
1> Goto SQL Server Manger
2> Select the DB Server (Eg : Local) -> Management->Right click and stop SQlServerAgent
Click the DB Server (Eg local) -> Right click and stop
3> Right click and start both Server and server Agent again.
- Proposed as answer by Keith Holman Thursday, August 19, 2010 9:58 PM
Very good Brother, I had problems connecting PHP + Mssql 100pts I worked wonderfully. for you
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker