locked
Where or How can I find the name of my MSSQL 2008 R2 Server? RRS feed

  • Question

  • I installed MSSQL 2008 R2 on a windows 7. All I want to do is findout what the server name is. Where can I find it. How can I find it. Please help!!!!
    Friday, April 29, 2011 11:21 PM

Answers

  • Assuming you are working with SQL Express

    By default SQL Express is installed as a named instance of  SQLExpress

    you can connect to it using localhost\SQLExpress or <ComputerName>\SQLExpress
    as server name in management studio express (computrename is hostname of your computer)

    you can find your local instance (default or named) by opening SQL Server configuration manager (Start-->Run-->SQLServerManager10.msc) or from command prompt

    running

    SQLCMD -L



    • Marked as answer by Didgeralien Saturday, April 30, 2011 12:42 AM
    Friday, April 29, 2011 11:36 PM

All replies

  • Assuming you are working with SQL Express

    By default SQL Express is installed as a named instance of  SQLExpress

    you can connect to it using localhost\SQLExpress or <ComputerName>\SQLExpress
    as server name in management studio express (computrename is hostname of your computer)

    you can find your local instance (default or named) by opening SQL Server configuration manager (Start-->Run-->SQLServerManager10.msc) or from command prompt

    running

    SQLCMD -L



    • Marked as answer by Didgeralien Saturday, April 30, 2011 12:42 AM
    Friday, April 29, 2011 11:36 PM
  • Are you able to log in? If yes, then in SSMS just do

    SELECT @@SERVERNAME
    


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog
    Friday, April 29, 2011 11:36 PM
  • Thank you Chiraq!!! That did the trick..."and the minstrels all rejoiced"


    Sean R McCormick Erin Go Bragh
    Saturday, April 30, 2011 12:44 AM