I need to set up a linked server.
I connect to a remote desktop, that has JXExplore (Active directory) data store on it. I connect to the RD with UserName= abc Password=123.
Then I connect to another remote desktop that has SQL 2008 on it. This is where I need to set up the linked server. I have read a million forums/articles on this but I CANNOT get connected for some reason. I have tried to query it and I have
also tried using SQL Server Business Intelligence method and can't connect.
I created the linked server like so...
sp_addlinkedserver 'ADSI', 'Active Directory Service Interface', 'ADSDSOObject', 'adsdatasource' <--Should I put my host name in for adsdatasource??
I created the Login like... (Here is where I 'Think' I go wrong)
sp_addlinkedsrvlogin 'ADSI', false, 'ls9', 'summit.local\abc', '123' <-- ls9 is the login name I use for SQL, summit.local is my host name, abc is the username to connect to the remote desktop the JXExplore is on and 123 is the password
I wrote some openquery queries to try and pull the data but my "LDAP://...." might have been wrong.
I do have all the Base DN, User DN, password, port number to connect to the JXExplore. I just have no idea where to input it all in my SQL statements
View Complete Post