Link to home
Create AccountLog in
Avatar of Bob Schneider
Bob SchneiderFlag for United States of America

asked on

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.
Avatar of Bradley Fox
Bradley Fox
Flag of United States of America image

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.
Avatar of Bob Schneider

ASKER

Did that...didn't seem to work.  It says I may have enabled "Prevent Saving Changes."  Where can I find that setting?
ASKER CERTIFIED SOLUTION
Avatar of Bradley Fox
Bradley Fox
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks!!