October 28, 2002 at 2:48 am
I am sitting in front of a Win2k PC. I try to start my SQL Server installation via the ServiceManager, that worked fine, a few days ago. Now i get the error number 1069. Its a german version of SQL Server, translated error text : "Error:1069, Service could not be started, due to an errounous authentication." something like that. I just can't think of any reason for it. Does anyone know a solution to this problem?
Thanks
DrGonzo
October 28, 2002 at 3:10 am
How is SQL Server being started?
If SQL Server is logging as a particular account (as opposed to the system account), has the password for the account changed recently, or the account been deleted?
October 28, 2002 at 3:47 am
SQL Server is being started by the SQLServer Service Manager or the Enterprise Manager. It is possible that some accounts have been altered by someone else. Which account should i check?
quote:
How is SQL Server being started?If SQL Server is logging as a particular account (as opposed to the system account), has the password for the account changed recently, or the account been deleted?
October 28, 2002 at 4:05 am
It doesn't matter whether it's being started by Enterprise Manager or Service Manager, the important bit is how SQL Server itself is starting.
I only have an NT4 workstation in front of me, but I believe on Win2K, if you go to Control Panel/Administrative Tools/Services and then Select the MSSQLServer service (or whatever it has been called), the LogOn tab will show you how it has been configured.
If it isn't the system account, then the account name shown is the one you need to check.
October 28, 2002 at 4:14 am
Thanks, it works fine now. SQLServer isn't run under the system account, and the pass for the account it's run under was wrong. Thats all.
quote:
It doesn't matter whether it's being started by Enterprise Manager or Service Manager, the important bit is how SQL Server itself is starting.I only have an NT4 workstation in front of me, but I believe on Win2K, if you go to Control Panel/Administrative Tools/Services and then Select the MSSQLServer service (or whatever it has been called), the LogOn tab will show you how it has been configured.
If it isn't the system account, then the account name shown is the one you need to check.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply