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