October 19, 2011 at 12:50 pm
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.
October 19, 2011 at 1:29 pm
try rerfreshing the view..
and check that are you connected to the same sever\instance that you installed it to
October 19, 2011 at 2:16 pm
I suspect you are connecting to the right instance that you have installed AdventureWorks DB on? Did the executable gave any errors while installing
October 19, 2011 at 2:20 pm
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?
October 19, 2011 at 2:23 pm
And Management Studio does see a localhost and all the system databases! So the instance does exist.
October 20, 2011 at 2:50 am
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.
October 20, 2011 at 7:27 am
Actually in the instance dropdownlist, it doesn't allow me to manually type in anything.
October 20, 2011 at 9:29 am
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
------------------------------
October 20, 2011 at 9:43 am
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
October 20, 2011 at 11:31 am
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.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply