By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Why two different views?

P: n/a
Hello all. I have an administrative account setup in Win XP Pro and I also
have a user account named "Jim Richards" (kinda logical, huh?). I previously
had to switch to the admin account to access the SQL Server Databases. Then
I gave myself admin privalidges to the SQL Server to the "Jim Richards"
account. I can now access SQL Server, update and change the database entries
(structure and data) from the "Jim Richards" account. But I get two
different views when I enter the Enterprise Manager and expand the Server
Group Line. Can anyone explain why I am getting two different views - one
which shows the Server name as "Local"

<a <a href="http://www.jimwrichards.com/images/JimRichardsView.gif">

JiJimRichardsView</a>

and the other which shows the Server name as "JIMRICHA" <a
href="http://www.jimwrichards.com/images/Admin24View.gif">Admin24View</a>?
Thanks in advance, Jim.
Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Depends how you reqister the server with enterprise manager for the
account.
(local) is the default instance on the current machine.
If the machine is called JIMRICHA then they will access the same server.

You can get them to look the same by deleting one registration and
adding it again.

Nigel Rivett
www.mindsdoor.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 23 '05 #2

P: n/a
Thank you Erland Sommarskog and Nigel Rivett. I was able to delete the
registration that used the "LOCAL" name and I re-registered it with the
"JIMRICHA" name. Now both accounts use the same SQL Server name and I feel
much better. Again I thank you both. Jim

"Nigel Rivett" <sq***@hotmail.com> wrote in message
news:41********@127.0.0.1...
Depends how you reqister the server with enterprise manager for the
account.
(local) is the default instance on the current machine.
If the machine is called JIMRICHA then they will access the same server.

You can get them to look the same by deleting one registration and
adding it again.

Nigel Rivett
www.mindsdoor.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.