Solved

SQL 2014 Express and report builder

Posted on 2016-10-04
31
39 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 19
  • 7
  • 4
  • +1
31 Comments
 
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41829027
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
ID: 41829030
I installed them, they are there.
0
 
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41829033
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

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

Author Comment

by:JohnMac328
ID: 41829066
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 28

Expert Comment

by:Pawan Kumar
ID: 41829068
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
ID: 41829083
The restore command only sees .bak,trn, or log - how do I get it to take a mdf file to restore ?
0
 
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41829093
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
ID: 41829104
SQL 2014 express will not see the northwind.bak file from the download link
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 41829384
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 13

Expert Comment

by:Arifhusen Ansari
ID: 41829647
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
ID: 41829878
Something strange with different errors - going to uninstall all and start over
0
 

Author Comment

by:JohnMac328
ID: 41829959
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 50

Expert Comment

by:Vitor Montalvão
ID: 41829971
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
ID: 41829977
Local - using laptop
0
 

Author Comment

by:JohnMac328
ID: 41829978
Also went and got adventure works 2014 sample - same thing
0
 
LVL 50

Expert Comment

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

Author Comment

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

Author Comment

by:JohnMac328
ID: 41830002
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 50

Expert Comment

by:Vitor Montalvão
ID: 41830016
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
ID: 41830028
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 50

Expert Comment

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

Author Comment

by:JohnMac328
ID: 41830050
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 50

Expert Comment

by:Vitor Montalvão
ID: 41830097
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
ID: 41830106
Ok - have a meeting but will be back
0
 

Author Comment

by:JohnMac328
ID: 41830343
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
ID: 41830446
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
ID: 41830567
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 50

Expert Comment

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

Author Comment

by:JohnMac328
ID: 41831511
I appreciate your help.
0
 

Author Closing Comment

by:JohnMac328
ID: 41838093
Figured it out
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Giving  direct access rights to main database  issues 9 59
CASE Statement for unknown # of columns 10 63
Server 2012 r2 and SQL 2014 6 30
Create a Calendar table 29 37
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

740 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