?
Solved

SQL Server 2008 Workstaions don't see Instance

Posted on 2014-04-29
4
Medium Priority
?
462 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
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
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

598 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