locked
simplest way to verify installation RRS feed

  • Question

  • My PC runs Windows 7 Home Premium 64-bit. I installed VS2010 Pro, which installed SQL Server 2008 64-bit.

    In "Control Panel > Programs > Programs and Features > Uninstall or change a program", some lines associated with SQL Server contain the string "2008 R2". Some contain the string "2008" without the "R2".

    SS Configuration Manager shows SQL Server is running with the name SQLEXPRESS.

    What is the simplest way to verify that SS is running? Is there a command line I can enter in a CMD window to verify?

    Bill

    Thursday, February 17, 2011 4:49 PM

Answers

  •  check the sql server services are running ..

    To verify that the service is running, type sqlcmd –S(local)\SQLEXPRESS at the command prompt. If you see "1>" that means that you managed to connect .

     

    you can even verify through sql server configuration manger or services.msc

    -------------------
    Thanks,Suhas V

    • Marked as answer by Bill Swartz Thursday, February 17, 2011 7:55 PM
    Thursday, February 17, 2011 5:04 PM