• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

Move SQL2008R2 VHD

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 ?

1 Solution
ok-fondenAuthor Commented:
Found the <servername>\administrator - instead of <domain>\administrator error
but still - logon failure
Metehan OzculluSQL Service ManagerCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now