Install Hub Server in Sql Server 2005

Install Hub Server in Sql Server 2005

  
Hello

I'm trying to install the platform in an sql server 2005 instance. Everything works except when i run the SetupHubState.sql this error occurs:

Msg 15118, Level 16, State 1, Line 1
Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.
Msg 15007, Level 16, State 1, Line 1
'HubState' is not a valid login or you do not have permission.
Msg 15023, Level 16, State 1, Line 1
User, group, or role 'HubSessionStateRole' already exists in the current database.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 80
User or role 'HubState' does not exist in this database.
Msg 15007, Level 16, State 1, Line 1
'HubState' is not a valid login or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the user 'HubState', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the user 'HubState', because it does not exist or you do not have permission.

I open the machine.config of .NET 2.0 platform i can't find an sessionstate element,and when i run the SCInstall.bat this occurs:

Deploying eSpace...
Failed to ping... will continue deploy anyway
Message 1
Id : FailedTenantDeployment_PingAspx
Type : Error
Message : Error publishing in node localhost (127.0.0.1): Tenant deployment
failed
Submitable : True
Details :
Deployment of tenant ServiceCenter failed. Could not invoke ping. Exception: O s
ervidor remoto devolveu um erro: (500) Erro interno de servidor.
at System.Net.HttpWebRequest.CheckFinalStatus()
at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.HttpWebRequest.GetResponse()
at OutSystems.HubEdition.DeployService.Deploy.invokePing(String espaceName, S
tring tenantName, ApplicationServerKind serverKind, Boolean partial, String test
AreaName)Html/Text returned:"Erro de servidor na aplicação '/ServiceCenter'.
Acesso negado ao caminho "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporar
y ASP.NET Files\servicecenter\8902b2ef\ffaf8984". Descrição: Excepção não proces
sada ao executar o pedido Web actual. Consulte o rastreio da pilha para obter ma
is informações sobre o erro e o respectivo ponto de origem no código.

Detalhes da excepção: System.UnauthorizedAccessException: Acesso negado ao cami
nho "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\servic
ecenter\8902b2ef\ffaf8984".

O processo do ASP.NET não está autorizado a aceder ao recurso pedido. Pondere a
hipótese de conceder direitos de acesso ao recurso à identidade do processo do A
SP.NET. O ASP.NET tem uma identidade de processo base (normalmente {MACHINE}\ASP
NET no IIS 5 ou no 'Serviço de rede' no IIS 6) utilizada se a aplicação não esti
ver a representar nenhuma identidade. Se a aplicação estiver a representar algum
a identidade através de <identity impersonate="true"/>, a identidade será o util
izador anónimo (normalmente IUSR_MACHINENAME) ou o utilizador de pedido autentic
ado.

Para conceder ao ASP.NET acesso de escrita para um ficheiro, clique com o botão
direito do rato no ficheiro no 'Explorador', escolha 'Propriedades' e seleccione
o separador 'Segurança'. Clique em 'Adicionar' para adicionar o utilizador ou g
rupo apropriado. Destaque a conta do ASP.NET e seleccione as caixas corresponden
tes ao acesso pretendido.

Erro de origem:

Foi gerada uma excepção não processada durante a execução do pedido Web actual.
As informações relativas à origem e localização da excepção poderão ser identif
icadas através da utilização do rastreio da pilha de excepções abaixo.
Rastreio da pilha:

[UnauthorizedAccessException: Acesso negado ao caminho "C:\WINDOWS\Microsoft.NE
T\Framework\v1.1.4322\Temporary ASP.NET Files\servicecenter\8902b2ef\ffaf8984".]
System.IO.__Error.WinIOError(Int32 errorCode, String str) +363 System.IO.Direct
ory.InternalCreateDirectory(String fullPath, String path) +600 System.IO.Directo
ry.CreateDirectory(String path) +180 System.Web.Compilation.PreservedAssemblyEnt
ry.DoFirstTimeInit(HttpContext context) +85 System.Web.Compilation.PreservedAsse
mblyEntry.EnsureFirstTimeInit(HttpContext context) +97 System.Web.Compilation.Pr
eservedAssemblyEntry.GetPreservedAssemblyEntry(HttpContext context, String virtu
alPath, Boolean fApplicationFile) +29 System.Web.UI.TemplateParser.GetParserCach
eItemFromPreservedCompilation() +91 System.Web.UI.TemplateParser.GetParserCacheI
temInternal(Boolean fCreateIfNotFound) +178 System.Web.UI.TemplateParser.GetPars
erCacheItemWithNewConfigPath() +125 System.Web.UI.TemplateParser.GetParserCacheI
tem() +99 System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String
inputFile, HttpContext context, ApplicationFileParser& parser) +171 System.Web.H
ttpApplicationFactory.CompileApplication(HttpContext context) +43 System.Web.Htt
pApplicationFactory.Init(HttpContext context) +497 System.Web.HttpApplicationFac
tory.GetApplicationInstance(HttpContext context) +170 System.Web.HttpRuntime.Pro
cessRequestInternal(HttpWorkerRequest wr) +414
Informações da versão: Versão do Microsoft .NET Framework:1.1.4322.2300; Versã
o do ASP.NET:1.1.4322.2300"
[UnauthorizedAccessException] Acesso negado ao caminho &quot;C:\WINDOWS\Microsof
t.NET\Framework\v1.1.4322\Temporary ASP.NET Files\servicecenter\8902b2ef\ffaf898 4&quot;.
at System.IO.__Error.WinIOError(Int32 errorCode, String str)
at System.IO.Directory.InternalCreateDirectory(String fullPath, String path)
at System.IO.Directory.CreateDirectory(String path)
at System.Web.Compilation.PreservedAssemblyEntry.DoFirstTimeInit(HttpContext context)
at System.Web.Compilation.PreservedAssemblyEntry.EnsureFirstTimeInit(HttpCont
ext context)
at System.Web.Compilation.PreservedAssemblyEntry.GetPreservedAssemblyEntry(Ht
tpContext context, String virtualPath, Boolean fApplicationFile)
at System.Web.UI.TemplateParser.GetParserCacheItemFromPreservedCompilation()
at System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean fCreateIfN otFound)
at System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath()
at System.Web.UI.TemplateParser.GetParserCacheItem()
at System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String inpu
tFile, HttpContext context, ApplicationFileParser& parser)
at System.Web.HttpApplicationFactory.CompileApplication(HttpContext context)
at System.Web.HttpApplicationFactory.Init(HttpContext context)
at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext conte xt)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)


ExtraInfo :
CompModule : Broadcast Message


Best regards,
João Fonseca
Hi João

The first error that occurred during the execution of the SetupHubState.sql script is due to Microsoft SQL Server 2005 password complexity enforcement policies that require a more complex password than the one specified in the the script, for the SQL HubState user.

If you can't disable this policy, you can change the password in the SQL script and also in the machine.config sqlconnectionstring configuration for the sessionstate element, to meet the policy requirements.

The following errors are due to lack of session state configuration that failed in the beginning.

Hope this information helps.

Cheers

Miguel João
Hi João

I noticed that you mentioned you were using .NET 2.0.
But it seems the errors you are getting are from .NET 1.1 : ....\v1.1.4322\

Please keep in mind:

OutSystems Platform 4.0 (or lower) use .NET 1.1
OutSystems Platform 4.1 (or higher) use .NET 2.0

machine.config in .NET 2.0 is much more concise, with no comments. You may have to add the XML attributes and properties, as they may even not be in the file. For session management in .NET 2.0, you may check for example http://msdn.microsoft.com/msdnmag/issues/05/09/SessionState/default.aspx

If you have problems with 1.1 and 2.0 interoperability, you might try to run one of the following commands (please read the documentation first to understand the consequences):

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
REM (for Hub Server >= 4.1)

or

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -u
REM (for Hub Server <= 4.0)

Regards,
António Melo