Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

Client in a workgroup with SQL Server using Windows Integrated Authentication

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carlos Felipe França da Fonseca - 01 Jul 2008 21:43 GMT
I have a SQL Server database server, member of a domain.
We use only Windows Integrated Authentication.
Now, we have some domain users that need to access our SQL Server, from
workstations not joined to the domain (member of workgroups).
Is it possible they access the databases using Windows domain logon
credentials even from workstations not joined to the domain?

Thanks,

Carlos Felipe França da Fonseca
Reply to this Message
Carlos Felipe França da Fonseca - 01 Jul 2008 22:09 GMT
I forgot... it's all via ODBC..

>I have a SQL Server database server, member of a domain.
> We use only Windows Integrated Authentication.
[quoted text clipped - 6 lines]
>
> Carlos Felipe França da Fonseca
Reply to this Message
Linchi Shea - 01 Jul 2008 22:19 GMT
It's possible, but highly undesirable because it defeats the purpose of the
integrated authetication.

Linchi

> I forgot... it's all via ODBC..
>
[quoted text clipped - 8 lines]
> >
> > Carlos Felipe França da Fonseca
Reply to this Message
Carlos Felipe França da Fonseca - 01 Jul 2008 22:22 GMT
Can you explain how it's possible?

Thanks!

Felipe

> It's possible, but highly undesirable because it defeats the purpose of
> the
[quoted text clipped - 14 lines]
>> >
>> > Carlos Felipe França da Fonseca
Reply to this Message
Linchi Shea - 01 Jul 2008 22:37 GMT
You can always supply the user and password to get authenticated first, and
then as long as you keep using that authenticated session, you don't have to
supply user name/password any more and can use integrated authentication. But
the fact you have to supply the username/password kind of defeats the purpose
of integrated authentication, doesn't it?

Linchi

> Can you explain how it's possible?
>
[quoted text clipped - 20 lines]
> >> >
> >> > Carlos Felipe França da Fonseca
Reply to this Message
Uri Dimant - 02 Jul 2008 06:23 GMT
Carlos
I agree with Linchi that it defeats the purpose of the
integrated authetication. In your case  you will have to create SQL Login
( switch  to mixed authenication)

> Can you explain how it's possible?
>
[quoted text clipped - 21 lines]
>>> >
>>> > Carlos Felipe França da Fonseca
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.