Unable to Connect to MSSQL Instance

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Unable to Connect to MSSQL Instance

Author

Topic

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2011-09-12 : 16:29:05

Hi,

I have an old, possibly unused, SQ: Server 2000 instance that I cannot access. I am in the local Administrators group.

How can I open Enterprise Manager when it is not in Start --> Programs?

I don't know the sa password.

Based on the service name MSSQLSERVER, it appears to NOT be a named instance.

Thanks, John

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-12 : 16:43:03

Are the SQL client tools even installed?

Try connecting with osql.exe from a cmd window:

osql -SserverName -E

Do you get an error or do you see a >?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2011-09-12 : 16:55:12

Tara,

osql -SPNCLBES -E

I get 1>

It's possible the client tools are not installed.

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-12 : 17:12:37

You are connected to PNCLBES now with osql. I don't have a 2000 system installed to check what the shortcut is to EM. You could choose to use SSMS 2005+ instead as that can connect to 2000. But osql.exe works too, just may be a tad hard to use if you aren't familiar with the commands (non-GUI approach).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-12 : 21:21:08

I don't remember the shortcut either, but you can always get to Enterprise Manager (if it's installed) by

START
RUN
type in MMC
<ENTER>

FILE
Add/Remove Snap-In
Choose SQL Server Enterprise Manager
Click Finsish

Also...you can always get to Query Analyzer by hitting START/RUN/isqlw <ENTER>

skybvi
Posting Yak Master

193 Posts

Posted - 2011-09-13 : 11:31:29

try
sqlwb.exe
in the run tab

Regards,
Sushant
DBA
West Indies

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-13 : 16:03:06

SQLWB is for SQL 2005.

John specifically asked about SQL 2000.

skybvi
Posting Yak Master

193 Posts

Posted - 2011-09-14 : 12:21:44

@russell

My bad :(

Regards,
Sushant
DBA
West Indies