SQL Server error 916

I get this error when I try to attach a database.

error message: An exception occured while executing transact sql statement or batch.

I have copied my database in the Data folder of an SQL Server server. I want to configure the database in SQL Server, but when I try to attach the database, it gives the 开发者_StackOverflowerror.

I have also tried to change the permissions related to the database.

The error you're getting and error 916 are different! (I am not an expert, I just read over the Internet.)

error 916 is this:

The server principal “username” is not able to access the database “databasename” under the current security context. (Microsoft SQL Server, Error: 916)

Anyway, to resolve the 916 error:

1. After starting Management Studio 2008, select Databases in the Object Explorer once.

2. If the Object Explorer Details are not already showing, select View from the toolbar then select Object Explorer Details.

3. Right click on any column header and make sure that “collation” is not checked.

4. Refresh the database list by clicking the Refresh button located at the top of the Object Explorer Details panel. You should have now have full access to your database at this point.

I (shamefully) copied from Microsoft SQL Server, Error: 916 and Resolving Microsoft SQL Server, Error: 916.

And to solve the error you've written in your explanation try You may receive error messages when you use the Configure Distribution Wizard in SQL Server 2005.

I hope it helped!