Hello,
After loading Service Pack 3A(to an existing SQL 2000 setup) I cannot access the SQL Server on my local machine. Error 1069 states 'The service did not start due to a logon failure'
Check the account that SQL Server is using to start up. Is it a domain account or local? If it is domain make sure it isn't locked out. Then make sure you have the correct password.
You can get this information from the services program
- Paul
- If at first you don't succeed, find out if the loser gets anything.
OK, the radio button 'Use SQL Server Authentication' is selected under Registered SQL Server Properties window, so I assume it's domain account. I perused through the Client and Server Network Utilities and saw nothing related to Account Locking or such. In fact nothing looks different, I just cannot start the server.
Also may be worth noting, I installed OLAP Services from the main disk with the hope that all those MDX functions would become available. After installing and trying to write IIF into a SELECT statement, Query Analyzer still gave me a 'Does not exist' error. However, it was not until I loaded SP3a that the server completely locked up.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.