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

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:
>osql U sa
>password
>Sp_attach_db whatever',
>@.filename1 = C:\Program Files\Microsoft SQL
Server\MSSQL\Data\CollaborationTools.mdf',
>@.filename2 = C:\Program Files\Microsoft SQL
Server\MSSQL\Data\CollaborationTools.ldf'
>go

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.

Shaunokay, 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:

>osql U sa
>password
>USE master
>EXEC sp_dboption collaboration', read only', FALSE'
>go

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.

-shaun|||"SS" <stiznoit@.yahoo.com> wrote in message
news:dab7211.0404141325.6df43251@.posting.google.co m...
> But now I'm getting the error message:
> 'Could not run BEGIN TRANSACTION in database 'whatever' because the
> database is read-only.'

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.

> Any help/guidance would be appreciated.
> Thanks very much.
> Shaun|||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:

>osql U sa
>password
>USE master
>EXEC sp_dboption collaboration', read only', FALSE'
>go

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.

-shaun