[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL 2008 connection issue

Posted on 2011-10-04
Medium Priority
Last Modified: 2012-05-12
I installed a second copy of MS SQL 2008 on a server to provide failover access to a database but I am having issues connecting to it. The original database is connected from clients via ODBC without issue. I can't recreate this on this second server. It must be permissions or share based issue but I can't figure it . The program I am using to connect to the database is Xytech. Xytech speaks to SQL server via ODBC connection. I set up the second backup via subscription so the data replicates to the second server as long as change the server pointer in ODBC it should connect but this second SQL database will not share. Not sure what else to do at this point or what's different.

Question by:vdms
  • 2
LVL 37

Accepted Solution

ValentinoV earned 1500 total points
ID: 36915006
Is the SQL Server Browser service running?  If not, activate it and try connecting.

I think you'll also need to install the Native Client, available in the Feature Pack downloads (look for "Microsoft SQL Server 2008 Native Client"): http://www.microsoft.com/download/en/details.aspx?id=6375

Besides that, maybe the info on following page contains some useful parts: http://msdn.microsoft.com/en-us/library/ms131415(v=SQL.100).aspx
LVL 53

Expert Comment

by:Vitor Montalvão
ID: 36923248
Did you receive any error? If so, what says the error?

Author Comment

ID: 36939105
Hi. I was able to resolve the connection issue with some permissions on services and turning on the TCP/IP service in SQL configuration. Xytech is still not sharing on that SQL though so I;m working with them. I did install the service pack 2 features as suggested.

Author Closing Comment

ID: 36939108
THis solved some of the issue but I was able to figure it out the rest.
Thank you for your help.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

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

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.
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

872 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