Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2008 Workstaions don't see Instance

Posted on 2014-04-29
4
Medium Priority
?
456 Views
Last Modified: 2014-05-13
Installed a new SQL Server Express 2008 Instance on a new 2011sbs server. The install went well and allowed me to add my Instance (SQLEXPRESS) no problem. Everything in the config looks good, but while I can connect to the SQLExpress Instance through the ODBC on the server itself without any problem I can't get the workstations to see the SQLExpress Instance in the ODBC Data Source Administrator. It just doesn't appear in the drop-down. Checked permissions and services, all look good (automatic and running). Logged onto a workstation as domain administrator and same, which would likely rule out permissions? In the surface area configuration I've allowed remote connections via TCP/IP both with and without named pipes. Every time I've tried something different I've re-staretd the services and re-booted the workstations. The only issue I can possibly think of which may be a factor is that the new server is taking over from a 2003sbs server following the standard Microsoft migration procedure and at this moment the old server is still running with an SQL 2005 instance of the same name (SQLExpress). It IS being seen in the ODBC SQL dropdown selection but the new server instance isn't. Could they be conflicting? I tried stopping the SQL services on the old server to see if that may help: When I do so, the instance on the old server is no longer available but the instance on the new server still has not become available.
0
Comment
Question by:laurencoull
  • 2
  • 2
4 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 40030031
as a general rule of thumb sometimes the instance will not appear on the drop down menu when creating an ODBC connection.. Sometimes its refresh rates, sometimes its just un-explainable.. I would just manually type in the server name and go through the motions of finishing the ODBC connection and run a connection test.  it should still work :)
0
 

Author Comment

by:laurencoull
ID: 40030221
Tried: The server name does appear in the drop down menu so I add "\SQLExpress" after it and go through the motions and run the connection test.
It returns "Server does not exist or access denied. Tests failed."
0
 
LVL 22

Accepted Solution

by:
plusone3055 earned 1720 total points
ID: 40030240
have you taken a look at Microsoft's listing for this error ?

http://support.microsoft.com/kb/328306

There are a lot of potential issues

have you tried entering the IP address ?
0
 

Author Closing Comment

by:laurencoull
ID: 40063123
IT was Windows Firewall blocking it!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

927 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