Today’s quick tip is for Windows Server 2012 and 2012 R2. If you’re attempting to use SQL Server Management Studio to manage the Windows Internal Database instance, the connection string has been changed.
To connect to Windows Internal Database on Windows Server 2012 and 2012 R2, you will need to use the following.
\.pipeMICROSOFT##WIDtsqlquery