asked on 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.
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.
Microsoft SQL Server 2008
Last Comment
angel7170
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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
Image1.PNG
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.
ASKER
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)
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)
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.
ASKER
Tried that as well...no luck yet :-(
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you DBADuck for your help.
ASKER
My comment has the resolution of this issue.
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.