September 21, 2005 at 9:27 am
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
September 21, 2005 at 9:49 am
How are you "Connecting" the error indicates that
A) you do not have a valid SPID on the network.
B) your trying to connect using a sql login, but sql server is set to only accept Windows logins.
C) I'm not sure.
September 21, 2005 at 10:13 am
How are you "Connecting" the error indicates that
A) you do not have a valid SPID on the network.
I am not sure what SPID is. Can you tell me plz.
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 AUTHORITY\SYSTEM
***THE REPORT SERVER WEB SERVICE WILL RUN UNDER THIS ACCOUNT***
Account : Computer name\ASPNET
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
---------------------------
B) your trying to connect using a sql login, but sql server is set to only accept Windows logins.
Sql server is set for mixed mode both sql * windows login.
C) I'm not sure.
I am not sure too.. plz advise...
September 21, 2005 at 10:45 am
Spid is what you get when you log into a windows domain. Security identifier, with your credentials.
Are you installing reporting manager on your machine, or just the client tools?
Does the sql server have reporting services installed on it?
I don't remember having the issues your having. But then again I just installed client tools connecting to a server that had it installed.
Check this link.
I'm not sure where its going awry
September 21, 2005 at 11:44 am
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.
September 22, 2005 at 12:07 am
Does your local PC have SQL Server installed? It's required if that's what you're installing to.
September 22, 2005 at 6:54 am
If you are installing Reporting Services on a box that is in a different domain than the SQL server box and you are using SQL credentials (as opposed to Windows credentials) for your SQL Server connection, you will need to run the installation program from the command line as follows where <path> is the fully-qualified path to rsrun.msi.
SETUP /i "<path>\setup\rsrun.msi" RSSETUPACCOUNT=<username> RSSETUPPASSWORD=<password>
September 26, 2005 at 12:19 pm
Success atlast... Well what I did was rather trial and error and it solved my problem. I tried what Jessica said 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 tried to edit the settings in that. 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.
Below is the link which helped me....
Here is the link http://weblogs.sqlteam.com/tarad/archive/2004/08/09/1895.aspx . Sorry mods if we are not supposed to post outside links. Plz remove it if ur policy doesnt allow this.
Thanks all for ur input.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply