Error 15401 Sql Server 2000
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: SQL 2000: Error 15401: Windows NT sql state 42000 sql error code 15401 User or group 'network\ASPNETACCESS' not found. Check the name again. For sql server error 15401 administrators "virtual" users only. SQL Server > SQL Server Manageability Question 0 Sign in to vote Hi everybody. microsoft sql server error 15401 I'm not sure if this is the right forum. I have a client that is experiencing the following error message in SQL 2000 when trying to
Sqlserver 15401
add a domain user that would also be shared by the web server: Error 15401: Windows NT User or group 'network\ASPNETACCESS' not found. Check the name again. Of course, I have actually changed the name of the user and network but still, largely the same. When adding users that are used for normal user error 15401 sql server 2012 accounts (like Mike Plumpkin or some other random person) it works fine. Does anybody know the reason or can anybody think of a reason for this? The server recently had to go through a catastrophic rebuild of AD and the SQL databases also had to be recovered from some crashed drives. (Word to the wise, never, EVER trust your client when they say their backups are being taken care of). The Domain users themselves already exist in AD to be added. We also ran the SQL script recommended in: http://support.microsoft.com/kb/324321/en-us to see if there were any duplicate SIDs. (there were none) Anybody seen this before? I've confirmed that the SQL Server can see the users I am looknig for if I browse for them with the ... button when attempting to add them. Also the top of the error window says: Microsoft SQL-DMO (ODBC SQLState: 42000) It does not seem to write anything to the SQL event logs when
United States Australia United Kingdom Japan Newsletters Forums Resource Library Tech Pro Free Trial Membership Membership My Profile People Subscriptions My stuff Preferences Send a message Log Out TechRepublic Search GO Topics: CXO Cloud Big Data Security Innovation Software Data Centers Networking windows nt user or group not found sql server 2012 Startups Tech & Work All Topics Sections: Photos Videos All Writers Newsletters Forums Resource Library Tech
Windows Nt User Or Group Not Found Sql Server 2014
Pro Free Trial Editions: US United States Australia United Kingdom Japan Membership Membership My Profile People Subscriptions My stuff Preferences Send a message
Error 15401 Sql Server 2014
Log Out TechRepublic | Forums | Networks Networks Register Now or Log In to post Welcome back, My Profile Log Out Recent Activity FAQs Guidelines Question 0 Votes Locked SQL Server User Error 15401 - How to work https://social.msdn.microsoft.com/Forums/sqlserver/en-US/18ce02d0-78e0-47df-8f96-02e4d25e477c/sql-2000-error-15401-windows-nt-user-or-group-networkaspnetaccess-not-found-check-the-name?forum=sqlkjmanageability around it? By esalo · 9 years ago Hi,I get this error message when I try and create a new user in MS SQL Server 2000 by attempting to create a new user with
Follow me on Twitter Search this Blog Archives June, 2009 (1) March, 2009 (3) February, 2009 (3) http://weblogs.sqlteam.com/joew/archive/2007/09/07/60323.aspx January, 2009 (3) November, 2008 (6) October, 2008 (3) September, 2008 (4) August, 2008 (10) July, 2008 (1) June, 2008 (2) May, 2008 (6) April, 2008 (6) March, 2008 (4) February, 2008 (8) January, 2008 (8) December, 2007 (3) November, 2007 (2) October, 2007 (5) September, 2007 (3) August, 2007 (4) Post Categories C# (rss) T-SQL (rss) Consulting (rss) Notification Services sql server (rss) Other Technologies (rss) Off Topic (rss) SQL Server (rss) Misc (rss) Current Events (rss) Community (rss) Reporting Services (rss) About me Recent Tweets (rss) << SQL Server 2000: when were the statistics updated? | Home | SSNS Status Codes >> Error 15401 when creating a new Login Recently, a client asked that I grant database access for several of error 15401 sql their new employees. The client uses SQL Server 2000 and has an Active Directory in place to manage domain users and resources. Windows Authentication is used almost exclusively in this environment. As I dutifully created the new Logins, granted access to the required databases, and assigned the users to the appropriate database roles, everything went as expected - that is, until I got to the last two employees on the list. As I attempted to create a new Login for those two employees, I received the following error: Error 15401: Windows NT user or group MYCLIENT\Sally not found. Check the name again. Fortunately, I had seen this error before and knew its likely cause. Each user in Active Directory is given a unique security identifier, or SID. It's statistically impossible for any two users to receive the same SID. A SID is associated with a user account throughout its existence. SIDs are the reason why you cannot simply create a new user account of the same name to replace a user account that was inadvertently deleted and expect the perm