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

[SS]

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.

Shaun

[SS]

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

[Greg D. Moore \(Strider\)]

"SS" <st******@yahoo.com> wrote in message
news:da*************************@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

[SS]

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