Scott Lock's Blog

Building the .Net Community through Caparea.Net, Consulting, and no sleep

posts - 62, comments - 30, trackbacks - 35

My Links

News

Twitter

steelcuda Painted my closet this weekend - that's right...my closet. about 15 days ago

steelcuda @susanlennon I did! www.caparea.net/sharepoint. Would you come and speak! about 15 days ago

steelcuda @briannoyes Amen! and snapshot managment is essential. about 18 days ago

steelcuda Sitting in a management meeting. Meetings suck. about 18 days ago

steelcuda Who doesn't love translating COBOL PICTURE field definitions into SQL Server data types. Nothing says love like PIC s9(18)v9(5). about 22 days ago

steelcuda @jake_grey Whats your gammer tag? mine is Steelcuda about 22 days ago

steelcuda @richcampbell Boy your arms must be tired....wooh! Try the veal. about 22 days ago

steelcuda @Darcy_Lussier I like to listen to John Williams, specifically American Journey about 22 days ago

steelcuda CNN has the first ever hologram interview about 27 days ago

steelcuda @shanselman Awesome, thanks Scott about 27 days ago

Post Categories

Blogs I Read

Microsoft MVP

User Groups

<< Paul Stovell on Platforms | Home | SOA Governance - Interesting Article >>

SQL Server Client Working on Vista, Not connected to a domain

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!

Print | posted on Wednesday, December 19, 2007 3:40 PM | Filed Under [ SQL Server Vista ]

Feedback

# re: SQL Server Client Working on Vista, Not connected to a domain

Glad you found it useful, Scott!

The downside is when you need to use different credentials for various servers on the domain... Under XP using Stored User Names and Passwords, I could have a single Management Studio open. Using the RUNAS technique, I need multiple SSMS instances - one for each credential.

I've dug into this pretty deep (including packet sniffing the network). MS has screwed up the LM stack somehow, but only for non-domain connected workstations. My detailed bug report on MSConnect was closed with a Bigg Phat "WILL NOT FIX" status.

I've also made contact with a great "Community-Friendly" source in MS, in hopes that he might find somebody who actually worked on those bits. I'm hopefuly that a simple registry key change could make everything "XP compatible" again. :-/

12/19/2007 4:28 PM | Jason

Post Comment

Title
Name
Email
Url
Comment
Remember Me?
Please add 7 and 3 and type the answer here: Enter the code shown above: