Users

All Posts (2)

avatar

(user deleted)

Disabled

SQL Server Management Studio | Non-Domain client

avatar
avatar
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?

SQL Server Management Studio | Non-Domain client

avatar
avatar
avatar

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

1 - 2 of 2 items