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.