February 18, 2009 at 5:37 am
After a fresh install of sql server developer edition, when i went on to launch the management studio and then open the local sever, i found one error. On investigating further, i found that the SQL server was not running.
So, i went to sql server surface area configuration clicked teh start button to start the sql server service. But, there came an error message:
An error occured while performing this operation
What are the possiblities? Do we have to have a log file checked?
I have attached screen shots.
Thanks..
February 18, 2009 at 8:09 am
You can always check the eventvwr to see what the error was. Please post what you see in the eventvwr
-Roy
February 18, 2009 at 8:17 am
think that you have to start the instance by using configuration manager, seems most likely the server instance is not started, let me know if this works 🙂
February 18, 2009 at 9:59 am
well, i have just checked the configuration and i checked the property of the sql server which is stopped and found that my domain credentials were used for the authentication. please find attached the file.
I changed that to local service then i started it successfully. However, for opening the sql management studio and opening the local server, i used the windows authentication and which worked fine and i was in.
Could you please let me know, what is local service and why did it worked with windows authentication when i opened the management studio?
February 18, 2009 at 10:42 am
It all depends on what right you have and how you set up your account as the SQL Server account. If you use the SQL Configuration tool to set your account as SQL Server account, then it will manage all the rights on the Disks. But still you will need to have the right to Run as Service account.
Check what kind of access level you have on your domain account.
-Roy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply