Re: Windows Users and Machine Name Change

• Previous message: Kevin McDonnell [MSFT]: "RE: Windows Users and Machine Name Change"
• In reply to: Kevin McDonnell [MSFT]: "RE: Windows Users and Machine Name Change"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: 30 Dec 2004 13:38:45 -0800

Thanks for your help Kevin

My fault I forgot to mention that I added SQL server following KB
article 303774.

But my question still remains the same about windows users.

Here's what I did.

My machine name was ABC with users User1, User2 and User3.
I installed MSDE 2000 and added users as ABC\User1, ABC\User2 and
ABC\User3
Application works fine. Here's the connection string I am using

ServerName = "(local)\\XYZ";
ConnectionString = "server=" + ServerName +
";Trusted_Connection=Yes;database= Test";

Now I changed my machine name to DEF and added MSDE following KB 303774
MSDE works fine.

None of my users can connect to MSDE now. Do I need to delete
ABC\User1, ABC\User2 and ABC\User3 and create DEF\User1, DEF\User2 and
DEF\User3 in the new server?

I thought windows authentication in sql server works on SID and
changing machine name will not make any difference.

Are there any other things that I need to take care while changing
machine name.

Thanks

Sanjiv

• Previous message: Kevin McDonnell [MSFT]: "RE: Windows Users and Machine Name Change"
• In reply to: Kevin McDonnell [MSFT]: "RE: Windows Users and Machine Name Change"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]