|
 |  |  |  |  |  |  |
| 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. |
| |||||||
 |
| |
07-07-2009
| #1 (permalink) |
| | SQL connection issue 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 |
|
07-07-2009
| #2 (permalink) |
| | Re: SQL connection issue "Bukkake Face" <admin@xxxxxx> wrote in message news:2920a536-55eb-4d92-b471-1252e84c795a@xxxxxx Quote: > 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? http://www.connectionstrings.com/sql-server For SQL Server 2000 I see SQLOLEDB, but not SQLOLEDB.1. Also, if 49168 is a port number, should the data source be an IP address? I assume you are using the default instance. -- Richard Mueller MVP Directory Services Hilltop Lab - http://www.rlmueller.net -- |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Connection issue after network connection | Network & Sharing | |||
| Connection Issue | Vista networking & sharing | |||
| Fixed! Remote Desktop Connection (RDC) SLOW/NO Connection Issue | Vista networking & sharing | |||
| Connection issue | Vista mail | |||
