Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
SBRDude
Starting Member
2 Posts |
Posted - 2011-01-27 : 17:29:18
|
I'm a fairly experienced SQL coder, but not much use when it comes to the admin side of things. Just installed the free version of Management Studio 2008 R2 and have connected to our database at our ISP. I can't even run a basic select statement without getting an message asking me to configure my firewall to open up TCP port 135 and UDP 4500/500. I opened those ports (do I need to reboot for them to really open? Dunno). One of the options on this message says I can cancel remote debugging, and when I do that, I get a second error message describing an inability to execute 'sp_enable_sql__debug' on the schema sys. It calls itself MS SQL Server Error 229. Googled to no avail.Now, I am able to return the top 1000 rows if I go through the object browser on the tables, but that's hardly helpful.I figure this has something to do with permissions, but I have no idea where to begin or what to look for. If there is something quick to do, that would be great. If I am going to need to get up to speed on some admin basics, could someone suggest a good resource? Thanks! |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2011-02-06 : 14:56:06
|
Look at this:http://msdn.microsoft.com/en-us/library/ms241735%28v=vs.80%29.aspx |
 |
|
|
|
|