Your question, your audience. Choose who sees your identity—and your question—with question security.
Editing SQL Server Remotely
I just installed sql server on a new pc and it works fine but when i try to edit the db on my server using the management console Ii get a message that says I can not edit the table. Is there a setting somewhere that i need to change so that I can do that? I believe I had that capability on my old machine.
Asked:
2-
2
1 Solution
LVL 22
It could be a couple issues. Open SQL Server Configuration Manager and make sure TCP/IP is enabled under protocols. You may also need to turn on the SQL Browser service. It is probably disabled; set it to auto and start it. You will have to restart the SQL Server service after enabling TCP/IP.
Did that...didn't seem to work. It says I may have enabled "Prevent Saving Changes." Where can I find that setting?
You can set a database to read-only but I'm not sure I've ever heard of the prevent saving changes setting...
http://blog.sqlauthority.com/2011/04/16/sql-server-making-database-to-read-only-changing-database-to-readwrite/
http://blog.sqlauthority.com/2011/04/16/sql-server-making-database-to-read-only-changing-database-to-readwrite/
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.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now