locked
Login failed for user sa RRS feed

  • Question

  • Hi, i am using following connection string for SQL Server 2005 connectivity..

    "Server=PURCHASE-KASHAN; User ID=sa; Password=; Initial Catalog=NovaLeathers; Integrated Security=SSPI;Persist Security Info=False;"

    SQL Server is istalled on my development machine which is PURCHASE-KASHAN,  and  i am on client server environment and the client of a domain. i am using ISA 2004 for internet usage.

    The problem is when i disconnect  from ISA the above connection is not established. however the sql is istalled on my local machine. why isa is interfering with it.? please solve my problem.

     

    Thanks in advance

    Tuesday, February 8, 2011 8:29 AM

Answers

  • hi Muhammad,

    You're mixing SQL Server authentication and Windows authentication, take a look at

    http://www.connectionstrings.com/sql-server-2008

    Using Integrated Security=SSPI; means that the connection attempt is made with your current Windows account. Use either Integrated Security=SSPI; or User=;Password=;Trusted?Connection=False;.


    Microsoft MVP Office Access
    https://mvp.support.microsoft.com/profile/Stefan.Hoffmann
    • Proposed as answer by WeiLin Qiao Thursday, February 10, 2011 5:51 AM
    • Marked as answer by WeiLin Qiao Wednesday, February 16, 2011 10:18 AM
    Tuesday, February 8, 2011 8:39 AM

All replies

  • Standard Security

     Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;

    Trusted security

    Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

     

    http://www.connectionstrings.com/sql-server-2008


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, February 8, 2011 8:39 AM
  • hi Muhammad,

    You're mixing SQL Server authentication and Windows authentication, take a look at

    http://www.connectionstrings.com/sql-server-2008

    Using Integrated Security=SSPI; means that the connection attempt is made with your current Windows account. Use either Integrated Security=SSPI; or User=;Password=;Trusted?Connection=False;.


    Microsoft MVP Office Access
    https://mvp.support.microsoft.com/profile/Stefan.Hoffmann
    • Proposed as answer by WeiLin Qiao Thursday, February 10, 2011 5:51 AM
    • Marked as answer by WeiLin Qiao Wednesday, February 16, 2011 10:18 AM
    Tuesday, February 8, 2011 8:39 AM