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 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
 Posted - 2007-03-14 : 03:28:02
|
| I am currently logged in as local admin on my laptop, and I want to connect to clients SQL Server 2005.I can't use my local admin and have to use company network login.How can I impersonate my network login when connecting to the SQL Server when using local admin account?Peter LarssonHelsingborg, Sweden |
|
|
pootle_flump
1064 Posts |
Posted - 2007-03-14 : 09:23:59
|
You might want to change the title to the thread if possibe - I thought that seemed a bit easy for someone like you  Dunno though - RDC onto another machine with SSMS tools installed? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-14 : 09:36:15
|
| Well, cannot do.I don't want to add my machine to their domain.I have a domain account.I do not have access to connect via Remote Desktop to SQL Server.I have dbo access to some databases.All I want to do is to add the SQL Servers to my local SSMS in "Registered servers". But the login window does not allow me to put in another domain account ("se\peterl") when selecting "Windows authentication". I am logged on to my laptop as "laptop\peso".Peter LarssonHelsingborg, Sweden |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-14 : 09:43:38
|
Scrap the "Windows authentication" goal then  |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-03-14 : 09:47:26
|
| Use the runas utility. Works for all of our consultants.EDIT: Suppose I should add a link, eh? ;-)http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/runas.mspx?mfr=true |
|
|
|
|
|
|
How do I impersonate a SQL Server login?