Question Locked

User Profile and Login Name Conflict

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I have two machines one is running Windows XP Pro SP2 and other having Windows Vista Home Premium and on both machines I have SQL Server 2000 and SQL Server 2005 installed.
My question is on both machines in order to login to SQL Servers using Windows Authentication (I set up using Mixed Mode) I need to add windows NT login name in administrator group of SQL Server. I have add the NT login name to admin security group of SQL Server but when I tried to login to the server using Windows Authentication I got error message that user name and password is incorrect.

Then finally I found out that on both the machines I changed the login name of the Windows NT administrator but the user profile still having the old login name, when I changed the Login name it just changed the login name but didn't changed the user profile associate with the old login name when I create the user first time. So I had to add the user profile name then the SQL Server on both machines allowed me login using windows authentication.

I would like to know is there a way to change the user profile to reflect the new windows Login name in order to avoid the confusion?

Thanks in advance.

8 replies

by older mycroft

And all I've had to do is read your post.

I'm sorry, I've read and re-read and re-read your post and I'm more confused than ever.

by syedali1975

Well, I can understands that it might confused some peoples and some can get it straight.

If you could let me know which part confused you then I can precise more on that part.

I tried to explain so that the question should not pose any confusion.

In simple term I wanted to ask is there a way to change the user profile to reflect the current user login name, because I have changed the Login name but still new login name associate with the old user profile which was created for the first time.

Because of this if I have to use Windows Authentication I have to provide the User Profile name not the current user Login name otherwise the windows authentication is not working with the current Login name.

by spambot

Do you mean that even when u use the new domain ID, it still hook up back to the old domain ID's profile? U may want to check if the user acc has a profile path specified.

by syedali1975

I agree with you but could you please let me know how to do it safely.
Because if I try to create a folder in 'C:\User\' in windows vista and 'C:\Documents and Settings' in Windows XP with the new login name and move all the data from old profile to the newly created folder then it wont accept it, because when the user profile created first time it has some registry entries which cannot be created in this way.

So how would I be able to create new user profile which should be make changes in the registry also and shouldn't pose any problem.

by syedali1975

I think you are correct, the new domain ID still hooks up to the old domain ID Profile.
I sound bit naive but how should I check the user Account has a profile path specified, please be precise on this one. It seems that this should resolve the issue.

This discussion is closed to new replies.