Missing person.person table when installing 2008 r2 sample database ?

Question

Hi, I didn't verify in details but it seems that person.person table in AdventureWorks from codeplex is missing after deployment on sql server 2008 r2 datacenter on windws 7. I have all the features installed. What can be the problem ? I am not familiar with  I have verified that setting around full text search and the analysis service and it all seems to be right.

Answer 1

I think this may be a case of looking in the wrong database.  From Object Explorer, open the Databases folder and examine the list of databases.  Assuming that you chose to install all of the databases available from the installation process, then you will have 2 version of the AdventureWorks OLTP database.  One named AdventureWorks and the other named AdventureWorks2008R2.

The AdventureWorks database is the original database designed for SQL Server 2005 (although it works just fine on instances of SQL Server 2008).  The AdventureWorks2008R2 database contains some schema changes such as a couple of table name changes.  In AdventureWorks2008R2, there is a table named Person.Person.  In the older AdventureWorks database, this table is named Person.Contact.    You can read up on other schema changes in the 2008R2 version here: Details.

Also, be aware that the sample databases use a case-sensitive collation. This means that if the table was created this way "Person.Person", querying against the table using "person.person" will cause an "object not found" error.

Regards,

Gail

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Review this steps

from this site ...

 

http://www.idevelopment.info/data/SQLServer/DBA_tips/Installation/INSTALL_10.shtml

---

cris

Answer 3

Assuming that you chose to install all of the databases available from the installation process, then you will have 2 version of the AdventureWorks OLTP database.  One named AdventureWorks and the other named AdventureWorks2008R2.

The AdventureWorks database is the original database designed for SQL Server 2005 (although it works just fine on instances of SQL Server 2008).  The AdventureWorks2008R2 database contains some schema changes such as a couple of table name changes.  In AdventureWorks2008R2, there is a table named Person.Person.  In the older AdventureWorks database, this table is named Person.Contact.

Regards,

Gail

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no right

The quoted answer given by MR. Gali is the solution. I've tried and it worked for me. Please go ahead as mentioned to work without any problem regarding this.

Thanks,

Sourav

Answer 4

Sorry for opening this old post, but I've found a solution for the common problem of databases/tables missing: FILESTREAM must be enabled when you install the samples. If not, the 2008R2 version of the database will not be installed.

Full post here:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4dca3ee8-ab02-447d-abf9-d0b90d85e605#c2cc1133-cf72-4d4b-8824-74289fb2b680