ccimino
Posts:7
 |
| 04/17/2008 19:31 |
|
|
Just downloaded the demo today in hopes of installing quickly and potentially purchasing. The install went fine but now I can't get conneted to my report server. My sql reporting services is installed on my local desktop for now so I am using the following entry:
Report Server URL = http:///ReportServer
Server Version = Reporting Services 2005
UserName = myusername
Password = *********
Domain =
Perhaps I am confused between the instance name, server name, and service name. My instance name is MSSQLSERVER. The service account is 711D-AHT/ccimino (my userid) and the server name (mahine name) is 711D-AHT. The report server and reports virtual directorys are all default names. The report server works fine on the local machine. What about the user name and password? Is that the same that is used to establish the service identity or is it the one in which the database uses? I had it set up to use the windows credentials on everything but I take it I need to use the SQL authentication.
Any help is appreciated. Thanks. chris
|
|
|
|
|
host
Posts:497
|
| 04/18/2008 06:16 |
|
| Chris, please put your domain name as 711D-AHT |
|
|
|
|
ccimino
Posts:7
|
| 04/18/2008 06:46 |
|
Tried that. Adding 711D-AHT gives the same error message:
There was an error: Unable to connect to the remote server
|
|
|
|
|
host
Posts:497
|
| 04/18/2008 06:54 |
|
| when you browse to http://reportserver/reportservice.asmx?wsdl what do you see? is this windows XP or windows 2003? |
|
|
|
|
ccimino
Posts:7
|
| 04/18/2008 07:00 |
|
| Using XP. When browsing to that I get an xml page displayed. |
|
|
|
|
host
Posts:497
|
| 04/18/2008 07:05 |
|
| That sounds right, and you selected this as a SQL RS 2005 server right? The credentials should be your domain or windows username / password. normally you put the domain name of the domain you are logging into, but in your case you'd use the machine name for the domain since you are doing all of this on your local machine. Can you validate on your reportserver directory that windows authentication is on in IIS? I assume you have reportserver somehow resolving to your local machine? You could try putting http://reportserver/reportserver in the URL as well, most times on XP, it is setup as a virtual directory so the entry would be http://localhost/reportserver or http://machinename/reportserver, but you sound like you have done something different in your setup. |
|
|
|
|
ccimino
Posts:7
|
| 04/18/2008 07:31 |
|
Yes, I believe I selected SQL RS 2005 (is there a way to check that?)
http://localhost/reportserver resolves and http://localhost/reports brings up the report manager and allows me to run reports. Under the SQL server configuration manager it shows the "log on as" .\ccimino (ccimino is my username). |
|
|
|
|
host
Posts:497
|
| 04/18/2008 08:05 |
|
| when you say http://localhost/reportserver resolves to http://localhost/reports, you mean it is redirecting and rewriting the URL? That shouldn't be happening if so. You tried putting this as your report server: http://localhost/reportserver/reportserver.asmx and then put your windows user (ccimino) and password and for the domain, put your machine name. |
|
|
|
|
ccimino
Posts:7
|
| 04/18/2008 08:17 |
|
No those were two separate statements. I just meant that both \localhost\reportserver AND \localhost\reports were working.
I tried http://localhost/reportserver/reportserver.asmx (note I am using ip address instead of "localhost" because my DNN installation is on another box. I have ccimino as the userid, the correct password (same as used on the local machine), and with my machine name as the domain. I've tried with and without the domain. Still doesn't work. Should I just reintall SQL RS 2005 to see if that fixes it? |
|
|
|
|
host
Posts:497
|
| 04/18/2008 09:00 |
|
| i don't think reinstall will fix this...it is an environment thing. so i'm clear, what machine is hosting the web server, is it on the same machine as sql reporting services? i thought all of this was on XP, but now i'm confused with what you said using the IP and DNN install on another box. |
|
|
|
|
ccimino
Posts:7
|
| 04/18/2008 09:27 |
|
Here is my landscape:
I have DNN installed on a Windows 2003 web server in a production environment.
The DNN database in SQL Server 2005 and on a another box.
The Report Server (RS 2005) and associated datbase (SQL Server 2005) are for now on my local machine (Windows XP). I will eventually move to a production machine if my testing goes well.
|
|
|
|
|
host
Posts:497
|
| 04/18/2008 10:10 |
|
| Go the webserver machine, from the console, open internet explorer and browse to http://yourip/reportserver, what do you see? |
|
|
|
|
ccimino
Posts:7
|
| 04/18/2008 11:22 |
|
Found the problem - XP firewall. I had to go into Control Panel->Windows Firewall, click on the Advanced tab, click on Settings in the Network Connection Settings, check the box that says "Web Server (HTTP)" and then add my ip address or machine name. Worked immediately once I did this!!
Thanks for your help.
|
|
|
|
|