SQL SERVER 2016 error when modifying “User Mapping”.
TITLE: Microsoft SQL Server Management Studio
——————————
Rename failed for User ‘dbo’. (Microsoft.SqlServer.Smo)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.37971.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rename+User&LinkId=20476
——————————
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
——————————
Cannot alter the user ‘dbo’. (Microsoft SQL Server, Error: 15150)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=13.00.5026&EvtSrc=MSSQLServer&EvtID=15150&LinkId=20476
——————————
BUTTONS:
OK
——————————
Solution:
Log in to SQL SERVER STUDIO with SA and execute the following command.
use testdatabaseName
EXEC sp_changedbowner ‘sa’,’true’
Similar Posts:
- [Solved] HTTP could not register URL http:/+:6001/
- This project references NuGet package(s) that are missing on this computer. Enable NuGet Package …
- [Solved] yarn: Unable to load the File C:\Users\Administrator\AppData\Roaming\npm\yarn.ps1, Because running scripts is prohibited on this system.
- [Solved] JDBC connection to SQL Service reported an error: “the driver cannot establish a secure connection with SQL server by using SSL encryption“
- error: Microsoft Visual C++ 14.0 is required. Get it with “Microsoft Visual C++ Build Tools”:
- [Solved] Vue : The file D:\Program Files\nodejs\node_global\vue.ps1 could not be loaded, because running scripts is disabled on this system.
- Gulp Serve Error: gulp.ps1 [How to Solve]
- An error occurred during local report processing: report definition has an invalid target namespace
- [notes] solve the problem of cannot find one or more components… When starting SQL Server Management Studio 17
- How to Solve .NET 6 running on win7 SP1 error