Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
denis_the_thief
Aged Yak Warrior
596 Posts |
 Posted - 2013-10-03 : 09:29:09
|
| I need to connect to a Remote account. I have a Windows Account for this remote machine. To connect to the Database, I RDP which includes entering a password. When I RDP to the machine, I can run SSMS and I can connect with Windows Authentication.My question is can I connect directly using my SSMS, i.e. without RDPing. As I seem to have everything just that my Windows Account requires a password to connect to Windows and the Windows Authentication has no option for a password. |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-10-03 : 09:43:48
|
| Since with Windows Authentication you have already logged on with a username/password (to Windows) you do not need to log on again to SQL Server.You may be able to connect directly to the SQL Server without RDPing to a separate system, if your computer has the rights to do so.djj |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-10-03 : 14:10:56
|
| Another option is to download ShellRunAs from SysInternals. Once you have that, you can register the /netonly option and it will create a context menu item.With that, you can then right-click (or shift right-click) any application and use the new context menu item to run as with network credentials. This will prompt you with a dialog box where you can enter the domain credentials instead of entering the credentials in a command window. ShellRunAs does open a command window - but you can close it once you enter your credentials. |
|
|
|
|
|
|
Connect with Windows Account