Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

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

Updated: 21 May 2010 | 4 comments
sscheube's picture
0 0 Votes
Login to vote

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?

Comments

Pikoshi's picture
13
Oct
2009
0 Votes 0
Login to vote

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
20
Oct
2009
0 Votes 0
Login to vote

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
27
Oct
2009
0 Votes 0
Login to vote

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
30
Oct
2009
0 Votes 0
Login to vote

Known Issue kb49872

Find the KB article to this known issue here:

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