Move SQL2008R2 VHD

Posted on 2011-10-06
Last Modified: 2012-05-12
Hi there.

We got an Axapta environment with a SQL2008R2 running on virtuel machines on a server
2008R2 Hyber-V server.
We needed to have a development environment exactly the same as the the production environment, so we installed a 2008R2 host. Created a DCT ctrl with same domain name
in a seperat net. On this we copied the productionservers : SQL and AXAPTA servers VHD files to the this environment, and kept there names, put them into the test domain and started.
Just can't access the database - why ?
We access with WIN authentication, but in USERNNAME it says : <servername>\administrator
instead of <domain>\administrator like the original.

Any help ?

Question by:ok-fonden

    Author Comment

    Found the <servername>\administrator - instead of <domain>\administrator error
    but still - logon failure
    LVL 7

    Accepted Solution

    if you start sql server in single user mode, your local administrators will be able to access the sql server. after accessing the server, you can fix any security issue. Starting SQL server in single user mode:

    named instance: in command prompt sqlservr.exe -m -s <instancename>
    default instance: in command prompt sqlservr.exe -m

    sql service should be stopped before running these commands.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    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.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now