SQL Server Project - Failed to connect to databse...

"Login failed for user "anaxyd". The user is not associated with a trusted SQL Server connection."

indicates that you are attempting to connect using a SQL login (anaxyd) to a server that only accepts Windows authentication. You should switch the authentication mode to mixed to enable loging in using SQL logins.

To connect using a SQL Login, you usually need the following:

(1) server should accept mixed authentication (both Windows and SQL logins)
(2) the login that you are using must exist on the server - it must have been created using CREATE LOGIN or sp_addlogin
(3) the password that you specify must be correct

The error message indicates that condition (1) is not true.

Thanks
Laurentiu

LaurentiuCristofor at 2007-9-9 >

Here is a quick example for creating a login, a database, and a user for the login in that database:

create login alice with password = 'password'
go
create database sandbox
go
use sandbox
go
create user alice
go

You can now login as 'alice' and you can work in database 'sandbox'.

Thanks
Laurentiu

LaurentiuCristofor at 2007-9-9 >