|
Home > Archive > MS SQL Server > July 2005 > lossing users after restore
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
lossing users after restore
|
|
| jaylou 2005-07-22, 9:23 am |
| Hi all,
I just restored a database from one server to another. in EM on win2K
machine I was able to see 5 users, 3 with login names 2 without.
On XP proff machine same EM version I can only see the 3 with login names.
Has anyone ever seen this before? And do you have a reason, solution for
this?
TIA,
Joe
| |
| Mike Epprecht (SQL MVP) 2005-07-22, 9:23 am |
| Hi
Have you granted those 'missing' logins access to the SQL Server on the XP
machine?
Then run sp_change_users_logi
n against that DB on the XP SQL server to get
the users in Sync.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"jaylou" wrote:
> Hi all,
> I just restored a database from one server to another. in EM on win2K
> machine I was able to see 5 users, 3 with login names 2 without.
> On XP proff machine same EM version I can only see the 3 with login names.
>
> Has anyone ever seen this before? And do you have a reason, solution for
> this?
>
> TIA,
> Joe
| |
| jaylou 2005-07-22, 11:23 am |
| Thanks for the response.
the only way I was able to get to see the users on the XP machines was to
run sp_change_user_login
s.
My question was, Have you seen the issue where I can see the missing logins
in Win2k EM version 1 but I can not see them in XP Proff EM version 2
Thanks agian,
Joe
| |
| Tibor Karaszi 2005-07-22, 1:23 pm |
| Same service pack of SQL Server? Also, are you using same version of Enterprise Manager against each
server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"jaylou" <jaylou@discussions.microsoft.com> wrote in message
news:F02CC433-7CCA-4D7A-8C16- FBC254ADC453@microso
ft.com...
> Thanks for the response.
>
> the only way I was able to get to see the users on the XP machines was to
> run sp_change_user_login
s.
>
> My question was, Have you seen the issue where I can see the missing logins
> in Win2k EM version 1 but I can not see them in XP Proff EM version 2
>
> Thanks agian,
> Joe
>
|
|
|
|
|