Issues moving Business Contact Manager Database (2007)

Posted on 2011-04-19
Last Modified: 2012-05-11
Just like to say, we attempted this today. We backed up the database from the orginal server, created a new DB on the new server using the BCM DB Tool, restored the database and shared the database, however, clients cannot connect to the database. It's a SQL 2005 named instance (SQLEXPRESS). Connecting to the database from BCM we are using the string server\sqlexpress, no go. No firewalls or anything in the way,

Any ideas?
Question by:Layer3User
    LVL 17

    Accepted Solution

    use the sql2005 Surface Area Configuration utility to ensure remote connections are enabled to the instance

    Author Closing Comment

    Slow at getting a solution, but the correct one.

    Author Comment

    Can I just add to this, this didn't actually fix the problem. We still cannot connect to the DB.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Use email signature images to promote corporate certifications and industry awards.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    759 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

    14 Experts available now in Live!

    Get 1:1 Help Now