Mixed Mode Authentication

From: Karen Kolbe (klkolbe@cmsenergy.com)
Date: 10/25/02 

From: "Karen Kolbe" <klkolbe@cmsenergy.com>
Date: Fri, 25 Oct 2002 11:14:52 -0700

We have changed our SQL Server Authentication to Mixed
Mode (Windows Authentication and SQL Server
Authentication) and restarted SQL Server. However, when
you attempting to login to EM and you want to give it a
userid and password for SQL Server Authentication such as
sa and its password. We are getting this error and don't
even see the SQL Server login window

A connection could not be established to PR1WNTD2
Reason: Login failed for user "PR1WNTD2\klkolbe'...

Please verify SQL Server is running and check you SQL
Server registration properties (by right-clicking on the
PR1WNTD2 node) and try again.

Any clues as why we have failed to set up Mixed Mode
Authentication????

Relevant Pages

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server 2005 login issure 2
    ... My programming knowlege is pretty rusty, but if you installed SQL Server ... if you installed with Windows Authentication and then ... ALTER LOGIN sa ENABLE; ... > If by any change you have read my original post titled "SQL Server 2005 ...
    (microsoft.public.sqlserver.connect)