Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 465
  • Last Modified:

SQL Server 2008 Workstaions don't see Instance

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
laurencoull
Asked:
laurencoull
  • 2
  • 2
1 Solution
 
plusone3055Commented:
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
 
laurencoullAuthor Commented:
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
 
plusone3055Commented:
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
 
laurencoullAuthor Commented:
IT was Windows Firewall blocking it!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now