SQL Server 2000 Enterprise Man - Reg new server? 1

[BadRabbit]

Hi,

I have a SQL Server 2000 database with my hosters, and I've set up a SQL server registration in Enterprise manager under a group. When I access this registration, I can log into my database remotely cos the profile on Enterprise Manager holds my username and password. So far so good.

But now I've got another database, so I want to set up another registration. The remote db is on the same server. However, Enterprise Manager doesn't let me set up a new SQL server registration. Whenever I try to create another SQL Server registration for this new one is just says that a registration already exists and stops. But I can't use the existing one because it has a different username and password.

I asked my hosters but they are worse than useless and just replied that they don't know. Can anyone here help out?

Thanks.

 

[SQLBill]

Registration in EM is NOT to a database. It's to a SERVER. You can only create one registration to a single server. When you expand on that server, you should see all the databases that you have access to.

It sounds like you will need to change your login and password on one of the databases.

-SQLBill

 

[BadRabbit]

Thanks! I didn't know that. I will change my username and password to be the same on both databases. It's a pity my hosters couldn't be bothered to suggest this!

 

[SQLBill]

To give them the benefit of the doubt, they may have thought you were trying to connect to two different servers. I had to re-read your post to realize you were talking about one server and two databases.

-SQLBill