How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Chris Baxter Your Own Question

Chris Baxter
Chris Baxter, Programmer
Category: Software
Satisfied Customers: 243
Experience:  Java, iOS, VB.net, SQL, C+, C++, Obj C
68869132
Type Your Software Question Here...
Chris Baxter is online now
A new question is answered every 9 seconds

My laptop has SQL 2014 express and SQL Report builder

Customer Question

My laptop has SQL 2014 express and SQL Report builder installed. Report builder wants to connect to a report server, which I assume is my instance of SQL server. That's called JOHNNEWLAPTOP\SQLEXPRESS. However, that does not work, nor does any variation thereof. What am I doing wrong?
Submitted: 2 months ago.
Category: Software
Expert:  Russell H. replied 2 months ago.

Hi, thank you for contacting JustAnswer.com. My name is Russell. I will do my best to provide the right answer to your question.

To boil advice down to a simplified version, try this:

http://<machine name>/ReportServer_<SQL Server instance name>

where the machine name is ***** *****'s name on the network, then SQL Server instance name is ***** ***** SQL server. Note that the last must be preceded by a _ (underscore character).

Something like, in your case,

http://JOHNNEWLAPTOP/ReportServer_SQLEXPRESS

perhaps.

But that is a URL for a web resource, not a proper reference for the Report Server to connect to... so, the point is, this way you get to a directory of elements published to Reporting Services. And this info may be entered in the Connect dialog for your Report Server.

Tell me whether I got that right, or whether that too does not work, please.

Customer: replied 2 months ago.
Nope, that did not work. I entered http://JOHNNEWLAPTOP/ReportServer_SQLEXPRESS
Expert:  Russell H. replied 2 months ago.

If it didn't work, I apologize, but I am out of ideas on this subject.

Um, did you enter that address

http://JOHNNEWLAPTOP/ReportServer_SQLEXPRESS

in a web browser, to bring up a listing, rather than entering it as the URL of the report server?

Customer: replied 2 months ago.
Attached is where I entered that information.
Expert:  Russell H. replied 2 months ago.

OK - that was the wrong place.

You have to go about gathering the information for the right entry to that

"Connect To Report Server"

entry box, by first looking up an informational URL address, using a web browser (such as Internet Explorer.)

You open Internet Explorer (or other web browser program) and enter

http://JOHNNEWLAPTOP/ReportServer_SQLEXPRESS

into the web browser's Address field, then press RETURN, to bring up a page full of information.

Can you do that?

Customer: replied 2 months ago.
That does not work either. It returns "Unable to connect" and a lot of other material basically saying there is no such IP. PLEASE! This is very important to me and it's been two days. If you are not able to help me, please refer this out.
Expert:  Russell H. replied 1 month ago.

I have Opted Out, with apologies, owing to my not knowing how to solve this problem (I admit.) This opens the case to other Experts in this category.

Expert:  Andrew James replied 1 month ago.

Hello,

I have only basic experience working with the 2008 version of this tool, but as it appears this has been sitting for awhile and hopefully it hasn't changed too drastically, I wanted to send you what I'm aware of. First, Your running SQLServer on the same laptop Report builder correct?

Since its been a few days, make sure SQL server is up and running still. In your browser the URL "should be" http://localhost/ReportServer_SQLEXPRESS if things are working on SQL Server. Also make sure in the SQL server express manager you have SQL Server Reporting Services turned on

From there in report builder you need to either connect to that same url, or cancel out choose "Web Service URL" and set the IP to either 127.0.0.1 or localhost. That should get you in.

If it doesn't I'll drop the question back in the queue, but hopefully this gets you moving forward.

Customer: replied 1 month ago.
None of that seems to work. What I don't understand is trying to connect through a browser. The report builder seems to need to make its own connection to SQL server. Or is it? What exactly is the "Report Server?" Is it a separate program? Or a separate folder?
Expert:  Andrew James replied 1 month ago.

It's because SQLEXPRESS runs on port 80 actually, so a browser is the quickest way to check and make sure its functional. There is a reporting service that does need enabled for it to work properly, its essentially analytics service that goes along with sqlexpress

I'm going to opt out also and hope someone else can figure out what is missing in this one.

Expert:  Chris Baxter replied 1 month ago.

I hate to redirect to another website, but trust me, this is worth the rating! ;) please give the tech net article at the following link a read, and you will see how that connection error works in explicit detail, and how to fix it. There is far too much to write here! Have a wonderful evening!

https://blogs.technet.microsoft.com/jessmeats/2011/01/13/connecting-to-report-server/

Customer: replied 1 month ago.
I see. Do I have to put the :80 in the path.
Expert:  Chris Baxter replied 1 month ago.

Yes, if you look at that article, there is a clear example of what you will need for that path, the port is just after your machine name, so "machine name:80"