Thread: Login failed. The user is not associated with a trusted SQL Server c

We have downloaded the demo software onto a windows 2003 server machine with IIS6 running.

Database management is via SQL Server Management Studio Express 2005.

Can access and see the database fine in the SQL Server Management Studio Express 2005 management console.

Server name is DRAGON-SERVER

So, web config reads:

<add key="DBConn" value="data source=DRAGON-SERVER;initial catalog=AspDotNetStorefront;user id=sa;password=Pa55word!;persist security info=True;packet size=4096" />

Problem is:
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

How can we overcome this?

Sounds like SQL was installed in 'Windows Authentication' mode rather than 'Mixed Mode', so SQL users won't work.

More info here.

Thank you, but that is not the case I'm afraid. Yhe server properties are checked to 'SQL Server and Windows Authentication mode'.

Do we need to add something or have we missed something?

Any ideas/suggestion? Anyone?

OK. All sorted with the database now, except that we now have a new problem.

When attempting to log in to admin we get the error message

Your account has been locked due to too many failed login attempts. Please contact the site administrator.

So, on the live site, changed the password, downloaded the db and restored this as our new local db, but still getting the same login error message.

Is there anyway over resolving this? Or creating a specific username/login for exclusive use locally? Essentially we want to use our local/in-house server for development and then upload to live once all happy and working.

all sorted now.