.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Windows Authentication and Vista

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server
I would like to know if this is possible?

First, I am a consultant and have several clients.  Before upgrading to Vista, I used Windows XP and was able to use SQL Server Management Studio to connect to SQL Servers (2000 and 2005) using my saved network passwords.  I would establish a connection to the remote SQL Server by doing a Start - Run "\\sqlservername\c$" and when prompted for credentials, I would give the domain account that the client has provided me and password and select the "Save password" checkbox.  This would put these credentials in my saved credentials list for my user account.  After doing this, I would be able to connect to the SQL Server via Windows Authentication in SSMS and Integrated Security (SSPI in connection strings) from applications (ASP and .Net).  Everything worked happily with locked down SQL Servers and Windows Authentication.

Then comes Vista...

None of this works.  It seems the stored credentials in Vista do not get honored when connecting to a SQL Server, other than the instance installed on my local machine.  I have been able to connect to a remote instance via Named Pipes, but most of my clients have that disabled because of incompatibility with Distributed Transactions.  So, I ask, is there any way to connect to a remote SQL Server instance (2000 or 2005) from Vista via TCP and Windows Authenticatio

View Complete Post

More Related Resource Links

Web Matrix + Windows Authentication


I'm curious if its possible to get windows auth working with asp.net webpages/webmatrix.

I've got it published to IIS with windows auth turned on and anonymous/forms/basic turned off.

I'm guessing the WebSecurity Helper probably won't work here but can you access User.Identity.Name etc?

Sorry for the newbie questions, I've only just started working with asp.net ^^,

Windows Authentication for IIS in Windows 7 Home Premium Edition - for ASP Websites.


How to create a virtual directory and get benefit of the IIS. Is there a workaround to accomplish this without the Windows Authentication for Windows 7 Home Premium Edition?

Thanks in advance, 

Using windows authentication to access SQL when using ASP.NET 4.0 via COM+


I am using SQL Server 2008 under windows authentication, front end is ASP.NET which uses COM+ to access database.

COM+ components are configured to run as domain user.

When looking through the logs (SQL Profiler), I can see the login name as the configured identity instead of windows indentity.

I have got Website running under "Intergrated Windows Authentication" and database is running locally on webserver.

Web configure contains entry for <identity impersonate="true"/>.

My connection string is

connectionString="data source=db01\test01;initial catalog=test; integrated security=SSPI;persist security info=False; Trusted_Connection=Yes"

Any ideas?




Windows with C++: Decoding Windows Vista Icons with WIC


In this month's installment, Kenny Kerr sings the praises of the new Visual C++ 2008 Feature Pack, which brings modern conveniences to Visual C++.

Kenny Kerr

MSDN Magazine June 2008

.NET Matters: IFileOperation in Windows Vista


The author creates a managed wrapper to use the new IFileOperations interface in Windows Vista from managed code.

Stephen Toub

MSDN Magazine December 2007

Gadgets: Build Your Own Windows Vista Sidebar Gadget


A Sidebar gadget is a powerful little too that's surprisingly easy to create. Get in on the fun with Donavon West.

Donavon West

MSDN Magazine August 2007

Windows with C++: Windows Vista Control Enhancements


With the release of Windows Vista, C++ developers will be happy to know there's plenty of magic left to perform. This new column will provide the necessary insight.

Kenny Kerr

MSDN Magazine August 2007

Security: Applying Cryptography Using The CNG API In Windows Vista


Cryptography Next Generation (CNG) is meant to be a long-term replacement for the CryptoAPI, providing replacements for all of the cryptographic primitives it offered.

Kenny Kerr

MSDN Magazine July 2007

CONCURRENCY: Synchronization Primitives New To Windows Vista


Windows Vista has lots of goodies for native C++ developers including condition variables, slim reader/writer locks, and one-time initialization.

Robert Saccone and Alexander Taskov

MSDN Magazine June 2007

Least Privilege: Teach Your Apps To Play Nicely With Windows Vista User Account Control


User Account Control in Windows Vista keeps the OS safe from intentional and accidental configuration changes.

Chris Corio

MSDN Magazine January 2007

Desktop Security: Create Custom Login Experiences With Credential Providers For Windows Vista


Why is a change to the Windows logon plug-in interface so exciting? Because with credential providers you can customize the logon experience for your users.

Dan Griffin

MSDN Magazine January 2007

Locale Hero: Enable Global Apps With Locale Builder And Windows Vista


Everything you need to know about locales in Windows Vista.

Kieran Snyder and Shawn Steele

MSDN Magazine December 2006

Smart Storage: Protect Your Data Via Managed Code And The Windows Vista Smart Card APIs


Smart cards are a compelling alternative to the reliance on passwords, which are the weakest link in authentication systems. Get the Windows smart card programming basics here.

Dan Griffin

MSDN Magazine November 2006

Peer To Peer: Harness The Power Of P2P Communication In Windows Vista And WCF


P2P applications face a number of barriers preventing their wide adoption as a productivity solution. Fortunately Windows Vista improves the situation, as you'll learn here.

Justin Smith

MSDN Magazine October 2006

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend