Solved

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

Posted on 2012-04-12
6
2,477 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

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…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

728 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