x

not finding SQL Server(MSSQLSERVER) in SQL Server services

not finding SQL Server(MSSQLSERVER) in SQL Server services
more ▼

asked Sep 29, 2010 at 01:47 AM in Default

Murali gravatar image

Murali
906 101 117 120

Murali this isnt a great way of looking for help. Can you explain exactly how we are meant to respond to your few words? What do you hope to be told?
Sep 29, 2010 at 01:51 AM Fatherjack ♦♦
Perhaps you need some new glasses?
Sep 29, 2010 at 02:02 AM Matt Whitfield ♦♦
Without a better question "Where did you have it last?" is a possible answer...
Sep 29, 2010 at 02:11 AM Fatherjack ♦♦
Have you looked under the sofa? :)
Sep 29, 2010 at 02:19 AM Matt Whitfield ♦♦
Reminds me of "DUDE WHERE IS MY MSSQL SERVER INSTANCE".
Sep 29, 2010 at 04:54 AM Tim
(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first
Do you know that SQL Server is in fact installed on the machine in question? If so, can you connect to it? If you can't see it as a service and you can't connect to it, maybe it's not installed.
more ▼

answered Sep 29, 2010 at 04:27 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
101k 19 21 74

+1 - not purely because you are the only grown up here.
Sep 29, 2010 at 05:17 AM Fatherjack ♦♦
Today I'm the grown up. Tomorrow or some other day I'll be one of the kids. No worries.
Sep 29, 2010 at 05:29 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Did you install a named instance rather than a default one?
more ▼

answered Sep 29, 2010 at 05:21 AM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 36

(comments are locked)
10|1200 characters needed characters left
We had that issue last time when sys admins decided to "lock down" certain security accesses to the server. It was resolved once the DBA Group (or the DBA username if if fits your case) was added to the local Administrators Groups.
more ▼

answered Sep 29, 2010 at 09:06 AM

ozamora gravatar image

ozamora
1.4k 2 3 5

(comments are locked)
10|1200 characters needed characters left

A few thoughts:

Are you sure it's installed? Is the software in the appropriate place? Do the registry settings for SQL Server lead you to the right place?

HKEY\_LOCAL\_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

is the home for the registry for SQL Server. Below that you should find a registry key called "Instance Names" which will guide you further.

What about the Services database within the registry? Did you look in there?

HKEY\_LOCAL\_MACHINE\SYSTEM\CurrentControlSet\Services\

In there, you'll find various services named "MSSQL" something.

And what about the files on your hard disk? If there's nothing there called "sqlservr.exe", then SQL Server isn't installed...
more ▼

answered Sep 29, 2010 at 12:10 PM

ThomasRushton gravatar image

ThomasRushton ♦
33.9k 18 20 44

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x17
x7

asked: Sep 29, 2010 at 01:47 AM

Seen: 2878 times

Last Updated: Sep 29, 2010 at 04:33 AM