| Author |
Topic |
|
BlooSky
Starting Member
8 Posts |
 Posted - 2005-12-21 : 19:35:46
|
| I have just installed SQL 2005 and it is up and running but I can't get the AdventureWorks DB to install. I have tried the Setup Install, uninstall, Re-install, uninstall, and install from downloaded .msi versions. All produce the same results. The DB does not appear in the list of DBs in the Management Studio, so I try to attach the DB. I get the following error:"Could not find row in sysindexes for database ID 6, for object 1, index ID 1. Run DBCC CHECKTABLE on sysindexes."Yet when I try to run this command, or a CHECKDB against 'AdventureWorks' I get: "Could not locate entry in sysdatabases for database 'AdventureWorks'.No entry found with that name. Make sure that the name is entered correctly. "It does not seem to know the db is there or let me get to it. How do I get the sample db installed? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-12-21 : 19:43:34
|
| The attach is failing because it is not passing an integrity check, so the files that you have are corrupt. That's my best guess at least. Are you able to download the package again from the MSDN site?Tara Kizeraka tduggan |
 |
|
|
BlooSky
Starting Member
8 Posts |
Posted - 2005-12-21 : 21:24:03
|
| I have tried it multiple ways. From the setup, and 3 or 4 times downloading from MS sites. Always, the same result. I always uninstall fully first, and install fresh. Its hard to believe that the MS files are corrupt, but ... |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-21 : 21:43:48
|
| Does this help ? [url]http://msdn2.microsoft.com/library/ms310325.aspx[/url]-----------------[KH]Learn something new everyday |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-12-22 : 12:27:10
|
quote:
Originally posted by BlooSky
I have tried it multiple ways. From the setup, and 3 or 4 times downloading from MS sites. Always, the same result. I always uninstall fully first, and install fresh. Its hard to believe that the MS files are corrupt, but ...
They might not be corrupt at the download site, but they could be getting corrupt during the download due to network hiccups.Tara Kizeraka tduggan |
|
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2005-12-22 : 13:20:41
|
| Tara's right, sounds like a corrupt file... hooray for MSSelect * from users where clue > 0 |
|
|
|
BlooSky
Starting Member
8 Posts |
Posted - 2005-12-22 : 19:32:09
|
[quote]Originally posted by khtan
Does this help ? [url]http://msdn2.microsoft.com/library/ms310325.aspx[/url]Been there done that. On the sp_attach_db step I get the same error as trying to attach with Studio. |
|
|
|
BlooSky
Starting Member
8 Posts |
Posted - 2005-12-22 : 19:33:19
|
quote:
Originally posted by tkizer
quote:
Originally posted by BlooSky
I have tried it multiple ways. From the setup, and 3 or 4 times downloading from MS sites. Always, the same result. I always uninstall fully first, and install fresh. Its hard to believe that the MS files are corrupt, but ...
They might not be corrupt at the download site, but they could be getting corrupt during the download due to network hiccups.Tara Kizeraka tduggan
I have downloaded many times, and it always comes out exactly the same error. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-12-22 : 19:34:23
|
| I just did this an attached without any problems. I used Mgmt Studio to attach to the MDF file.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
BlooSky
Starting Member
8 Posts |
Posted - 2005-12-22 : 19:35:18
|
quote:
Originally posted by Auric
Tara's right, sounds like a corrupt file... hooray for MSSelect * from users where clue > 0
Hard to believe that the db is corrupt on the MS site. Seems like you would hear more about it. But I installed Pubs and Northwind no problem, so its beginning to look that way. |
|
|
|
BlooSky
Starting Member
8 Posts |
Posted - 2005-12-22 : 21:15:06
|
quote:
Originally posted by graz
I just did this an attached without any problems. I used Mgmt Studio to attach to the MDF file.===============================================Creating tomorrow's legacy systems today.One crisis at a time.
I wish I knew what was different between our systems. I am wondering if Security configuration could have anything to do with it. |
|
|
|
BlooSky
Starting Member
8 Posts |
Posted - 2005-12-23 : 20:54:55
|
| Well, I think I found the solution. There was MSSQL Instance of the machine from and MSDE install for the Veritas Backup program. I uninstalled MSSQL 2005, turned off all the MSSQL services, and Veritas Backup Services, and reinstalled SQL 2005. I also, gave in a Custom Instance name instead of default (to distinguish it from the Backup Instance). Now the AdventureWorks Sample DB comes up and running, and I have no more remote access problems. |
|
|
|
Best
Starting Member
1 Post |
Posted - 2006-01-13 : 03:15:18
|
| Hi!Had the same problem and uninstalling the instance of MSDE and reinstalling/upgrading SQL Server 2005 Works.Thanx |
|
|
|
BlooSky
Starting Member
8 Posts |
Posted - 2006-01-13 : 17:30:04
|
| Yea, that was it. Actually, as a side note, I didn't have to uninstall the MSDE, just turn off everything, and reinstall MS SQL 2005. But glad it worked out for you. |
|
|
|
|
AdventureWorks Won't Install