SQL Server - read-only error
Asked By sakshi gupta
29-Jan-10 02:32 PM
hello,
I have made software for client,in setup i added sql
server express as pre requisite. after installation wen m trying to
access the data ,its showing me datbase is in read only mode...
can
anyone help me in solving this problem. how can i give write permission
also so dat i can access my data and software strat running properly.
thanks in advance
Pranay Singh replied to sakshi gupta
I am not sure about this but you can give it a try.
in the microsoft sql server studio interface, right click on database name select properties and in properties window click on permissions. You can set permissions there like alter any database or create database for particular users
I hope this works but again not sure if this is what you are looking for...try it.
Thanks
Jonathan VH replied to sakshi gupta
ALTER DATABASE YourDatabaseName
SET READ_ONLY;
Jonathan VH replied to Jonathan VH
Oops, make that:
ALTER DATABASE YourDatabaseName
SET READ_WRITE;
net ADO is designed primarily for connected access ADO.net the disconnected access to the database is used In ADO you communicate with the database by making calls to an OLE DB provider. In ADO.NET you communicate with the database through a data adapter (an OleDbDataAdapter, SqlDataAdapter, OdbcDataAdapter, or OracleDataAdapter object), which makes calls to or the APIs provided by the underlying data source. In ADO you cant update the database from the recordset. ADO.NET the data adapter allows you to control how the changes to the dataset are transmitted to the database. On order to get assembly info which namespace we should import? System.Reflection Namespace How tab”) This will fill the dataset with the records starting at 5 to 15 .NET Database interview questions How do you call and execute a Stored Procedure in.NET? Give an Fill(ds1); dg1.DataSource = ds1; dg1.DataBind(); Answer2 Yes Dim cn as new OleDbConnection ( “Provider = Microsoft.Jet.OLEDB.4.0;”+ _ “Data Source = C: \ Documents and Settings \ User \ My Documents \ Visual Products”) DataGrid1.DataSource = ds.Tables(”Products”) What is the maximum length of a varchar in SQL Server? Answer1 VARCHAR[(n)] Null-terminated Unicode character string of length n, with a maximum
authentication to the site. So the settings for a particular user should be saved in database. . . but when i am trying to login i am getting following error. . . An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Here is the code for my web.config file. . . Please see the connectionString settings. . i
Error while installing SQL 2005 on Win 2003 Server Hi, I have installed Win 2003 Server standard edition to work with MOSS 2007. When i tried to install SQL server 2005, it is throwing error like "Your Operating system does not meet service pack requirement for this SQL server for this release." Can any one direct me, which version of Win 2003 Service Pack this issue. Please provide me the Link for SP download. Regards Saravanan. Step 1: Download SQL Server 2005 Express Edition The SQL Server 2005 Express Edition download page has three separate
uninstalling sql server express 2005 problem Dear Sir, When i am uninstalling sql server 2005 express through add remove program in control panel, my system reboots without uninstalling sql server. This occurs every time i uninstall sql server. Pls help me how to uninstall sql
How to find the password of my sql server Hi, I forgot the password of my sql server 2008 R2(express edition) but I kept remember password as marked so that I can enter into the To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the it. Try this and let me know. Hi, Option 1 : If there is any other SQL Server Login that is a member of sysadmin role, you can log in using that