In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!
Change Database permission to Read/Write using Visual Studio 2010
Please let me know how one can change a database's permissions to read/write using queries, in Visual Studio 2010.
If possible, please give me the step by step procedure.
Thanks!
If possible, please give me the step by step procedure.
Thanks!
Who is Participating?
Hi,
You should have the corresponding rights and launch following query :
ALTER DATABASE mydatabase READ_WRITE
Good luck !
You should have the corresponding rights and launch following query :
ALTER DATABASE mydatabase READ_WRITE
Good luck !
Can't I execute the query using Visual Studio 2010? I remember someone saying in a forum that it can be done. Maybe he's wrong. Please let me know.
There should be a way to do it through Visual Studio by using :
Data -> T-SQL Editor
Build new connection to the corresponding server
then execute the given query.
Data -> T-SQL Editor
Build new connection to the corresponding server
then execute the given query.
Yeah.. I figured that out. But, I'm not sure how to proceed from there. Where exactly do I enter the query and how do I run it?
you type the query I gave you, you click on Execute.
but if you wonder those kind of thing, I guess you don't have the rights to do it.
but if you wonder those kind of thing, I guess you don't have the rights to do it.
I'm sure I have the permissions.
I right click on the database name under, Data Connections, and then say 'New Query', and it then shows me a list of tables. Here's where I'm not sure what to do.
Even if I select some random tables, and enter the query, I don't see any 'Execute' button or option.
I right click on the database name under, Data Connections, and then say 'New Query', and it then shows me a list of tables. Here's where I'm not sure what to do.
Even if I select some random tables, and enter the query, I don't see any 'Execute' button or option.
Hi,
Please refer to this document : http://msdn.microsoft.com/en-us/library/aa833418.aspx
then, apply the statement I gave in first post.
Please refer to this document : http://msdn.microsoft.com/en-us/library/aa833418.aspx
then, apply the statement I gave in first post.
Thanks for the link.
When I try to execute "ALTER DATABASE ASPNETDB.MDF READ_WRITE", it says "Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'."
"ALTER DATABASE ASPNETDB READ_WRITE" does not woek as well.
When I try to execute "ALTER DATABASE ASPNETDB.MDF READ_WRITE", it says "Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'."
"ALTER DATABASE ASPNETDB READ_WRITE" does not woek as well.
Yes. That is the default database created by Visual Studio for an website.
I get the following error for the second statement:
"Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'READ_WRITE'."
I get the following error for the second statement:
"Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'READ_WRITE'."
When I execute "ALTER DATABASE ASPNETDB SET READ_WRITE", I get the following error:
The database has been created by me and I am the administrator on my laptop. So what could the problem be?
The database has been created by me and I am the administrator on my laptop. So what could the problem be?
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database 'ASPNETDB', or the database does not exist.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
when using Data -> Transact-SQL Editor -> New Query Connection...
Choose "SQL Server Authentication" instead of "Windows Authentication" inside Authentication panel.
then input admin login & password.
Choose "SQL Server Authentication" instead of "Windows Authentication" inside Authentication panel.
then input admin login & password.
I guess I do not have an SQL Server account. Could you tell me how I can create one?
Apologies again, for asking too much!
Apologies again, for asking too much!
you said you created the database, you have been asked to input an administrator password.
use login = "sa" and password = "yourpassword"
to go ahead, I advise you log on the server itself and user SQL Server Management Studio, you'll get a better view of the server.
use login = "sa" and password = "yourpassword"
to go ahead, I advise you log on the server itself and user SQL Server Management Studio, you'll get a better view of the server.
Well, I did not create the database myself. It was created automatically by Visual Studio 2010 when my website was launched.
I do not have SQL Server Management Studio installed. Does it come bundled with Visual Studio 2010?
I do not have SQL Server Management Studio installed. Does it come bundled with Visual Studio 2010?
nop.
I guess you encounter a problem of rights at OS level not at sql server level.
Check rights applied to aspnetdb.mdf and ensure it's not readonly.
(ensure the file is not under source control, etc.)
You should be able to confirm this doubt by running code below in Transact-SQL Editor window:
USE master
SELECT name, is_read_only FROM sys.databases
I guess you encounter a problem of rights at OS level not at sql server level.
Check rights applied to aspnetdb.mdf and ensure it's not readonly.
(ensure the file is not under source control, etc.)
You should be able to confirm this doubt by running code below in Transact-SQL Editor window:
USE master
SELECT name, is_read_only FROM sys.databases
I'm not clear with 1 thing - say I have several .MDF files on my computer, how do I select a particular instance to apply queries on?
you use wrong vocabulary.
An instance is representing the environment where your db lives and queries are executed.
A Database is where code resides.
you are looking for a way to turn a database into read_write mode.
By looking to the last statement I gave you, you can see that ASPNETDB does not exists, or the login rights you are using to connect to the instance do not allow you to see this database.
1) ensure ASPNETDB.mdf is present in the server folder
2) ensure you use the credentials with right to see the given database (like those used to build the sql server environment)
to answer your last question (which, to my eyes, has nothing to do with what we are trying to achieve) the statement to switch among Database (not instances) is "USE mydatabase"
Good luck :)
An instance is representing the environment where your db lives and queries are executed.
A Database is where code resides.
you are looking for a way to turn a database into read_write mode.
By looking to the last statement I gave you, you can see that ASPNETDB does not exists, or the login rights you are using to connect to the instance do not allow you to see this database.
1) ensure ASPNETDB.mdf is present in the server folder
2) ensure you use the credentials with right to see the given database (like those used to build the sql server environment)
to answer your last question (which, to my eyes, has nothing to do with what we are trying to achieve) the statement to switch among Database (not instances) is "USE mydatabase"
Good luck :)
Another useful link - Walkthorugh to create and execute Transact-SQL script:
http://msdn.microsoft.com/en-us/library/aa833241.aspx
http://msdn.microsoft.com/en-us/library/aa833241.aspx
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month7 days, 1 hour left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
