Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Move SQL2008R2 VHD

Posted on 2011-10-06
Medium Priority
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

ID: 36927650
Found the <servername>\administrator - instead of <domain>\administrator error
but still - logon failure

Accepted Solution

mozcullu earned 2000 total points
ID: 36941899
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

580 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