error when connecting to SQL server using ASP.NET (VB) with windows authentication

Hi,

I got an error when i tried to connect to SQL server using ASP.NET (VB) with windows authentication using the statement:

sqlconnection(server=sqlserver;database=db;integrated security=SSPI)

the error was:

SQL Error : Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
SQL Source: .Net SqlClient Data Provider
SQL Error Number: 18452



Answer this question

error when connecting to SQL server using ASP.NET (VB) with windows authentication

  • Gorm Braarvig

    Does the ASP.NET account have the appropriate rights on your DB


  • FoxP

    Hello

    The Server is not setup to accept a trusted connection. Check the Server Configuration and make sure that you accept both types of connection.



  • error when connecting to SQL server using ASP.NET (VB) with windows authentication