Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Report Builder 3.0

Author  Topic 

maineman
Starting Member

7 Posts

Posted - 2013-02-28 : 12:11:16
I have recently installed SQL Server 2008 SP3 and when I open the Report Builder I cannot get it to connect to the server.

I have tried http://mssqlserver/reportbuilder

but that doesn't seem to be the right one. Can anyone provide the correct way to connect Report Builder 3.0? I'm just starting to learn Report Builder and would like to connect. Thanks in advance for any help.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-28 : 12:23:24
Did you mean the Report Server? Try this: http://YourServerNameHere/Reports

In the above, "YourServerName" is the network name of the box where you have reportserver installed.
If that does not work, launch the Reporting Services Configuration Manager (it's under SQL Server 2008 -> Configuration Tools program group), connect to the server where you have ReportServer installed, and look under the Report Manager URL.

If you indeed meant report builder, once you connect to the Report Server (use Internet Explorer and not chrome or firefox), you can launch report builder from there.
Go to Top of Page

maineman
Starting Member

7 Posts

Posted - 2013-02-28 : 12:38:25
I cannot connect to the report server using the method you described.
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-28 : 12:40:31
Is SQL Server Reporting Services running? Start->Run->Services.msc, look for SQL Server Reporting Services, and verify that it is running. If it is, then connect using the configuration manager as I had described in my previous post.
Go to Top of Page

maineman
Starting Member

7 Posts

Posted - 2013-02-28 : 12:46:04
Sorry to be so ignorant but I cannot find reporting services in the configuration manager as you described under properties.

This is the free version(s) from the web so I am not sure if all components are installed during setup. Server wise.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-28 : 12:47:55
quote:
Originally posted by maineman

I cannot connect to the report server using the method you described.


whats the error?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-28 : 12:49:50
quote:
Originally posted by maineman

Sorry to be so ignorant but I cannot find reporting services in the configuration manager as you described under properties.

This is the free version(s) from the web so I am not sure if all components are installed during setup. Server wise.


that means reporting service is not installed. You need to get it installed before you configure your report server

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

maineman
Starting Member

7 Posts

Posted - 2013-02-28 : 12:55:23
ok i think i need the version with advanced services. I will uninstall the version I have and install that version to see if that solves my problem.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-28 : 12:58:10
yep..you need one with advanced services which includes reporting services as well.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -