Unable to run DBInstaller.exe

[Migration User]

I'm setting up a new Deployment Server and when I try to install either DS 6.8 SP1 I get the error - Setup was unable to run "DBInstaller.exe" to create the "eXpress" SQL database...Cancelling Setup...

I looked in the Knowledgebase and tried to follow the suggestions but I still can't install.

I am attempting to create a new database on an existing Deployment Server already running in our environment. Info from Altiris' knowledgebase says a possible issue is not having permissions to create a database on the destination, I verified with my DBA and I do have permissions.

Anyone have any input?

Jason

[Migration User]

Someone else had this problem recently and it was because SP4 for SQL was not installed on the SQL server.

[Migration User]

I found that post, at first it was SQL SP3a but it is not updated to SP4 and I still get the error.

[Migration User]

This drove me crazy!!

According to other forum posts and knowledge base articles I tried the following (among other things):
I made sure I'm using a domain account which has rights.
I used the SQL account which has rights to the database.
I had checked and TCP/IP and named pipes were enabled.
I had tried using both ports 1433 and 2799 for the TCP/IP settings for the SQL settings.
I had checked to make sure the ODBC settings are correct and tested them.

Every time I got the dbinstaller failed message.
I checked the dbinstaller.log and saw the following:
Neither the option -cd nor -ud option is available

That led me to know that it had to be something with SQL. I was using the custom install. On the screen that asks for the SQL password I had been changing it to our specific "sa" account with the password. I tried it again using "Windows authentication" and it successfully installed. (That is the default option, btw.)

[Migration User]

I've got the same issue as well too.

Let me ask you, how are you running your setup install?

To resolve my issue I had to install SQL SP4 and run the setup using the "Simple" option.

[Migration User]

I use the Custom because I have my install go to a bigger drive on my DS server.

[Migration User]

I'm bumping this ... I have the same thing.

[Migration User]

I'm having the same issue with a test install of DS 6.9 beta. I've installed SQL Express 2005, which it requires. It's the SP2 Advanced version of Express. I get the error with SA or Windows credentials.

[Migration User]

OK, I've solved this one. Check out article 2044 in the Altiris knowledge base.

If you're running SQL Express 2005 like I am on the 6.9 product, you have to adjust the directions give in the KN article. In SQL Server Config Mgr, click on Network Config...Protocols...then enable Named Pipes and TCP/IP. Also, double-click on TCP/IP...the IP Adresses tab, and set the IP Port (I set IP-ALL to port 1433). The SQL Help file says this is enabled by default, but I didn't get the install to work unless I manuallt specified the port here. Restart the SQL service and it should work.

One note: I'm doing this in a test environment. Change settings as you need in a production setting.

[Migration User]

I have used all steps in all of these articles mentioned. I still get the error. I have verified the account I am using has permissions on the DS server, as well as the server the database is housed on. I still get the error. I also followed the instructions I found in another KB about manually updating the database by running server.exe. That did not work because it never extracted the files.


There isn't any reason I can't go from DS 6.8 SP1 to 6.9, is there? I no longer see DS 6.8 SP2 available as a download, so I have skipped that version. I need to get this done this week, as we are currently on Spring Break. I need to have all clients updated before the teachers/students come back next week. Does anybody have any ideas?

[Migration User]

This, as is usually the case for me, was user error. I was still trying to use the port number from our old SQL 2000 instance. We have migrated this database to a new SQL 2005 instance. As soon as I found out what the correct port was for the database, the update from 6.8 SP1 to 6.9 went without a hitch. We are now running the console @ 6.9 and the clients are slowly upgrading to the new version. Make sure you are using the correct SQL instance TCP port.

[Migration User]

I had the same problem, followed the information and KB that bzilinek gave and everything worked. Thanks for the info.

[Migration User]

can someone post a line to that KB atricle, becuase i searched for it, and it cant find it.... the search in this KB program is certainly not the best.

[Migration User]

quote:

---

Originally posted by: [e-mail]
can someone post a line to that KB atricle, becuase i searched for it, and it cant find it.... the search in this KB program is certainly not the best.

---

I don't know if you still need this information, as the last update was from June, but the article number is 2044. Just go to http://kb.altiris.com In the search line, just type in 2044 and it will take you to the article.