Re: Unable to add login
From: Steve Thompson (stevethompson@nomail.please)
Date: 12/04/02
- Next message: Walt: "RE: Exporting data to another server"
- Previous message: Birthe: "Login and users, Security scenario"
- In reply to: Terry Kargel: "Unable to add login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Steve Thompson" <stevethompson@nomail.please> Date: Wed, 4 Dec 2002 09:46:15 -0500
"Terry Kargel" <terry.kargel@questar.com> wrote in message
news:021e01c29a58$15851d00$d6f82ecf@TK2MSFTNGXA13...
> I am a new SQL Server admin. When our Windows NT4 admin
> recently changed my NT username to fit a new company
> standard I went into my SQL2000 server to update logins
> since I am using Windows authentication. I had no
> problem deleting my old username, but went I went to add
> my new username I got message "Error 15401: Windows NT
> user or group 'domain\username' not found. Check the
> name again". I found Article Q324321 on the Microsoft
> Knowledge Base and am reasonably sure that none of those
> problems exist. Have others encountered this problem
> and, if so, do you have any suggestions for getting around
> this problem? I did have our NT admin delete my new
> username and then recreate it, and then I could add it to
> SQL2000 but it was a big hassle reestablishing all my user
> profile stuff. Other users that I've had this problem
> with would not be happy to go through what I was willing
> to go through to get more information about the problem.
If the user name had been renamed, you should not have had to do anything
further with SQL Server. Internally, SQL Server 2000 uses the SID so is
unaffected by account renames. Account deletion and new accounts do add
another layer of complexity in management.
Steve
- Next message: Walt: "RE: Exporting data to another server"
- Previous message: Birthe: "Login and users, Security scenario"
- In reply to: Terry Kargel: "Unable to add login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
