SQL Database connectivity|| SharePoint Configuration || Named Pipes Error In MOSS 2007


Hello Friends,

MOSS2007 is still live and sometime we need to check certain features and that can give learning too. Recently one of my friend was installing MOSS 2007 on his Virtual machine and during the configuration of the “SharePoint Configuration Wizard” he encountered an error while creating a new farm.

Ashish-Sql connec

Error is reflecting that SQL Server cannot be connected to the network, To diagnose it further we check lot of stuff:

  • VMware network settings.
  • IP addresses Provided to the servers were in the same subnet mask.
  • Any specific DNS issue.
  • able to ping IP address from both ends.
  • Non blockage of SQL port 1433 by firewalls.

It was my mistake and didn’t check PS config Diagnostic configuration error log at first in the 12 Hive. After spending some time and checking the log thoroughly. We got a log entry that “Named Pipes” might not be enabled on the SQL Server.

I check the Microsoft sites and there was no need for Named pipes as the connection are made through TCP socket but still I enabled Named Pipes on Sql server.

I tried the things again and this time it run without any error. It was success.

“Named Pipes” can be enabled as:

  1. Go to “SQL Server Configuration Manager”
  2. Go to “SQL Server 2005 Network Configuration”
  3. Go to “Protocols for MSSQLSERVER”
  4. Right-click the “Named Pipes” and “Enable” it.

If you uninstall and install sharepoint again or disable named pipes on same server configuration you will never get the error again. But if you create a new server VM and all configuration it will give same error. I have checked it but not sure why it gives error on new servers. Might be on fresh it needs named pipes to be enabled for a single time.

But nevertheless problem got resolved.

Hope I was able to describe the content correctly based on my knowledge and learning.

If you liked this post, do like on Facebook at: https://www.facebook.com/Ashishsharepointblog

Feel free to Rate and provide feedback if you find post useful

Hope this help
Ashi

About these ads
This entry was posted in MOSS 2007, SQLServerPedia and tagged , , , , , , , , , , , , . Bookmark the permalink.

10 Responses to SQL Database connectivity|| SharePoint Configuration || Named Pipes Error In MOSS 2007

  1. Christina says:

    Thank you for your other fantastic post. The place else could anybody get that kind of info in such an ideal means of writing? I’ve a presentation next week, and I am on the search for such information.

    Thanks

  2. Una Avilez says:

    Generally I do not read article on blogs, however I wish to say that this write-up very pressured me to try and do so! Your writing taste has been surprised me. Thank you, very great article.

  3. Lavalle says:

    You are so intelligent. You know thus considerably in relation to this topic, produced me individually imagine it from numerous numerous angles. Your own stuffs outstanding. All the time care for it up!

  4. Justin says:

    You made some decent points there. I looked on the internet for the subject matter and found most individuals will agree with your website.

  5. Yong Jeanclaude says:

    Well I truly liked studying it. This tip procured by you is very practical for correct planning.

  6. Manya says:

    I am sure this article has touched all the internet users,
    its really really pleasant article on building up new
    weblog.

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