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.
Bob SchneiderCo-OwnerAsked:
Who is Participating?
 
mcsweenConnect With a Mentor Sr. Network AdministratorCommented:
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/
0
 
mcsweenSr. Network AdministratorCommented:
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.
0
 
Bob SchneiderCo-OwnerAuthor Commented:
Did that...didn't seem to work.  It says I may have enabled "Prevent Saving Changes."  Where can I find that setting?
0
 
Bob SchneiderCo-OwnerAuthor Commented:
Thanks!!
0
All Courses

From novice to tech pro — start learning today.