Attach database failed for Server 'Server_name'. (Microsoft.SqlServer.Smo)

[bougie]

I have created a database (SCB) in sql server 2008 and I want to move this to SQL server 2008 express edition the problem is: when I attach the database (SCB) in the sql server 2008 express I got this message:

Attach database failed for Server 'Server_name'. (Microsoft.SqlServer.Smo)

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not find row in sysindexes for database ID 6, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'SCB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

Pleaase can anyone help on this problem

Kind regards,
bougie

[Oralloy]

Bougie,

I'm shooting in the dark, but it looks like you got your attach database name and/or credentials wrong.

Try starting with simple experiments, first. Make sure you can attach, then build from there.

[bougie]

Oralloy,
how can I set the database credentials?
and how can I be sure if I can attach or not ?
and I'm sure of the database name. and I atttached to you the error window
thank you very much for your efforts..

regards,

bougie

[Oralloy]

Bougie,

It looks like you have a permissions problem.

This Page is the quickie guide on attaching files, but I suspect you already know that.

Can you just copy the file across the network to your local system? Using the proper account, of course. If not, then you've got to fix your network credentials.

Also, make sure the share that you're using is capable of read/write; simply being able to read the file is probably not enough to run against it.

[Oralloy]

Also, this page is the "CREATE DATABASE" reference, but you probably new that.

[bougie]

thanks oralloy for your efforts I found out the solution for this problem,
thank you very much...

regards
Bougie

[Oralloy]

Bougie,

Glad to help.

Good luck with your project!

Oralloy