Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

SPS 2003 installation on SQL Server 2005 express

Asked By: Nicholas Scott Date: Aug 31, 2006 Category: Sharepoint Views: 729

I have tried this installation several times, and still end up with the same results. Whenever I create a new portal, the creation fails at about 52% complete. Is there a difference in configuration between SQL 2000 and SQL 2005? When I use SQL 2000 I have no problems, and I believe I am missing a detail somewhere. Below is the portion of the creation log where the install fails.

11:58:09 cmd.CommandText set as: Update dbo.orgle_errormsg set LocalizedMsg =

N'User' where ErrorID='-1' Update dbo.orgle_errormsg set LocalizedMsg = N'Target

Audiences' where ErrorID='-2' Update dbo.orgle_errormsg set LocalizedMsg =

N'Select Audience' where ErrorID='-3' Update dbo.orgle_errormsg set LocalizedMsg

= N'Select' where ErrorID='-4' Update dbo.orgle_errormsg set LocalizedMsg =

N'Compilation failed to start due to an error connecting to the database. Please

check the AudienceJob log file for details.' where ErrorID='1' Update

dbo.orgle_errormsg set LocalizedMsg = N'The audience cannot be compiled while

user profiles are being imported from Active Directory directory service. Wait

until the import process completes and then try again.' where ErrorID='2' Update

dbo.orgle_errormsg set LocalizedMsg = N'The audience cannot be compiled while

another job in progress.' where ErrorID='3' Update dbo.orgle_errormsg set

LocalizedMsg = N'Compilation has finished successfully, but the ending status

has not been properly set. If you need to rerun audience compilation, stop the

current process before you rerun.' where ErrorID='4' Update dbo.orgle_errormsg

set LocalizedMsg = N'Unable to cancel audience compilation. Retry canceling the

compilation.' where ErrorID='5' Update dbo.orgle_errormsg set LocalizedMsg =

N'An error occurred while attempting to update audience membership. Check the

AudienceJob log file for details.' where ErrorID='6' Update dbo.orgle_errormsg

set LocalizedMsg = N'An error occurred while attempting to update audience

membership. Error in rule:' where ErrorID='7' Update dbo.orgle_errormsg set

LocalizedMsg = N'Membership in this audience has been successfully updated. An

error occurred while trying to update the job status flag.' where ErrorID='8'

Update dbo.orgle_errormsg set LocalizedMsg = N'An error occurred while

attempting to update audience membership. Unable to retrieve group membership

from Active Directory directory service for this group:' where ErrorID='9'

11:58:09 Start- sqlConnection.ExecuteNonQuery(cmd= Update dbo.orgle_errormsg set

LocalizedMsg = N'User' where ErrorID='-1' Update dbo.orgle_errormsg set

LocalizedMsg = N'Target Audiences' where ErrorID='-2' Update dbo.orgle_errormsg

set LocalizedMsg = N'Select Audience' where ErrorID='-3' Update

dbo.orgle_errormsg set LocalizedMsg = N'Select' where ErrorID='-4' Update

dbo.orgle_errormsg set LocalizedMsg = N'Compilation failed to start due to an

error connecting to the database. Please check the AudienceJob log file for

details.' where ErrorID='1' Update dbo.orgle_errormsg set LocalizedMsg = N'The

audience cannot be compiled while user profiles are being imported from Active

Directory directory service. Wait until the import process completes and then

try again.' where ErrorID='2' Update dbo.orgle_errormsg set LocalizedMsg = N'The

audience cannot be compiled while another job in progress.' where ErrorID='3'

Update dbo.orgle_errormsg set LocalizedMsg = N'Compilation has finished

successfully, but the ending status has not been properly set. If you need to

rerun audience compilation, stop the current process before you rerun.' where

ErrorID='4' Update dbo.orgle_errormsg set LocalizedMsg = N'Unable to cancel

audience compilation. Retry canceling the compilation.' where ErrorID='5' Update

dbo.orgle_errormsg set LocalizedMsg = N'An error occurred while attempting to

update audience membership. Check the AudienceJob log file for details.' where

ErrorID='6' Update dbo.orgle_errormsg set LocalizedMsg = N'An error occurred

while attempting to update audience membership. Error in rule:' where

ErrorID='7' Update dbo.orgle_errormsg set LocalizedMsg = N'Membership in this

audience has been successfully updated. An error occurred while trying to update

the job status flag.' where ErrorID='8' Update dbo.orgle_errormsg set

LocalizedMsg = N'An error occurred while attempting to update audience

membership. Unable to retrieve group membership from Active Directory directory

service for this group:' where ErrorID='9' )

11:58:09 End- sqlConnection.ExecuteNonQuery(cmd= Update dbo.orgle_errormsg set

LocalizedMsg = N'User' where ErrorID='-1' Update dbo.orgle_errormsg set

LocalizedMsg = N'Target Audiences' where ErrorID='-2' Update dbo.orgle_errormsg

set LocalizedMsg = N'Select Audience' where ErrorID='-3' Update

dbo.orgle_errormsg set LocalizedMsg = N'Select' where ErrorID='-4' Update

dbo.orgle_errormsg set LocalizedMsg = N'Compilation failed to start due to an

error connecting to the database. Please check the AudienceJob log file for

details.' where ErrorID='1' Update dbo.orgle_errormsg set LocalizedMsg = N'The

audience cannot be compiled while user profiles are being imported from Active

Directory directory service. Wait until the import process completes and then

try again.' where ErrorID='2' Update dbo.orgle_errormsg set LocalizedMsg = N'The

audience cannot be compiled while another job in progress.' where ErrorID='3'

Update dbo.orgle_errormsg set LocalizedMsg = N'Compilation has finished

successfully, but the ending status has not been properly set. If you need to

rerun audience compilation, stop the current process before you rerun.' where

ErrorID='4' Update dbo.orgle_errormsg set LocalizedMsg = N'Unable to cancel

audience compilation. Retry canceling the compilation.' where ErrorID='5' Update

dbo.orgle_errormsg set LocalizedMsg = N'An error occurred while attempting to

update audience membership. Check the AudienceJob log file for details.' where

ErrorID='6' Update dbo.orgle_errormsg set LocalizedMsg = N'An error occurred

while attempting to update audience membership. Error in rule:' where

ErrorID='7' Update dbo.orgle_errormsg set LocalizedMsg = N'Membership in this

audience has been successfully updated. An error occurred while trying to update

the job status flag.' where ErrorID='8' Update dbo.orgle_errormsg set

LocalizedMsg = N'An error occurred while attempting to update audience

membership. Unable to retrieve group membership from Active Directory directory

service for this group:' where ErrorID='9' )

11:58:09 Exit UserProfileLocalizationInstaller.Install

Tagged:sps 2003 installation on sql server 2005 express

7 Answers Found

Answer #1 Answered By: Shara Johnson Answered On: Aug 31, 2006

SQL Server 2005 or SQL Express? Your subject said Express, but inline you only said SQL 2005.

I don’t think you’ll be able to use SQL Express with SPS 2003.

Answer #2 Answered By: Christop Mcfadden Answered On: Aug 31, 2006

Sorry, it’s SQL 2005 Express...................

Answer #3 Answered By: Cassidy Sharpe Answered On: Aug 31, 2006

I’m 90% sure that you can’t use SQL Express for SPS 2003… only SQL 2005 (and only if you have SPS2003 SP2 installed).

Answer #4 Answered By: Damon Garner Answered On: Aug 31, 2006

You were 100% correct. I switched to SQL 2000 with SP3a, and no problems. I will try using SQL 2005 another time, but will save that for a rainy day.

Answer #5 Answered By: Hans Weiss Answered On: Aug 31, 2006

I did this about two months ago for a project that needed SQL Server
2005 for its improved BI capabilities, but was also going to use
SharePoint 2003. Rather than have two separate database installations
(2005 for BI and a separate 2000 SP3a just for SharePoint), I found a
document online that walks through a somewhat odd procedure:
http://support.microsoft.com/kb/917446 .

Basically, you have to install SPS 2003 but, in the middle of the
installation process, before you allow the creation of a content
database, you have to stop, install Service Pack 2 for both WSS and
SPS (in that order), and then continue with the installation.

Evidently, if you don't install the Service Packs in time you'll fail
when creating the content database.

For what it's worth, I haven't had any problems so far with using the
same SQL Server 2005 installation for both SharePoint content
databases and Analysis Services/Reporting Services. The two are
unrelated, so I wouldn't expect problems, but you never know until you
try.

I was surprised to find the BI tools relatively easy to pick up (I
admit I did have an excellent consultant helping me), although the the
Reporting Services Web Parts weren't very good. It seems that Report
View Web Part just loads a report page into a Page View Web Part. I
could never get the graphs in a report rendered in a usable way.

Answer #6 Answered By: Alison West Answered On: Aug 31, 2006

There’s nothing wrong with using SQL Server 2005… but remember there are two very distinct products:

- SQL Server 2005

- SQL Express 2005

The former is the next version of SQL Server 2000. The latter is the next version (kinda… don’t jump on my back everyone, just saying conceptually) of MSDE. Your initial post said you were using Express in the subject line, but the body of the question wasn’t specific to the flavor. I’m just assuming you are still trying to use Express, and that is what I’m saying it’s supported.

WSS v2 SP2 and SPS 2003 SP2 will DEINFATELY work with SQL Server 2005 (that’s one of the big things SP2 brought us), I just don’t think they will work with SQL Express 2005.

Answer #7 Answered By: Freddy Heath Answered On: Aug 31, 2006

Last night I installed SPS2003 sp2, and then installed SQL Server 2005. No problems with SQL 2005, and the creation of the portal.

Didn't find what you were looking for? Find more on SPS 2003 installation on SQL Server 2005 express Or get search suggestion and latest updates.