473,320 Members | 2,146 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
Jul 20 '05 #1
3 7980
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
Jul 20 '05 #2

"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

Jul 20 '05 #3
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
Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
by: noah | last post by:
Does PHP have a feature to associate Cookie sessions with a persistent database connection that will allow a single transaction across multiple HTTP requests? Here is how I imagine my process: I...
1
by: Steve Thorpe | last post by:
Hi have have two linked SQL Servers and I am trying to get things working smootly/quickly. Should I be using 'BEGIN TRANSACTION' or 'BEGIN DISTRIBUTED TRANSACTION' ? Basicly, these SPs update...
4
by: Leaf | last post by:
Greetings, I've been reading with interest the threads here on deadlocking, as I'm finding my formerly happy app in a production environment suddenly deadlocking left and right. It started...
2
by: gabriel | last post by:
Greetings, I am adding foreign keys to a database and saving the generated scripts. What I do not understand is that all script begin with empty transactions. Why ? Example follows : /*
3
by: t2581 | last post by:
Hi , I run restore with rollforward In job in output, last commited transaction time less then backup image time Is it normal ? RESTORE DATABASE PRICE_V8 FROM "E:\BACKUP" TAKEN AT...
3
by: Eric Porter | last post by:
Dear All, I have a VB6.COM program using a VB6.COM DLL, which in turn uses ADODB that performs various bits of SQL. I have re-written the VB6.COM DLL in C#.NET (with a VB6 shell), which uses...
1
by: Horace | last post by:
Hello I am writing an ASP.NET / SQL-Server application and wanting to know when to connect/begin-transaction and commit/disconnect. I have a common module which I call at the beginning of...
9
by: Eugene F | last post by:
The database is currently in the circular logging mode (no log archiving). I want to track the database transaction log switch history in form of (switch-timestamp, active-log-sequence-number) to...
0
by: cmrhema | last post by:
Hello I am using Asp.net with VC# having backend SQL SERVER I have written a procedure in sqlserver as below. It does not throw any error in sqlserver. This is the procedure set ANSI_NULLS...
2
by: =?Utf-8?B?Q2hyaXMgRmluaw==?= | last post by:
I have the following requirements and am looking to make this into a c# transaction. 1. Read from a file into a memory stream 2. Insert the stream into a DB 3. Delete the file Is it possible...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.