SBS 2011 SQL Express 2008 R2 does not exist or access denied

Hello All.

I am havin a problem that is driving me crazy.  I have an SBS 2011 server running just fine.  on that server, SQL Express 2008 R2 is installed and running.  I have a SQL instance setup for a maintenace program.  the program is installed and running just fine on the server.

I have the firewall open on the server for the 1433 and 1434 ports.

TCP/IP is enabled in SQL Configuration and I have the option to allow remote connections turned on.  

When I install the program on the workstations, I cannot connect to the SQL database.  I use the same connection string as the server and it fails.  when I try to use the ODBC tools to connect to the database on the server I get;

error 17, SQL server does not exist or access denied

I have double checked the firewalls, it does work from the server, i have even tried to connect with the sa account, no dice.

any help would be appreciated.

Mark
LVL 2
bobbydall2000Asked:
Who is Participating?
 
Obi WanConnect With a Mentor FixerUpperCommented:
Check error message 2 resolution mate

http://support.microsoft.com/kb/839269
0
 
sconstableConnect With a Mentor Commented:
By Default SQL express cannot be accessed over the network,
You need to go into the SQL configuration Utility and enable the TCP/IP and Named Pipes.
0
 
venk_rCommented:
Check to see if The Microsoft SQL Browser service is turned off or not installed on the database server system.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
bobbydall2000Author Commented:
Hi.  I have enabled TCP/IP and Named Pipes on the server using the SQL Config Utility.  the SQL Browser service is running on the server and 445 is allowed on all firewalls.  I ran the cliconfig utility on the client and created and alias and made sure TCP and Named Pipe were added as protocols.  No change.
0
 
bobbydall2000Author Commented:
As a note, when I try to create a SQL Server ODBC connection from the workstation using the ODBC tools, the drop down shows the server name (SBSSERVER) but not the instance (SBSSERVER\TEST).
0
 
bobbydall2000Author Commented:
Never mind, solved it myself.  When creating an alias using cliconfig, I created a TCP/IP alias which didn't work.

I added a Named Pipe alias and that worked.  So the program is ok now running from the workstation.

Cheers
Mark
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.