SQL Authentication

• tsd_suresh

  SSC Enthusiast

  Points: 111

  More actions

  December 21, 2009 at 7:08 am

  #213826

  Hi,

  I am facing SQL users authentication failed . I have created a SQL users with Read/write permisson. when i try to connect to using this SQL users i cannot able to connect to Database. but the same time i can able to login using windows login.

  Please help me solve this issue.

  I have encounter follwoing error msg,

  Error: 18452, Severity: 14, State: 1.

  Login failed for user 'user123'. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]

  Another time i encounter following msg,

  A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

  Regards

  Suresh

• Bru Medishetty

  SSC-Insane

  Points: 23606

  More actions

  December 21, 2009 at 7:13 am

  #1094737

  Look at the Authentication Mode of your Server is it set to Mixed Mode?

  select authmode=case serverproperty('IsIntegratedSecurityOnly')

  when 1 then 'Windows Mode' Else 'Mixed Mode' end

  Run that command and see what does is results.

  ---

  Bru Medishetty

  Blog -- LearnSQLWithBru

  Join on Facebook Page Facebook.comLearnSQLWithBru

  Twitter -- BruMedishetty