| Author |
Topic |
|
Jumbuck
Starting Member
11 Posts |
 Posted - 2009-12-18 : 11:50:47
|
When I turn my computer each morning and try to access SQL Server I get an error message that the server was not found or was not accessible. To deal with this error I have to manually start SQL server via administrative tools under the Start menu.How can I program SQL server to start on computer startup?Thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-12-18 : 12:31:43
|
switch startmode in sql server configuration manager from manual to automatic (SQL SERVER MSSQLSERVER).
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Jumbuck
Starting Member
11 Posts |
Posted - 2009-12-19 : 09:02:30
|
| the start mode has been on automatic all along.After reading your post yesterday, I checked that the startmode was automatic, and restarted my computer. SQL server started.But this moring, when I restarted my computer, I had the same problem. It seems that the occurrence of the problem is connected somehow to the time of day.What do you think? Thanks |
|
|
|
wayne.zjw
Starting Member
10 Posts |
Posted - 2009-12-19 : 12:36:15
|
| hi, i think that's because some firewall settings affecting the performance of your sql serveryou can give it a try! |
|
|
|
Jumbuck
Starting Member
11 Posts |
Posted - 2009-12-22 : 14:36:25
|
| The SQL Server and the program trying to access it are on the same computer, so I don't think there's any firewall involved. The Server was stopped. I think a firewall could not turn the server off.So I'm back at square one. Thanks for the idea. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-12-22 : 14:40:08
|
Ignore wayne's post. He was just posting spam to this thread and not providing any useful information to assist you, hence the reason why I edited his post and removed the spam. I'm a moderator on this site.  If the service is set to automatic and it does not start at startup after a reboot, then it is failing to start. You'll need to check the Application Log in Event Viewer for the service failure. You can post it here, and we'll help you get it resolved.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
Jumbuck
Starting Member
11 Posts |
Posted - 2009-12-24 : 15:48:05
|
| Thanks.I found the following log error:Product: Microsoft SQL Server 2005 Express Edition -- Error 29565. SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete. Start the Remote Registry service and go to Add/Remove Programs, select the Change button for Microsoft SQL Server 2005, and then select SQL instance SQLEXPRESS and complete the setup.I selected the Change button in for Microsoft SQL Server 2005 (in windows Vista/ Control Panel/Programs and Feaures) and followed the prompts. I got as far as an error message "The feature you are trying to use is on a network resource that is unavailable - enter a path to a folder containing the installation package 'SqlRun_SQL.msi'. I can't find this file.Your help would be appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Jumbuck
Starting Member
11 Posts |
Posted - 2009-12-25 : 11:36:07
|
| I would have downloaded and run the install program from a microsoft download site. |
|
|
|
|
Set Server to start on computer startup