SQL 2008 connection issue

Posted on 2011-10-04
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
    LVL 37

    Accepted Solution

    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"):

    Besides that, maybe the info on following page contains some useful parts:
    LVL 44

    Expert Comment

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

    Author Comment

    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    In this article I will describe the Detach & Attach 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.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    779 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

    12 Experts available now in Live!

    Get 1:1 Help Now