Re: Usergroup setup & Changing authentecation

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 06:47:51 -0500

Your post is not exactly clear. What are you trying to do?

You can "test" SQL Server authentication by creating a (SQL) user via
sp_addlogin.
sp_grantlogin allows you to create a Windows Authentication login. 

-- 
Keith
"GarryD" <garrydawkins@hotmail.com> wrote in message
news:0d9a01c49b5c$c9682a40$a401280a@phx.gbl...
> It's been so long since I've done this. I need to test sql
> server authentacation and setup a test usergroup to test
> in our new development environment. Any ideas????
>

Relevant Pages

  • Re: SQL Server Authentication hacking
    ... If so, SQL Server Authentication ... is vulnerable to sniffers that can decrypt password. ... > password is passed across the network (connection string ...
    (microsoft.public.sqlserver.security)
  • SQL Server Authentication hacking
    ... I currently connect to SQL 7 and 2K servers using SQL ... server authentication. ... This means that in the connection ... password is passed across the network (connection string ...
    (microsoft.public.sqlserver.security)
  • answered...
    ... Had to change connection string o use OLEDB provider ... instead of ODBC-type connection which only supports SQL ... Server Authentication. ...
    (microsoft.public.sqlserver.security)
  • anonymous logging on ISA SEVER
    ... SQL database(SQL server authentication) behind an ISA ... firewall without allowing anybody at all to log on to my ...
    (microsoft.public.isaserver)
  • Re: SQL development in VS.NET
    ... replace the need for developers to use the SQL Enterprise Manager ... development environment or is it a limited but convenient environment. ... VS.NET (eg. where is the SQL Profiler, DTS, etc.)? ... there is no way to run profiler, DTS etc directly from server explorer. ...
    (microsoft.public.dotnet.general)