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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-03-14 : 09:13:56
|
| I have different login credentials for my laptop and servers. And I don’t have any SQL logins. As a result, to connect to the servers I need to RDP every time. Sometime back I solved this problem , which I don’t remember now. I guess, I was mapping a drive of the server to my laptop with server credentials ..etc. …Does anyone know how to resolve this problem?------------------------I think, therefore I am - Rene Descartes |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-03-14 : 09:15:46
|
Maybe you use SQL Authentication instead ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-03-14 : 09:20:53
|
| I can not do that because of some obvious reasons…..But I am sure there is a workaround for this…------------------------I think, therefore I am - Rene Descartes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-14 : 22:37:01
|
| You can start ssms with different account. |
|
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2008-03-17 : 06:35:32
|
| u can try new sqlserver registration by right clicking and u get a wizard which would direct u ,,, make sure u select sqlserver login instead of windows authentication.. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-03-17 : 10:26:10
|
| I don't have a SQL account. Can I start SSMS with a different WINDOWS account?------------------------I think, therefore I am - Rene Descartes |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-03-17 : 10:48:34
|
quote:
Originally posted by ravilobo
I don't have a SQL account. Can I start SSMS with a different WINDOWS account?------------------------I think, therefore I am - Rene Descartes
Right click the SSMS application shortcut, and select Run-As...CODO ERGO SUM |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-03-17 : 11:04:01
|
quote:
Right click the SSMS application shortcut, and select Run-As...
Thanks MVJ, you saved me again!------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
|
|
Different Windows authentications