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

Hot Topic

Error Number : 29503 The SQL Server service failed to start.
Cannot open backup device 'F:\foldername'. Operating system error 5(Access is denied.).
ADO.NET Source Custom Properties - Documentation Wrong?
matrix subtotal
SSIS and Notification Service
Can SSIS work without SQL SERVER 2005
Using reference ReportItems! in report totals
Licensing question, and other report building tools
Watermark Generation is Invalid Error
Metadata storage and intelligent use

SQL Server

SQL 2000 Best Practices Analyzer report clarification needed.
Analysis Services clusters
Passing Multivalue Parameters Through a Report Link
Adding SDF data into a Listview - C#
Dynamically creating cube
Capturing Processing Status and Progress Messages
Replication for Full-Text Index
Is it possible to create a bar code in SQL reporting?
smalldatetime type behavior
Compiling SQL statement in stored proc

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

Hi! I installed SQL Server on my server today and im new to it. I configured it and now im trying to make a SQL Server Project with my other computer... Then the program asks for some account information to logon to a database on the server. Then i fill it out and i get this error: Login failed for user "anaxyd". The user is not associated with a trusted SQL Server connection.
Do i need to join the domain that the server is in Or is it something with my account at the server I have created a account at the server management studio in my server: MAINSERVER\Security\logins\anaxyd.
Whats wrong



Answer this question

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

  • Lilian K

    How do I give users permissions to the server
    Plz answer.. Im stuck here.. Tongue Tied



  • Rick Broider

    The login still has to be given permissions on the server and permissions to the database....especially for testing you will want to set up your server security as "windows authentication only"

  • Ian Wallace

    Ok.. i have changed the option to accept mixed...

    But i need help to create a user... Can u specify it more Im a newb... :D

  • ymhtp

    Can someone please help me

  • Paulbo99

    The error message that you obtained:

    "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

  • EZanker

    You can look at the CREATE LOGIN and CREATE USER topics in Books Online (BOL).

    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


  • SQL Server Project - Failed to connect to databse...
Answer this question