Table of Contents
SQL Server Error : 15063 Details
SQL Server Error: 15063
Severity: 16
Event Logged or not: No
Description:
The login already has an account under a different user name.
Severity 16 Description:
Indicates general errors that can be corrected by the user.
Reading sql server error log location from SQL Query
Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.
USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go
For other ways to read and find error log location please our article https://sqlserver-dba.co.uk/error-log/sql-server-identify-location-of-the-sql-server-error-log-file.html
Solution for Resolving the Error
Easy fix for this error would be
The login was incorrectly linked to the database as the dbo. Because this account built a database during the installation, this happened.
sp_changedbowner 'sa'
Then just re-map your login DomainName\UserName to the database (double click on the login->User Mapping->check your DB->check Datareader/Datawriter->Ok)
Picked it up from here http://www.sqlservercentral.com/Forums/Topic788865-146-1.aspx
hope this helps some one
SQL Server Error Code and solution summary
SQL Server Error: 15063
Severity: 16
Event Logged or not: No
Description:
The login already has an account under a different user name.
Ԍreat work! Thiѕ iѕ thee typ of informatioin tһɑt ѕhould be shared aгound the
internet. Shame on Google fοr no longer positioning
tһiѕ put uup upper! Comе on over and consult with my site .
Thɑnk you =)