Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

AdventureWorksDW2008R2 Expand / Collapse
Author
Message
Posted Wednesday, October 19, 2011 12:50 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, January 21, 2015 9:03 AM
Points: 845, Visits: 1,496
Please do not laugh at me because this question might seem to be dumb to anyone:

I downloaded AdventureWorksDW2008R2 installation executable and ran it on SQL 2008 server, however, after that, I don't see the database appears in SQL Server Management Studio 2008R2.

Where did it go?

Thank you.
Post #1193148
Posted Wednesday, October 19, 2011 1:29 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 9, 2015 7:11 PM
Points: 2,808, Visits: 7,192
try rerfreshing the view..

and check that are you connected to the same sever\instance that you installed it to
Post #1193188
Posted Wednesday, October 19, 2011 2:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 31, 2015 10:56 AM
Points: 85, Visits: 534
I suspect you are connecting to the right instance that you have installed AdventureWorks DB on? Did the executable gave any errors while installing
Post #1193218
Posted Wednesday, October 19, 2011 2:20 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, January 21, 2015 9:03 AM
Points: 845, Visits: 1,496
I just did it again: this time I noticed the problem might be because the "installation instance" is empty when I installed it. Why it is empty? and I can't see any instance in the dropdownlist. Is it because the original installer (a co-op student with little experience) didn't install any instance? how do I correct this?

Thank you.


PS. This is funny, how come there was no any warning during my "successful" installation of this database?
Post #1193219
Posted Wednesday, October 19, 2011 2:23 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, January 21, 2015 9:03 AM
Points: 845, Visits: 1,496
And Management Studio does see a localhost and all the system databases! So the instance does exist.
Post #1193221
Posted Thursday, October 20, 2011 2:50 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 29, 2015 11:06 AM
Points: 1,932, Visits: 1,595
I just did it again: this time I noticed the problem might be because the "installation instance" is empty when I installed it.


Would you mind doing this exercise once again? But make sure you enter 'localhost' as installation instance. Let us know if you still face any issues.


Dev

*** Open Network for Database Professionals ***
http://www.linkedin.com/in/devendrashirbad
Post #1193431
Posted Thursday, October 20, 2011 7:27 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, January 21, 2015 9:03 AM
Points: 845, Visits: 1,496
Actually in the instance dropdownlist, it doesn't allow me to manually type in anything.
Post #1193667
Posted Thursday, October 20, 2011 9:29 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, January 21, 2015 9:03 AM
Points: 845, Visits: 1,496
I found mdf file for the sample database, however I failed with this:


TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:


Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridControl)

------------------------------
BUTTONS:

OK
------------------------------
Post #1193845
Posted Thursday, October 20, 2011 9:43 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 29, 2015 11:06 AM
Points: 1,932, Visits: 1,595
You might have missed some important steps. Please verify it once.

Installing SQL Server 2008R2 Sample Databases
http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20SQL%20Server%202008R2%20Databases


Dev

*** Open Network for Database Professionals ***
http://www.linkedin.com/in/devendrashirbad
Post #1193859
Posted Thursday, October 20, 2011 11:31 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, January 21, 2015 9:03 AM
Points: 845, Visits: 1,496
Cause identified! It turned out that I was missing some privileges in the server, I can't create database! That's why although I installed it, it was actually never been installed - Microsoft should give some warning before the installation takes place.

Thanks for discussing.
Post #1193923
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse