DB creation in MSDE

I have setup a new dedicated machine where I am using HC msde for db creation. But I am facing error " Unable to connect db server ", Even though sa password and sql instance are configured correctly.

Build version = 18

This is not an issue. Microsoft has upgraded its API for MSSql from DMO to .Net based SMO since the release of MSSql 2005. Also old API DMO is not supported on 64 bit machines, due to which we had to switch to the new API. This API requires installation of MSSql 2005 Sql client utilities on the machine. These utilities are automatically installed on the system if the client is using MSSql express 2005 or MSSql Server 2005. In case of MSDE or SqlServer 2000, they need to be seperately installed. Please refer below for the installation links and order of installation.

1. Microsoft Core XML Services (MSXML) 6.0 (http://www.microsoft.com/downloads/details.aspx?FamilyId=993C0BCF-3BCF-4009-BE21-27E85E1857B1&displaylang=en)

2. Microsoft SQL Server Native Client (http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/sqlncli.msi)

3. Microsoft SQL Server 2005 Management Objects Collection (http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_XMO.msi)


Please note that these links correspond to x86 machines. Please refer to following link for x64 machines.

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en


Abdullah Inayat


________________________
HC Support Team
support@hostingcontroller.com
http://hostingcontroller.com
+1-213-341-1419

Thanks after applying Sql client services issue has been fixed.

That's good. :)

________________________
HC Support Team
support@hostingcontroller.com
http://hostingcontroller.com
+1-213-341-1419