CLICONFG and Setting the Alias

History:

I was running into errors adding the SharePoint 2010 farm to the Quest Tools Site Administrator Console. The error I was getting was:

NetBIOS or DNS name or IP address of the SharePoint server
Error: The SharePoint SQL database server cannot be reached at SQLALIAS. Please verify that the firewall does not block SQL Server ports on SQLALIAS and SERVERNAME. SQL aliases used on SharePoint front-end servers must also be configured for SERVERNAME.
Details SQLALIAS (Database Server): Database access failed (Error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Source: Microsoft OLE DB Provider for SQL Server SQLSTATE: 08001 Native error: 17 Server: Error state: 1 Error severity: 16 Strings: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. )

I had used the CLICONFG from the “run” command to set the alias for the SQL Cluster:

However, when working with the helpdesk from Quest Tools, he had me set the CLICONFG from C:\Windows\SysWOW64. This resolved the issue.

Advertisements

2 Responses to CLICONFG and Setting the Alias

  1. Anonymous says:

    Great thanks! I had the same error and I added my server in cliconfg.exe via start – run but not in the syswow64 folder!

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: