Hi All,
hope there is someone, out there, that is able to give me some
assistance and expertise......
i've successfully installed wss 3.0 and then run the sharepoint
products and technologies configuration wizard.
o/s SBS 2003 prem (with all service packs and security updates insitu)
I'm tring to upgrade wss version 2 (service packed) to wss v 3.0 beta 2
without success.
"Failed to initate the upgrade sequence. An exception of type
System.Data.SqlClient.SqlException was thrown. Additional exception
information: Directory lookup for the file "C:\Program Files\Microsoft
SQL Server\MSSQL$SHAREPOINT\Data\STS_jca1_4.mdf
failed with the operating system error
5(error not found)."
i have an excerpt from the error log:
08/15/2006 06:33:08 5 INF Leaving function
GetConfigConnectionString
08/15/2006 06:33:08 5 INF The old partial config
connection string is:
Provider=SQLOLEDB;Server=JCA1\SharePoint;Database=STS_Config;User
Id=;Password=
08/15/2006 06:33:08 5 INF The old instance name is:
SharePoint
08/15/2006 06:33:08 5 INF The new partial config
connection string is:
Provider=SQLOLEDB;Server=JCA1\MICROSOFT##SSEE;Database=STS_Config;User
Id=;Password=
08/15/2006 06:33:08 5 INF Entering function
ConfigDbConnectionString
08/15/2006 06:33:08 5 INF The old config
connection string is: Data Source=JCA1\SharePoint;Initial
Catalog=STS_Config;Integrated Security=True;Pooling=False
08/15/2006 06:33:08 5 INF Entering function
ConfigDbConnectionString
08/15/2006 06:33:08 5 INF The new config
connection string is: Data
Source=\\.\pipe\MSSQL$Microsoft##SSEE\sql\query;Initial
Catalog=STS_Config;Integrated Security=True;Pooling=False
08/15/2006 06:33:08 5 INF The configuration
database name is: STS_Config
08/15/2006 06:33:08 5 INF Entering function
GetMigrationDatabasesList
08/15/2006 06:33:09 5 INF Database STS_jca1_4
should be moved.
08/15/2006 06:33:09 5 INF Configuration
Database STS_Config should be moved.
08/15/2006 06:33:09 5 INF Entering function
GetFilesList
08/15/2006 06:33:09 5 INF File C:\Program
Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_jca1_4.mdf
is associated with Database
STS_jca1_4.
08/15/2006 06:33:09 5 INF File C:\Program
Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_jca1_4_log.LDF
is associated with Database
STS_jca1_4.
08/15/2006 06:33:09 5 INF Leaving function
GetFilesList
08/15/2006 06:33:09 5 INF Entering function
GetFilesList
08/15/2006 06:33:09 5 INF File C:\Program
Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_Config.mdf
is associated with Database
STS_Config.
08/15/2006 06:33:09 5 INF File C:\Program
Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_Config_log.LDF
is associated with Database
STS_Config.
08/15/2006 06:33:09 5 INF Leaving function
GetFilesList
08/15/2006 06:33:09 5 INF Leaving function
GetMigrationDatabasesList
08/15/2006 06:33:09 5 INF Entering function
ResetSqlService
08/15/2006 06:33:09 5 INF Entering function
ServiceHelper.Stop
08/15/2006 06:33:09 5 INF Trying to stop
service mssql$SharePoint and waiting 120 sec to do so
08/15/2006 06:33:09 5 INF service
mssql$SharePoint is Running, so will stop it
08/15/2006 06:33:09 5 INF stopping service
mssql$SharePoint (it may already be stopped)
08/15/2006 06:33:11 5 INF Leaving function
ServiceHelper.Stop
08/15/2006 06:33:11 5 INF Entering function
ServiceHelper.Start
08/15/2006 06:33:11 5 INF Trying to start
service mssql$SharePoint and waiting 120 sec to do so
08/15/2006 06:33:11 5 INF service
mssql$SharePoint is Stopped, will try to start it
08/15/2006 06:33:12 5 INF starting service
mssql$SharePoint (it may already be started)
08/15/2006 06:33:15 5 INF Leaving function
ServiceHelper.Start
08/15/2006 06:33:15 5 INF Leaving function
ResetSqlService
08/15/2006 06:33:15 5 INF Entering function
ResetW3wpService
08/15/2006 06:33:15 5 INF Entering function
ServiceHelper.Stop
08/15/2006 06:33:15 5 INF Trying to stop
service w3svc and waiting 120 sec to do so
08/15/2006 06:33:15 5 INF service w3svc is
Running, so will stop it
08/15/2006 06:33:15 5 INF stopping service
w3svc (it may already be stopped)
08/15/2006 06:33:17 5 INF Leaving function
ServiceHelper.Stop
08/15/2006 06:33:17 5 INF Entering function
ServiceHelper.Start
08/15/2006 06:33:17 5 INF Trying to start
service w3svc and waiting 120 sec to do so
08/15/2006 06:33:17 5 INF service w3svc is
Stopped, will try to start it
08/15/2006 06:33:17 5 INF starting service
w3svc (it may already be started)
08/15/2006 06:33:18 5 INF Leaving function
ServiceHelper.Start
08/15/2006 06:33:18 5 INF Leaving function
ResetW3wpService
08/15/2006 06:33:18 5 INF Starting WYukon
service
08/15/2006 06:33:18 5 INF Entering function
ServiceHelper.Start
08/15/2006 06:33:18 5 INF Trying to start
service MSSQL$MICROSOFT##SSEE and waiting 120 sec to do so
08/15/2006 06:33:18 5 INF service
MSSQL$MICROSOFT##SSEE is Running, nothing to do
08/15/2006 06:33:18 5 INF starting service
MSSQL$MICROSOFT##SSEE (it may already be started)
08/15/2006 06:33:18 5 INF Leaving function
ServiceHelper.Start
08/15/2006 06:33:18 5 INF Entering function
DetachDatabases
08/15/2006 06:33:18 5 INF Entering function
OfflineDatabase STS_jca1_4.
08/15/2006 06:33:18 5 INF Leaving function
OfflineDatabase STS_jca1_4.
08/15/2006 06:33:18 5 INF Entering function
DetachDatabase STS_jca1_4.
08/15/2006 06:33:18 5 INF Successfully
detach database STS_jca1_4.
08/15/2006 06:33:18 5 INF Leaving function
DetachDatabase STS_jca1_4.
08/15/2006 06:33:18 5 INF Entering function
OfflineDatabase STS_Config.
08/15/2006 06:33:18 5 INF Leaving function
OfflineDatabase STS_Config.
08/15/2006 06:33:18 5 INF Entering function
DetachDatabase STS_Config.
08/15/2006 06:33:18 5 INF Successfully
detach database STS_Config.
08/15/2006 06:33:18 5 INF Leaving function
DetachDatabase STS_Config.
08/15/2006 06:33:18 5 INF Leaving function
DetachDatabases
08/15/2006 06:33:18 5 INF Entering function
AttachDatabases
08/15/2006 06:33:18 5 INF Entering function
AttachDatabase STS_jca1_4
08/15/2006 06:33:19 5 INF Entering function
Fixing ACL on C:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_jca1_4.mdf
08/15/2006 06:33:19 5 INF Leaving function
Fixing ACL on C:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_jca1_4.mdf
, with ret code = True
08/15/2006 06:33:19 5 INF Entering function
Fixing ACL on C:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_jca1_4_log.LDF
08/15/2006 06:33:19 5 INF Leaving function
Fixing ACL on C:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_jca1_4_log.LDF
, with ret code = True
08/15/2006 06:33:19 5 ERR Fail to attach
database STS_jca1_4, with exception System.Data.SqlClient.SqlException:
Directory lookup for the file "C:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_jca1_4.mdf
" failed with the operating system error 5(error not found).
at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result)
at
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.SharePoint.PostSetupConfiguration.UpgradeBootstrapTask.AttachDatabase(SqlConnectionStringBuilder
scsb, String database, ArrayList files)
08/15/2006 06:33:19 5 ERR Task
upgradebootstrap has failed with an unknown exception
08/15/2006 06:33:19 5 ERR Exception:
System.Data.SqlClient.SqlException: Directory lookup for the file
"C:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_jca1_4.mdf
" failed with the operating system error 5(error not found).
at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result)
at
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.SharePoint.PostSetupConfiguration.UpgradeBootstrapTask.AttachDatabase(SqlConnectionStringBuilder
scsb, String database, ArrayList files)
at
Microsoft.SharePoint.PostSetupConfiguration.UpgradeBootstrapTask.AttachDatabases(SqlConnectionStringBuilder
scsb, ArrayList databases, ArrayList databaseFiles)
at
Microsoft.SharePoint.PostSetupConfiguration.UpgradeBootstrapTask.UpgradeWmsdeToWyukon()
at
Microsoft.SharePoint.PostSetupConfiguration.UpgradeBootstrapTask.Run()
at
Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask().
I'm stumped - any assistance will be appreciated.
With regards,
Alchemy