Error Code 0x534 Sqlstate 42000
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies
Error Code 0x534 Sql Server
of this site About Us Learn more about Stack Overflow the company Business errorcode 1064 sqlstate 42000 Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question
Errorcode 904 Sqlstate 42000
_ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it errorcode 936 sqlstate 42000 only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Changed server name, now maintenance plan fails up vote 3 down vote favorite I am using SQL Server 2008 R2. When I try to execute a maintenance plan I get the following error: Message error code 1064 sql state 42000 [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'WIN-6QFI9JAK804\sqladmin', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin) I ran the following queries: sp_dropserver 'WIN-OldName' GO sp_addserver 'VM-MSSQL-2008R2', local GO I then restarted the MSSQLSERVER service and the agent service. When I run select @@servername I do get VM-MSSQL-2008R2 returned however the original error persists when I try to execute the maintenance plan again. Is there another step that I haven't performed yet? UPDATED: I ran: select * from msdb.dbo.sysssispackages and noticed that the only plan is called Backups. So I instead ran the query: UPDATE msdb.dbo.sysssispackages SET ownersid = SUSER_SID('VM-MSSQL-2008R2\sqladmin') WHERE name = 'Backups' I ran the following two selects to make sure that the are the same: select SUSER_SID('VM-MSSQL-2008R2\sqladmin') select ownersid from msdb.dbo.sysssispackages WHERE name = 'Backups' And they both return the same value. When I run the plan, I get the same error message as before. (I have created a new Backup Plan, but I'd still like to figure out why this one is working just for knowledge's sake) sql-server sql-server-2008-r2 maintenance-plans share|improve this question edited Apr 5 '13 at 15:00 StanleyJohns 5,28711341 a
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove
Sql State 42000 Sql Error Code 8180
From My Forums Answered by: MS SQL server maintenance translating sqlexception with sql state 42000 error code 1064 plan failed: error code 0x534. [SQLSTATE 42000] (Error 15404)) SQL Server > SQL
Sqlserver Error: 15404, Could Not Obtain Information About Windows Nt Group/user
Server Express Question 0 Sign in to vote hello, we have changed the name of MS SQL server 2005 from XYZ to http://dba.stackexchange.com/questions/39298/changed-server-name-now-maintenance-plan-fails ABC using sp_dropserver
up Stay up to date: Daily newsletters with brand new articles, scripts, editorials and a Question of the Day help you keep on top of http://www.sqlservercentral.com/articles/SQLServer/135372/ SQL Server. Sign up No thanks Want more great articles like this? Sign up for fresh SQL Server knowledge delivered daily. Sign up Thank this author by sharing: Rate this Join the discussion http://www.sqldbadiaries.com/2011/02/25/unable-to-determine-if-the-owner-of-job-has-server-access/ Add to briefcase Fixing Maintenance Plan Error code 0x534 By Ganapathi varma, 2016/03/24 Have you ever changed Server name on which SQL Server instance is installed? One of my friends changed the hostname of state 42000 a Windows server with SQL Server already installed. After this, the SQL Server maintenance plan jobs started to fail. As we know, internally SQL Server still shows the old hostname this must be dropped manually. Otherwise your SQL Server maintenance plan jobs fail with this error. The Job failed: Could not obtain information about Windows NT group/user'XXXXXX\Administrator', error code 0x534. [SQLSTATE 42000] (Error15404)) In this post, I will sql state 42000 show you the procedure to resolve the errors and execute the SQL Server Agent Maintenance Plan jobs successfully.Below is the error screenshot showing job failure in the SQL Server agent logs. The error is highlighted in the image in red. First, connect to your SQL Server instance with SQL Server Management Studio and run the below queries to check SQL Server name: use master select @@SERVERNAME -- The current hostname SQL Server recorded select SERVERPROPERTY('machinename') -- The hostname the operating system recorded In the below screenshot, the server name and machine name are different. Run the below shown T-SQL scripts to drop the old server name, and then it add back the SERVERNAME to match the operating system’s hostname. In the below screenshot, first we dropped old server name. In the below screenshot, we have added new server name using T-SQL. Now, log into the SQL Server with a “sysadmin” privileged user. Go to SQL Server logins, and you can still see the oldServername\administrator login bound with the SQL Server engine. Drop the login “OldServername\administrator” and create a new windows login as “NewServername\administrator”, adding the sysadmin Server role. CREATE LOGIN [NewServername\administrator] FROM WINDOWS; GO EXEC sp_addsrvrolemember N'NewServername\administrator', N'sysadmin'; In the below screenshot, we