Posts Tagged ‘SQL Express’

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

February 1, 2012

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.