How do I tell if the MS SQL server is installed on the default instance?


Webtrends Analytics 8.x
Webtrends Analytics 9.x


Installations of Webtrends 8.5x and earlier using MS SQL as the system database require SQL server is installed on the default instance. Named instances are not supported.


To verify whether or not the database is installed on the default instance, perform the following steps:

1. On the server where the database is installed, go to Start > Run > and typecmdto open a command line window.

2. Type the following command and hit Enter:

sqlcmd -S<server>

Replace <server> with the name of the server.

If installed to the default instance, a SQL command shell prompt should appear as follows:


This indicates the SQL server on the default instance accepted the command and is ready for queries.

If an error message similar to the one shown below is displayed, this indicates the default instance is not accepting logins:

HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

Changing a SQL installation from a named instance to a default instance will require uninstalling and then re-installing the SQL server.