Help: Login username and password

From: Steve (smartin@cambridgeassociates.com)
Date: 08/22/02 

From: "Steve" <smartin@cambridgeassociates.com>
Date: Thu, 22 Aug 2002 13:32:31 -0700

Mark,

It sounds like the security of the server is set for
trusted access only. To change this, you need to open
enterprise manager, right click on the server and select
properties and on the security tab, select authentication
mode SQL Server and Windows. If you do not have sa rights
to the server, you will need to talk to the DBA and ask
the DBA to change the security to mixed mode.... For more
information see SQL Server Books on Line Mixed Mode
security

Steve

>-----Original Message-----
>Hi,
>I'm fairly new to SQL Server. I've set up a database,
>tables, entered data, and created login
>username/passwords. I've been able to access data to a
>vb.net Windows application using Windows authentication.
>
>How do I set up SQL Server to use SQL Server
>authentication for Logins?
>
>I've tried creating a new login usernames and passwords
>in the security folder. When I Use thouse usernames and
>passwords in code or even when I try to run a query it
>SQL Server denies me access giving an error like:
>
> 'Login failed for user 'Mark2'. Reason: Not associated
>with a trusted SQL Server connection.'
>
>I don't understand because I added 'Mark2', a password,
>and rights to the approprate database.
>
>The reason I need to use SQL Server authentication is
>that I'm developing an application for the Web.
>
>Any help is appreciated.
>Thank you for your time,
>Mark
>.
>

Relevant Pages

  • Re: Login without password
    ... Sue has provided you with great resources to resolve your issue. ... Protection Program and to order your FREE Security Tool Kit, ... |>How can I delete the login and add it back? ... I migrate the server from ...
    (microsoft.public.sqlserver.security)
  • Re: hack using xp_cmdshell
    ... I'm no security expert, so please forgive if I'm not using the right ... install SQL Server in Windows Only mode and then Switch down to Mixed mode, ... Is the SQL Server instance a default instance? ... > port 65300, which has never been open on my firewall. ...
    (microsoft.public.sqlserver.server)
  • Re: Unknown Domain user - domain authentication appears limited
    ... (using cached login). ... Microsoft MVP (Windows Server System: Security) ... > due to the following error: Logon failure: the user has not been granted ...
    (microsoft.public.windows.server.security)
  • security-basics Digest of: get.123_145
    ... VPN to ASP a security risk? ... Re: Multiple IPSec tunnels? ... Subject: Security NT Server ... VPN to ASP a security risk? ...
    (Security-Basics)
  • << SBS News of the week - Sept 26 >>
    ... And he points to the info you need to put the file on the server in the ... at the network perimeter. ... The Symantec Firewall/VPN and the Gateway Security ... by the firewall at risk. ...
    (microsoft.public.backoffice.smallbiz2000)