Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - Connect SQL 2000 using Windows Authenticaion in another domain

Reply
 
Old 06-04-2009   #1 (permalink)
Bukkake Face


 
 

Connect SQL 2000 using Windows Authenticaion in another domain

Hi,

Im trying to connect to a SQL server and instance in another domain. I
need to authenticate using windows user account in the domain the SQL
server is in but constantly get access denied errors.

Connection string im using is :

strSQLConnString = "Provider=SQLOLEDB.1;Data
Source=SQLSERVER1,49168;Persist Security Info=False;Initial Catalog="
& strSQLDatabase & ";User ID=" & strDomain & "\" & strAdminUserName &
";Password=" & strPassword & ";"

The error I get is :

Login failed for user 'DOMAIN\USERACCOUNT'.. Error code : -2147217843

DOMAIN\USERACCOUNT has been substitutied for my actual domain and user
account but you get the idea.

Any help please?

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Join domain - Windows 2000 Server Vista networking & sharing
Vista and Windows 2000 domain controller Vista networking & sharing
Connecting Vista Ultimate 64 bit to a Windows 2000 domain Vista networking & sharing
Windows vista business in a 2000 Domain Vista networking & sharing
Unable to Join Windows 2000 Domain Vista networking & sharing


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 Ltd

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