none
打开sql server management studio 2008 报错,求解 RRS feed

  • 问题

  • sql server 2008 安装在windows server 2008上,安装后可以正常使用,但是过一段时间后再打开这个管理工具,就报错,

    错误显示为:SSMS-sql server management studio has stopped working

    下面的详细信息为:

    Problem signature:
      Problem Event Name: APPCRASH
      Application Name: Ssms.exe
      Application Version: 2007.100.1600.22
      Application Timestamp: 48753da6
      Fault Module Name: Ssms.exe
      Fault Module Version: 2007.100.1600.22
      Fault Module Timestamp: 48753da6
      Exception Code: c0000005
      Exception Offset: 0013e016
      OS Version: 6.1.7600.2.0.0.274.10
      Locale ID: 1033
      Additional Information 1: 0a9e
      Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
      Additional Information 3: 0a9e
      Additional Information 4: 0a9e372d3b4ad19135b953a78882e789

    Read our privacy statement online:
      http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

    If the online privacy statement is not available, please read our privacy statement offline:
      C:\Windows\system32\en-US\erofflps.txt

     

    重装这个工具后,又可以使用,但是过几天,又不能用,求答案!!!

    还有一个问题是,这个管理工具为什么安装在program files(x86)文件夹上,没有64位的 management tool吗?

    2010年9月1日 8:04

答案

  • 不过按道理,sql server 2008是可以正常运行的,程序可以正常运行,只是一个管理工具不能用,这是sp1的问题吗?
    Looks like something is wrong in your rtm onstallatio package, sp1 may fix it.
    2010年9月3日 3:30

全部回复

  • Any related error in windows event logs? Did you apply sql2k8 sp1? Yes, it's in 32-bit folder only.
    2010年9月1日 12:59
  • C:\Windows\system32\en-US\erofflps.txt

    这里面写的是什么?

    sql server 并不是所有的组件都支持 64 位, 至少像 managent studion 和 prifile 这些工具还是 32 位的

    2010年9月2日 4:48
  • C:\Windows\system32\en-US\erofflps.txt的内容为


    Windows 7 Offline Privacy Statement for the Microsoft Error Reporting Service

    For the most up-to-date privacy information, see the online Windows 7 Privacy Statement at:

    http://go.microsoft.com/fwlink/?LinkId=104288

    WHAT THIS FEATURE DOES

    The Microsoft Error Reporting Service helps Microsoft and Microsoft partners diagnose problems in the software you use and provide solutions. Not all problems have solutions, but when solutions are available, they are offered as steps to solve a problem you’ve reported or as updates to install. To help prevent problems and make software more reliable, some solutions are also included in service packs and future versions of the software.

    The Microsoft Error Reporting Service also provides Setup Repair, an error reporting service that may run during Windows setup if a problem occurs.

    INFORMATION COLLECTED, PROCESSED, OR TRANSMITTED

    Many Microsoft software programs, including Windows 7, are designed to work with the reporting service. If a problem occurs in one of these software programs, you might be asked if you want to report it.  If you host virtual machines using a Windows operating system, reports generated by the Windows operating system for the Microsoft Error Reporting Service might include information about virtual machines.

    The reporting service collects information that is useful for diagnosing and solving the problem that has occurred, such as:

      *  Where the problem happened in the software or hardware
      *  The type or severity of the problem
      *  Files that help describe the problem
      *  Basic software and hardware information
      *  Possible software performance and compatibility problems

    These reports might unintentionally contain personal information. For example, a report that contains a snapshot of computer memory might include your name, part of a document you were working on, or data that you recently submitted to a website. If a report is likely to contain this type of information, Windows will ask if you want to send this information, even if you have enabled automatic reporting through the “Recommended settings” option in setup, or Control Panel. This gives you the opportunity to review the report before sending it to Microsoft. Reports including files and data might be stored on your computer until you have an opportunity to review and send them, or after they have been sent.

    If an error report contains personal information, Microsoft does not use the information to identify you or contact you. In addition, if you enable automatic reporting through the "Recommended settings" option in setup, or in Control Panel, the reporting service will send basic information about where problems occur automatically, but these reports will not have the detail described above.

    After you send a report, the reporting service might ask you for more information about the error you experienced. If you choose to provide your phone number or e-mail address in this information, your error report will be personally identifiable. Microsoft might contact you to request additional information to help solve the problem you reported.

    The Microsoft Error Reporting Service generates a globally unique identifier (GUID) that is stored on your computer and sent with error reports to uniquely identify your computer. The GUID is a randomly generated number; it does not contain any personal information and is not used to identify you. We use the GUID to distinguish how widespread the feedback we receive is and how to prioritize it. For example, the GUID allows Microsoft to distinguish between one customer experiencing a problem one hundred times and one hundred customers experiencing the same problem once.

    USE OF INFORMATION

    Microsoft uses information about errors and problems to improve Microsoft products and services as well as third-party software and hardware designed for use with these products and services. Microsoft employees, contractors, vendors, and partners might be provided access to information collected by the reporting services. However, they will use the information only to repair or improve Microsoft products and services and third-party software and hardware designed for use with Microsoft products and services.

    Microsoft might share aggregate information about errors and problems. Microsoft uses aggregate information for statistical analysis. Aggregate information does not contain specific information from individual reports, nor does it include any personal or confidential information that might have been collected from a report.

    Except as described in this statement, personal information you provide will not be transferred to third parties without your consent. We occasionally hire other companies to provide limited services on our behalf, such as performing statistical analysis. We will only provide those companies the personal information they need to deliver the service, and they are prohibited from using that information for any other purpose.

    Microsoft may access or disclose information about you, including the content of your communications, in order to: (a) comply with the law or respond to lawful requests or legal process; (b) protect the rights or property of Microsoft or our customers, including the enforcement of our agreements or policies governing your use of the software; or (c) act on a good faith belief that such access or disclosure is necessary to protect the personal safety of Microsoft employees, customers, or the public.

    Information collected by or sent to Microsoft by Windows 7 may be stored and processed in the United States or any other country in which Microsoft or its affiliates, subsidiaries, or service providers maintain facilities. Microsoft abides by the safe harbor framework as set forth by the U.S. Department of Commerce regarding the collection, use, and retention of data from the European Union.

    CHOICE AND CONTROL

    If you choose the recommended settings during Windows 7 setup, basic information about errors will be sent automatically to Microsoft. If a more detailed error report is required, you will be prompted to review it before it is sent. You can change this setting at any time by going to Action Center in Control Panel.

    SECURITY PRACTICES

    Microsoft is committed to helping protect the security of your information. We use a variety of security technologies and procedures to help protect your information from unauthorized access, use, or disclosure. For example, we store the information you provide on computer systems with limited access, which are located in controlled facilities.

    FOR MORE INFORMATION

    If you have questions about this privacy statement, please contact us by submitting your questions online to Privacy Feedback at:

    http://go.microsoft.com/?LinkID=9634754

    Windows 7 Offline Privacy Statement for the Microsoft Error Reporting Service
    c/o Microsoft Privacy Response Center
    Microsoft Corporation
    One Microsoft Way
    Redmond, Washington 98052 USA

    2010年9月2日 10:23
  • windows event logs

     

    Fault bucket , type 0
    Event Name: APPCRASH
    Response: Not available
    Cab Id: 0

    Problem signature:
    P1: Ssms.exe
    P2: 2007.100.1600.22
    P3: 48753da6
    P4: Ssms.exe
    P5: 2007.100.1600.22
    P6: 48753da6
    P7: c0000005
    P8: 0013e017
    P9:
    P10:

    Attached files:

    These files may be available here:
    C:\Users\setupuser\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppCrash_Ssms.exe_4d7fcf4646492f8bf61b86fc6e108bb8904f174f_34c203b0

    Analysis symbol:
    Rechecking for solution: 0
    Report Id: 1fa23b91-b5ac-11df-b77c-001ec9b121ec
    Report Status: 0

     

     

     

    Windows detected your registry file is still in use by other applications or services. The file will be unloaded now. The applications or services that hold your registry file may not function properly afterwards. 

     DETAIL -
     3 user registry handles leaked from \Registry\User\S-1-5-21-2283299564-3205556881-2388454337-1008:
    Process 1008 (\Device\HarddiskVolume2\Windows\System32\svchost.exe) has opened key \REGISTRY\USER\S-1-5-21-2283299564-3205556881-2388454337-1008
    Process 1008 (\Device\HarddiskVolume2\Windows\System32\svchost.exe) has opened key \REGISTRY\USER\S-1-5-21-2283299564-3205556881-2388454337-1008\Software\Microsoft\Windows NT\CurrentVersion\Windows
    Process 1008 (\Device\HarddiskVolume2\Windows\System32\svchost.exe) has opened key \REGISTRY\USER\S-1-5-21-2283299564-3205556881-2388454337-1008\Printers\DevModePerUser

     

     

     

    Faulting application name: Ssms.exe, version: 2007.100.1600.22, time stamp: 0x48753da6
    Faulting module name: Ssms.exe, version: 2007.100.1600.22, time stamp: 0x48753da6
    Exception code: 0xc0000005
    Fault offset: 0x0013e017
    Faulting process id: 0xb20
    Faulting application start time: 0x01cb49b9f3ad14ab
    Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe
    Faulting module path: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe
    Report Id: 326f41f5-b5ad-11df-b77c-001ec9b121ec

    2010年9月2日 10:29
  • 已经安装 microsoft sql server compact 3.5 sq1 englisth  这个是代表已经应用sp1了吧?
    2010年9月2日 10:34
  • No, it's not sql2k8 sp1.
    2010年9月2日 13:06
  • 不过按道理,sql server 2008是可以正常运行的,程序可以正常运行,只是一个管理工具不能用,这是sp1的问题吗?
    2010年9月3日 2:16
  •  sql2k8 sp1 有安装尝试过了吗?
    Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    2010年9月3日 3:23
    版主
  • 不过按道理,sql server 2008是可以正常运行的,程序可以正常运行,只是一个管理工具不能用,这是sp1的问题吗?
    Looks like something is wrong in your rtm onstallatio package, sp1 may fix it.
    2010年9月3日 3:30