SQL Server Performance

Error during install - login failed for user null

Discussion in 'SQL Server Reporting Services' started by ajashadi, Sep 21, 2005.

  1. ajashadi New Member

    Hi,
    I am trying to install Reporting services on my pc which has Winxp pro. I connect to sql server 2000 sp3 database instance which is on LAN. During the install I got this error message - login failed for user null not associated with trusted SQL SERVER CONNECTION. Any suggestions are welcome. By the way, I have .net,visual studio and everything working fine on my pc including iis.


    Thanks in advance
  2. satya Moderator

    http://weblogs.asp.net/AChang/archive/2004/04/15/113866.aspx

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Reddy New Member

    Are you connecting with a domain account or with a SQL Server login?
    Your error indicates that sql server does not know who you are,Usually this occurs when the server is not mixed mode, but using sql logon.

    Thanks!
    "He laughs best who laughs last"

  4. ajashadi New Member

    quote:Originally posted by Reddy

    Are you connecting with a domain account or with a SQL Server login?
    Your error indicates that sql server does not know who you are,Usually this occurs when the server is not mixed mode, but using sql logon.

    Thanks!
    "He laughs best who laughs last"

    Thanks for the reply everyone,

    Here are the details or steps about installation options :

    ****SELECT AN ACCOUNT UNDER WHICH REPORTSERVER WINDOWS SERVICE WILL RUN ****

    Use a Built-in account : NT AUTHORITYSYSTEM

    ***THE REPORT SERVER WEB SERVICE WILL RUN UNDER THIS ACCOUNT***

    Account : Computer nameASPNET

    This is what I have selected. When I get to Report server database screen it asks for this

    SQL SERVER INSTANCE : iam using the ip i use to connect to db using enterprise manager.

    NAME : ReportServer

    CREDENTIALS TYPE : ServiceAccount.

    For credentials type i have also tried Domain user acc and sql login acc but it didnt work.

    Heres the error again

    ---------------------------
    Microsoft SQL Server 2000 Reporting Services Setup
    ---------------------------
    Cannot connect to the SQL server instance 109.107.101.3.(dummy ip real ip is different)

    Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
    ---------------------------
    OK
    ---------------------------

    By the way, Sql server is set for mixed mode both sql * windows login.

    I am using client tools to connect to sql server which is on remote server throught lan. I am able to connect to this remote sql server using enterprise manager from my pc. I am trying to install reporting services on my pc. i am not sure if reporting services are present on server, but my guess is its not.

    By the way, i was succesfull in doing this at my home pc where i have sql server db and everything on one single machine.

    Any suggestions are welcome.



  5. ajashadi New Member

    Hello,
    Anyone has seen this error before. I am still waiting for your inputs.

    Thanks.
  6. satya Moderator

  7. ajashadi New Member

    Success atlast... Well what I did was rather trial and error and it solved my problem. I tried what someone told me to do i.e. <br />****you will need to run the installation program from the command line as follows where &lt<img src='/community/emoticons/emotion-4.gif' alt=';p' />ath&gt; is the fully-qualified path to rsrun.msi. <br /><br />SETUP /i "&lt<img src='/community/emoticons/emotion-4.gif' alt=';p' />ath&gt;setup
    srun.msi" RSSETUPACCOUNT=&lt;username&gt; RSSETUPPASSWORD=&lt<img src='/community/emoticons/emotion-4.gif' alt=';p' />assword&gt; ***<br /><br />But it didnt work for me but helped me pursue my job still further by searching on the net. I used template.ini file and edited the settings in that like username and pwd etc. Then I ran setup /settings template.ini at commandprompt. If someone doesnt know template.ini heres a short overview. While installation, we have to enter some entries in text boxes but using template.ini you can automatically populate those entries. Coming back to point, the strange part is that whatever settings i.e. username pwd I entered in template file, where the same as the ones I had used earlier without any luck. But this time I didnt get any errors. I dont know of this strange behaviour but it worked for me. <br /><br />Below is the link which helped me....<br /><br />Here is the link<a target="_blank" href=http://weblogs.sqlteam.com/tarad/archive/2004/08/09/1895.aspx>http://weblogs.sqlteam.com/tarad/archive/2004/08/09/1895.aspx</a> . Sorry mods if we are not supposed to post outside links. Plz remove it if ur policy doesnt allow this.<br /><br />Thanks all for ur input.<br />

Share This Page