Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2012 - Virtual directories not being created Expand / Collapse
Author
Message
Posted Wednesday, October 16, 2013 2:40 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 8:31 AM
Points: 269, Visits: 784
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






Post #1505418
Posted Thursday, October 17, 2013 2:03 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 1:18 AM
Points: 3,163, Visits: 1,377
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

Post #1505521
Posted Thursday, October 17, 2013 2:44 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 8:31 AM
Points: 269, Visits: 784
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



Post #1505911
Posted Thursday, October 17, 2013 2:44 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 8:31 AM
Points: 269, Visits: 784
Thanks Fitz for jumping in there with some help. I appreciate it.


Post #1505912
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse