Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Connect button Grayed Out Expand / Collapse
Posted Friday, June 15, 2012 8:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 6, 2016 7:59 AM
Points: 38, Visits: 304
I'm just starting to play with the 2012 version of SSMS, I got the 2012 Express with SSMS installer and installed an instance of 2012 on my laptop.

I downloaded the 2012 Adventure works DB from codeplex and ran this query to install it:

CREATE DATABASE AdventureWorks2012 ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\AdventureWorks2012_Data.mdf') FOR ATTACH_REBUILD_LOG;

This generated a level 20 error:
Msg 948, Level 20, State 1, Line 1
The database 'AdventureWorks2012' cannot be opened because it is version 706. This server supports version 661 and earlier. A downgrade path is not supported.

Uh oh, looks like I connected to my default 2008R2 instance, not my new 2012 instance.

I went to press the connect button next to the database drop down list, I noticed that both connect and disconnect are grayed out.

I know that a Level 20 error will kill your connection, but usually the connect icon becomes available.

I was able to get around this by just executing a "USE Master" command to reconnect, then disconnect and connect to the proper instance, but I found this behavior odd.

I couldn't find any info on this via Google or searching the forums here. Anyone else noticed this?

To verify that this is caused by an error, I ran the following and it too grayed out both connect and disconnect:
RAISERROR (N'This is message %s %d.', -- Message text.
20, -- Severity,
1, -- State,
N'Error', -- First argument.
5) WITH log; -- Second argument.
Post #1316698
Posted Monday, March 18, 2013 9:01 PM


Group: General Forum Members
Last Login: Tuesday, November 29, 2016 9:50 PM
Points: 11, Visits: 321
Simply go back to the SSMS query and execute it despite the fact that the connection icon is still GREYED OUT. The query should get reconnected and finish! It's that simple.
Post #1432447
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse