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.
| Author |
Topic |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2008-01-02 : 14:54:29
|
| Guys,This morning I came in and found out nothing is there under EM of SQL 2000. All applications are running connected to database and working fine. But I can't see any database, Jobs, Security through EM, I can go see the data through QA or SQL 2005 SSMS.Also when I tried to execute my SQL BACKUP jobs through maintenance plan in SQL 2000, I errors stright away.Please help me to resolve this issue.Thanks in advanceSKR |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-02 : 14:55:40
|
| Sounds like you've lost your permissions.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2008-01-02 : 15:02:59
|
| I have sa login, I connected with that. Also I can see all database through SSMS of SQL 2005.How could it be permission issue? is there anyway to resolve this?Many Thanks Tara..SKR |
|
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2008-01-02 : 15:23:29
|
| Here is the error which I recieved after last night backup, which might help.Executed as user: NZADMIN\sqlaccess. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.I can really start SQL Server box easily as this is production server, so I have to investigate WHY this happened and try to resolve it as qucikly as possible while online.Any more ideas or help pelase?ThanksSKR |
|
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2008-01-02 : 15:55:13
|
| I don't know is it a bug in SQL 2000 EM.I had one database offline. I removed that databases bingo I can see everything now.I got all back and working... Thanks for your help Tara.SKR |
|
|
|
|
|
|
URGENT Help required Please..