Geeks With Blogs
Scott Lock Thoughts on .Net, and Windows Phone

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!


Posted on Wednesday, December 19, 2007 3:40 PM SQL Server , Vista | Back to top

Comments on this post: SQL Server Client Working on Vista, Not connected to a domain

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Scott Lock | Powered by: