Solved

SQL 2014 Express and report builder

Posted on 2016-10-04
31
23 Views
Last Modified: 2016-10-11
I have a new install of SQL 2014 Express and report builder for 2014.  When I create the data connection in report builder the only databases I can select are under the system databases even though I have Northwind and Pubs etc.  Why won't Northwind show up when I have that as the default database under my login?

Thanks,
John
0
Comment
Question by:JohnMac328
  • 19
  • 7
  • 4
  • +1
31 Comments
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
This is because these databases are not installed by default. One has to manually download and set these ones.

The location from which we can download these DBs is - https://www.microsoft.com/en-us/download/details.aspx?id=23654

I hope it helps. ! Enjoy
0
 

Author Comment

by:JohnMac328
Comment Utility
I installed them, they are there.
0
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
Ohh okies, What access you have on the DB Server ? Do you have access on these databases / Also note that these are very old DB ( SQL 2000 ) so may be some compatibility..
0
 

Author Comment

by:JohnMac328
Comment Utility
I DL the script that creates them.  I also have full privileges on the databases.
0
 

Author Comment

by:JohnMac328
Comment Utility
ok even though I created northwind with a script and they are in the database list, the only ones that show up in report builder are the ones that have a mdf and ldf in the data folder under SQL.  Like model.mdf and modellog.ldf - Can I export the northwind to create the mdf and ldf files?
0
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
Please download Northwind from below URL and restore it on your server. It will have mdf and ldf.

https://northwinddatabase.codeplex.com/releases/view/71634

Enjoy ! Please let me know if you face any issues.
0
 

Author Comment

by:JohnMac328
Comment Utility
The restore command only sees .bak,trn, or log - how do I get it to take a mdf file to restore ?
0
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
Hi John,

Once you restore the .bak file , it will Northwind database for you with mdf file and ldf file.

Please try it out. It will take 1-2 minutes. :)
0
 

Author Comment

by:JohnMac328
Comment Utility
SQL 2014 express will not see the northwind.bak file from the download link
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
It's possible that you have another SQL Server instance in the machine and you by mistake created the databases there instead of the correct SQL Server instance?
0
 
LVL 12

Expert Comment

by:Arifhusen Ansari
Comment Utility
If every thing is perfect. Like you have restore all the databases. Database you have restored are on the correct instance and also you were trying to connect the correct one.

Please try to connect the Server instance using sql server authentication .

May be the account you are using to connect the server do not have access to those database.
You try login with sql authentication "sa".

If after connecting with "sa" you can see the database. you have to set the user mapping for your credential. you might be using windows credentials

2016-10-05_16-06-41.png
Hope it will help
0
 

Author Comment

by:JohnMac328
Comment Utility
Something strange with different errors - going to uninstall all and start over
0
 

Author Comment

by:JohnMac328
Comment Utility
Did a complete uninstall/reinstall - only one instance running.  Open mgnt studio and select restore - browse to the location of the .bak file and it does not see it.  I double click the file and it does not allow me to associate with sql 2014.  Running win 10 64bit - I can create db from script but this tells me things are not right
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
Open mgnt studio and select restore - browse to the location of the .bak file and it does not see it.
It can only see from local disk. Is the file in a local disk? If not you need map a drive to the network location or run it manually in a query window by typing the RESTORE command:
RESTORE DATABASE Northwind
FROM DISK = '\\NetworkShareName\Northwind.bak'

Open in new window

0
 

Author Comment

by:JohnMac328
Comment Utility
Local - using laptop
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:JohnMac328
Comment Utility
Also went and got adventure works 2014 sample - same thing
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
Did you try the RESTORE command? You just need to provide the correct path in the above example.
0
 

Author Comment

by:JohnMac328
Comment Utility
I double click on the bak file I get thisscreen
I choose ok and it just keeps popping up
0
 

Author Comment

by:JohnMac328
Comment Utility
Yes I tried the restore command - it does not "see" the .bak file - it does not appear in the window to select it
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
double click on the bak file I get this
This is SQL Server. Only thing that works with the double-click are script files (.sql), trace files (.trc) and query plan files (.sqlplan). All the rest don't work.

Yes I tried the restore command - it does not "see" the .bak file - it does not appear in the window to select it
When trying SQL commands there are no windows to pop up. It's like working with command line no results are all throwing back to the screen. What's you experience with SQL Server and it's GUI?
0
 

Author Comment

by:JohnMac328
Comment Utility
When you use the GUI and choose restore, you then navigate to the area where the bak file is and you then select it correct?  I can't select it because it does not appear.  8 years experience by the way
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
So you're able to run queries, right?
What the RESTORE command returns?
0
 

Author Comment

by:JohnMac328
Comment Utility
Yes but something more is wrong when it will not see the bak file - also adding that to all the other issues I have been having.  I should just go back to 2008
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
Since I don't have access to your machine the only way I can help you is if you post the following screenshots:
  1. Bak files and respective location in your computer
  2. Restore from SSMS with the bak files not listed
  3. Restore command from query window with the respective error message
0
 

Author Comment

by:JohnMac328
Comment Utility
Ok - have a meeting but will be back
0
 

Author Comment

by:JohnMac328
Comment Utility
From what I can see I should have rights to run this - I am logged in as sa

Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\Users\johnm\Northwind.BAK'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
0
 

Author Comment

by:JohnMac328
Comment Utility
I decided to create northwind from a script since report builder is my problem - when I try to select the database from report builder connection this is what shows for the databases

screen2
Does not matter if I use windows auth or sa login
0
 

Accepted Solution

by:
JohnMac328 earned 0 total points
Comment Utility
Ok this can be closed - forgot to open up port 1433 and set browsing to automatic - after those changes were made the connection worked.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
Good.
You can close this question by choosing your last comment as solution.
0
 

Author Comment

by:JohnMac328
Comment Utility
I appreciate your help.
0
 

Author Closing Comment

by:JohnMac328
Comment Utility
Figured it out
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now