none
SQL Server 2008 Erro ao Acessar SQL Server Management Studio RRS feed

  • Pergunta

  • Instalar o SQL 2008 em um Windows 2008 R2 certinho, atualizei tudo, o SQL 2008 com SP2, tudo bonito. Coloquei para funcionar uma base de testes, funcionando perfeitamente. Mas agora, ao acessar o SQL Server Management Studio, o sql dá um erro e pára de funcionar. Mando iniciar o serviço e funciona tudo, mas ao acessar o SQL SERVER MANAGER, pára de novo. ATENÇÃO: o SQL Server Manager da Máquina mesmo, externo não dá este erro. Segue o erro do event viewr SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
    Alessandro
    quinta-feira, 7 de julho de 2011 12:56

Respostas

  • Na boa.. reinstalei tudo, windows 2008 e sql 2008. Parece que agora tá tudo funcionando.

    Seguei os passos:

    http://support.microsoft.com/kb/955392/en-us

     

    PAra criar uma instalação já com o SP1.

     

    Depois apliquei o SP2

     

    E até agora o ambiente está estável.

     

    Vamos ver.


    Alessandro
    • Marcado como Resposta ELJusticeiro terça-feira, 12 de julho de 2011 13:53
    terça-feira, 12 de julho de 2011 13:53

Todas as Respostas

  • Alessandro

    Faz o seguinte

    1- do server que da o erro, tente acessar.. (vc vai tomar o erro...)
    2- da estação que vc conegue acessar execute o comando abaixo a pós a etapa acima
    exec  sp_readerrorlog 1

    Poste o resultado.

    Att.
    Marcelo Fernandes


    MCP, MCDBA, MCSA, MCTS.
    Se útil, classifique!!!
    Me siga no twitter: @marcelodba

    quinta-feira, 7 de julho de 2011 13:44
    Moderador
  • Msg10054, Level 20, State 0, Line 0
    Um erro no nível de transporte ocorreu ao enviar a solicitação ao servidor. (provider: Provedor TCP, error: 0 - Foi forçado o cancelamento de uma conexão existente pelo host remoto.)

    Porque o sistema pára, iniciei os serviços (sql server e agent), e rodei a sua query

     

    2011-07-07 10:51:36.460    Server    Error: 26073, Severity: 16, State: 1.
    2011-07-07 10:51:36.460    Server    TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket.  Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists, contact Technical Support.
    2011-07-07 10:52:46.310    Server    Error: 26073, Severity: 16, State: 1.
    2011-07-07 10:52:46.310    Server    TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket.  Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists, contact Technical Support.
    2011-07-07 10:52:48.650    Server    Error: 26073, Severity: 16, State: 1.
    2011-07-07 10:52:48.650    Server    TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket.  Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists, contact Technical Support.
    2011-07-07 10:52:48.930    Server    Error: 26073, Severity: 16, State: 1.
    2011-07-07 10:52:48.930    Server    TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket.  Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists, contact Technical Support.
    2011-07-07 10:53:19.470    Server    Error: 17311, Severity: 16, State: 1.
    2011-07-07 10:53:19.470    Server    SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
    2011-07-07 10:53:19.470    Server    Using 'dbghelp.dll' version '4.0.5'
    2011-07-07 10:53:19.480    Server    **Dump thread - spid = 0, EC = 0x0000000000000000
    2011-07-07 10:53:19.480    Server    ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0018.txt
    2011-07-07 10:53:19.480    Server    * *******************************************************************************
    2011-07-07 10:53:19.480    Server    *
    2011-07-07 10:53:19.480    Server    * BEGIN STACK DUMP:
    2011-07-07 10:53:19.480    Server    *   07/07/11 10:53:19 spid 4780
    2011-07-07 10:53:19.480    Server    *
    2011-07-07 10:53:19.480    Server    * ex_handle_except encountered exception C0000005 - Server terminating
    2011-07-07 10:53:19.480    Server    *
    2011-07-07 10:53:19.480    Server    *
    2011-07-07 10:53:19.480    Server    *  MODULE                          BASE      END       SIZE
    2011-07-07 10:53:19.480    Server    * sqlservr                       0000000000B60000  00000000043C5FFF  03866000
    2011-07-07 10:53:19.480    Server    * ntdll                          0000000077090000  0000000077238FFF  001a9000
    2011-07-07 10:53:19.480    Server    * kernel32                       0000000076F70000  000000007708EFFF  0011f000
    2011-07-07 10:53:19.480    Server    * KERNELBASE                     000007FEFD7B0000  000007FEFD81AFFF  0006b000
    2011-07-07 10:53:19.480    Server    * MSVCR80                        0000000074180000  0000000074248FFF  000c9000
    2011-07-07 10:53:19.480    Server    * msvcrt                         000007FEFF0D0000  000007FEFF16EFFF  0009f000
    2011-07-07 10:53:19.480    Server    * MSVCP80                        0000000073D60000  0000000073E68FFF  00109000
    2011-07-07 10:53:19.480    Server    * ADVAPI32                       000007FEFD8C0000  000007FEFD99AFFF  000db000
    2011-07-07 10:53:19.480    Server    * sechost                        000007FEFDD30000  000007FEFDD4EFFF  0001f000
    2011-07-07 10:53:19.480    Server    * RPCRT4                         000007FEFDB50000  000007FEFDC7CFFF  0012d000
    2011-07-07 10:53:19.480    Server    * sqlos                          0000000073CA0000  0000000073CA6FFF  00007000
    2011-07-07 10:53:19.480    Server    * Secur32                        000007FEFD100000  000007FEFD10AFFF  0000b000
    2011-07-07 10:53:19.480    Server    * SSPICLI                        000007FEFD380000  000007FEFD3A4FFF  00025000
    2011-07-07 10:53:19.480    Server    * pdh                            000007FEF7620000  000007FEF766DFFF  0004e000
    2011-07-07 10:53:19.480    Server    * SHLWAPI                        000007FEFDCA0000  000007FEFDD10FFF  00071000
    2011-07-07 10:53:19.480    Server    * GDI32                          000007FEFD9A0000  000007FEFDA06FFF  00067000
    2011-07-07 10:53:19.480    Server    * USER32                         0000000076BC0000  0000000076CB9FFF  000fa000
    2011-07-07 10:53:19.480    Server    * LPK                            000007FEFDA70000  000007FEFDA7DFFF  0000e000
    2011-07-07 10:53:19.480    Server    * USP10                          000007FEFDA80000  000007FEFDB48FFF  000c9000
    2011-07-07 10:53:19.480    Server    * USERENV                        000007FEFC830000  000007FEFC84DFFF  0001e000
    2011-07-07 10:53:19.480    Server    * profapi                        000007FEFD4F0000  000007FEFD4FEFFF  0000f000
    2011-07-07 10:53:19.480    Server    * WINMM                          000007FEF75E0000  000007FEF761AFFF  0003b000
    2011-07-07 10:53:19.480    Server    * opends60                       0000000073CC0000  0000000073CC7FFF  00008000
    2011-07-07 10:53:19.480    Server    * NETAPI32                       000007FEFB3C0000  000007FEFB3D5FFF  00016000
    2011-07-07 10:53:19.480    Server    * netutils                       000007FEFB3B0000  000007FEFB3BBFFF  0000c000
    2011-07-07 10:53:19.480    Server    * srvcli                         000007FEFD040000  000007FEFD062FFF  00023000
    2011-07-07 10:53:19.480    Server    * wkscli                         000007FEFB390000  000007FEFB3A4FFF  00015000
    2011-07-07 10:53:19.480    Server    * LOGONCLI                       000007FEFCE20000  000007FEFCE4FFFF  00030000
    2011-07-07 10:53:19.480    Server    * SAMCLI                         000007FEFA8E0000  000007FEFA8F3FFF  00014000
    2011-07-07 10:53:19.480    Server    * BatchParser                    0000000073550000  000000007357BFFF  0002c000
    2011-07-07 10:53:19.480    Server    * IMM32                          000007FEFF170000  000007FEFF19DFFF  0002e000
    2011-07-07 10:53:19.480    Server    * MSCTF                          000007FEFE230000  000007FEFE338FFF  00109000
    2011-07-07 10:53:19.480    Server    * psapi                          0000000077260000  0000000077266FFF  00007000
    2011-07-07 10:53:19.480    Server    * instapi10                      0000000073CB0000  0000000073CBCFFF  0000d000
    2011-07-07 10:53:19.480    Server    * cscapi                         000007FEF75B0000  000007FEF75BEFFF  0000f000
    2011-07-07 10:53:19.480    Server    * sqlevn70                       0000000073A50000  0000000073C4EFFF  001ff000
    2011-07-07 10:53:19.480    Server    * CRYPTSP                        000007FEFCD40000  000007FEFCD56FFF  00017000
    2011-07-07 10:53:19.480    Server    * rsaenh                         000007FEFCA70000  000007FEFCAB6FFF  00047000
    2011-07-07 10:53:19.480    Server    * CRYPTBASE                      000007FEFD420000  000007FEFD42EFFF  0000f000
    2011-07-07 10:53:19.480    Server    * BROWCLI                        000007FEF5590000  000007FEF55A1FFF  00012000
    2011-07-07 10:53:19.480    Server    * AUTHZ                          000007FEFCF90000  000007FEFCFBEFFF  0002f000
    2011-07-07 10:53:19.480    Server    * MSCOREE                        000007FEFA830000  000007FEFA89EFFF  0006f000
    2011-07-07 10:53:19.480    Server    * mscoreei                       000007FEFA7A0000  000007FEFA82FFFF  00090000
    2011-07-07 10:53:19.480    Server    * ole32                          000007FEFDDA0000  000007FEFDFA2FFF  00203000
    2011-07-07 10:53:19.480    Server    * credssp                        000007FEFC940000  000007FEFC949FFF  0000a000
    2011-07-07 10:53:19.480    Server    * msv1_0                         000007FEFCC30000  000007FEFCC80FFF  00051000
    2011-07-07 10:53:19.480    Server    * cryptdll                       000007FEFD070000  000007FEFD083FFF  00014000
    2011-07-07 10:53:19.480    Server    * kerberos                       000007FEFCD60000  000007FEFCE13FFF  000b4000
    2011-07-07 10:53:19.480    Server    * MSASN1                         000007FEFD590000  000007FEFD59EFFF  0000f000
    2011-07-07 10:53:19.480    Server    * schannel                       000007FEFCAC0000  000007FEFCB16FFF  00057000
    2011-07-07 10:53:19.480    Server    * CRYPT32                        000007FEFD5A0000  000007FEFD706FFF  00167000
    2011-07-07 10:53:19.480    Server    * security                       0000000073A40000  0000000073A42FFF  00003000
    2011-07-07 10:53:19.480    Server    * WS2_32                         000007FEFDD50000  000007FEFDD9CFFF  0004d000
    2011-07-07 10:53:19.480    Server    * NSI                            000007FEFDD20000  000007FEFDD27FFF  00008000
    2011-07-07 10:53:19.480    Server    * SHELL32                        000007FEFE340000  000007FEFF0C7FFF  00d88000
    2011-07-07 10:53:19.480    Server    * OLEAUT32                       000007FEFF1A0000  000007FEFF276FFF  000d7000
    2011-07-07 10:53:19.480    Server    * ftimport                       0000000060000000  0000000060024FFF  00025000
    2011-07-07 10:53:19.480    Server    * MSFTE                          0000000049980000  0000000049D2DFFF  003ae000
    2011-07-07 10:53:19.480    Server    * VERSION                        000007FEFC600000  000007FEFC60BFFF  0000c000
    2011-07-07 10:53:19.480    Server    * dbghelp                        0000000072E90000  0000000072FEDFFF  0015e000
    2011-07-07 10:53:19.480    Server    * WINTRUST                       000007FEFD820000  000007FEFD859FFF  0003a000
    2011-07-07 10:53:19.480    Server    * ntmarta                        000007FEFC6F0000  000007FEFC71CFFF  0002d000
    2011-07-07 10:53:19.480    Server    * WLDAP32                        000007FEFDA10000  000007FEFDA61FFF  00052000
    2011-07-07 10:53:19.480    Server    * ncrypt                         000007FEFCF00000  000007FEFCF4DFFF  0004e000
    2011-07-07 10:53:19.480    Server    * bcrypt                         000007FEFCEC0000  000007FEFCEE1FFF  00022000
    2011-07-07 10:53:19.480    Server    * PCTLsp64                       000000000C450000  000000000C4C2FFF  00073000
    2011-07-07 10:53:19.480    Server    * mswsock                        000007FEFCC90000  000007FEFCCE4FFF  00055000
    2011-07-07 10:53:19.480    Server    * wship6                         000007FEFCEF0000  000007FEFCEF6FFF  00007000
    2011-07-07 10:53:19.480    Server    * wshtcpip                       000007FEFC6D0000  000007FEFC6D6FFF  00007000
    2011-07-07 10:53:19.480    Server    * ntdsapi                        000007FEF7570000  000007FEF7596FFF  00027000
    2011-07-07 10:53:19.480    Server    * bcryptprimitives               000007FEFC990000  000007FEFC9DBFFF  0004c000
    2011-07-07 10:53:19.480    Server    * CLBCatQ                        000007FEFE190000  000007FEFE228FFF  00099000
    2011-07-07 10:53:19.480    Server    * sqlncli10                      000000006FB10000  000000006FE18FFF  00309000
    2011-07-07 10:53:19.480    Server    * COMCTL32                       000007FEF7F20000  000007FEF7FBFFFF  000a0000
    2011-07-07 10:53:19.480    Server    * COMDLG32                       000007FEFF280000  000007FEFF316FFF  00097000
    2011-07-07 10:53:19.480    Server    * SQLNCLIR10                     0000000072D70000  0000000072DA6FFF  00037000
    2011-07-07 10:53:19.480    Server    * netbios                        000007FEE31D0000  000007FEE31D9FFF  0000a000
    2011-07-07 10:53:19.480    Server    * xpsqlbot                       0000000072D60000  0000000072D67FFF  00008000
    2011-07-07 10:53:19.480    Server    * xpstar                         0000000072CD0000  0000000072D57FFF  00088000
    2011-07-07 10:53:19.480    Server    * SQLSCM                         0000000073510000  000000007351BFFF  0000c000
    2011-07-07 10:53:19.480    Server    * ODBC32                         000007FEF0020000  000007FEF00D0FFF  000b1000
    2011-07-07 10:53:19.480    Server    * ATL80                          0000000074090000  00000000740AEFFF  0001f000
    2011-07-07 10:53:19.480    Server    * odbcint                        0000000072B70000  0000000072BA7FFF  00038000
    2011-07-07 10:53:19.480    Server    * xpstar                         0000000072CA0000  0000000072CC4FFF  00025000
    2011-07-07 10:53:19.480    Server    * xplog70                        0000000072C40000  0000000072C4FFFF  00010000
    2011-07-07 10:53:19.480    Server    * xplog70                        0000000072BB0000  0000000072BB1FFF  00002000
    2011-07-07 10:53:19.480    Server    * SAMLIB                         000007FEFAC10000  000007FEFAC2CFFF  0001d000
    2011-07-07 10:53:19.480    Server    * dsrole                         000007FEFC6E0000  000007FEFC6EBFFF  0000c000
    2011-07-07 10:53:19.480    Server    * DNSAPI                         000007FEFCB20000  000007FEFCB7AFFF  0005b000
    2011-07-07 10:53:19.480    Server    * IPHLPAPI                       000007FEFB8E0000  000007FEFB906FFF  00027000
    2011-07-07 10:53:19.480    Server    * WINNSI                         000007FEFB880000  000007FEFB88AFFF  0000b000
    2011-07-07 10:53:19.480    Server    * rasadhlp                       000007FEEFA80000  000007FEEFA87FFF  00008000
    2011-07-07 10:53:19.480    Server    * fwpuclnt                       000007FEFB6B0000  000007FEFB702FFF  00053000
    2011-07-07 10:53:19.480    Server    * dbghelp                        0000000067A20000  0000000067B7DFFF  0015e000
    2011-07-07 10:53:19.480    Server    *
    2011-07-07 10:53:19.480    Server    *     P1Home: 00000000118FCB98:  0000000000000000  0000000000000000  0000000000000000  0000000000000000  0000000000000000  0000000000000000 
    2011-07-07 10:53:19.480    Server    *     P2Home: 00000000770E6279:  4100000110C48148  5F5C415D415E415F  9090909090C35B5E  9090909090909090  FF90909090909090  EC814856415441F6 
    2011-07-07 10:53:19.480    Server    *     P3Home: 00000000118FCB91:  0000000000000000  0000000000000000  0000000000000000  0000000000000000  0000000000000000  0000000000000000 
    2011-07-07 10:53:19.480    Server    *     P4Home: 00000000005A5BC0:  005C003F003F020F  0050005C003A0043  00720067006F0072  00460020006D0061  00730065006C0069  00630069004D005C 
    2011-07-07 10:53:19.480    Server    *     P5Home: 0000000000000230: 
    2011-07-07 10:53:19.480    Server    *     P6Home: 00000000004C0000:  0000000000000000  01005E9CCE7AE5CE  00000000FFEEFFEE  000000000CDC0018  00000000004C0128  00000000004C0000 
    2011-07-07 10:53:19.480    Server    * ContextFlags: 000000000010000F: 
    2011-07-07 10:53:19.480    Server    *      MxCsr: 0000000000001F80: 
    2011-07-07 10:53:19.480    Server    *      SegCs: 0000000000000033: 
    2011-07-07 10:53:19.480    Server    *      SegDs: 000000000000002B: 
    2011-07-07 10:53:19.490    Server    *      SegEs: 000000000000002B: 
    2011-07-07 10:53:19.490    Server    *      SegFs: 0000000000000053: 
    2011-07-07 10:53:19.490    Server    *      SegGs: 000000000000002B: 
    2011-07-07 10:53:19.490    Server    *      SegSs: 000000000000002B: 
    2011-07-07 10:53:19.490    Server    *     EFlags: 0000000000000206: 
    2011-07-07 10:53:19.490    Server    *        Rax: 000000006687859C: 
    2011-07-07 10:53:19.490    Server    *        Rcx: 00000000118FCA00:  00000000118FCB98  00000000770E6279  00000000118FCB91  00000000005A5BC0  0000000000000230  00000000004C0000 
    2011-07-07 10:53:19.490    Server    *        Rdx: 0000000000000000: 
    2011-07-07 10:53:19.490    Server    *        Rbx: 0000000000000000: 
    2011-07-07 10:53:19.490    Server    *        Rsp: 00000000118FD010:  0000000000000000  00000000118FD2C0  0000000000000000  000000000CE87788  00000000000042AC  0000000000000000 
    2011-07-07 10:53:19.490    Server    *        Rbp: 00000000118FF940:  0000000000000000  0000000000000000  0000000000000000  0000000000000000  0000000077009330  0000000077009330 
    2011-07-07 10:53:19.490    Server    *        Rsi: 00000000118FD2C0:  000000000CE87780  0000000000000000  0000000000000000  0000000000000000  0000000000000000  0000000000000000 
    2011-07-07 10:53:19.490    Server    *        Rdi: 0000000000000000: 
    2011-07-07 10:53:19.490    Server    *         R8: 0000000000000000: 
    2011-07-07 10:53:19.490    Server    *         R9: 0000000000000000: 
    2011-07-07 10:53:19.490    Server    *        R10: 0000000000000000: 
    2011-07-07 10:53:19.490    Server    *        R11: 00000000118FD800:  00000000118FCB98  00000000770E6279  00000000118FCB91  00000000005A5BC0  0000000000000230  00000000004C0000 
    2011-07-07 10:53:19.490    Server    *        R12: 000000000000003F: 
    2011-07-07 10:53:19.490    Server    *        R13: 0000000000000000: 
    2011-07-07 10:53:19.490    Server    *        R14: 00000000118FE6D0:  0068005F00780065  006C0064006E0061  00780065005F0065  0074007000650063  0063006E00650020  0074006E0075006F 
    2011-07-07 10:53:19.490    Server    *        R15: 0000000000000001: 
    2011-07-07 10:53:19.490    Server    *        Rip: 000007FEFD7BA49D:  C3000000C8C48148  003B830874F68548  0001BD1689660376  02D6840FFD3B0000  F3840F02FF830000  870F07FF83000002 
    2011-07-07 10:53:19.490    Server    * *******************************************************************************
    2011-07-07 10:53:19.490    Server    * -------------------------------------------------------------------------------
    2011-07-07 10:53:19.490    Server    * Short Stack Dump
    2011-07-07 10:53:19.490    Server    000007FEFD7BA49D Module(KERNELBASE+000000000000A49D)
    2011-07-07 10:53:19.490    Server    00000000024ECBDD Module(sqlservr+000000000198CBDD)
    2011-07-07 10:53:19.500    Server    00000000024FB966 Module(sqlservr+000000000199B966)
    2011-07-07 10:53:19.500    Server    00000000024FC009 Module(sqlservr+000000000199C009)
    2011-07-07 10:53:19.500    Server    00000000022E228C Module(sqlservr+000000000178228C)
    2011-07-07 10:53:19.520    Server    0000000077009490 Module(kernel32+0000000000099490)
    2011-07-07 10:53:19.520    Server    00000000771243B8 Module(ntdll+00000000000943B8)
    2011-07-07 10:53:19.520    Server    00000000770A85A8 Module(ntdll+00000000000185A8)
    2011-07-07 10:53:19.520    Server    00000000770B9D0D Module(ntdll+0000000000029D0D)
    2011-07-07 10:53:19.520    Server    00000000770A91AF Module(ntdll+00000000000191AF)
    2011-07-07 10:53:19.520    Server    00000000770E1278 Module(ntdll+0000000000051278)
    2011-07-07 10:53:19.520    Server    00000000770DE4B4 Module(ntdll+000000000004E4B4)
    2011-07-07 10:53:19.520    Server    00000000770DE3DB Module(ntdll+000000000004E3DB)
    2011-07-07 10:53:19.520    Server    000000000C4540CD Module(PCTLsp64+00000000000040CD)
    2011-07-07 10:53:19.520    Server    000000000C454721 Module(PCTLsp64+0000000000004721)
    2011-07-07 10:53:19.520    Server    000000000C455454 Module(PCTLsp64+0000000000005454)
    2011-07-07 10:53:19.520    Server    0000000076F8652D Module(kernel32+000000000001652D)
    2011-07-07 10:53:19.520    Server    00000000770BC521 Module(ntdll+000000000002C521)
    2011-07-07 10:53:19.520    Server    Stack Signature for the dump is 0x00000001BB0D7B75
    2011-07-07 10:53:19.820    Server    External dump process return code 0x20000001.  External dump process returned no errors.
    2011-07-07 10:53:19.820    spid9s    SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. 


    Alessandro
    quinta-feira, 7 de julho de 2011 13:57
  • Só completando, o meu maior medo é que estou migrando 2000 para 2008, (uso protheus, totvs), restaurei backup e comecei os testes, durante uns 3 dias funcionou perfeitamente, mas parece que depois de atualizações do windows, começou este problema.

     

    Já ia colocar em produção.


    Alessandro
    quinta-feira, 7 de julho de 2011 14:00
  • Alessandro

    probleminha de rede ou placa de rede... o KB abaixo vai ajudar...

    http://support.microsoft.com/kb/2491214

    Att.
    Marcelo Fernandes


    MCP, MCDBA, MCSA, MCTS.
    Se útil, classifique!!!
    Me siga no twitter: @marcelodba

    quinta-feira, 7 de julho de 2011 14:14
    Moderador
  • Agora ao dar o comando.

     

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Failed to start debugger

    ------------------------------
    ADDITIONAL INFORMATION:

    Error HRESULT E_FAIL has been returned from a call to a COM component. (mscorlib)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------


    Alessandro
    quinta-feira, 7 de julho de 2011 14:14
  • Veja o KB que passei.. aplique o CU6

     

    Att.
    Marcelo Fernandes


    MCP, MCDBA, MCSA, MCTS.
    Se útil, classifique!!!
    Me siga no twitter: @marcelodba

    quinta-feira, 7 de julho de 2011 14:15
    Moderador
  • Desculpa incomodar, mas qual arquivo especificamente baixar, tem um monte de arquivos lá.

     

    E parece ser isso mesmo, pois ao usar (local) ao invés de endereço ip ou nome da máquina funciona perfeitamente.


    Alessandro
    quinta-feira, 7 de julho de 2011 14:30
  • Alessandro

    este é o link para o CU6 do SQL 2008 R2

    http://support.microsoft.com/kb/2489376

    Qual versão do Windows? esta com o ultimo SP?

    no KB que te enviei anteriomente tem um workaround que vc altera umas chaves de registros...

    Att.
    Marcelo Fernandes

     


    MCP, MCDBA, MCSA, MCTS.
    Se útil, classifique!!!
    Me siga no twitter: @marcelodba

    quinta-feira, 7 de julho de 2011 15:17
    Moderador
  • Sim, meu Windows é R2 com SP1. Mas os meu Sql 2008 acredito não ser o R2.
    Alessandro
    quinta-feira, 7 de julho de 2011 16:40
  • Alessandro

    execute ocomando select @@version e poste o resutado...

    att.
    Marcelo Fernandes


    MCP, MCDBA, MCSA, MCTS.
    Se útil, classifique!!!
    Me siga no twitter: @marcelodba

    quinta-feira, 7 de julho de 2011 17:12
    Moderador
  • Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64)   Feb 25 2011 13:56:11   Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
    Alessandro
    quinta-feira, 7 de julho de 2011 17:29
  • Alessandro,

    Segue o ultimo Cumulative Update do SQL

    http://support.microsoft.com/kb/2527180

    vc fez o workaround? deu certo?

    Att.
    Marcelo Fernandes


    MCP, MCDBA, MCSA, MCTS.
    Se útil, classifique!!!
    Me siga no twitter: @marcelodba

    quinta-feira, 7 de julho de 2011 19:12
    Moderador
  • No registro?? fiz e não funcionou. to baixando os hotfix deste link que você mandou.
    Alessandro
    quinta-feira, 7 de julho de 2011 19:13
  •  

    Baixei os hotfix:

     

    SQL Server 2008 All (Global) x64 sp2 2008_SP2_RSShrPnt_CU4_2527180_10_00_4285_x64
    <input id="chk433016" type="checkbox" /> SQL Server 2008 All (Global) x64 sp2 SQLServer2008_SP2_CU4_2527180_10_00_4285_X64
    <input id="chk433018" type="checkbox" /> SQL Server 2008 All (Global) x64 sp2 2008_SP2_SNAC_CU4_2527180_10_00_4285_x64

     

    Hum tenteni instalar não instalou, versão incompatível. Então instalei somente um.

     

    Mas continua do mesmo jeito. É to achando que vou continuar com o sql server 2000, está estável, só está pesado.

    Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64)   Feb 25 2011 13:56:11   Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition

    (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)


    Alessandro
    sexta-feira, 8 de julho de 2011 11:37
  • Alessandro

    se vc tem um contrato premier com a Microsoft abre um chamado, mas tente permanecer no 2008, o 2000 já perdeu o suporte...

    Se este ambiente ainda não estiver em produção avalie a possibilidade de aplicar este fix do Windows

    http://support.microsoft.com/kb/2398202

    OBS. para windows 2008 ! e precisa reinicar o server após a aplci~ção do fix

    Att.
    Marcelo Fernandes


    MCP, MCDBA, MCSA, MCTS.
    Se útil, classifique!!!
    Me siga no twitter: @marcelodba


    sexta-feira, 8 de julho de 2011 18:15
    Moderador
  • Na boa.. reinstalei tudo, windows 2008 e sql 2008. Parece que agora tá tudo funcionando.

    Seguei os passos:

    http://support.microsoft.com/kb/955392/en-us

     

    PAra criar uma instalação já com o SP1.

     

    Depois apliquei o SP2

     

    E até agora o ambiente está estável.

     

    Vamos ver.


    Alessandro
    • Marcado como Resposta ELJusticeiro terça-feira, 12 de julho de 2011 13:53
    terça-feira, 12 de julho de 2011 13:53