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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2009-10-02 : 04:27:56
|
| Hi there,This is my first time using SQL server 2000 (I use 2005). I've used remote desk top into one of our servers and have opened enterprise manager to access a sql server. however, on opening I dont see any servers, only (local)(winodws NT) and if I attempt to open that I get the message:A connection could not be established to (local)Reason: Login failed for user ...Please verify sql server is running and check your reg properties...I'm unsure what to do at this point. Do I have to personally register so I can view all the databases on this server?Hope someone can helpThanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-02 : 11:13:58
|
| you need to register the sql servers you want to access in enterprise manager.http://www.serverintellect.com/support/sqlserver/connect-database-enterprise.aspx |
 |
|
|
master
Starting Member
4 Posts |
Posted - 2009-10-15 : 06:03:04
|
| you can use ip address bro (new registration sometime its appeared when you are in work group computer but the server was in a domain or vice versa) |
|
|
|
cidr
Posting Yak Master
207 Posts |
Posted - 2009-10-21 : 05:18:06
|
| Thanks for the responses folks. I'll remember your suggestions for the future:) |
|
|
|
|
|
|
connecting to a server