During a lab setup of XenDesktop 7.6 I used a Microsoft SQL 2008 R2 instance which I installed before while setting up the rest of my lab environment. While the database setup worked seamlessly for other environments it seemed that I couldn’t access the SQL server from the XenDesktop Setup wizard.
Tag Archive for SQL
Using the MDT database: “ZTI error opening SQL Connection. SQL server does not exist or access denied”
For one of my current projects we’re using MDT 2012 Update 1 and we configured the MDT DB using the database wizard as we’re using the MDT database as source for our deployment. It holds host name and IP configuration of the target machines (as we can remove the need to press F12 for PXE with the use of RES Automation Manager 2012 we have a great ZTI solution).
But we ran into a problem when using the database as the targets would use the DB information so they were deployed using the automatically generated hostsnames and based on DHCP. So when looking into the results in the C:\Windows\Temp folder we discovered that we got an error: