Cannot open a database while in Enterprise Manage

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 2000 Forums

Transact-SQL (2000)

Cannot open a database while in Enterprise Manage

Author

Topic

Lin100
Yak Posting Veteran

70 Posts

Posted - 2006-09-15 : 13:11:54

Cannot open a database while in Enterprise Manage r.
I got an error message when I open a server.

ERROR MESSAGE:
A connection could not be established to Win-2000-Server.
Reason: Cannot open user default database. Login failed

Please vrify SQL Server is running and check your SQL server registration
properties(by right clicking on the Win-2000-Server node and try again)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-09-15 : 13:22:40

Have the sysadmin of your server change your default database to master.

Tara Kizer

Lin100
Yak Posting Veteran

70 Posts

Posted - 2006-09-15 : 13:44:37

Hi tkizer.
I am the sysadmin. The SQL 2000 Server is on the same hard drive as the
Windows 2000 Server that I am running.

Console Root --> Microsoft SQL Servers --> SQL Server Group --> WIN-2000-SERVER -->
I DID NOT SEE ANY DATABSES. Therefore I cannot select a Master database as
a default database

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-09-15 : 13:49:20

Are you using the sa account or just a sysadmin account?

Tara Kizer

Lin100
Yak Posting Veteran

70 Posts

Posted - 2006-09-15 : 13:52:28

I do not know Which account I am using because I cannot see any object underneath
WIN-2000-SERVER within "SQL Server Enterprise Manager". There is nothing here.
Everything has disappear.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-15 : 14:00:49

The information about connected servers are missing from the registry. Restore your registry, the part about sql server.
Or re-register the servers manually.

Peter Larsson
Helsingborg, Sweden

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-09-15 : 14:12:34

Right click on your server in EM, go to Edit. Let us know what it says.

Tara Kizer

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-09-15 : 14:14:08

quote:
Originally posted by Peso

The information about connected servers are missing from the registry. Restore your registry, the part about sql server.
Or re-register the servers manually.

Peter Larsson
Helsingborg, Sweden

I take it that this isn't a new question from this poster.

Tara Kizer

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-15 : 14:25:44

Tara,

I noticed that Lin100 posted following on 09/15/2006 13:44:37

quote:
Originally posted by Lin100

I do not know Which account I am using because I cannot see any object underneath
WIN-2000-SERVER within "SQL Server Enterprise Manager". There is nothing here.
Everything has disappear.

Peter Larsson
Helsingborg, Sweden

Luis Martin
Yak Posting Veteran

54 Posts

Posted - 2006-09-15 : 15:31:48

EM is a GUI tool. Sometimes lost conexion without any reason.
Since you are SysAdm, I suggest to reinstall SQL tools.

Lin100
Yak Posting Veteran

70 Posts

Posted - 2006-09-15 : 17:07:56

"EM is a GUI tool. Sometimes lost conexion without any reason.
Since you are SysAdm, I suggest to reinstall SQL tools."

1) What is the specific name of the SQL tools ? Is it "SQL Tools" ?

Lin100
Yak Posting Veteran

70 Posts

Posted - 2006-09-15 : 17:43:10

I remember that I ran a trial version of "Registry Mechanic 5.2" by PC Tools Software
today and that is why I am having a problem running SQL 2000 Server, since tkizer
mentioned about the registry information is missing.

I try to install SQL Server

SQL Server 2000 Components --> Clicked on "Install Database Server", but it said

Set up initialization error. Access is denied.
Source f:\x86\setup\sqlspre.ini
Target: D:\Winnt\temp\setupswl.ini

Luis Martin
Yak Posting Veteran

54 Posts

Posted - 2006-09-15 : 18:26:20

Did you remove "Registry Mechanic" before try to install SQl Server Tools?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-09-15 : 18:36:41

I never mentioned anything about the registry.

Tara Kizer

Kristen
Test

22859 Posts

Posted - 2006-09-16 : 01:48:12

"I never mentioned anything about the registry."

Yeah, but at least you are in this thread having your name taken in vain, unlike:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72015&SearchTerms=Tara

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources