SQL Management Studio and instances
Hi,
I am trying to add an SQL Management Studio item.
I want to connect to a specific instance, but there are no field to fill the information.
I tried setting the instance name in the Host field, but it doesn't work.
I tried with SERVERNAME\INSTANCE in the host field but I get Error 18456.
Thank you.
All Comments (7)
Hello,
Are you trying to connect to SSMS using Remote Desktop Manager using this session type?
If so, what is your SSMS version?
Best Regards,
Etienne Lord
ssms.jpg
Hi,
Yes, this is indeed what I am trying to do.
I am using SQL Server Management Studio v18 (15.0.18118.0)
Regards.
Hello,
Our add-on is build with the command line offer by Microsoft and they have Removed the -P command line parameter, which (Most Probably) causes your issue. You could revert back to SSMS 17.
Here's the article regarding the parameters that have been removed in SSMS 18
https://cloudblogs.microsoft.com/sqlserver/2019/04/24/sql-server-management-studio-ssms-18-0-released-for-general-availability/
Best Regards,
Etienne Lord
Ok, thanks for the info.
Regards.
Will there be an addon for SSMS 18.xx which will work again?
Not if you use username/password to authenticate. Microsoft officially removed the -P (password) parameter in SSMS v18. So your options are Windows Authentication or SSMS v17.
If ever they implement a secure way to supply the password (Example: SecureString with PowerShell) we will make the required adjustments.
Command line option -P removed – Due to security concerns, the option to specify clear-text passwords on the command line was removed.
Best regards,
Stéfane Lavergne
thanks for the quick reply