Sql Server does not start
hello all,
I am using SQL Server 2000.
I am facing a problem since yesterday that my sql server does not start.
It gives me the error that 'Could not start sql server. sql server does not exists or access denied....Instance already running' when I try to start or connect to the server.
I changed Authentication mode from WIndows Only to Sql Server and Window a week ago. It worked fine. Then I changed it back to WIndows Only. When I did that, server is not starting up. it is set to automatically start with operating system. But when I restart my computer, even then server does not start.
What has happened to the server? Is it because of Authentication mode change that I mentioned above or something else?
Please help me! I need to start it soon and make 3 new tables and some new stored procedures. I am stucked.
please help!
Thanks in advance.
Thanks for your reply!
No, I did not change the password of the service account.
It is System Account (which is by default i think).
I just chaned authetication from Windows to SQL Server and Windows.
And now as the SQL Server is not starting up, I can't do anything i.e change the password or any setting.
I am very much depressed as I have to do much work in my SQL Server database(create tables, procedures).
Please help me!
please!!
I am waiting for your reply!
Thanks
Thanks for writing to me!
Yes, I rebooted the system but of no avail!
I have also checked the Autostart service when OS starts checkbox.
All of the settings are default. I can't understand what has happened and how to get the solution.
Please help me in solving this problem. I am doing no work. I am stucked.
Thanks again!
waiting for your reply!
Greetings.
There are a couple of places to look to get more info:
You can look in the system event log to see if there are errors reported by SQL that relate to the startup.
You can also look in the SQL log (by default \program files\Microsoft SQL Server\MSSQL$<instance_name>\LOGS\ERRORLOG) and see if you see anything there indicating the problem.
If you still don't see anything obvious, email the SQL log to me at kfarlee@microsoft.com and I'll see what I can find.
