I had a databases running on SQL Server (EVALUATION VERSION).

I moved it to another system running:

-Windows 2000 Server
-IIS 5.0
-BlueDragon Server
-MSDE

I applied all of the latest service packs, security updates, etc...
Intalled SQL Server Web Data Administrator and .NET framework.

I attached the database using sp_attach_db:
[quoted text, click to view]

I added my datasource using the ODBC Admin Tool...
Verified it using the BlueDragon Admin Datasources page....

But now I'm getting the error message:

'Could not run BEGIN TRANSACTION in database 'whatever' because the
database is read-only.'

Any help/guidance would be appreciated.
Thanks very much.

[quoted text, click to view]

Unless I'm missing something, it's pretty obvious. For some reason database
"whatever" has the read-only flag set.

See db_options to reset.

And since of course since it's read only, there's no point in allowing a
transaction since you can't do anything in it anyway.


[quoted text, click to view]

okay, thanks for the guidance....

here's what i did:

i went to the location of the .mdf and .ldf files and made sure the
read only attribute wasn't checked.

i then entered the following commands via the cmd prompt:

[quoted text, click to view]

I verified by viewing the database properties in the Web Data
Administrator. The Status of the Database now reads ‘Normal' not
‘Standby'.

Thanks very much.