Error when install NTA 3.6

Do you know if you had an NTA eval or older version of NTA on this machine before?

It´s a new installation, NPM SLX 9.5.1 and NTA 3.6 with an independent  SQL 2005 Enterprise Server. I found the installation wizard log:

2010-03-04 00:33:17,218 [1] INFO ConfigurationProgressScene - Shutting down services ...
2010-03-04 00:33:17,234 [6] DEBUG ConfigurationProgressScene - Stopping service "NetPerfMonService".
2010-03-04 00:34:30,500 [6] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsAlertingEngine".
2010-03-04 00:34:30,500 [6] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsSyslogService".
2010-03-04 00:34:30,500 [6] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsTrapService".
2010-03-04 00:34:30,500 [6] DEBUG ConfigurationProgressScene - Stopping service "SWJobSchedulerSvc".
2010-03-04 00:34:30,500 [6] DEBUG ConfigurationProgressScene - Stopping service "SWJobEngineSvc".
2010-03-04 00:34:30,515 [6] DEBUG ConfigurationProgressScene - Stopping service "OrionModuleEngine".
2010-03-04 00:34:30,515 [6] DEBUG ConfigurationProgressScene - Stopping service "SWOrionInformationServicev1".
2010-03-04 00:34:30,515 [6] DEBUG ConfigurationProgressScene - Stopping service "SWInfoServiceSvc".
2010-03-04 00:34:30,546 [6] DEBUG ConfigurationProgressScene - Configuring Plugin "NetFlow Traffic Analyzer" - Component "NetFlow Database"
2010-03-04 00:34:30,546 [1] INFO ConfigurationProgressScene - Updating Orion database. Processing NetFlowTrafficAnalysis.DBStructure file ...
2010-03-04 00:34:31,265 [1] INFO ConfigurationProgressScene - Updating Orion database. Processing NetFlowDatabaseScheme.dbConfig file ...
2010-03-04 00:34:34,296 [6] ERROR DBConfigProcessor - Error while executing script - Must declare the scalar variable "@Script"..
2010-03-04 00:34:34,296 [6] ERROR DBConfigProcessor - Failing Sql command:


CREATE PROCEDURE dbo.swsp_DropRoutineIfExists
@routineName varchar(max)
AS
BEGIN

DECLARE @script nvarchar(max)
SET @script=''

SELECT @script = @script +' DROP ' + ROUTINE_TYPE + ' ' + ROUTINE_SCHEMA + '.' + ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME=@routineName

EXEC sp_executesql @Script

END
2010-03-04 00:34:34,296 [6] ERROR ConfigurationProgressScene - Error while executing script- Must declare the scalar variable "@Script".
SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- Must declare the scalar variable "@Script".
at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.ExecuteSqlBatch(IDbConnection connection, String sqlQuery, ConfigurationLogDelegate configLog)
at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.Process(IDbConnection connection, ConfigurationProgressDelegate progress, String scriptFile, ConfigurationLogDelegate log)
at SolarWinds.ConfigurationWizard.Plugin.Common.ModuleHelper.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log, String dbStructureFile, String dbConfigFile, String initialWebConfigFile)
at SolarWinds.ConfigurationWizard.Plugin.NetFlow.NetFlowPlugin.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)
at SolarWinds.ConfigurationWizard.Plugin.NetFlow.NetFlowPlugin.DoConfigure(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)
at SolarWinds.ConfigurationWizard.Plugin.Common.OrionConfigPlugin.SolarWinds.ConfigurationWizard.Common.IOrionConfigPlugin.DoConfig(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)
at SolarWinds.ConfigurationWizard.Host.ConfigurationProgressScene.DoConfigForComponent(IOrionConfigHost host, Int32 componentId)
2010-03-04 00:34:34,453 [1] DEBUG IIS6Configurator - Parsed IIS binding string of ":8090:". Address is "" and port is "8090"
2010-03-04 00:34:34,468 [1] DEBUG IISHelper - Detecting if IIS6 is installed: True
2010-03-04 00:34:34,546 [1] DEBUG SqlHelper - SQL: SELECT TOP 1 NodeID FROM Nodes
2010-03-04 00:35:06,421 [1] DEBUG SqlHelper - SQL: SELECT TOP 1 NodeID FROM Nodes

Hi,

what's your collation schema? I would say, that you have CASE SENSITIVE and that's probably the problem.

thanks

Correct, and we don't support CASE SENSITIVE DB configurations at this point. 

You are Rigth!!!

I change the collation schema of SQL 2005 server database to Case Insensitive:

I need to:

1. uninstall NTA module
2. delete NetPerfMonDB (my DB was empty ) from SQL server
3. change the collation scheme of my server:
   start /wait setup.exe /qb INSTANCENAME=MY_SQL_SERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=mypassword SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI
4. Run configuration wizard for NPM to rebuild database
5. install NTA

;-) Thank´s