Deployment Solution

 View Only
  • 1.  Deployment Console Unable to connect to sql server

    Posted Jul 01, 2013 11:30 AM

    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?

     



  • 2.  RE: Deployment Console Unable to connect to sql server
    Best Answer

    Posted Jul 01, 2013 01:27 PM

    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.



  • 3.  RE: Deployment Console Unable to connect to sql server

    Posted Jul 02, 2013 10:03 AM

    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!!