• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 61
  • Last Modified:

SQL 2014 Express and report builder

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
JohnMac328
Asked:
JohnMac328
  • 19
  • 7
  • 4
  • +1
1 Solution
 
Pawan KumarDatabase ExpertCommented:
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
 
JohnMac328Author Commented:
I installed them, they are there.
0
 
Pawan KumarDatabase ExpertCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
JohnMac328Author Commented:
I DL the script that creates them.  I also have full privileges on the databases.
0
 
JohnMac328Author Commented:
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
 
Pawan KumarDatabase ExpertCommented:
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
 
JohnMac328Author Commented:
The restore command only sees .bak,trn, or log - how do I get it to take a mdf file to restore ?
0
 
Pawan KumarDatabase ExpertCommented:
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
 
JohnMac328Author Commented:
SQL 2014 express will not see the northwind.bak file from the download link
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Arifhusen AnsariBusiness Intelligence AnalystCommented:
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
 
JohnMac328Author Commented:
Something strange with different errors - going to uninstall all and start over
0
 
JohnMac328Author Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
JohnMac328Author Commented:
Local - using laptop
0
 
JohnMac328Author Commented:
Also went and got adventure works 2014 sample - same thing
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you try the RESTORE command? You just need to provide the correct path in the above example.
0
 
JohnMac328Author Commented:
I double click on the bak file I get thisscreen
I choose ok and it just keeps popping up
0
 
JohnMac328Author Commented:
Yes I tried the restore command - it does not "see" the .bak file - it does not appear in the window to select it
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
JohnMac328Author Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
So you're able to run queries, right?
What the RESTORE command returns?
0
 
JohnMac328Author Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
JohnMac328Author Commented:
Ok - have a meeting but will be back
0
 
JohnMac328Author Commented:
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
 
JohnMac328Author Commented:
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
 
JohnMac328Author Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Good.
You can close this question by choosing your last comment as solution.
0
 
JohnMac328Author Commented:
I appreciate your help.
0
 
JohnMac328Author Commented:
Figured it out
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 19
  • 7
  • 4
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now