Viewing 15 posts - 766 through 780 (of 822 total)
It appears that a re-install of the Oracle client software solved this problem.
Sorry this was posted in the wrong forum.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 15, 2010 at 3:55 pm
Thanks for the feedback from everyone.
Grant, how do you receive forum alerts from MSDN? I've tried setting up alerts thru my Windows Live account, but they don't seem to...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 14, 2010 at 10:07 am
Error seems fairly poignant...you mentioned it's across a different domain, I'm wondering if you're running into the AD replication cycle or something.
Hard to tell what the problem...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 13, 2010 at 10:32 am
Any errors in the event log (SQL and Windows events) on the receiving server? Wonder if you have something running there that bogs down the server, or drops connections...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 13, 2010 at 10:25 am
I've used SQL Server DTS successfully, so I'm sure the SSIS packages are just as nice. I've also used the SSMA for migrating Access, fairly clean interface also.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 1, 2010 at 10:21 am
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
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?
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
March 18, 2010 at 9:19 am
I haven't seen any issues with KB970892 on my systems.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
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.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
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.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
March 1, 2010 at 9:18 am
Viewing 15 posts - 766 through 780 (of 822 total)