SQL Server database showing read only
SQL Server database showing read only
We are going to share with you Microsoft SQL server database solution when you attached your old database with SQL server at that time some time you see that Read-only database show so we have solution of this make sure that your database same directory where all the database working because some time happen that you have not permission on that particular folder where you are going to store database in these condition you make sure your database file is correct location and you have required permission on that work.
Following all the steps:-
Step 1:- Right Click on your read only database and select Properties.
Step 1:- Right Click on your read only database and select Properties.
Step 2:- Click on General Tab and cursor scroll down and see "Database Read Only - TRUE " If database read only true so change it into False before doing false make sure that your SQL database not connected with another user.
Tags:
SQL
Troubleshoot
0 comments
Please leave your comments...... Thanks