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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Communications off Domain

Author  Topic 

AlphaTwin
Starting Member

2 Posts

Posted - 2012-01-06 : 11:48:32
Hello All,

Forgive me if this question has been asked, I'm not even sure how to properly word it to get viable hits.

We have a piece of software that is SQL driven (Procede). If I'm on the Windows Domain, Procede works fine, however if I load Procede on a system that has not been joined to the domain, it will not connect.

I can get to windows shares on that same server with no problem if I give my domain credentials, but my odbc data source doesn't seem to work properly off domain.

So my guess is SQL does something different, can anybody point out my problem. Is their a way to allow off domain clients to connect to the SQL database?

Thanks
Eric

AlphaTwin
Starting Member

2 Posts

Posted - 2012-01-06 : 12:16:18
It looks to me from other comments that I have now found, that people are being told to use "with SQL server authentication." This is how mine appears to be set. On the server, if I right click on the db and go to the permission page, I have an account set for just this purpose. As a matter of fact that is how my client all connect when they are on the domain, yet I still seem unable to connect off domain.

hmmm
Go to Top of Page
   

- Advertisement -