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
 SQL Server Administration (2000)
 no databaes is server started with enterprise mgr

Author  Topic 

michaelm
Starting Member

1 Post

Posted - 2007-04-17 : 16:29:51
Hello all,

we changed the path for our database structure. We did it by changing master, tmpdb, msdb, model and user databases. For this we started sqlservr from the command line with the options -c -m [-T3608]. If I run the sqlservr now without any options from the command line I can see all expected databases from the enteprise manager. If I start the sqlserver service (for example with the enterprise manager) then I don't see a single database. Not even master. Any hint how to track down that problem? Btw. the sqlagent can't be started as well.

Thx for any help,
Michael

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-17 : 16:32:53
Did you use this method:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2k

Please post the errors in the application and system logs in Event Viewer.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -