Need help setting up SQL Server Instance/Database

Posted on 2012-09-14
Last Modified: 2012-10-17
I'm a complete newbie to SQL, but here's my issue.
I'm running Desktop Authority on a Windows 2003 server. I need to move it's database to another server. On the new target server, I'm running Server 2008 and have SQL Server 2008 installed.
I think I need a new instance or database installed on the target server so that the original server and Dekstop Authority can see it. How do I do that? I don't have a clue where to begin. Please help!
Question by:lenivan
    LVL 12

    Expert Comment

    What version of SQL Server are you running on your Windows 2003 server?

    Author Comment

    SQL Server 2005
    LVL 12

    Accepted Solution

    You could backup the database in 2005, and restore it to 2008. Then if you run the following command against the database it would make your database 08 compatible.

    ALTER DATABASE <database>

    That would leave the original database in tact.

    You could also use the Wizard in 2008 talked about a little here:

    Or you could detach the database files from one instance, move them, and attach them on the new instance. (To me, this seems to make the LEAST sense in your situation).

    Author Comment

    I will try the suggestions you posted.
    Additionaly, while in Desktop Authority on Server 2003, I try to connect to a database on my target server and recieve an error message. I've attached a screen shot. Does this tell you anything to point me in the right direction?
    LVL 12

    Expert Comment

    All I can tell is that you're having some issues connecting to the new SQL Server from Desktop Authority.

    SQL Server 2008 is probably installed as an unnamed or default instance. If that's the case you should only need the server name to connect (Rather than <server name>\<instance name>).

    I don't have any experience with Desktop Authority (does it try to connect to a specific database?), so I can't offer much help how to change the database connection settings.

    A sql connection is generally made up of the server name (and possibly instance name), user authentication, and possibly a database name.

    You might try connecting with SSMS, or an SSMS alternative that will establish a connection to the sql server without trying to connect to a single database to help start narrowing down the problem with the connection.

    I wish I could be more help with that error.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

    761 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

    8 Experts available now in Live!

    Get 1:1 Help Now