July 26, 2008 at 8:42 am
Hello All,
Background:
I have installed Active Directory on Server#1 with a SQLCLient (Windows 2003 Server x64).
SQLServer2005 x64 STD was installed on Server #2(Windows 2003 Server x64) before I installed Active Directory on Server#1.
Symptom:
If I log onto Server#1(AD Box) and try to connect to SQLServer2005(Server#2 Box) using Windows Authentication sometimes it will timeout, other times it will connect then disconnect. I have confirmed that the ADHelperServicer is installed, and in the LOG FILE I get the following error when Biztalk(on Server#1 tries to run a job):
"...Message: The job failed. Unable to determine if the owner (MYADDOMAINNAME\Administrator) of job MessageBox_Parts_Cleanup_BizTalkMsgBoxDb has server access (reason: Could not obtain information about Windows NT group/user 'MYADDOMAINNAME\Administrator', error code 0x5. [SQLSTATE 42000] (Error 15404)).
HELP!!!
My Thanks in Advance!
July 26, 2008 at 10:09 am
This isn't really a SQL Server problem, but it could be a kerberos or AD issue between the servers. Your secure channel to the domain controller might be down, or perhaps there are timing issues that prevent the OS on which SQL Server is installed from verifying authorization.
Can the user listed "log onto" the SQL Server box from the console? Have you tried changing the job owner and resetting it back?
July 26, 2008 at 10:21 am
Thank you for the response.
I DO suspect this to be an AD issue, but do not know enough to fix. I read that the SQL SERVER AGENT needs to have the LOG ON set to a trusted user from the AD, however, I am not able to change the LOG ON for the SQL SERVER AGENT. Keeps giving me an error no matter what user I set (even if I try and set it to a user from the local box.
Using the console on Server#1, I can generally can windows authenticate but usually get terminated, however, mostly I am not able to windows authenticate (times out). I can, however, authenticate perfectly fine using Sql Server Authentication (no problems).
Unfortuneatly, Biztalk requires windows authentication.
Any help would be greatly appreciated!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply