Table of Contents
Sometimes your system may display an error stating that the sqlserver error 15404 database is being copied. This problem can be caused by a number of reasons.
PC running slow?
- 2 minutes to read.
In Aria-label = “Article In This Article
Details
attribute | value |
---|---|
Product name | SQL Server |
Event ID | 15404 |
Event Source | MSSQLSERVER |
component | SQL Engine |
Symbolic name | SEC_NTGRP_ERROR |
Message text | Unable to get information from Windows NT user / group “Users”, error code. |
Explanation
15404 is used for authentication when an invalid principal is specified. Or, impersonation of each Windows account fails because there is no full trust relationship between the SQL Server service account and the domain of that Windows account.
User Response
If this error is entirely the result of a lack of trust between the SQL Server online account and the domain of the Windows account, the following steps can certainly resolve the error:
-
Use a credentialThe one you see is in the same domain as the Windows user to find the SQL Server service.
-
If SQL Server typically uses a computer account such as Network Service or Local System, the computer must be a trusted domain for these Windows users.
-
Use a SQL Server account.
I created an online hospital management system database with 10 tables. Now I want to create a database diagram given this database, but I am getting some of the following errors. Please share your knowledge to fix this error. Thanks.
NAME: Microsoft SQL Server Studio
administration
Failed to get information for Windows NT user / group “HAIER-PC 92347”, error code 0x534. (Microsoft SQL Server Error: 15404)
I go crazy easily. I am your professional programmer and mainly deal with security and database issues.
However, we had a quick reboot server after the MS update. I restored my entire computer from a Windows backup, but found that I could restore my computer byBecause you cannot use a Windows backup to restore your database to another computer, AFAICT. Instead, I need real database backups for this.
When I search for regular SQL Server backups, I find an error in the properties docs:
[298] SQL Server Error: 15404, Windows NT user / group information ‘WIN-443PT0LULQU Administrator’ could not be displayed, error coupon code 0x534
PC running slow?
ASR Pro is the ultimate solution for your PC repair needs! Not only does it swiftly and safely diagnose and repair various Windows issues, but it also increases system performance, optimizes memory, improves security and fine tunes your PC for maximum reliability. So why wait? Get started today!
Basically, I turned on SSMS SQL Server Viz Agent, then created an employer plan to perform full backups on our company’s SQL Server instance, and scheduled this for day to day operations.
However, when I manually ask this method to do this work – make sure all functions are working correctly – I get an error:
[298] SQL Server Error: 15404, Windows NT Group / Windows NT User Information 'WIN-443PT0LULQU Administrator' could not be retrieved, code 0x534 failed
This sounds like an NT permissions issue to me – is it an XP agent anyway? – Initiatives to obtain user rights were discussed earlier – and this is not successful.
There issome weird – it probably won’t be the “WIN-443PT0LULQU” machine – which can’t be found – is WTH causing SQL Server to take its original place ?!
I want this to be done as an administrator – on the local machine ‘BUILD-SERVER’ – not always using the garbage name it logs …
I’m completely overwhelmed here, and the whole process is insane.
How is it not possible in 2018 to click a few appropriate wizard-style NEXT buttons and configure Windows / SQL Server for regular correct support?
In SQL Server 2012, be sure to configure scheduled backup maintenance plans for the SharePoint 2013 farm databases. When you try to run a maintenance plan, you receive all of the following errors:
[date] [time] ,, error, [298] SQLServer error: 15404Unable to getWindows NT user / group information [account you are logged intoType error] Code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
- Define the domain account that you want to use to connect to SQL Server (for example, spAdmin) to create recovery plans and database maintenance ddata farms. Active
- Start the user and computer directory as an administrator.
- Access this account in the directory.
- Right-click this account type, select and Properties.
- Select the Security tab.
- Click the Add button.
- Enter the plan for the domain of the SQL Server service and click OK.
- In the Properties dialog box, select this account from the Specific Group or Name list.
- Make sure read is allowed and all of its subordinate permissions (for example, read restrictions, general read information, etc.). Disabling and enabling read automatically activates any additional read permissions.
- Click OK.
- SharePoint 2013: Service Account Configurations and Permissions
- First software for administration and organization of accounting in SharePoint 2013
- The above error will appear in the SQL Server error logs: [Server Name]> Administration> SQL Server Agent> Error Logs.
Improve the speed of your computer today by downloading this software - it will fix your PC problems.
멋진 데이터베이스를 복사하는 동안 SQLserver 오류 15404를 수정하는 데 걸리는 시간
Como Corrigir O Erro 15404 Do SQLserver Ao Copiar Qualquer Banco De Dados
Come Correggere L’errore SQLserver 15404 Durante La Copia Di Un Database
So Beheben Sie Den SQLserver-Fehler 15404 Beim Kopieren Einer Datenbank
Så Här åtgärdar Du SQLserver -fel 15404 När Du Kopierar En Databas
Как исправить ошибку SQLserver 15404 при копировании базы данных
Hoe – SQLserver-fout 15404 Oplossen Tijdens Het Kopiëren Van Elke Database
Comment Commencer Par Les Problèmes SQLserver Error 15404 Lors De La Copie D’une Base De Données
Jak Naprawić Błąd Serwera SQL 15404 Podczas Kopiowania Bazy Danych
Cómo Reparar El Error 15404 Del Servidor SQL Mientras Se Copia Una Base De Datos