Avatar of Bob Schneider
Bob Schneider
Flag 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.
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Bob Schneider

8/22/2022 - Mon
Bradley Fox

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.
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
Bradley Fox

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Bob Schneider

ASKER
Thanks!!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy