[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Users on SQL Server 2000

RickSean

3/1/2007 2:14:00 PM

I have a large number of users connecting to SQL Server database from an
application that uses a System DSN for connection.

How do I setup SQL Server so the users are able to connect to the SQL Server
using 'Windows Authenication' ?
2 Answers

Uri Dimant

3/1/2007 2:16:00 PM

0

Rick

1) Right click on Server and choose Properties
2) Go to Security Tab and check Windows Only checkbox

Note , you will have to modify connection string to copnnect with WA




"RickSean" <RickSean@discussions.microsoft.com> wrote in message
news:2A75074E-310C-451A-92B5-7E383A56010E@microsoft.com...
>I have a large number of users connecting to SQL Server database from an
> application that uses a System DSN for connection.
>
> How do I setup SQL Server so the users are able to connect to the SQL
> Server
> using 'Windows Authenication' ?


Hari

3/1/2007 4:17:00 PM

0

After the change Uri pointed out you need to stop and start SQL Server
service.

Thanks
Hari

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:%2301oIxAXHHA.2256@TK2MSFTNGP02.phx.gbl...
> Rick
>
> 1) Right click on Server and choose Properties
> 2) Go to Security Tab and check Windows Only checkbox
>
> Note , you will have to modify connection string to copnnect with WA
>
>
>
>
> "RickSean" <RickSean@discussions.microsoft.com> wrote in message
> news:2A75074E-310C-451A-92B5-7E383A56010E@microsoft.com...
>>I have a large number of users connecting to SQL Server database from an
>> application that uses a System DSN for connection.
>>
>> How do I setup SQL Server so the users are able to connect to the SQL
>> Server
>> using 'Windows Authenication' ?
>
>