Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS 2012 - Virtual directories not being created


SSRS 2012 - Virtual directories not being created

Author
Message
WebTechie
WebTechie
SSC Veteran
SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)

Group: General Forum Members
Points: 295 Visits: 916
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



Mark Fitzgerald-331224
Mark Fitzgerald-331224
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3694 Visits: 1513
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
WebTechie
WebTechie
SSC Veteran
SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)

Group: General Forum Members
Points: 295 Visits: 916
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



WebTechie
WebTechie
SSC Veteran
SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)

Group: General Forum Members
Points: 295 Visits: 916
Thanks Fitz for jumping in there with some help. I appreciate it.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search