Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

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.
0
Bob Schneider
Asked:
Bob Schneider
  • 2
  • 2
1 Solution
 
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
 
mcsweenSr. 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
 
Bob SchneiderCo-OwnerAuthor Commented:
Thanks!!
0
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now