Error SQL72014: .Net SqlClient Data Provider: Msg 15404, Level 16, State 11, Line 1 Could not obtain information about Windows NT group/user 'DESKTOP-QEMQDPL\alenc', error code 0x534.

Alen Cappelletti 992 Reputation points
2021-10-03T14:06:48.167+00:00

Hi, in many situation (not always) I got this error... now I'm trying to install using powershell a library.
"DESKTOP-QEMQDPL\alenc" was the name of my workstation before I renamed it... unfortunately after SQL SERVER installation.

It's my DEV environment and this was the name of the sysadmin windows authentication.

There is a way for fixe it definitely.
Alen

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,343 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 106.8K Reputation points
    2021-10-03T17:40:20.927+00:00

    What does SELECT @@servername return? May I guess DESKTOP-QEMQDPL?

    Do this:

    EXEC sp_dropserver 'DESKTOP-QEMQDPL'
    EXEC sp_addserver 'MACHINENAME', 'local'
    

    And then restart SQL Server. Verify that SELECT @@servername now returns the correct name.

    Also check sys.server_principals if there are any logins with the old machine name:

    ALTER LOGIN [DESKTOP-QEMQDPL\login] WITH NAME = [MACHINENAME\login]
    

0 additional answers

Sort by: Most helpful