June 29, 2010 at 7:11 am
I have recently installed an instance of SQL 2008 R2. As part of the install SSMS was also upgraded. However whenever I try and start SSMS I get the following error in the Error Log and SSMS won't start.
Event Type:Error
Event Source:.NET Runtime 2.0 Error Reporting
Event Category:None
Event ID:1000
Date:29/06/2010
Time:14:01:51
User:N/A
Computer:
Description:
Faulting application ssms.exe, version 2009.100.1600.1, stamp 4bb679e7, faulting module kernel32.dll, version 5.1.2600.5781, stamp 49c4f482, debug? 0, fault address 0x00012afb.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 00 70 00 70 00 6c 00 A.p.p.l.
0008: 69 00 63 00 61 00 74 00 i.c.a.t.
0010: 69 00 6f 00 6e 00 20 00 i.o.n. .
0018: 46 00 61 00 69 00 6c 00 F.a.i.l.
0020: 75 00 72 00 65 00 20 00 u.r.e. .
0028: 20 00 73 00 73 00 6d 00 .s.s.m.
0030: 73 00 2e 00 65 00 78 00 s...e.x.
0038: 65 00 20 00 32 00 30 00 e. .2.0.
0040: 30 00 39 00 2e 00 31 00 0.9...1.
0048: 30 00 30 00 2e 00 31 00 0.0...1.
0050: 36 00 30 00 30 00 2e 00 6.0.0...
0058: 31 00 20 00 34 00 62 00 1. .4.b.
0060: 62 00 36 00 37 00 39 00 b.6.7.9.
0068: 65 00 37 00 20 00 69 00 e.7. .i.
0070: 6e 00 20 00 6b 00 65 00 n. .k.e.
0078: 72 00 6e 00 65 00 6c 00 r.n.e.l.
0080: 33 00 32 00 2e 00 64 00 3.2...d.
0088: 6c 00 6c 00 20 00 35 00 l.l. .5.
0090: 2e 00 31 00 2e 00 32 00 ..1...2.
0098: 36 00 30 00 30 00 2e 00 6.0.0...
00a0: 35 00 37 00 38 00 31 00 5.7.8.1.
00a8: 20 00 34 00 39 00 63 00 .4.9.c.
00b0: 34 00 66 00 34 00 38 00 4.f.4.8.
00b8: 32 00 20 00 66 00 44 00 2. .f.D.
00c0: 65 00 62 00 75 00 67 00 e.b.u.g.
00c8: 20 00 30 00 20 00 61 00 .0. .a.
00d0: 74 00 20 00 6f 00 66 00 t. .o.f.
00d8: 66 00 73 00 65 00 74 00 f.s.e.t.
00e0: 20 00 30 00 30 00 30 00 .0.0.0.
00e8: 31 00 32 00 61 00 66 00 1.2.a.f.
00f0: 62 00 0d 00 0a 00 b.....
I've applied uninstalled and re-installed the tools to no avail. Tried re-installing .Net service packs but still no luck.
Any ideas????
June 29, 2010 at 7:14 am
What OS is this installed on?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
June 29, 2010 at 7:16 am
Doh, forgot the important details 🙂
It's on Windows XP SP3.
June 29, 2010 at 7:35 am
If you review the install log does it show any errors while trying to install SSMS or any portion of the desktop tools while it was upgrading them?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
June 29, 2010 at 7:45 am
According to the log:
Product: SQL Server 2008 R2 Management Studio -- Installation completed successfully.
June 29, 2010 at 9:43 am
Have you checked the CUs released so far for SQL 2008 R2. June 23 the CU #2 was released but I have not gone through the details of those.
Also, since this is Windows XP have you tried logging in with a different profile (different user or new profile) to see if you receive the same error?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
June 30, 2010 at 10:40 am
Tried a local user rather than domain user and at least it got passed the splashscreen but did crash on exit with anothe .NET Runtime 2 error. So it looks like a possible Registry issue but which Hive to look at????
June 30, 2010 at 11:09 am
Since it is just the Tools, I would probably not mess with the registry hive. I would suggest trying:
1) Remove SSMS and desktop tools for SQL 2008 R2
2) repair/reinstall .NET Framework 3.5 service packs
3) Install SQL 2008 R2 tools again
I came across one post on MSDN where the guy was getting the fault for kernel21 and the same fault address and it states he just reinstalled the service pack for .NET 3.5 framework. I know you stated you had already tried this, but you didn't state if you had repaired/reinstalled SQL 2008 R2 toosl.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
July 2, 2010 at 3:50 am
Fixed it!!!!
I removed the HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100 and re-started SSMS. It got a little further before crashing. I then remembered that I had APEX SQL Refractor installed on SSMS2005 and didn't see the addin when I logged in as the other user, when I uninstalled this and restarted SSMS2008 R2, everything was happy:-D
Weird in that the Apex tool never got mentioned in any of the messages though
November 1, 2010 at 12:02 am
I had exactly the same issue, tried to repair 2008 R2, removed and reinstalled client tools, removed client tools for 2005 and then reinstall for R2 only. Reinstalled R2 completely. Also repaired .net framework 2.0 SP2 and 3.5SP1, nothing worked.
The weird thing is that installing the same setup on the laptop worked without any problems.
It was only after coming across this post that I realised that APEX SQL Refactor is installed on the desktop (not on the laptop). Removed this and hey presto SSMS fired up immediately.
Lesson learnt - search SQLServerCental.com before Google in the future...
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply