ADMT 3.2 on DC with SQLexpress 2008 fails – [DBNETLIB][ConnectionOpen (Connect().]SQL Server does not exist or access denied.”

In my small VM testenvironment, i created 2 2008 R2 DC’s and 1 Windows 7 client, to test some cross-forest migration scenarios.
For this, i tried to instal the ADMT (Active Directory Migration Tool ) 3.2.on one of the Domain Controllers.
Of course, you never would install this on a DC in production, but i simply did not have enough resources to add a member server to run this on. So, on the DC it is.
The ADMT needs a SQL server (sql express is also OK) to store its data in.
So i figured to install SQL Express 2008 SP1 on the DC.
Right away i got an error:

“SQL Server Setup Failure.
SQL Server Setup has encountered the following error:
Invoke or BeginInvoke cannot be called on a control unit until the window handle has been created..”

Workaround was using a custom install of sql express (using commandline) to provide the parameters to use a service account for the instance, because you cannot run it as a local service on a DC. Fair enough. Run the sqlexpress setup with the /? parameter and you get all the info needed. Installation of part 1 succeeded.

After that, i tried to install the ADMT. During this setup, it could not connect to the local SQL express instance, no matter what i tried.
Got the error:

“Unable to connect to ‘server\instance’, please ensure the SQL Server hosting this instance is running and connections can be made to this instance. [DBNETLIB][ConnectionOpen (Connect().]SQL Server does not exist or access denied.”

Then i stumbled across this posting, describing all the workarounds needed to get sql 2008 express working on the DC.
Also, it explained that there is no advantage to using sql 2008 express over 2005. Aha.
Conclusion: don’t run sql 2008 express on a DC. Use SQL 2005 Express with SP3 instead.

Advertisements

Tags: ,

3 Responses to “ADMT 3.2 on DC with SQLexpress 2008 fails – [DBNETLIB][ConnectionOpen (Connect().]SQL Server does not exist or access denied.””

  1. Jitendra Says:

    Thanks Dude. I just started searching around this issue and got pointed to your forum and saved myself lot of time. 🙂

    • rikkos2 Says:

      Cool, that’s exactly what i’m writing thesse blogs for. Happy to have helped 🙂

      • jason Says:

        I have a very similar situation, except the my solution is the problem, Im getting the same set of erros as you but im installing sql server express2005 sp3.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: