none
how to identify my sql server name RRS feed

  • Question

  • i have installed SQL SERVER and i dont know my server name  .

    i tried with my  Pc name  but its also not accepting  

    can any  one  help me out how to  get my server name  r modify my sever  name  .

    Saturday, July 21, 2012 6:20 PM

Answers

All replies

  • Hello,

    The "Server name" is a combobox, expand it and select "<Browse...>", the function may should you the installed instance name.

    Other option: Open Windows Service Manager (services.msc) and head up for "SQL Server (here stands the instance name)".

    Have you installed the Express Edition with default settings? Then try .\SQLEXPRESS as server name.


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing

    Saturday, July 21, 2012 6:45 PM
  • start SQL Server Configuration Manager - under the node sql services you'll see all the sql services in the right pane together with their instance name.

    alternatively you can consult your SQL Server installation log file.

    what version & edition had you installed?


    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.


    Saturday, July 21, 2012 7:05 PM
  • helo,

    Open Windows Service Manager (services.msc) is not ther .

    and  I have   Express Edition2012 , i tryed  with .\SQLEXPRESS it  showing as connection failed

    Monday, July 23, 2012 7:09 AM
  • http://sqlserver-help.com/2011/06/19/help-whats-my-sql-server-name/

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    Monday, July 23, 2012 7:30 AM
    Moderator
  • check this video

    http://www.youtube.com/watch?v=DLrxFXXeLFk

    option 2

    open -> regedit adn search the below path for intance name

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL

    kb from

    http://blogs.msdn.com/b/askjay/archive/2011/10/11/how-can-i-get-a-list-of-installed-sql-server-instances.aspx


    Ramesh Babu Vavilla MCTS,MSBI


    Monday, July 23, 2012 10:02 AM