Solved

Editing SQL Server Remotely

Posted on 2013-01-05
4
166 Views
Last Modified: 2013-01-05
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
Comment
Question by:Bob Schneider
  • 2
  • 2
4 Comments
 
LVL 21

Expert Comment

by:mcsween
ID: 38747325
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
 

Author Comment

by:Bob Schneider
ID: 38747346
Did that...didn't seem to work.  It says I may have enabled "Prevent Saving Changes."  Where can I find that setting?
0
 
LVL 21

Accepted Solution

by:
mcsween earned 500 total points
ID: 38747373
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
 

Author Closing Comment

by:Bob Schneider
ID: 38747375
Thanks!!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now