October 28, 2009 at 9:07 am
We've installed SQL Server 2008 developered, and sp1. And created domain accounts for the services to run under. But sQL Agent will not start. We get error message:
SQLServer Error: 18452, Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [SQLSTATE 28000] Unable to connect to server '(local)' ; SQLServerAgent cannot start
and:
SQLServer Error: 18452, Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [SQLSTATE 28000] Logon to server '(local)' failed (DisableAgentXPs)
Also have in ErrorLog:
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: <local machine>]
2009-10-28 09:51:04.80 Logon Error: 17806, Severity: 20, State: 2.
2009-10-28 09:51:04.80 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: <local machine>]
2009-10-28 09:51:04.80 Logon Error: 18452, Severity: 14, State: 1.
This is Sharepoint integrated and we also have this error:
The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config_2355c737-4b5b-4743-9fb3-cebc052c60e2 on VMSHAREPOINTTES\OfficeServers. Check the database connection information and make sure that the database server is running..
I will greatly appreciate any ideas on what we are missing here.
Thanks very much.
Denise
October 28, 2009 at 9:23 am
The developer edition is like express most things are disabled by default the Agent is one such feature so go into configuration manager and enable it before trying to use. If it is permission related you can change the account it uses in the same place.
Kind regards,
Gift Peddie
October 28, 2009 at 9:30 am
I have enabled SQL Agent service. What would I have to do to the permissions though? The other services work just fine.
Thanks!
October 28, 2009 at 10:11 am
Denise McMillan (10/28/2009)
I have enabled SQL Agent service. What would I have to do to the permissions though? The other services work just fine.Thanks!
The Agent runs with Network Service so you need to check to see if it is using your new account.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply