Deployment Server - Silent install with SQL User (not SA) not working

sscheube's picture

I am trying to run the silent installation of DS 6.9 SP3. The SQL Server is off-box and I have a SQL User, which is not the SA. The installation works perfectly if I am using the "GUI" however if I use the same user in the "silent.ini" the installation fails with the following error:

[144SQ] We are unable to login to the SQL Server testserver with the user name sa and the specified password.  Make sure that you have specified a supported SQL server with a valid user name and password.

You may need to use Windows NT authentication.

Has anyone come across this problem?

Pikoshi's picture

Dumb question here, what does

Dumb question here, what does the line SQLUsername= have as a value in your silent.ini?  It sounds like it may be set to the default of sa, or maybe the installer is just bypassing this line.

If your question was answered, mark the anwser as the solution
Give thumbs up if you found a post helpful

sscheube's picture

Dumb question or good question?

I actually had to check again if I am not telling something wrong. Actually I have a script which dynamicall changes the "Silent.ini" because I want to be able to provide the SQL Username name dynamically. And yes the username is not the sa if I use a username different then the SA.

So in my test I have created the sql user "altiris_sa" which has both "dbcreator" and "sysadmin" role. And once the script has changed the "silent.ini" shows the line SQLUsername=altiris_sa

Additionally the script checks with the same account if the "express" Database already exists and if yes it asks to delete it before continuing. That's also proves that I have access with the user to the sql server.

Have you tried it once yourself?

sscheube's picture

Bug!

I seems to be a bug in the Silent installation. It could be reproduced with by the Symantec Support. The backline is now investigating.

sscheube's picture

Known Issue kb49872

Find the KB article to this known issue here:

https://kb.altiris.com/article.asp?article=49872&p=1