MSSQL$SQLEXPRESS login failed

  • I keep getting this weird error in the application log where it basically says.

    Login failed for user ´sa´[Client: ]

    Anyone know what this might be? I´m running (i think) a single instance of SQLExpress and I havent changed the sa password which is automatically assigned to a certain applivcation database.

    The box it is running on has windows 2003 server enterprise edition and service pack 2

  • Try to login into the SQL server using the windows credentials as System Adminstrator and then change the sa password.

    Greetings

    Santiago Carela.

  • Pls make sure that you have set authentication to 'Windows and SQL authentication' under the properties.

    This might be the case!

    🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply