Video Screencast Help

Deployment Console Unable to connect to sql server

Created: 01 Jul 2013 • Updated: 02 Jul 2013 | 2 comments
This issue has been solved. See solution.

I am having an issue when I try to launch Deployment Console.  I am getting prompted to login with a username and password to Sql Express 2005.  

"The console was not able to connect to the site you selected.  Enter a user name and password to connect to the site or cancel to connect to another site."

I have tried every username and password I can think of and tried to enter the site manually with no luck.

It seems to me that the Deployment Console configuration does not know where to look for this database.  

I am able to go to the SQL Server Management Studio and see the database via the named pipe \\.\pipe\SQLLocal\MSSQLSERVER.  

Entering SQL Server Management Studio via the named pipes I can see the following databases.  System Database, eXpress, hpvmmsqldb, Inisight_V50_0_16125125 and PMP_v5_0

The database is up running and all of the Altiris services and SQLServer Service are started.  

Anyone have any suggestions on how I can get Deployment Console to start?

Operating Systems:

Comments 2 CommentsJump to latest comment

A Knoke's picture

I think I figured out my problem.  For some reason the ODBC drivers needed to be reconfigured to point at the server using the IP address instead of DNS.  Once I did this it all seemed to work again.

Thomas Baird's picture

Funny - that was my first thought - check your ODBC connection.  The DS console launch is essentially 2 steps: 1) launch the EXE from the Express share (or locally - makes no difference) and 2) use the ODBC connection to connect to the DB.  Thus, no matter where you launch the console from - locally or remotely - the process is identical.  So when you said you couldn't connect to the DB, the first thought it to check your ODBC settings.  Glad you found it first!!

Thomas Baird
Enthusiast for making things better!