SQL Server Home
Thank you for your feedback!
Command Line Options Not working for SSMS
- by Vishal Gajjar
This item appears to be a duplicate of another existing Connect or internal item.
A more detailed explanation for the resolution of this particular item may have been provided in the comments section.
4/28/2011 3:28:01 AM
Unable to Autoconnect to an instance using command-line options for SSMS.
ATTACH A FILE
EDIT THIS ITEM
Item can only be reassigned when it is active.
to post a comment.
Please enter a comment.
on 10/18/2011 at 12:12 AM
Just installed CTP3 - cannot use command line at all even with workaround
on 5/26/2011 at 11:00 PM
Thank you for your feedback. This is a known issue being tracked internally. We're presently working on the fix.
on 4/28/2011 at 5:02 AM
Yep, I posted a follow-up already.
on 4/28/2011 at 4:59 AM
colon is required for Denali, not for Older versions.
if you execute it at command prompt it will give you error.
C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio>ssms -S VG
Microsoft SQL Server Management Studio 11.0.1103.9
Copyright (C) Microsoft Corp. All rights reserved.
Invalid command line.
ssms [-?] [-S:server_name[\instance_name]] [-d:database] [-U:user] [-P:password]
[-E] [-nosplash] [file_name[, file_name]*]
Available command line switches:
-S The name of the SQL Server instance to connect to.
-d The name of the SQL Server database to connect to.
-U The name of the SQL Server login to connect with.
-P The password associated with the login.
-E Use Windows Authentication to login to SQL Server.
-noSplash Suppress splash screen.
-? Displays this usage information.
on 4/28/2011 at 4:46 AM
Sorry, I take it back, I do observe different behavior and the requirement of the colon when launching ssms directly from within its own folder.
on 4/28/2011 at 4:44 AM
Vishal, this is not a bug. You're not using the syntax correctly. Try without the colon:
"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe" -S VISHAL\DENALI -E
to post a workaround.
Please enter a workaround.
on 4/28/2011 at 3:41 AM
Vishal: Workaround is to launch SSMS from command-line:
change current directory:
cd "Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio"
launch ssms.exe using:
ssms -S:VGAJJAR\DENALI -E
Attach a file
3. Works fine from command-line.JPG
3. Error Message Displayed.JPG
1. Shortcut Properties.JPG
© 2015 Microsoft