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 |
|
surajkapadia
Starting Member
3 Posts |
 Posted - 2008-04-17 : 11:24:20
|
| I am using SQL Server 2000. I am logging on local machine. When I open "SQL Server Enterprise Manager," I only see following:Console Root --> Microsoft SQL Servers --> SQL Server Group --> (No items)The server is running properly and applications are able to access the database. Also, I can run "Query Analyzer" and view all databases.Please help to resolve the issue to view items in SQL Server Group.Thanks,Suraj. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-17 : 11:27:23
|
| You need to register you servers. Rightclick SQL Server group and click add new server and follow the instruction of the Add Server wizard |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-17 : 11:27:53
|
| Have you registered a server?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
surajkapadia
Starting Member
3 Posts |
Posted - 2008-04-17 : 11:38:24
|
| When I login to server with Local Admin Account, I am able to view items under SQL Server Group.Now, I am logging as a domain account on same server. Do I still need to register server as recommemded?Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-17 : 12:09:17
|
| Yup you need to |
|
|
|
surajkapadia
Starting Member
3 Posts |
Posted - 2008-04-17 : 14:51:44
|
| Visakh and Nigel,Thanks for your help. One more question, do I need to register server for each logon? If someone logs in the server with their domain account, they will not see any items in SQL Server Group unless they register the server, am I correct?Thanks,Suraj. |
|
|
|
|
|
|
SQL Server Group (No items) ... help