|
 |  |  |  |  |  |  |
| 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. |
| |||||||
 |
| |
06-28-2009
| #1 (permalink) |
| | SQL connection to server 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 Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Lost connection after joining to Domain | Network & Sharing | |||
| Specify A domain for Connection...? | PowerShell | |||
| Internet connection through domain network | Vista networking & sharing | |||
| No Internet Connection, Vista on NT4 Server Domain | Vista General | |||
| Remote Desktop Connection on Domain | Vista networking & sharing | |||
