WASP MobileAsset SQL error: 26 – Error Locating Server/Instance Specified

When installing the WASP MobileAsset client you may get SQL error 26, error locating server/instance.  If you are not using MobileAsset but get this error with another application that uses SQL database, the problem may have the same simple solution.  As the linked article explains, this specific error has to do with trying to connect to a SQL Server named instance.

The article provided troubleshooting steps that helped me realize that WASP MobileAsset SQL error: 26 – Error Locating Server/Instance Specified was due to the firewall on the PC/ Server hosting the WASP MobileAsset SQL Database.  Since the MobileAsset Client needs remote access to the SQL database, not having the appropriate firewall exceptions will cause you to get this error when trying to authenticate as the firewall will block incoming connections.

Source: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified – SQL Protocols – Site Home – MSDN Blogs

Ultimately, what solved the problem for me was the following post:

Four exceptions must be configured in Windows Firewall to allow access to SQL Server:A port exception for TCP Port 1433. In the New Inbound Rule Wizard dialog, use the following information to create a port exception: Select Port Select TCP and specify port 1433 Allow the connection Choose all three profiles (Domain, Private & Public) Name the rule “SQL – TCP 1433″ A port exception for UDP Port 1434. Click New Rule again and use the following information to create another port exception: Select Port Select UDP and specify port 1434 Allow the connection Choose all three profiles (Domain, Private & Public) Name the rule “SQL – UDP 1434 A program exception for sqlservr.exe. Click New Rule again and use the following information to create a program exception: Select Program Click Browse to select ‘sqlservr.exe’ at this location: [C:\Program Files\Microsoft SQL Server\MSSQL11.\MSSQL\Binn\sqlservr.exe] where is the name of your SQL instance. Allow the connection Choose all three profiles (Domain, Private & Public) Name the rule SQL – sqlservr.exe A program exception for sqlbrowser.exe Click New Rule again and use the following information to create another program exception: Select Program Click Browse to select sqlbrowser.exe at this location: [C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe]. Allow the connection Choose all three profiles (Domain, Private & Public) Name the rule SQL – sqlbrowser.exe

Source: .net – SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904) – Stack Overflow

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