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: Thursday, December 18, 2014 9:18 AM
Points: 832, Visits: 1,485
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: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
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, December 9, 2014 1:13 PM
Points: 85, Visits: 524
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: Thursday, December 18, 2014 9:18 AM
Points: 832, Visits: 1,485
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: Thursday, December 18, 2014 9:18 AM
Points: 832, Visits: 1,485
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: Tuesday, August 19, 2014 6:53 PM
Points: 1,932, Visits: 1,589
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

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T)
*** Open Network for Database Professionals ***

LinkedIn: 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: Thursday, December 18, 2014 9:18 AM
Points: 832, Visits: 1,485
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: Thursday, December 18, 2014 9:18 AM
Points: 832, Visits: 1,485
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: Tuesday, August 19, 2014 6:53 PM
Points: 1,932, Visits: 1,589
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

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T)
*** Open Network for Database Professionals ***

LinkedIn: 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: Thursday, December 18, 2014 9:18 AM
Points: 832, Visits: 1,485
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