Solved

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

Posted on 2012-04-12
6
2,479 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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:
Obi Wan 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 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