Solved

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

Posted on 2012-04-12
6
2,466 Views
Last Modified: 2012-04-13
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
0
Comment
Question by:bobbydall2000
6 Comments
 
LVL 6

Assisted Solution

by:sconstable
sconstable earned 250 total points
ID: 37839557
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
 
LVL 6

Accepted Solution

by:
Jamielive2011 earned 250 total points
ID: 37839567
Check error message 2 resolution mate

http://support.microsoft.com/kb/839269
0
 
LVL 8

Expert Comment

by:venk_r
ID: 37839568
Check to see if The Microsoft SQL Browser service is turned off or not installed on the database server system.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 2

Author Comment

by:bobbydall2000
ID: 37842963
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
 
LVL 2

Author Comment

by:bobbydall2000
ID: 37843049
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
 
LVL 2

Author Comment

by:bobbydall2000
ID: 37843087
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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now