dbTalk Databases Forums  

Windows authentication.

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Windows authentication. in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Smith
 
Posts: n/a

Default Windows authentication. - 02-06-2008 , 06:48 PM






Dear professional.

I would appreciate if anyone can reply me about this. As my understanding
and microsoft also recommend that always use Windows authentication mode for
security. Can anybody let me know if I use windows authentication mode then
how application and database connect each other, is there any buildin
machine level user or how to mention in my webconfig file to connect to
database and what if I want to connect my database from client side, which
userid should I provide to connect as I am using windows authenciation mode.
In mixed mode we can create couple of uses and use that users to connect to
sql server (query analyzer). What I have to use in Windows authentication
mode and Both client and server are not in same Domain or may be both are on
workgroup.

Please advice.

Thanks


Reply With Quote
  #2  
Old   
Duncan McC
 
Posts: n/a

Default Re: Windows authentication. - 02-06-2008 , 07:56 PM






In article <F1D9444A-DE39-418F-AAD0-549F665FAF8D (AT) microsoft (DOT) com>,
naissani (AT) hotmail (DOT) co says...
Quote:
Dear professional.

I would appreciate if anyone can reply me about this. As my understanding
and microsoft also recommend that always use Windows authentication mode for
security. Can anybody let me know if I use windows authentication mode then
how application and database connect each other, is there any buildin
machine level user or how to mention in my webconfig file to connect to
database and what if I want to connect my database from client side, which
userid should I provide to connect as I am using windows authenciation mode.
In mixed mode we can create couple of uses and use that users to connect to
sql server (query analyzer). What I have to use in Windows authentication
mode and Both client and server are not in same Domain or may be both are on
workgroup.
There are various methods your app could use to talk to the db. One eg.
might be ADO. Using that eg. you'll then have an ADO config in Control
Panel, and in there you can set Windows Auth and the database to connect
to.

That's just one eg (using ADO).

--
Duncan


Reply With Quote
  #3  
Old   
Duncan McC
 
Posts: n/a

Default Re: Windows authentication. - 02-06-2008 , 07:56 PM



In article <F1D9444A-DE39-418F-AAD0-549F665FAF8D (AT) microsoft (DOT) com>,
naissani (AT) hotmail (DOT) co says...
Quote:
Dear professional.

I would appreciate if anyone can reply me about this. As my understanding
and microsoft also recommend that always use Windows authentication mode for
security. Can anybody let me know if I use windows authentication mode then
how application and database connect each other, is there any buildin
machine level user or how to mention in my webconfig file to connect to
database and what if I want to connect my database from client side, which
userid should I provide to connect as I am using windows authenciation mode.
In mixed mode we can create couple of uses and use that users to connect to
sql server (query analyzer). What I have to use in Windows authentication
mode and Both client and server are not in same Domain or may be both are on
workgroup.
There are various methods your app could use to talk to the db. One eg.
might be ADO. Using that eg. you'll then have an ADO config in Control
Panel, and in there you can set Windows Auth and the database to connect
to.

That's just one eg (using ADO).

--
Duncan


Reply With Quote
  #4  
Old   
Duncan McC
 
Posts: n/a

Default Re: Windows authentication. - 02-06-2008 , 07:56 PM



In article <F1D9444A-DE39-418F-AAD0-549F665FAF8D (AT) microsoft (DOT) com>,
naissani (AT) hotmail (DOT) co says...
Quote:
Dear professional.

I would appreciate if anyone can reply me about this. As my understanding
and microsoft also recommend that always use Windows authentication mode for
security. Can anybody let me know if I use windows authentication mode then
how application and database connect each other, is there any buildin
machine level user or how to mention in my webconfig file to connect to
database and what if I want to connect my database from client side, which
userid should I provide to connect as I am using windows authenciation mode.
In mixed mode we can create couple of uses and use that users to connect to
sql server (query analyzer). What I have to use in Windows authentication
mode and Both client and server are not in same Domain or may be both are on
workgroup.
There are various methods your app could use to talk to the db. One eg.
might be ADO. Using that eg. you'll then have an ADO config in Control
Panel, and in there you can set Windows Auth and the database to connect
to.

That's just one eg (using ADO).

--
Duncan


Reply With Quote
  #5  
Old   
Duncan McC
 
Posts: n/a

Default Re: Windows authentication. - 02-06-2008 , 07:56 PM



In article <F1D9444A-DE39-418F-AAD0-549F665FAF8D (AT) microsoft (DOT) com>,
naissani (AT) hotmail (DOT) co says...
Quote:
Dear professional.

I would appreciate if anyone can reply me about this. As my understanding
and microsoft also recommend that always use Windows authentication mode for
security. Can anybody let me know if I use windows authentication mode then
how application and database connect each other, is there any buildin
machine level user or how to mention in my webconfig file to connect to
database and what if I want to connect my database from client side, which
userid should I provide to connect as I am using windows authenciation mode.
In mixed mode we can create couple of uses and use that users to connect to
sql server (query analyzer). What I have to use in Windows authentication
mode and Both client and server are not in same Domain or may be both are on
workgroup.
There are various methods your app could use to talk to the db. One eg.
might be ADO. Using that eg. you'll then have an ADO config in Control
Panel, and in there you can set Windows Auth and the database to connect
to.

That's just one eg (using ADO).

--
Duncan


Reply With Quote
  #6  
Old   
Duncan McC
 
Posts: n/a

Default Re: Windows authentication. - 02-06-2008 , 07:56 PM



In article <F1D9444A-DE39-418F-AAD0-549F665FAF8D (AT) microsoft (DOT) com>,
naissani (AT) hotmail (DOT) co says...
Quote:
Dear professional.

I would appreciate if anyone can reply me about this. As my understanding
and microsoft also recommend that always use Windows authentication mode for
security. Can anybody let me know if I use windows authentication mode then
how application and database connect each other, is there any buildin
machine level user or how to mention in my webconfig file to connect to
database and what if I want to connect my database from client side, which
userid should I provide to connect as I am using windows authenciation mode.
In mixed mode we can create couple of uses and use that users to connect to
sql server (query analyzer). What I have to use in Windows authentication
mode and Both client and server are not in same Domain or may be both are on
workgroup.
There are various methods your app could use to talk to the db. One eg.
might be ADO. Using that eg. you'll then have an ADO config in Control
Panel, and in there you can set Windows Auth and the database to connect
to.

That's just one eg (using ADO).

--
Duncan


Reply With Quote
  #7  
Old   
Duncan McC
 
Posts: n/a

Default Re: Windows authentication. - 02-06-2008 , 07:56 PM



In article <F1D9444A-DE39-418F-AAD0-549F665FAF8D (AT) microsoft (DOT) com>,
naissani (AT) hotmail (DOT) co says...
Quote:
Dear professional.

I would appreciate if anyone can reply me about this. As my understanding
and microsoft also recommend that always use Windows authentication mode for
security. Can anybody let me know if I use windows authentication mode then
how application and database connect each other, is there any buildin
machine level user or how to mention in my webconfig file to connect to
database and what if I want to connect my database from client side, which
userid should I provide to connect as I am using windows authenciation mode.
In mixed mode we can create couple of uses and use that users to connect to
sql server (query analyzer). What I have to use in Windows authentication
mode and Both client and server are not in same Domain or may be both are on
workgroup.
There are various methods your app could use to talk to the db. One eg.
might be ADO. Using that eg. you'll then have an ADO config in Control
Panel, and in there you can set Windows Auth and the database to connect
to.

That's just one eg (using ADO).

--
Duncan


Reply With Quote
  #8  
Old   
Duncan McC
 
Posts: n/a

Default Re: Windows authentication. - 02-06-2008 , 07:56 PM



In article <F1D9444A-DE39-418F-AAD0-549F665FAF8D (AT) microsoft (DOT) com>,
naissani (AT) hotmail (DOT) co says...
Quote:
Dear professional.

I would appreciate if anyone can reply me about this. As my understanding
and microsoft also recommend that always use Windows authentication mode for
security. Can anybody let me know if I use windows authentication mode then
how application and database connect each other, is there any buildin
machine level user or how to mention in my webconfig file to connect to
database and what if I want to connect my database from client side, which
userid should I provide to connect as I am using windows authenciation mode.
In mixed mode we can create couple of uses and use that users to connect to
sql server (query analyzer). What I have to use in Windows authentication
mode and Both client and server are not in same Domain or may be both are on
workgroup.
There are various methods your app could use to talk to the db. One eg.
might be ADO. Using that eg. you'll then have an ADO config in Control
Panel, and in there you can set Windows Auth and the database to connect
to.

That's just one eg (using ADO).

--
Duncan


Reply With Quote
  #9  
Old   
Duncan McC
 
Posts: n/a

Default Re: Windows authentication. - 02-06-2008 , 07:56 PM



In article <F1D9444A-DE39-418F-AAD0-549F665FAF8D (AT) microsoft (DOT) com>,
naissani (AT) hotmail (DOT) co says...
Quote:
Dear professional.

I would appreciate if anyone can reply me about this. As my understanding
and microsoft also recommend that always use Windows authentication mode for
security. Can anybody let me know if I use windows authentication mode then
how application and database connect each other, is there any buildin
machine level user or how to mention in my webconfig file to connect to
database and what if I want to connect my database from client side, which
userid should I provide to connect as I am using windows authenciation mode.
In mixed mode we can create couple of uses and use that users to connect to
sql server (query analyzer). What I have to use in Windows authentication
mode and Both client and server are not in same Domain or may be both are on
workgroup.
There are various methods your app could use to talk to the db. One eg.
might be ADO. Using that eg. you'll then have an ADO config in Control
Panel, and in there you can set Windows Auth and the database to connect
to.

That's just one eg (using ADO).

--
Duncan


Reply With Quote
  #10  
Old   
Duncan McC
 
Posts: n/a

Default Re: Windows authentication. - 02-06-2008 , 07:56 PM



In article <F1D9444A-DE39-418F-AAD0-549F665FAF8D (AT) microsoft (DOT) com>,
naissani (AT) hotmail (DOT) co says...
Quote:
Dear professional.

I would appreciate if anyone can reply me about this. As my understanding
and microsoft also recommend that always use Windows authentication mode for
security. Can anybody let me know if I use windows authentication mode then
how application and database connect each other, is there any buildin
machine level user or how to mention in my webconfig file to connect to
database and what if I want to connect my database from client side, which
userid should I provide to connect as I am using windows authenciation mode.
In mixed mode we can create couple of uses and use that users to connect to
sql server (query analyzer). What I have to use in Windows authentication
mode and Both client and server are not in same Domain or may be both are on
workgroup.
There are various methods your app could use to talk to the db. One eg.
might be ADO. Using that eg. you'll then have an ADO config in Control
Panel, and in there you can set Windows Auth and the database to connect
to.

That's just one eg (using ADO).

--
Duncan


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.