Using SQL Server Client Network Utility to Determine the Name of Your SharePoint Application Database

You can use the SQL Server Client Network Utility to Determine the Name of your SharePoint Application Database. See the Problem and solution below.

| Nicole Gantzhorn | 21 November 2018

SQL Server Client Network Utility

The Problem:

SharePoint is, of course, a monster of an application platform with many configuration quirks.  As a DBA supporting a content database utilized by a SharePoint environment, I ran across a problem:  After installing SharePoint, there is no way for the application administrator to tell the DBA the real database name. 

The Reason: 

During installation, an alias is created for the database.  Unless you write that name down or name the alias something that reflects the database name, there is no clear way to determine the name of the database, either in the application or in the configuration files.

The Solution:

Since the solution was not particularly obvious, I’d like to share it, so that another DBA does not have to solve the issue at the worst possible time:  an outage.

You need to run the SQL Server Client Network Utility on the SharePoint Application Server, but when you look around in Start/All Programs in Windows for the utility, you won’t find it.  Instead, you must execute a command in the Windows directory from the command prompt.

Finding the Alias Name with SQL Server Client Network Utility:

1.      Run the CLICONFG.exe command

a. From the Command Prompt, run the command cliconfg.exe from the directory C:\windows\system32\

OR

b.  From the Windows Start/Run Command section, run cliconfg.exe.

The SQL Server Client Network Utility screen appears.

Image

2.  Click on the Alias tab.  The SharePoint Alias and Database Name appears in the Server alias configurations grid.

Image

All Blog Articles
Tips & Tricks
Tips for a Successful Phone Interview: Be Prepared

You Have an Interview! Congratulations!  Scoring a telephone interview means you have made it to the pool of promising applicants.  While a telephone interview sounds like it’s easy, there is an art...

30 March 2018

Database Administration
Database Server Consolidation

Reduce Operational Costs and Optimize Your Environment: Continually evolving businesses (e.g., entering new markets, mergers, and acquisitions), coupled with high DBA-turnover rate can quickly result...

19 July 2021

Tips & Tricks
SQL Tips and Tricks: Find All Query

Find All Query The Problem Your boss has asked you to make changes to an application that will affect an MS SQL Server database, and first needs to know the impact analysis of those changes before...

27 November 2020

footerLogo

610-783-0600 info@aspect-consulting.com

20140 Valley Forge Circle King of Prussia, PA 19406

Resources

Aspect Consulting, Inc © 2022      All rights reserved.

Privacy Policy        Title of the document Legal Disclaimer