469,950 Members | 1,924 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

Local SQL Service Not Starting but SQL Server is running?

Hello there,

This is a bit of strange one.
My local version of SQL Server fails to start when I boot yet if I
start Enterprise Manager its started and working fine. ISQL or Query
Analyzer is also not working.

If I try and register the server by another SQL Server is not there. Me
thinks that the named pipes might be a bit broken but would appreciate
any advise from people.

Thanks

Ginters

Jul 23 '05 #1
2 2081
Ray
Couple of thoughts. One the service is not starting until you start EM and
click on the server? By default when a server is registered in EM it sets
the checkbox for automatically start. Right click the server in EM, choose
Edit server registration and look at the bottom checkbox.

Another is only shared memory is working and you are trying to connect from
isql (osql) and QA remotely? In this case check the SQL server error log
for what protocols SQL started and verify that on the client that these
protocols are activated in the client network utility.

If this is a default installation then shared memory, named pipes, and tcp
are all active. Is the MSSQLServer service set to start automatically?
"Ginters" <jp*******@talk21.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Hello there,

This is a bit of strange one.
My local version of SQL Server fails to start when I boot yet if I
start Enterprise Manager its started and working fine. ISQL or Query
Analyzer is also not working.

If I try and register the server by another SQL Server is not there. Me
thinks that the named pipes might be a bit broken but would appreciate
any advise from people.

Thanks

Ginters

Jul 23 '05 #2
Ginters (jp*******@talk21.com) writes:
This is a bit of strange one.
My local version of SQL Server fails to start when I boot yet
Do you get any error message?

Do you have the service set to start automatically?
if I start Enterprise Manager its started and working fine. ISQL or Query
Analyzer is also not working.
Even if SQL Server is running?

Which operating system and which version of SQL Server are you using?
If I try and register the server by another SQL Server is not there. Me
thinks that the named pipes might be a bit broken but would appreciate
any advise from people.


Which protcols have you enabled in the Client Network Utility? Is
shared memory on?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Tom Brown | last post: by
3 posts views Thread by Johann Blake | last post: by
5 posts views Thread by guy | last post: by
4 posts views Thread by Tim Brooks | last post: by
reply views Thread by robpimentel | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.