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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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