SQL Server Error 5123 When Attaching Database

sql-server windows-security
Kevin Jones picture Kevin Jones · Jun 8, 2018 · Viewed 7.7k times · Source

I have two databases. Both are in the same folder. Both have, as far as I can tell, the exact same ownership and permissions. I can attach one but not the other - I get an error 5123.

For both files...

  • Owner is MSSQLSERVER

Permission entries:

  • MSSQLSERVER - Full control

  • OWNER RIGHTS - Full control

  • Administrators - Full control

I reviewed the other question referenced below but could not get any of the suggestions to work given my constraints listed above. I posted what finally worked below.

Answer

seraj picture seraj · Jul 25, 2020

Add your User to Permissions:

[your user] - full control  

MSSQLSERVER - Full control

OWNER RIGHTS - Full control

Administrators - Full control

Related questions

Cannot connect to SQL Server from PowerShell with domain credentials

I have a problem where I cannot connect to a SQL Server using domain credentials. Using the SA credentials it works and the query runs as expected. But when I use domain credentials, I get an error. Here is the …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More