Installing new database on SQL Server

Posted on 2012-08-27
Last Modified: 2012-08-30
Good day,

We have SQL Server 2008 installed on a virtual server-KYSQL1P

I need to install a restored version of a SQL 2005  database onto this server. When I attempt to register the new server from within Enterprise Manager, I get a login error upon test. I think I need to nmake sure tha t i have rights to perform this type of operation before procedding. Please advise.

Thanks! :)
Question by:wasmithpfs
    LVL 10

    Expert Comment

    When moving a db from one server to another you may need to change owner on the new server.


    Author Comment

    Thanks, DJCanter,

    But I cannot even connect to the server through Management Studio. Although I can see the registered server in the local server group, I cannot connect to it. Since I cannot connect to it, I cannot restore the database to it and run the chabge owner query. See the attached file.


    LVL 10

    Accepted Solution


    Author Closing Comment

    Thanks that worked. :-)

    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

    Join & Write a Comment

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    755 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

    19 Experts available now in Live!

    Get 1:1 Help Now