Basic authentication question

From: Partha (pd_niit_at_rediffmail.com)
Date: 09/19/03


Date: Fri, 19 Sep 2003 08:38:16 -0700


>-----Original Message-----
>Hi,
>
>I'm trying to remotely connect to my SQLServer 6.5, but
it's throwing me
>and error saying that I need to set the SQL Server
authetication on the
>server.
>
>Where would I do this.
>
>thanks,
>
>
>It probably means that your authentication is set to
Windows only.That's why it's searching for a windows user
account/login.You may change it to either dual or sql only
authentication modes.

Regards

Partha
>.
>



Relevant Pages

  • AUTHENTICATION TO APPLY SP3
    ... a problem with SP3? ... > SQL Server 2000 RTM Standard Edition ... >windows user. ... >These accounts and passwords are good because I can get ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2008 set up
    ... Probably you did not install your SQL Server 2008 Instance under this Windows User Account and probably you did not add this user to the "SQL Server System Administrators" list during SQL Server 2008 Setup. ...
    (microsoft.public.sqlserver.setup)
  • Re: ASP.NET Forms Authentication Via A SQL Server Database With Windows User types?
    ... we have decided to go with SQL Server security vs Windows (using ... Standard SQL Users, not the Windows Users) - it just seems to be the ideal ... The Windows user type in SQL Server uses the security context of the ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Copy User permission
    ... We are migrating Windows user to amnother domain, ... server windows users have sid, and name hard coded to the ... SQL Server ... login id to a new login id? ...
    (microsoft.public.sqlserver.security)
  • Re: Get Login
    ... In "Windows Authentication mode" the system_user returns the ... Sql Server can't know the Windows User name if the Authentication is "SQL ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)

Quantcast