Archive for the ‘Uncategorized’ Category

Named Pipes Provider, error: 40 – Could not open a connection to SQL Server

Friday, August 11th, 2017

This is a small entry mainly for my part.  For the life of me, I keep forgetting this with SQL Express.

We are using it for small Citrix sites and get the big long error when I try to establish my Xendesktop Controller.

In this matter, pipe and TCP/IP have to be enabled!

The steps:

  • SQL Configuration Manager
  • SQL Server Network Configuration.
  • Change Named Pipes to Enabled
  • Change TCP/IP to Enabled.
  • Start SQL Server Management Studio
  • Right-Click the Server entry
  • Select restart
  • Wait

After that the SQL portion of the Xendesktop setup works.



Happy New Year everyone!

Friday, January 1st, 2016

The stats helper monkeys prepared a 2015 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 10,000 times in 2015. If it were a concert at Sydney Opera House, it would take about 4 sold-out performances for that many people to see it.

Click here to see the complete report.

Cygwin sshd multiple user access.

Monday, May 4th, 2015

Some of our development groups like to use SSH.  Especially, if they have a Linux background and were tossed into the windows world.

The basic configuration does work.  However, it’s for the main user running the sshd.

The documentation will tell you to have the user run ssh-config-user.  However, it’s not enough as you will be tormented by messages of /bin/bash not allowed and the connection dropping right after password entry.

Certain authority rights have to be established for the main account to allow other users to access the box.  Try the following:

  • editrights -l -u <local or domain/user>
  • editrights -a SeAssignPrimaryTokenPrivilege -u <local or domain/user>
  • editrights -a SeCreateTokenPrivilege -u <local or domain/user>
  • editrights -a SeTcbPrivilege -u <local or domain/user>
  • editrights -a SeServiceLogonRight -u <local or domain/user>
  • editrights -l -u <local or domain/user>

Restart you cygwin service and you should be able to ssh from any box.

RIP Spock!

Friday, February 27th, 2015

Not exactly a post in line with the usual contents of this blog.  However, Leonard Nimoy died today. He was said to be a good man and many people have feelings of knowing him. For many he sparked imagination with the desires for the unknown; the desire to join Star Fleet and explore the unknown.

Towards the end he tweeted something profound:

“A life is like a garden. Perfect moments can be had, but not preserved, except in memory. LLAP”

Thank you for the memories Mr. Nimoy.

The world seems sadder….

Windows 7/8 and hiberfil.sys

Tuesday, October 14th, 2014

Windows 8 increased the boot speed by making use of the hibernate function to store the kernel session rather then completely shutdown.

For laptops and even desktops; this is a nice feature.  However, for a testing server or virtual machine; this is a waste of disk space especially if you have a large amount of RAM (in one situation, a windows 7 and 8 setup had two sixty gig files for hiberfil.sys).

This consumption also confused the users as they would see their free space as small and yet looking at their folders didn’t show these files.   Programs like windirstat will point this out.

The simplest way to disable this feature is to use the powercfg command.  Start an administrative level cmd shell.

Enter:  powercfg /h off

The hiberfil.sys file will disappear right after.

Startup time will increase but for these users; space was more important.

How to extend a Windows Server trial period.

Tuesday, October 14th, 2014

Every so often I will get the “emergency” request for a Windows Server machine and either it will take too long to purchase a license or it’s only a trial to check something.  Of course, the server is established and all is forgotten.

One hundred and eighty days later; an issue is raised over the server being offline.  A quick check and of course the license has expired so the machine will start regularly shutting itself down.

The test of course is not over so do we extend it or get a license? The license idea is rejected to we can only extend the trial period.

Microsoft understands these issues and gave a simple way to extend a trial:

  1. Start a command prompt as administrator
  2. enter : slmgr.vbs /rearm
  3. The system will need a reboot for the extension to begin.

A new period of 180 days will be displayed and you can do this 2 more times.

Removing the Jenkins slave service

Sunday, February 16th, 2014

I had a simple task to uninstall the Jenkins slave service from a series of machines.

There was the small problem of it not being in the programs control panel nor was there an obvious uninstaller.

A quick review of the online documentation showed all you needed to do was enter the following command:

jenkins-slave.exe uninstall

To be through I rebooted the system and later deleted the folder where it was installed.


The computer has rebooted from a bugcheck. The bugcheck was: 0x0000007e (0xffffffffc000001d

Friday, February 14th, 2014

I have a couple servers which crash reboot from time to time.

Looking over the event log, the bug check reported:

The computer has rebooted from a bugcheck. The bugcheck was: 0x0000007e (0xffffffffc000001d

Researching the Net, really didn’t point to an obvious reason.  Suggestions offered:

  • Run:  sfc /scannow

 Didn’t find any errors.

  • Run a disk check.

 Didn’t find any errors.

I decided to update the BIOS and the controller firmware.

So far the systems haven’t crashed.

Solaris network link information

Saturday, April 21st, 2012

Though Solaris is slowly disappearing(at least at my current company), there are still legacy machines which will remain and sometimes you have to debug them especially over network speed. Solaris has a legacy of having problems with auto-negoting.  Sometimes you may think you are running full-duplex and you are not.

If you have access to the network switch, it’s easy to check. If you don’t you have to rely on solaris commands.

The NDD command will give you configuration information on the interface.

For example:
# ndd /dev/bge0 link_duplex
# ndd /dev/bge0 link_autoneg
# ndd /dev/bge0 link_status
# ndd /dev/bge0 link_speed

Here duplex is full with auto-negotiating off and the link is down.

NDD can do much more but I only needed to check the interface settings.

Excel can’t paste formatted text.

Saturday, April 21st, 2012

I had an odd excel issue today.  My co-worker asked if I had seen a situation where you loose the ability to paste formatted text to a spreadsheet.

I had a look at his office 2010 setup and nothing obvious was missing and there were no error messages to suggest a problem.

I right-clicked a cell and selected “Paste Special..” and found the only option left was unicode text.

Even though I knew it would not solve it; I ran a repair on office.

I checked around the Net and found a few suggestions to edit the cells via vba through the alt-F11 command but they did not solve the problem.

I searched the Microsoft site and found an article  about the clipboard loosing the ability for format pasting.

The problem seems to center around the use of Skype’s Click to Call.

This seemed odd but we tried disabling it on the browser and the add-ons for Excel and Word. The problem remained.

We ended up uninstalling Click to Call and after restarting the browser and Excel; we found the ability for formatted pasting had returned.

Lesson of the day: The integrated clipboard can cause problems after installing new software.