Windows Vista Forums
Vista Forums Home Join Vista Forums Tech Publications Windows 7 Forum Vista Tutorials Webcasts Tags

Welcome to Vista Forums we are your forum for Windows Vista help and discussion. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
Register at Vista forums...the world biggest Windows Vista resource Join Vista Forums Now

Go Back   Vista Forums > Vista Newsgroups > Vista General

failure connecting to SQL 2005 /w integrated authentication in another domain

Update your Vista Drivers
Reply
 
Thread Tools Display Modes
Old 10-12-2006   #1 (permalink)
Robert Gajdzica
Guest


 

failure connecting to SQL 2005 /w integrated authentication in another domain

I'm trying to replace my current Windows XP with Vista RC2 on my workstation
and I'm unable to connect to SQL 2005 in another domain using integrated
authentication from Vista.

I have domain A and domain B. My workstation is in domain A and SQL server
is in domain B. There are no trust relationship between domain A and B
mainly for security reasons.
On Windows XP I was used to create record for domain B in Windows Password
Manager (Control Panel/User Accounts/Advanced/Manage Passwords). It looks
like this:
Server: B\*
User Name: B\my_account
Password: *********

Connection to SQL with this configuration from WinXP was without any
problem.


This is impossible in Vista. Character * is not allowed in server name. So I
replaced * with actual SQL server name. After clicking on OK server name was
stripped to B.
Then I added another record and server name was set to servers FQDN. And
after that I created another recordwith just server name without domain.

I'm still not able to connect to SQL server using SQL Server Management
Studio. I'm receiving this message every time:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection. (Microsoft SQL Server, Error: 18452)

Is there any other way how to connect to SQL in another domain with
integrated authentication?

Robert



My System SpecsSystem Spec
Reply
Update your Vista Drivers

Thread Tools
Display Modes



Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Connecting to a share that requires authentication Alex K. Angelopoulos PowerShell 2 08-28-2008 06:11 PM
Pre-Authentication Failure with Vista Yoann Roman Vista security 1 03-05-2008 12:50 PM
Pre-Authentication Failure with Vista Yoann Roman Vista networking & sharing 1 03-05-2008 12:50 PM
Pre-authentication Failure James Vista networking & sharing 0 07-19-2007 11:19 AM
RC2 and Integrated Authentication Chupacabra Vista General 1 10-10-2006 03:08 PM


Complimentary Industry Resources

Vista Forums has joined forces with TradePub.com to offer you a new, exciting, and entirely free professional resource. Visit http://vistax64.tradepub.com today to browse our selection of complimentary Industry magazines, white papers, webinars, podcasts, and more across 34 industry sectors. No credit cards, coupons, or promo codes required. Try it today!




Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media 2005-2008

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51