September 14, 2005 at 4:32 am
Has anyone ever heard of SQL Server refusing connection from SQL Server Agent / Executive running under the local system acccount. The SQL Server is running in Mixed mode.
Nigel Moore
======================
September 14, 2005 at 5:22 am
What message are you getting?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 14, 2005 at 5:41 am
Not associated with a trusted sql server connection.
Nigel Moore
======================
September 14, 2005 at 6:57 am
According to microsoft it should work under mixed mode. but i had this problem but only on certain agent tasks like task with cross server queries. Hence i created a windows login and used to startup the agent and works fine.
just out of intrest what account does sql server run under. Is the agent starting after sql service.
September 14, 2005 at 6:59 am
This is all not the same machine no remote connection issues. SQL Server service is also running uner local system and is running. SQL Executive cannot start because of this issue (yes its 6.5).
Nigel Moore
======================
September 14, 2005 at 10:48 pm
If you have removed sysadmin from BUILTIN\Administrators or removed this SQL Server login, then SYSTEM has no way to login to the SQL Server 2000 databases, see KB 317746.
Andy
September 15, 2005 at 10:57 am
Agreed.
Try explicitly re-adding the system account back to SQL Server. Something like:
use master
EXEC sp_grantlogin [NT Authority\System]
EXEC sp_addsrvrolemember [NT Authority\System] , 'sysadmin'
go
should work.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply