Error 3906 In Sql Server 2005
Contents |
sqlserver error 3906 Recent PostsRecent Posts Popular TopicsPopular Topics Home microsoft sql server error 3906 Search Members Calendar Who's On Home » SQL Server 2008 » SQL Server failed to update database because the database is read-only sql server 2008 - General » Grant db_datareader database role to a user... 17 posts,Page 1 of 212»» Grant db_datareader database role to
Failed To Update Database Because The Database Is Read-only +(microsoft Sql Server, Error: 3906)
a user for a readonly database Rate Topic Display Mode Topic Options Author Message gary1gary1 Posted Thursday, January 13, 2011 2:11 PM Say Hey Kid Group: General Forum Members Last Login: Monday, June 20, 2016 10:56 PM Points: 701, Visits: 2,227 Hi,I have configured error 3906 sql log shipping for a database Mydb and the secondary is in Standby mode.Now I have created a login called scott on secondary instance and trying to map that login to the standby mode database. But I'm getting the below error:TITLE: Microsoft SQL Server Management Studio------------------------------Create failed for User 'scott'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1015+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+User&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Failed to update database "Mydb" because the database is read-only. (Microsoft SQL Server, Error: 3906)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=3906&LinkId=20476------------------------------BUTTONS:OK------------------------------Please advice Post #1047578 Steve Jones - SSC EditorSteve Jones - SSC Editor Posted Thursday, January 13, 2011 2:20 PM SSC-Dedicated Group: Administrators Last Login: Today @ 12:13 PM Points: 34,214, Visits: 18,366 You cannot make changes to a db in standby mode. Follow me on Twitter: @wa
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create failed to update database because the database is read-only alwayson new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members |
Failed To Update .mdf Database Because The Database Is Read-only
Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server
Failed To Update Database Because The Database Is Read-only Visual Studio
2005 Forums Other SQL Server Topics (2005) Need help Error :3906 in sql server 2005 Reply to Topic Printer Friendly Author Topic scsfdev Starting Member Singapore 4 Posts Posted-12/05/2008: 02:51:26 http://www.sqlservercentral.com/Forums/Topic1047578-391-1.aspx Hi all,I have one problem and so need ur guys F1.Problem issue: I moved my DB from SQL Server Location (Program/MSSQL/..) to a location i created (D:/Database).And then I attach the DB to SQL Server, the error popup. it said DB read-only. (When I move back my DB to SQL Server default location and then attach again, it worked well!) I already give all permission to D:/Database folder (including all http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=115739 users still not work).Don't know what I missed out.Can anybody give me some hints or some links or some help....Thanks.Visual Studio 2005 Pro + SQL Server 2005 sodeep Flowing Fount of Yak Knowledge USA 7174 Posts Posted-12/05/2008: 09:33:38 Use Alter Database ... Modify file instead. Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) Service Broker (2005) Replication (2005) High Availability (2005) Analysis Server and Reporting Services (2005) Express Edition and Compact Edition (2005) Other SQL Server Topics (2005) SQL Server 2000 Forums SQL Server Development (2000) SQL Server Administration (2000) Import/Export (DTS) and Replication (2000) Transact-SQL (20
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help https://www.experts-exchange.com/questions/22602410/Readonly-Database-SQL-Management-Studio-Express.html Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Readonly Database - SQL Management Studio Express Want to Advertise Here? Solved Readonly Database - SQL Management Studio Express failed to Posted on 2007-05-30 MS SQL Server 2005 1 Verified Solution 4 Comments 4,779 Views Last Modified: 2012-08-14 I have database setup on one server using SQL 2005 now when I try to detach and attached that database on workstation with SQL Server Express 2005, it came up as Readonly message I get this message when try to alter database. failed to update Message is "Failed to Update databse "database name" because the database is read-only. (Microsoft SQL Server, Error: 3906)". Server: Windows 2003, SQL 2005, Database compatibility level is SQL Server 2000 (80) Workstation: Windows XP Professional, SQL Express 2005, Compatibility level SQL Server 2005 (90) Note: I am not able to change the compatibility level on workstation because its readonly. Thanks 0 Question by:punjwani Facebook Twitter LinkedIn Google LVL 27 Best Solution byptjcb Do the service accounts have full permissions on the folder? Have you tried: sp_dboption 'table name', 'Read Only', 'False' Go to Solution 4 Comments LVL 33 Overall: Level 33 MS SQL Server 2005 4 Message Expert Comment by:hongjun2007-05-30 Did you happen to attach from a CD? Make sure the mdf file is not read-only 0 LVL 1 Overall: Level 1 Message Author Comment by:punjwani2007-05-30 I checked both files mdf and ldf attributes are not Read-only. 0 LVL 27 Overall: Level 27 MS SQL Server 2005 16 Message Accepted Solution by:ptjcb2007-05-30 Do the service accounts have full permissions