Cannot login from Asp.net 2.0

• souravmoysau

  SSC Journeyman

  Points: 90

  More actions

  March 3, 2008 at 10:37 pm

  #91653

  Hello,

  i am using sql server 2005 and installed in mixed mode withe user name sa and password #sa

  and from Sql Server Surface Area Configuration i select the Using both TCP/IP and named pipes for remote settings under Database Engine

  version is [@@version]

  Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

  My os is Xp with service pack2

  I am using asp.net 2.0 and using connection string in web.config

  SOURAV is my local Database Server name.

  I can connect server with the user name password from the SQL Server Management Studio,

  But the problem arise when i hit con.open() from asp.net page

  error message show login fauled for user 'sa'

  Please help how to solve this problem ,

  Thanks in advance

  Sourav

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  March 4, 2008 at 10:55 am

  #785081

  In IIS Deny Anonymous Access and in your Web.Config enable impersonation.

  Kind regards,
  Gift Peddie