SQL Server Performance

server asses

Discussion in 'SQL Server 2005 General DBA Questions' started by farrokhp, Jun 11, 2010.

  1. farrokhp New Member

    How can I say what servie accounts is for a sql server 2k or 2005 in windows xp or 2003 or vista?
    How can I find out what is the local sever name and what if there is any named sever?
    How can I know what people has admin acess to this server?
    What are the 5 or 10 first things you do when you inherit a new sql server?
    Thanks Folks
    farrokhp, Jun 11, 2010
    #2

  2. MohammedU New Member

    How can I say what servie accounts is for a sql server 2k or 2005 in windows xp or 2003 or vista?
    Questio is not clear...
    How can I find out what is the local sever name and what if there is any named sever?
    OSQL -L
    Check BOL http://msdn.microsoft.com/en-us/library/aa214012(v=SQL.80).aspx
    How can I know what people has admin acess to this server?
    Open query window and run the following select
    SELECT * FROM SYS.LOGINS WHERE SYSADMIN = 1
    What are the 5 or 10 first things you do when you inherit a new sql server?
    1. SQL Server configuration
    2. Backup and recovery plan
    3. Security
    4. HW configuration
    etc....
    MohammedU, Jun 12, 2010
    #3

  3. Luis Martin Moderator

    Home work?
    Interview?
    Luis Martin, Jun 13, 2010
    #4

  4. satya Moderator

    Using SQL Server configuration manager you can find the service account used for SQL Server services.
    FOr server name you can use SERVERPROPERTY function.
    Within the Security pane you can find what kind of logins do have the access.
    The first thing you go about SQL Server is to search on this site & books online for such similar questions to get more information.
    satya, Jun 14, 2010
    #5

Share This Page