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

Hot Topic

OLEDB command gets compile errors but works in Query analyzer.
how to get Alias name in columns and mapped column from views
After enabling named pipes and disabling again, not able to start engine
Using result sets from a stored procedure
How to concatenate constants and expressions in report field
GetValue on a DTSProperty Object
SQL Server <-> Terminal Server
How to get detailed info of views?
unclean uninstall of beta, can't install SQL Server 2005 Std
SQL Server 2005 Standard edition install fails; An instance with the same name.../

SQL Server

Multi-Instance
SQL Server Management Studio Express CTP
AGGREGATE doesn't do MIN/MAX on textual columns
Error evaluating expression
Error in execute sql task
SqlServer2K5_BOL.msi
Dynamic Tooltip for TextBoxes in Reports?
order by in a view in sqlserver2005
Escape character for /SET option of dtexec
Patching SqlRun_Sql.msi not successful

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

Hi,

I have 2 windows 2003 server, i instllaed sql server 2005 enterprise edition on the first one (Mixed Mode), and i am trying to install sql server reporting 2000 on the second one,

I installed the sql 2000 connectivity only on the second one , and i installed the sql server sp4 also, while installing reporting services i used the sql login account (sa,pwd)

i got the following error :

Cannot connect to sql server instance ...

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

NB1: Allow Remote connection is enabled on sql server 2005.

NB2: I tried to connect from server 2 to server 1 from odbc and it worked properly with (sa,pwd) i have only a problem from reporting server.

Please any help

Tarek Ghazali

SQL Server MVP

Answer this question

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

  • Sianspheric

    Login failures are normally logged. Are you sure you checked the log on the right server - the one you were trying to connect to Also, have you got any insights from running a Profiler trace

    Thanks
    Laurentiu



  • John Bocachica

    Hi Laurentiu,

    Thx for your reply,

    I have 2 servers on the same domain and under vmware virtual

    server (the new release beta 2) ,about sql 2000 connectivity you can install sql server 2000 as (database server or client or connectivity).

    I don't have any log error.

    Thanks,

    Tarek Ghazali

    SQL Server MVP

  • Vittorio Vagliani

    Here's a thread that may be related to the issue you are seeing: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=422598&SiteID=1

    Thanks
    Laurentiu



  • Kyrin

    Are the machines in the same domain What is the network configuration What does "sql 2000 connectivity" mean

    Have you checked the errorlog Is there any additional information on the failure there

    Try running a Profiler trace on the SQL Server machine to see if you can find any additional information on the login attempt.

    Thanks
    Laurentiu



  • cesarmello

    Hi Laurentiu,

    I created a user on the domain , and i logged on windows by this user on the second server, i added this user to have access login on the first server and it worked fine.

    Regards,

     

    Tarek Ghazali

    SQL Server MVP

     
  • Login failed for user ''. Reason: Not associated with a trusted SQL Server connection.
Answer this question