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
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?