SQL SERVER 2012 Query Analyzer

Hello,

I’m installing SQL Server 2012 Cluster on Windows Server 2012.  After my first successfully SQL Server installation on NodeA I can’t open the Query Analyzer.  Every time I attempt to open the QA I get error saying SQL SERVER Management Studio has stopped working and asks me to Restart\Close the program.
angel7170Asked:
Who is Participating?
 
angel7170Connect With a Mentor Author Commented:
The error is caused by the Print Spooler service being disabled per our security requirements.

http://social.technet.microsoft.com/Forums/en-US/dc0eeb2f-7097-4d9c-b611-274bf147a679/windows-server-2012-r2-preview-rtm-server-manager-has-stopped-working?forum=windowsserverpreview 

We have discovered that if the *Print Spooler Service* is stopped or
disabled in Windows Server 2012 R2, the color profiles will not load
properly and Color Management will be blank.  If the color profiles are
unable to load, then when Server Manager is trying to load them to
display the bitmap icon, it returns a null and causes Server Manager to
crash.  This issue only seems to occur in Windows Server 2012 R2 and not
Windows Server 2012.
0
 
tigin44Commented:
what is the exact error message you get?

by the way, did you install the SQL Server management tools? installing these tools is not recommended and not selected by default in a cluster installation. Check if they properly installed.
0
 
DBAduck - Ben MillerConnect With a Mentor Principal ConsultantCommented:
Also ensure that you install SQL 2012 SP1 or later to ensure that everything is in place for use with Windows 2012.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
angel7170Author Commented:
I can login to that instance from another SQL Server 2008R2 server and open query windows with no problem on .  Please see the image.
Image1.PNG
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
I was simply stating that your install was RTM (11.0.2100) and Management Studio may need additional software or bug fixes to exist on Windows 2012, so I would install at least SP1 for SQL 2012 and try the Management Studio again.
0
 
angel7170Author Commented:
Just applied SP1 CU7 and I still cannot open the QA from SSMS on the locol server.  


Select @@VERSION

Microsoft SQL Server 2012 (SP1) - 11.0.3393.0 (X64)   Oct 25 2013 19:04:40   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
Did you run the SSMS as Administrator?  Right click on the icon and click Run As Administrator.  There may be a setup that requires approval on UAC.
0
 
angel7170Author Commented:
Tried that as well...no luck yet :-(
0
 
angel7170Author Commented:
Thank you DBADuck for your help.
0
 
angel7170Author Commented:
My comment has the resolution of this issue.
0
All Courses

From novice to tech pro — start learning today.