Solved

SQL SERVER 2012 Query Analyzer

Posted on 2014-01-06
10
4,443 Views
Last Modified: 2014-01-14
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.
0
Comment
Question by:angel7170
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
10 Comments
 
LVL 26

Expert Comment

by:tigin44
ID: 39759481
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
 
LVL 24

Assisted Solution

by:DBAduck - Ben Miller
DBAduck - Ben Miller earned 250 total points
ID: 39759718
Also ensure that you install SQL 2012 SP1 or later to ensure that everything is in place for use with Windows 2012.
0
 

Author Comment

by:angel7170
ID: 39760081
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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 24

Expert Comment

by:DBAduck - Ben Miller
ID: 39760369
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
 

Author Comment

by:angel7170
ID: 39760657
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
 
LVL 24

Expert Comment

by:DBAduck - Ben Miller
ID: 39760768
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
 

Author Comment

by:angel7170
ID: 39762270
Tried that as well...no luck yet :-(
0
 

Accepted Solution

by:
angel7170 earned 0 total points
ID: 39769213
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
 

Author Comment

by:angel7170
ID: 39769234
Thank you DBADuck for your help.
0
 

Author Closing Comment

by:angel7170
ID: 39778778
My comment has the resolution of this issue.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question