Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connect button Grayed Out Expand / Collapse
Author
Message
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, September 3, 2014 12:55 PM
Points: 31, Visits: 246
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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 22, 2014 1:50 PM
Points: 9, Visits: 298
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