During the setup of Deployment Solution 6.x, the error message "Setup was unable to run dbinstaller.exe to create the express database—canceling setup" is received.
Insufficient rights on the SQL server.
TCP/IP and Named Pipes Protocols have not been enabled for MSDE.
Port 1433 has not been defined in SQL configuration
Verify the user name, password, and authentication type being used for the MSDE\SQL Server. If you are going through the custom setup and the SQL server resides on a different server than Deployment Solution is being installed on, make sure that on the first section after selecting your SQL server, you are using a user with administrative privileges to the SQL box. On the next screen, you will get a choice of using NT Authentication or SQL authentication; please note that if you select NT Authentication, this will use the logged on user and not the NT Account you specified on the previous screen. The user you use on this screen will need to exist on the SQL server; this can be verified by using the SQL Enterprise Manager. If using MSDE or SQL Server 2005 Express, make sure that you enable the protocols named pipes and TCP/IP.
To do this: 1. Go into Program Files\Microsoft SQL Server\80\Tools\Bin and select svrnetcn.exe.
Or open the 'SQL Server Configuration Manager' under All Programs, Microsoft SQL Server 2005 2. Under the General tab, select Named Pipes and TCP/IP and add them to the enabled protocols. 3. Also select TCP/IP and click the Properties button and make sure the Default Port is set to 1433. 4. You will need to restart the SQL service after making this change. 5. Also, verify the ODBC Datasource tested successfully as well by going to Start > Program Files > Administrator Tools > ODBC. Verify the Instance name and that it's pointing to the eXpress database. If connection fails, make sure the NT authentication is being used. 6. Also make sure the latest Microsoft SQL Server Service Pack is installed. 7. You may need to install Deployment Server manually based on the installer kept creating a Server Alias which broke the SQL Server connection. 8. Verify the port 1433 is open
In SQL Server 2005 Express this is called Network configuration. Located in Program Files> SQL Configuration Manager. Network Configuration> Double click and select Yes to enable the TCP/IP and Named Pipes.
Right Click on the TCP/IP and verify that all portions of TCP show 1433.
For more information, see article 3733.
Right Click on the TCP/IP and select properties. View the port is set to 1433 and restart the SQL Services.
You may need to reinstall a fresh database. If it is still not working, then read article 3541, "MSDE installation DS 6.5 DBInstaller cannot install or uninstall MSDE."
For information on how to preinstall SQL Server Express 2005, see article 19577. Note: For Standard SQL Server 2000, make sure the latest SP4 has been installed. Current workaround: SQL Server 64-bit running on a Windows 2003 64-bit operating system with Deployment Solution 6.8.SP2 installed on a 32-bit operating system currently needs to be installed on a 32-bit SQL Server then move the database to a 64-bit Environment. Reconnect the ODBC connection to point to the SQL 64-bit Instance. This is resolved in Deployment Solution 6.8.378 SP2 build, soon to be released. 9. If you uninstall the MSDE > You need to clean the registry of all MSSQL: HKLM/Software/MSSQL. Then reboot the server. Install MSDE by selecting the executable. After the MSDE is installed C:\DSSetup folder and execute the axinstall.exe.
****** Always use the Custom install option instead of Simple during the Install Wizard
SQL Server 2005 Express Edition SP2 .....SQL Server 2005 Express Edition with Advanced Services SP2
Install Microsoft SQL Server 2005 Express Edition Microsoft SQL Server 2005 Express Edition is the free, easy-to-use, lightweight version of SQL Server 2005. Integrated with Microsoft Visual Studio 2005, SQL Server Express makes it easy to develop data-driven applications that are rich in capability, offer enhanced storage security, and are fast to deploy. SQL Server Express is free to redistribute and can be seamlessly upgraded to more sophisticated versions of SQL Server.
Download1 (36.5 MB)
SQL Server Management Studio Express SQL Server Management Studio Express is installed by running the setup program for either SQL Server Express with Advanced Services or SQL Server Express Toolkit. Before you install SQL Server Management Studio Express, you must install MSXML 6.0.
For more information, see Managing SQL Server Express Edition with Management Studio Express.
Download2 (43.1 MB)
Applies To Deployment Solution 6.5 using MSDE or SQL or Deployment Solution 6.8 using SQL 64-bit ODBC connection
Imported Document ID: TECH12822
Subscribing will provide email updates when this Article is updated. Login is required.