Viewing 15 posts - 766 through 780 (of 817 total)
I'm curious about this problem now, also, as I have to administer a few SS2K boxes and could see this happening to me. I still think it's a port...
March 18, 2010 at 12:46 pm
Open a Windows DOS prompt and try and telnet to your SQL Server on port 1433:
telnet <IP address> 1433
(Replace <IP address> with the actual IP address of the remote SQL...
March 18, 2010 at 9:55 am
Since you can't connect remotely, is there a firewall rule in place keeping you from getting port 1433?
March 18, 2010 at 9:19 am
I haven't seen any issues with KB970892 on my systems.
March 17, 2010 at 2:38 pm
My port suggestion only makes sense if the service is running (in the Windows Service list) but can't be connected to thru SSMS.
If the service isn't running, go...
March 11, 2010 at 3:40 pm
In your list of Windows Services, look for the service specific to your 'SHAREPOINT' instance. It will say
SQL Server (SHAREPOINT)
If this isn't running, you won't be able to connect...
March 11, 2010 at 3:20 pm
Thanks Lowell, makes a lot of sense. Didn't even think about doing it this way, either. This is goin' in the toolbox.
March 11, 2010 at 10:22 am
I'd like to get some feedback regarding this question, also. In two different jobs, my storage admins have said that the SAN/NetApp would handle the disparate I/O, so it's...
March 4, 2010 at 10:08 am
Thanks Scott, 'preciate the feedback. Interestingly, I found this blog also:
http://sqlblogcasts.com/blogs/acalvett/archive/2007/12/30/the-job-whose-owner-kept-coming-back.aspx
It posts some code to help.
March 3, 2010 at 12:10 pm
Dedicated server? Do you mean a single instance (default or named) hosting a single database? Here are some benefits of a separate instance:
Can allocate specific memory to that...
March 1, 2010 at 9:18 am
Did it run as your user (the user you're logged in as)? Seems whenever I created T-SQL jobs, it uses my credentials.
February 26, 2010 at 5:37 pm
Once again, check the port that the destination server instance is listening on and make sure it's not blocked by a firewall. Ping'ing the server is not a valid...
February 26, 2010 at 9:34 am
What port is the destination SQL Server machine listening on? Make sure it's not being blocked by a host based firewall.
February 25, 2010 at 9:28 am
1) You can download and install SSMS express without any licensing problems:
2) Not sure about this one
3) When you fire up SQL Profiler, it asks for a server to connect...
February 24, 2010 at 2:25 pm
Do you get the same behavior using the OPENQUERY command?
February 24, 2010 at 10:37 am
Viewing 15 posts - 766 through 780 (of 817 total)