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.

Question

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 1,047

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

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Erland Sommarskog 134.7K MVP Volunteer Moderator

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]

Alen Cappelletti 1,047 Reputation points

2021-10-03T20:59:52.097+00:00

Hi Erland,
thank for your response....
I deleted the original "old" LOGIN, after with dbatools reassign all DB's to owner sa

Set-DbaDbOwner -SqlInstance localhost -ExcludeDatabase XXX,XXX1,XXX2,XXX3

and I reinstalled with success my powershell librar, anyway those are the result of the query you asked me

SELECT @@servername
HP-PROBOOK

EXEC sp_dropserver 'DESKTOP-QEMQDPL'
The server 'DESKTOP-QEMQDPL' does not exist. Use sp_helpserver to show available servers.

EXEC sp_addserver 'MACHINENAME', 'local'
The server 'MACHINENAME' already exists.

Thanks, Alen
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator

2021-10-03T21:01:35.83+00:00

Seems like the issue was with the logins and not @@servername.
Alen Cappelletti 1,047 Reputation points

2021-10-03T21:42:04.527+00:00

But surely related to workstation renaming...
;: (
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator

2021-10-03T21:45:29.17+00:00

Yes, I've also done renaming and installing of SQL Server in the wrong order myself a few times. :-)

Share via

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.

0 additional answers

Your answer