February 11, 2014 at 8:03 am
I usually RDP to the Server using dba credentials. However, I just installed SQL client on my local machine and I wanted to log into DB from SSMS directly which is installed on my local machine. When I open up SSMS, in Windows authentication it gives me the domain name\username but I want to log in as a different user using different domain\username, Can anyone tell me how it can be done? Again I am not trying to log in with SQL authentication.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 11, 2014 at 8:16 am
Can you log in with any account?
Is the other "domain\username" added to the AD? and if not, add it and then you should add it to the Logins too.
Do you already have a SQL type login and cannot log in from your PC?
Check out the "remote" options in sys.sp_configure
Check out the server network protocols.
Regards,
IgorMi
Igor Micev,
My blog: www.igormicev.com
February 11, 2014 at 8:26 am
Web search is your friend. I searched Google for the words
ssms login other domain user
and came up with a number of references to using the windows Run As Different User and/or using a batch file with runas and netonly.
http://dirq.net/2013/04/run-ssms-as-another-windows-login/
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 11, 2014 at 8:26 am
All the other servers we have use different domain name. I can login into the server with SQL authentication but not windows authentication. Thanks for the reply.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 11, 2014 at 8:32 am
TheSQLGuru (2/11/2014)
Web search is your friend. I searched Google for the wordsssms login other domain user
and came up with a number of references to using the windows Run As Different User and/or using a batch file with runas and netonly.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 11, 2014 at 8:39 am
Thank you guys for replying to this post. However, I ended up creating a dedicated account to do DBA chores so I don't have to RDP into servers.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 11, 2014 at 8:59 am
A dedicated account is a good idea. A SQL login is a little weak for it though. You can just so easily use secondary logins by right-clicking on the SSMS program and choosing "Run As." That's how I've administered production servers for years and years. And, as you say, through that separate dedicated account.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
February 12, 2014 at 5:14 am
+1 Grant
right click (on your local SSMS), run as a different user (domain account)
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
February 12, 2014 at 5:23 am
Hi,
I believe you VPN into other network, please check runas command with /netonly option.
Refer following blog for additional information: http://vijredblog.wordpress.com/2014/02/05/connect-with-domain-controller-credentials-after-vpn-solution/
Thanks,
Vijay
-Vijred (http://vijredblog.wordpress.com)
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply