navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

SQL Service not auto starting.

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> Server Issues >> SQL Service not auto starting.
Page: [1]
 
fhenkel

 

Posts: 183
Joined: 1/7/2004
Status: offline

 
SQL Service not auto starting. - 7/25/2007 15:07:35   
I've just rebuilt my Server 2003 and everything is working great except that after a reboot the SQL Service Manager does not auto-start the service? If I type in the servername\sharepoint it then lists SQL and click refresh it loads and runs fine. What am I missing?
Spooky

 

Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: SQL Service not auto starting. - 7/25/2007 20:00:16   
Is it enabled as automatic in the services?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to fhenkel)
fhenkel

 

Posts: 183
Joined: 1/7/2004
Status: offline

 
RE: SQL Service not auto starting. - 7/25/2007 22:38:42   
Hi Spooky, yes it is set to automatic. Right now it is running if I'm looking at the correct one, it is MSSQL$SHAREPOINT, correct?

(in reply to Spooky)
fhenkel

 

Posts: 183
Joined: 1/7/2004
Status: offline

 
RE: SQL Service not auto starting. - 7/25/2007 22:49:41   
Ok, I had to reboot the machine for a MS update and it comes up stating that one service or driver failed to load. I logged in and the SQLAgent$SHAREPOINT is set to automatic but is not started. I opened the SQL Service Manager and again entered the servername\SHAREPOINT in the Server box and then click refresh. It then shows SQLServer in the Services box and starts and the AutoStart box is checked.

(in reply to fhenkel)
fhenkel

 

Posts: 183
Joined: 1/7/2004
Status: offline

 
RE: SQL Service not auto starting. - 7/26/2007 7:43:53   
Well after some digging I did a Start, Run of the SVCNETCN.exe and found that both "Named Pipes and TCP/IP" were not enabled. I enabled them both and now the SQL Server starts up fine and the Manager lists the services.

I'm still getting a message that "A Service or Driver did not run" when I hit the login screen. I've looked in the Event Log but nothing stands out? Is there a way to pin point where the error is from?

(in reply to fhenkel)
Page:   [1]

All Forums >> Web Development >> Server Issues >> SQL Service not auto starting.
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts