Here is a great post about how to configure the firewall part.

http://www.lewisroberts.com/2009/08/16/msdtc-through-a-firewall-to-an-sql-cluster-with-rpc/

But the idea is that every cluster after Windows 2003, you configure the MSDTC resource inside each...

Thanks. I will have that fixed.

OK, thanks. I have used it on SQL 2005 and above with great success so I guess mileage varies on the project and versions of SQL server.

Thanks for commenting.

Is this just a comment or is there a question you have? I know that SMO is not perfect, but it has a lot of functionality and in my...

The error is most likely indicating that you do not have a WindowsPowerShell directory in your Documents folder.

You can solve that by using this:

New-Item -Path (Split-Path $profile) -ItemType Directory -Force

Then...

I simply mean that when you think of a module you will use Import-Module modulename.

With dot-sourcing, it is simply a .ps1 file somewhere that has a function in it or...

Well, you should be able to have both the Cmdlet100 and the Provider100 loaded with the SQLPS.

But if you loaded 2012 on your machine, you would have what you have...

Something just does not seem right. What is the OS?

I am assuming that you can connect via management studio. But if you close PowerShell and open it fresh...

This should be able to help you.

http://blogs.msdn.com/b/john_daskalakis/archive/2009/05/07/9593110.aspx

If you only have SQL 2012 installed then try this:

Import-Module SQLPS

Then try the command.

This is due to not having Administrative privileges on the machine you are going against. So on the remote machine you have to be able do administrative things so...

SQLSERVER:\SQL is a PSDrive and path.

If you use Get-PSDrive you will see that there is a SQLSERVER: drive and SQL is a path under SQL Server.

You can see which paths...

Ariel, if you go to the previous Level in this stairway you will see where you can get PowerShell for WinXP SP3. In the table there it shows that...

I think it just means that I am a really good author 🙂

Well, to change the prompt, there just needs to be a prompt function in place. It does not have to be in a profile, but it is convenient to...