Solved

SQL Server 2008 Workstaions don't see Instance

Posted on 2014-04-29
4
410 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 430 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

867 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

23 Experts available now in Live!

Get 1:1 Help Now