Geek asks and answers

Accessing a database on another Active Directory server

I am currently logged on to a user’s computer in Active Directory A, and I need to access the database in MSSQL 2000 located in domain B through VB6. The user has accounts in both Active Directory servers. Active Directory domains are unrelated or unrelated.

I am currently using the following MSSQL connection string:

gcnnBD.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" & gsDataBase & ";Data Source=" & gsServidor & ";Connect Timeout=" & gsTimeOutconnection string.

Can I connect to domain B through the connection string if I am registered in domain A?

What will be the connection string?

Any suggestions are welcome.

+5
source share
3 answers

Will this application have to access network resources in the domain at all?

- .

, , RUNAS/NETONLY ( , A ). http://ss64.com/nt/runas.html

, , , API Win32, , , : RUNAS/NETONLY (#/. NET/WinForms)?

+2

, , B . , . , , \ server.domain.

+2

This is an example of a connection string used to access SSIS from different database servers in a different domain. Data Source = [IP Address]; User ID = [Windows Login]; Password = [your password]; Start Directory = [Your Database Name]; Provider = SQLNCLI10.1

Hope this helps.

+2
source

More articles:


All Articles