troubleshooting Question

Problem INstalling AdventureWorks Sample database for Visual Studio 2005 and SQL Server 2005 Express for ItemFinder full-text search solution

Avatar of globalvalues
globalvalues asked on
.NET ProgrammingMicrosoft SQL Server 2005Windows Vista
7 Comments1 Solution429 ViewsLast Modified:
I am trying to install the AdventureWorks sample database for SQL Server 2005 Express so that I can use the ItemFinder sample solution in Visual Studio 2005 Professional as a guide for developing full-text searches for web applications.  I am running on Vista.  I cannot execute the install.sql query for ItemFinder, without receiving the following errors:

Msg 911, Level 16, State 1, Line 25
Could not locate entry in sysdatabases for database 'AdventureWorks'. No entry found with that name. Make sure that the name is entered correctly.
Msg 7609, Level 17, State 100, Line 7
Full-Text Search is not installed, or a full-text component cannot be loaded.
Msg 7609, Level 17, State 100, Line 1
Full-Text Search is not installed, or a full-text component cannot be loaded.
Msg 7609, Level 17, State 100, Line 1
Full-Text Search is not installed, or a full-text component cannot be loaded.
Msg 208, Level 16, State 49, Line 7
Invalid object name 'HumanResources.JobCandidate'.
Msg 208, Level 16, State 49, Line 1
Invalid object name 'Production.ProductModel'.
Msg 208, Level 16, State 49, Line 1
Invalid object name 'Production.Document'.
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'transform noise words' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'precompute rank' changed from 1 to 1. Run the RECONFIGURE statement to install.
Msg 2714, Level 16, State 3, Procedure usp_SearchResumes, Line 25
There is already an object named 'usp_SearchResumes' in the database.
Msg 2714, Level 16, State 3, Procedure usp_SearchProducts, Line 17
There is already an object named 'usp_SearchProducts' in the database.
Msg 2714, Level 16, State 3, Procedure usp_SearchDocuments, Line 17
There is already an object named 'usp_SearchDocuments' in the database.
Msg 2714, Level 16, State 3, Procedure usp_AddDocument, Line 16
There is already an object named 'usp_AddDocument' in the database.

I cannot figure out what I'm doing wrong.

Any help would be greatly appreciated.

Thanks, Bill
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros