Post reply

Connect button Grayed Out

  • June 15, 2012 at 8:43 am

    #260012

    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.

  • March 18, 2013 at 9:01 pm

    #1598267

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply