SQL Server Performance Forum – Threads Archive

Login failed for user ‘(null)’. Reason: Not associ

Hi friends,
When I tried to connect to a report server I am getting this error. Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. The sql server database is on one machine with windows 2003 standard edition and report server is on another machine with windows 2003 webserver edition. Any help please.
Thanks in advance,
Claudia

---

This happen when SQL machine and Reporting service machine aren’t on a
single domain or on a couple of trusted domain. Try to put the same password on local administrator user on both
machine. When the setup is completed succesfully, you can change the
passwords to a different couple again

---

More infotmation If its a domain member server, connect as the domain administrator,
for some reason RS uses your builtin/administrator account to verify
the account BEFORE it uses the details you typed in (why? because if
it doesnt fine the user it will prompt you re its creation if you
choose to do so). In my case, I was logged in locally to the member as administrator,
then got the trusted connection error. I can connect fine via my SQL
user, but RS simply ignored whatever i typed and didnt attempt to use
this in its first set of checks. With the domain admin account, my SQL authentication to my
ReportServer repository then worked a treat on install.

---

]]>