Scott Lock

Thoughts on .Net, Caparea.net and Windows Phone


News

My Stats

  • Posts - 77
  • Comments - 134
  • Trackbacks - 21

Tag Cloud


Recent Comments


Recent Posts


Archives


Post Categories


Image Galleries


Blogs I Read


Microsoft MVP


User Groups



To continue in the traditiion of trackbacks, and since I can't seem to find an orginal post in my body, I thought that I would share this one with you.  Jason Follas psted a solution on how to get SQL Client, running on Vista, to use different credentials when connecting to a SQL Server using Windows Authentication.  Basically, there are a ton of posts out there, but this is the ONLY one that that I could find that had the solution.  Here's the link to the full explantion:  Making SQL Server Management Server work on Windows Vista

Here's the solution - Create a "runas.exe" shortcut with the following configuration:

C:\Windows\System32\runas.exe /netonly /user:domainx\myusername
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

Works like a charm!  Thank's Jason!

 


Comments

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: