Version 16


    3rd party DB Connectivity Test Utility Attached (Please download the attachment )


    If you want to quickly test a database connection this is it.

    You can also use this to quickly execute sql command and see the output in a grid.

    Provides exception information to help troubleshoot connection issues. for more details please find the link below.


    Database Connection String / Command / SQL Tester Utililty Download Link


    Database Connection String / Command / Sql Tester - Home

     

    Quick Database Connectivity Testing

    http://sqlblog.com/blogs/andy_leonard/archive/2011/08/26/quick-database-connectivity-testing.aspx

     

    ********* DOWNLOAD LINKS FOR SQL SERVER EXPRESS EDITION  ******

    SQL 2005

    http://www.microsoft.com/en-us/download/details.aspx?id=21844

     

    SQL 2005 SP 4

    Download SQL Server 2005 Express Edition SP4 from Official Microsoft Download Center

     

    SQL 2008 RTM (MGMT TOOLS INCLUDED )

    Download details: Microsoft® SQL Server® 2008 R2 SP2 - Express Edition - Microsoft Download Center

     

    SQL 2012 SP1 CTP

    Download Microsoft® SQL Server® 2012 Express from Official Microsoft Download Center

    http://www.microsoft.com/en-ie/download/details.aspx?id=34700

    Download Microsoft® SQL Server® 2012 Express from Official Microsoft Download Center

     

    ********** HOW TO INSTALL SQL SERVER STEP BY STEP GUIDE ***********

    http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide.aspx

     

    http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/

     

    http://www.sqlcoffee.com/SQLServer2008_0013.htm

    ******************************************************************************************

     

    ********** DATABASE CONNECTION SETTINGS REQUIRED DURING NPM INSTALLATION *********

     

    In order to verify connectivity from Orion NPM server &  SQL DB Server  .

    Please download SQL Studio Management Client and install on Orion Server to verify the connectivity from Orion server to required SQL Server.  ( Please chose required Version as matching with your SQL Server installed )

    If you have failure with SQL Studio Please consult your Database Manager for further support.

    SQL 2008

    http://www.microsoft.com/en-ie/download/details.aspx?id=7593

    SQL 2005

    http://www.microsoft.com/en-ie/download/details.aspx?id=8961

    SQL 2012

    Download Microsoft® SQL Server® 2012 Express from Official Microsoft Download Center

    http://freewareupdate.com/developer-tools/4446-2935693919883077577837190221163836935304436249923857738807915379845127

     

    Step-by-Step: Installing SQL Server Management Studio 2008

     

    Download Link Microsoft® SQL Server® 2008 Management Studio Express

     

    http://www.microsoft.com/en-us/download/details.aspx?id=7593

     

    http://www.codefrenzy.net/2011/06/03/how-to-install-sql-server-2008-management-studio/

     

    http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx

    Video Help

    How to install SQL Server 2008 Management Studio Express on Windows 7 - YouTube

    db1.jpg

    Please Note . Orion Configuration Wizard shares the same information as above during installation while connecting with SQL Server .

    db3.jpg

     

     

    Please use the same connection information with Orion Database Manager as below

    db2.jpg