Devolutions ForumDevolutions Forum

SQL Server Management Studio | Non-Domain client

SQL Server Management Studio | Non-Domain client

avatar
(user deleted)
Disabled

Hello all,
I am trying to connect to a sql server in the domain of my client. My laptop is not a domain member. I installed the SQL Server Add-On. However I stumbled upon several problems:
1) If I start SSMS from Remote Desktop Manager Enterprise (RDME) with default credentials, I get the following message:
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Erro: 18452)
2) If I start SSMS from RDME with credentials from my credential repository, I get the following message:
Login failed for user '<domain>\<username>'. (Microsoft SQL Server, Erro: 18456)

However if we could run the program with 'runas' permissions it would work.
If I start SSMS from a command prompt like hereafter, I get prompted for the password and everything works fine:
runas /netonly /user:domain\username "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

So remaining question how to incorporate this within RDME??

Kind regards

All Comments (3)

avatar
David Hervieux

This is not supported in the SQLServer add-on. Howewer instead of using the add, why not use a command line session

http://help.remotedesktopmanager.com/sessions_commandline.htm

David Hervieux

avatar

David,

Thanks for the swift reply. To wrap things up and give other people the change to benefit from this.

1) Create a new entry - Command Line
2) Fill out "Host and Credentials"
3) Use in "Run" the following command line:
RunAs /NetOnly /user:$DOMAIN$\$USERNAME$ "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe -S $HOST$"

Outcome:
A DOS box pops up asking you for your password. Hereafter SSMS will connect to the correct server with the correct credentials.

Leaves me with 2 questions:

1) Could we parse the $PASSWORD$ variable into this box?
2) How to make this a sub connection for the corresponding SQL server?

avatar
David Hervieux

Hi,
You could create a Typing macro to send the password and Enter. This is available in the Events tab page. For the sub connections, I don't understand. There should not have any difference:

http://help.remotedesktopmanager.com/settings_subconnections_overview.htm

David Hervieux