Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How to create OLEDB connection from another system

Author  Topic 

zaidiwaqas
Starting Member

8 Posts

Posted - 2011-02-07 : 14:39:03
Hi,
I have SQL Server 2005 installed on Windws Server 2003.
There are multiple database and the system is part of domain netowrk.

now i have another system having windows 7 on it. that system is not part of domain. i need to know how can i create an OLEDB connection from this system to the main one. it is giving message that "not trusted user connection" . how can i create a trusted connection at windows server.?

regards,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-02-07 : 14:46:05
It's easiest to use SQL authentication in this scenario.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -