October 26, 2011 at 5:59 pm
I administer 2 servers (among others) a SQL 2005 Server and a SQL 2008 R2 server.
I can run Powershell scripts against either server from my workstation. When I Remote Desktop into the SQL 2008 R2 server, I can run Powershell scripts against that server. However, I can't even access the Powershell SQL Server provider for the SQL 2005 Server from the SQL 2008 R2 server.
I would like to be able to run Powershell scripts which access the SQL 2005 server from the other server. How can I do this?
I get this error when I try to access the SQL 2005 server (via powershell) from the SQL 2008 R2 server:
WARNING: Could not obtain SQL Server Service information. An attempt to connect to WMI on 'ServerName' failed with the following error: the RPC server is unavailable. <Exception from HRESULT: 0x800706BA>
When I Google this error message, I am told that the problem relates to Windows Firewall. However, I am not running Windows Firewall on either server. There could be another firewall running somewhere, but that should prevent me from accessing the SQL 2005 server using Powershell on my workstation, too, shouldn't it?
This error is driving me insane. :crazy:
October 27, 2011 at 12:32 am
I can confirm its NOT a powershell issue. I can manage all of my servers through powershell in some form, although Im sometimes restricted in the method when remoting is disabled. You're talking at least 200 instances when you take into account dev and uat environments.
Can you run the powershell on the server directly? You can install powershell 2.0 on the server directly if its missing.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply