How to move the database from one server to another server?

Using SQL Server 2005

I attached the database in Windows authentication Mode, then it detach the database, and then i try to attach the same database in sql authentication mode. It showing error as "cannot create a sysindex"

The d开发者_如何学运维atabase was created in windows authentication mode, It is working in all windows authentication mode. It was not able to attach in SQL Server Authentication mode.

How to solve this issue.

instead of detaching the database, pause all transactions and backup the database. Restore it on other machine. That should work.