Retired hobby coder needing help yet again.  I graduated college with a degree in economics Summa Cum Laude, but I gotta tell you, the Microsoft "family" of product and their usage totally bafflesme.

I purchase SQL Server 2014 and use Sequel Server Management Studio to access it.  Wanting to learn reporting I downloaded Microsoft Report Builder 3.0 and find myself unable to figure out how to connect to the SQL Server.

I would like to connect to this database.

Whenever I run the connection wizard I can't find even a sniff of the server in the above.

I'm sure it's all somewhere in the concisely written, ever logical and clear documentation...but I'm unable to find it.  Can someone please point me in the correct direction?

Regards,

Minuend

Hello,

Report Builder 3.0 was intended for SQL Server 2008 R2. Try using the following version of the tool.

http://www.microsoft.com/en-us/download/details.aspx?id=42301

The following post may be useful.

http://blogs.technet.com/b/jessmeats/archive/2011/01/13/connecting-to-report-server.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator 10 hours 42 minutes ago

Thanks for the suggestion.  I uninstalled existing version and downloaded and installed Report Builder 3 for SQL Server 2014. Unfortunately I'm having the same problem.

The wizard setup looks a little different but leads to the same bad, no sql server identified place.

Whenever I try to 'Build' the connection string I get this:

Note it says its for sql svr 2000 or 2005.  The Azure selection has the same note.  I clicked on the Sql Svr Analysis Server selection and it, too is blank.

Regards,

Minuend

Hi

Your heading in the right direction, in the text block that says server name, put int he value HP_1\MSSQLSERVERDEV

This is the instance name of you database server. The data source would be SQL server. 

Hi Minuend, 

According to your description, when creating data source, you cannot see the servername, right?

 
In Report Builder, when creating data source, we can select the servername to connect the local database or remote database. In your scenario, if the computer is not in the domain, you cannot see other doamin users servername. For you reqirement, you want to connect the local database, you can type . or localhost in the serveranme text box, and then select the database which you want to connect.

 

If you have any other question, please feel free to ask. 

Regards, 
Shrek Li