Home > ASP Development > SQL Error - Login failed for user..

SQL Error - Login failed for user..

Hi,

I get the following error when trying to connect to sql server:

Microsoft OLE DB Provider for SQL Server (0x80004005)

Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

I've changed the sql server security settings to mixed mode.(SQL Server and Windows), and restarted sql server but I still get the error.

Any suggestions?

Thanks

Guest

dont associate your sa account with asp pages, because it has full rights,
create a new user, just for that database(which the asp site will use) and
grant only the rights its going to need(read/write)

add this account to your connection string and see if the error still occurs

Was this answer helpful ? Yes No

Guest

Sorry, I dont usually use the sa account to connect to the server.

I have another account set up for db access.The only reason why I used the sa account's to test if I dont get the error.

So , no I also get the error on my other account.

Was this answer helpful ? Yes No

Guest

and if you change the login mode to sql server only?

Was this answer helpful ? Yes No

Guest

how do you do that?

Was this answer helpful ? Yes No

Guest

sorry, my mistake, if was think of mixed mode