Results 1 to 21 of 21

Thread: MSSQL 2008

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jun:2013
    Location: >.<
    Posts: 6,182

    MSSQL 2008

    (: , ).

    : ( , Windows 7 Pro, , ) MSSQL 2008 . 1 - . :



    :
    -
    - named pipes -
    - IPv6 ( hosts laptop10 IP localhost - , ping IPv4):

    Code:
    C:\Users\laptop>ping laptop10
    
    Pinging laptop10 [fe80::872:3d6e:f5f5:f5ee%16] with 32 bytes of data:
    Reply from fe80::872:3d6e:f5f5:f5ee%16: time<1ms
    Reply from fe80::872:3d6e:f5f5:f5ee%16: time<1ms
    Reply from fe80::872:3d6e:f5f5:f5ee%16: time<1ms
    Reply from fe80::872:3d6e:f5f5:f5ee%16: time<1ms
    
    Ping statistics for fe80::872:3d6e:f5f5:f5ee%16:
        Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
    Approximate round trip times in milli-seconds:
        Minimum = 0ms, Maximum = 0ms, Average = 0ms
    
    C:\Users\laptop>
    - :
    Code:
    C:\Users\laptop>sc query mssqlserver
    
    SERVICE_NAME: mssqlserver
            TYPE               : 10  WIN32_OWN_PROCESS
            STATE              : 4  RUNNING
                                    (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)
            WIN32_EXIT_CODE    : 0  (0x0)
            SERVICE_EXIT_CODE  : 0  (0x0)
            CHECKPOINT         : 0x0
            WAIT_HINT          : 0x0
    Code:
    C:\Users\laptop>sqlcmd -L
    
    Servers:
        LAPTOP10
    
    
    C:\Users\laptop>
    Code:
    C:\Users\laptop>sc query sqlbrowser
    
    SERVICE_NAME: sqlbrowser
            TYPE               : 10  WIN32_OWN_PROCESS
            STATE              : 4  RUNNING
                                    (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)
            WIN32_EXIT_CODE    : 0  (0x0)
            SERVICE_EXIT_CODE  : 0  (0x0)
            CHECKPOINT         : 0x0
            WAIT_HINT          : 0x0
    
    C:\Users\laptop>
    - ( )
    - , , , , - - Managment Studio ( - () ).
    - - ,
    - , DHCP -
    - - - , , ( , , ..)

    ?
    , .
    Last edited by user313; 27th May 2017 at 12:55.

  2. #2
    Registered User Rabfak's Avatar
    Join Date: Jun:2014
    Location:
    Posts: 1,715
    Server name "localhost" ?

  3. #3
    The Drapery Falls janko's Avatar
    Join Date: Dec:2002
    Location:
    Posts: 13,718
    TCP/IP- SQL-
    MSSQLserver
    , localhost,
    Last edited by janko; 27th May 2017 at 17:26.

  4. #4
    Registered User
    Join Date: Jun:2013
    Location: >.<
    Posts: 6,182
    Quote Originally Posted by janko View Post
    TCP/IP- SQL-
    MSSQLserver
    , localhost,
    ( 1 ). - .
    (mssqlserver) local - .


    Server name "localhost" ?
    :
    localhost
    127.0.0.1
    local
    .
    ip- 4
    ip- 6

    ( laptop10,1444 ( , , ) - : ; )

    .
    : Managment Studio- , 100% Managlent Studio .

    MSSQL, , .
    , , (, , , ..).

    - , MSSQL :

    Code:
    C:\Users\laptop>netstat -ano | findstr 3532
      UDP    0.0.0.0:1434           *:*                                    3532
      UDP    [::]:1434              *:*                                    3532
    
    C:\Users\laptop>
    TCP !!! .
    Last edited by user313; 27th May 2017 at 18:05.

  5. #5
    Registered User
    Join Date: Jan:2005
    Location: BG
    Posts: 4,903
    . localhost\SQLEXPRESS, localhost?
    , , ... ...

  6. #6
    Registered User
    Join Date: Jun:2013
    Location: >.<
    Posts: 6,182
    Quote Originally Posted by flancer View Post
    . localhost\SQLEXPRESS, localhost?
    , ,

  7. #7
    Registered User
    Join Date: Sep:2003
    Location: Where you live
    Posts: 976
    MSSQL, , :
    1. : 10.10.10.17, : 1433, 14333. MSSQL ? ,

    2. :

    C:\Users\laptop>netstat -ano | findstr 3532
    UDP 0.0.0.0:1434 *:* 3532
    UDP [::]:1434 *:* 3532

    , ipV4 ipV6 1434

    . , . :

    telnet localhost 1433
    telnet localhost 14333
    telnet 10.10.10.17 1433
    telnet 10.10.10.17 14333
    telnet localhost 1434
    telnet 10.10.10.17 1434

    , ...

  8. #8
    Registered User
    Join Date: Sep:2003
    Location: Where you live
    Posts: 976
    , , : 1433 14333 , 1434. UDP. 1433 ? SQL .

  9. #9
    Registered User
    Join Date: Jun:2013
    Location: >.<
    Posts: 6,182
    SP4 .

  10. #10
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , , , . $. SP SQL-a ( , ).
    , . , -, (vmware tools ) ..
    SP- , - , .. VM, , , 1:1 .
    IP -, .
    Win-a. .NET-, VC++ ..
    .
    Last edited by tedych; 28th May 2017 at 11:18.

  11. #11
    Registered User
    Join Date: Jun:2013
    Location: >.<
    Posts: 6,182
    Windows-a, MSSQL- - .
    .

    ( SP4 ), :

    Code:
    C:\Users\laptop>netstat -ano | findstr 1896
      TCP    0.0.0.0:1433           0.0.0.0:0              LISTENING       1896
      TCP    127.0.0.1:1434         0.0.0.0:0              LISTENING       1896
      TCP    [::]:1433              [::]:0                 LISTENING       1896
      TCP    [::1]:1434             [::]:0                 LISTENING       1896
    
    C:\Users\laptop>
    .

    , 2 30GB, 600-800GB .
    Last edited by user313; 28th May 2017 at 13:31.

  12. #12
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    10.10.10.... 192.168...., ..?
    .
    TCP/IP .
    , .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |