October 16, 2013 at 2:40 pm
Hello,
I am trying to set up a SQL Server 2012 SSRS Server.
I've gone through the steps that I done for our other SSRS servers (Windows 2008 R2). However, for some reason, the virtual directories for ReportServer and Reports are not being created. I've opened up IIS Manager and I don't see an application or virtual directories for the report server.
When I try to go to the report server website, I am getting an error. The error is:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
I can't figure out why the directories are being created. I've created the firewall rule for port 80. I've restarted the server. I've looked at the config files and everything looks like it should.
Has anyone else had a problem setting up a SSRS 2012 server?
Thanks.
Tony
Things will work out. Get back up, change some parameters and recode.
October 17, 2013 at 2:03 am
WebTechie38 (10/16/2013)
Hello,I am trying to set up a SQL Server 2012 SSRS Server.
I've gone through the steps that I done for our other SSRS servers (Windows 2008 R2). However, for some reason, the virtual directories for ReportServer and Reports are not being created. I've opened up IIS Manager and I don't see an application or virtual directories for the report server.
When I try to go to the report server website, I am getting an error. The error is:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
I can't figure out why the directories are being created. I've created the firewall rule for port 80. I've restarted the server. I've looked at the config files and everything looks like it should.
Has anyone else had a problem setting up a SSRS 2012 server?
Thanks.
Tony
Standalone Mode:
SSRS from SQL 2008 onwards no longer interacts or uses the IIS service or IIS manager instead using is own HTTP stack. The configuration for the SSRS is controlled / maintained using the Report Services Configuration Manager or XML config files. No SSRS virtual directories within IIS Manager.
SharePoint Integrated Mode:
Still uses the IIS Manager due to SharePoint using it. Again though no SSRS virtual directories would be ceated.
I have had the issue before when installing SSRS that the administrator (you) cannot connect due to not having the rights on the SSRS server at the site level. I ran IE locally in admin mode to then add my own name to the security.
Fitz
October 17, 2013 at 2:44 pm
Yay! I got it to work. Here is my journal of how I did it:
•Installed developer install of SQL SERVER for reporting services.
•Got an error that says: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
•I modified the config. Nothing.
•I modified the config files. Nothing.
•I ran repair. Nothing. Same problem.
•I then renamed the config files with bak. I created an archive folder. I then copied all the config files into that folder.
•I then ran a repair. Nothing. Now I was getting a 503 error saying something about the service being unavailable.
•I then uninstalled Reporting services.
•I tried to reinstall again.
•I then got a setup error. It was a redundancy error.
•I then cleaned rebooted the server. I ran the install again and this time used a domain service account. I was able to get a successful install.
•As I was configuring configuration manager, I got the virtual directories created. However, I got error messages saying the URL was already reserved.
•I then open up an administrator run command window.
•I then keyed in netsh and then http show urlacl to see the available URLs.
•I then keyed in http delete urlacl url=http://+:80/reportserver
•I went back to configuration manager and hit apply. Yeah!! Now I was able to properly configure the webservice URL.
•I recreated the databases.
•I then tried to configure the reporting url and got the message the URL already reserved.
•I then keyed in http delete urlacl url=http://+:80/reports. Yeah, now I was able to properly configure the reporting URL.
•Now the site came up on the server, but failed on the other pcs.
• At that point, I just had to create the appropriate new role, add my groups domain and…I am up and running.
It took forever, but I won the war. While I was doing all that, I got word that some users are experiencing bad performance on another server. Off to the next battle.
Tony
Things will work out. Get back up, change some parameters and recode.
October 17, 2013 at 2:44 pm
Thanks Fitz for jumping in there with some help. I appreciate it.
Things will work out. Get back up, change some parameters and recode.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply