ok i give up - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

ok i give up

Author

Topic

bbxrider
Starting Member

37 Posts

Posted - 2009-06-21 : 18:46:01

downloaded the sqlserver 8.0 trial pkg, and have spent hours installing, reading, googling, but evidently its not installed or i'm missing something real basic here. please see end of post for the summary.txt log, which appears to show a successful install.

there are services running for the hp (HPWJA) and visual studio express (SQLEXPRESS) instances but no service for 8.0?

i also tried to install the MS 2008 Management Studio Express, but that just brought up sql installation center, the same as from the pkg install, but there was nothing additional for the mgt pkg, so that evidently went nowhere.

summary.txt log file (partial)
Overall summary:
Final result: Passed
Exit code (Decimal): 0
Exit message: Passed
Start time: 2009-06-21 12:44:12
End time: 2009-06-21 12:44:44
Requested action: RunDiscovery

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2005 HPWJA MSSQL.1 Database Engine Services 1033 Express Edition 9.3.4035 No
Sql Server 2005 HPWJA MSSQL.1 SQL Server Replication 1033 Express Edition 9.3.4035 No
Sql Server 2005 HPWJA MSSQL.1 SharedTools 1033 Express Edition 9.3.4035 No
Sql Server 2005 SQLEXPRESS MSSQL.2 Database Engine Services 1033 Express Edition 9.3.4035 No
Sql Server 2005 SQLEXPRESS MSSQL.2 SQL Server Replication 1033 Express Edition 9.3.4035 No
Sql Server 2005 SQLEXPRESS MSSQL.2 SharedTools 1033 Express Edition 9.3.4035 No
Sql Server 2005 Tools 1033 Express Edition 9.3.4035 No
Sql Server 2005 ToolsClient 1033 Express Edition 9.3.4035 No
Sql Server 2005 ToolsClient\Connectivity 1033 Express Edition 9.3.4035 No
Sql Server 2008 Client Tools Connectivity 1033 10.0.1600.22 No
Sql Server 2008 Client Tools SDK 1033 10.0.1600.22 No

Package properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0
Installation location: F:\x86\setup Installation edition: EVAL

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-22 : 03:04:14

1. SQL Server 2005 is version 9.0
2. SQL Server 2008 is version 10.0
3. SQL Server 2000 is version 8.0

It seems you are using SQL Server 2005.

Which operating system are you using? If using Vista or later, you need to elevate your current account to be administrator for SQL Server.
This was automatically done with Windows XP and earlier but since Vista this has to be done manually.
Also, not all editions of SQL Server installs on a desktop operating system. Developer Edition does.
Which edition are you trying to install?

If you are trying to install Express, and you already have an instance of Express install through Visual Studio, try to rename your new installation instance to another name than "SQLEXPRESS" since that name alrady is taken.
This is true for all version 8.0, 9.0 and 10.0.

E 12°55'05.63"
N 56°04'39.26"

bbxrider
Starting Member

37 Posts

Posted - 2009-06-23 : 13:07:00

i want to install a version that allows filestream. i need that for an asp application i'm writing. i have a 32bit platform. i'm running xp pro and i do all this work from an adm acct.
other posts say that only 64bit sqlexpress will support filestream and as long as server 2005 is installed, filestream won't be available.
seems i'm stuck for a while with the server 2000, it was installed by hp for a jetdirect 300x print server. the 2005 was installed by my visual studio 2005 for the dev environment.
i was trying install the enterprise version, so looks like another 3gb download for the developer version.
my current thinking is to uninstall server 2005 and sqlexpress, and then install a single an instance of 2008, hopefully with filestream, leave the (hp) server 2000 and hope it won't interfere with the 2008 filestream objective.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-23 : 13:51:28

Filestream was introduced with SQL Server 2008.

E 12°55'05.63"
N 56°04'39.26"

bbxrider
Starting Member

37 Posts

Posted - 2009-06-23 : 14:16:51

well that is one the few things that is clear and easy about filestream.

my problem/questions is about the details, if you have any suggestions about installing, i would appreciate that
my current situation can be seen at http://img413.imageshack.us/img413/4843/2008discoveryrpt.jpg

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources