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.

*sighs*

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: