Hi OPC.. I've tried the code from your earlier posting. While it registers a success (in the SQL Server Agent result), I added my usual logging to the process...

Thanks OPC.Three.. That points to the problem being local to us.. Much appreciated you spending the time to replicate this and provide proof that it should work..

OPC.Three..

The difference I see between your setup and mine from this is that I'm using a Domain account, rather than a local machine account.

Do you get the same behaviour with...

I'll peer more down there.. I'd run straight into security issues on the PnP stack!

Hi Laerte,

That, from a quick scan of the code, seems to be an automation of the previous links...

Thanks Nadrek. I'd actually already discounted that (as that's largely for remote access to WMI, and you'll need Powershell V2, not the in built SQLPS mini shell, due to...

A little bit of further info..

Turning on object fail auditing gives rise to event 4656:

Object:

Object Server:SC Manager

Object Type:SC_MANAGER OBJECT

Object Name:ServicesActive

Handle ID:0x0

Process Information:

Process ID:0x208

Process Name:C:\Windows\System32\services.exe

Access Request Information:

Transaction ID:{00000000-0000-0000-0000-000000000000}

Accesses:Connect to service...

Thanks for that.. It does help focus the mind to know it's not something simple I've overlooked, and is repeatable elsewhere. 🙂

This makes me wonder whether it's an intentional...

There are a few bugs in this script that'll catch the unwary. First being 'TEXT' types; they can't actually be given a column length (which the script does), so...

Thanks Dick,

I was hoping to be able to avoid scripting this to get a fast resolution for testing, but it looks as though the SSMS...

Already done that, and checked that owner is the correct schema.

I've flipped through the binding and partitioning to see if that makes a difference, but alas, no difference (the tables...

DNS aliases don't work in replication. Even setting the SPN doesn't seem to work either, as the subscriber always seems to recognise that you're not the originating server, and...

Try CVS (or Subversion). Slapping one of those up on a home machine will let me have access to whatever I write whenever I feel like. Having the...

With a cluster, the fact you have 3 nodes is largely irrelevant.

The nodes form part of one cluster. All references should be made to the virtual cluster server itself.

Thus,...

"less" is a command that I find most useful for browsing through text based files.

Ability to scroll forward, backwards, jump to line number, and so on, all make this an...