Установка Гидры. Не могу победить :-(

я победил аналогичную проблему так:

2011-06-06T13:04:45Z

Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удаетс...

2011-06-06T12:38:37Z

Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)". File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect. Возможно у процесса SQLServer-а нет прав на запись в данную директорию

Удалил все приложения, связанные с SQL Установил SQL Server 2005 Express

Запускаю скрипт trading.sql из SQL Server Management Express и вот такая хрень вылазит

Msg 22002, Level 16, State 1, Line 0 RegCreateKeyEx() returned error 5, 'Отказано в доступе.' Необходимо перезапустить SQL Server Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '100'. Msg 102, Level 15, State 6, Line 2 Incorrect syntax near 'HONOR_BROKER_PRIORITY'. Msg 2715, Level 16, State 7, Line 1 Column, parameter, or variable #3: Cannot find data type time. Msg 2715, Level 16, State 7, Line 1 Column, parameter, or variable #24: Cannot find data type datetime2. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #3: Cannot find data type time. Parameter or variable '@WorkingFrom' has an invalid data type. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #4: Cannot find data type time. Parameter or variable '@WorkingTo' has an invalid data type. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #5: Cannot find data type time. Parameter or variable '@Interval' has an invalid data type. Msg 2715, Level 16, State 3, Procedure Security_UpdateById, Line 1 Column, parameter, or variable #24: Cannot find data type datetime2. Parameter or variable '@LastTradeTime' has an invalid data type. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_HydraSecurityInfo_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_HydraSecurityInfo_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Order_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Order_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Position_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Position_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 4902, Level 16, State 1, Line 2 Cannot find the object "dbo.Security" because it does not exist or you do not have permissions. Msg 4902, Level 16, State 1, Line 1 Cannot find the object "dbo.Security" because it does not exist or you do not have permissions. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Trade_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Trade_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 15151, Level 16, State 1, Line 1 Cannot find the object 'MarketDataSourceSettings_UpdateBySourceId', because it does not exist or you do not have permission. Msg 15151, Level 16, State 1, Line 1 Cannot find the object 'Security_UpdateById', because it does not exist or you do not have permission. Configuration option 'clr enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.

Через администрирование/службы перезапускаю службу SQL Server повторно запускаю скрипт - та же самая хрень... Уже неделю бьюсь. Ничего не понимаю, что еще надо сделать-то чтоб базы сформировались и запустились. В папке c:\stocksharp создалось 2 файла - база и лог, все ок. Но почему дальше ошибки летят - неясно. Выручайте, профи-SQLщики ! А то руки опускаются уже.

Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удаетс...

2011-06-06T07:28:46Z

Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)". File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect. Возможно у процесса SQLServer-а нет прав на запись в данную директорию

Когда запускаю скрипт trading.sql - вылазят ошибки Какие именно ошибки? вот чего пишет Msg 15025, Le...

2011-06-06T07:17:46Z

Когда запускаю скрипт trading.sql - вылазят ошибки Какие именно ошибки?

вот чего пишет Msg 15025, Level 16, State 1, Line 41 The server principal 'trading' already exists. Msg 1801, Level 16, State 3, Line 3 Database 'Trading' already exists. Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '100'. Msg 5120, Level 16, State 101, Line 2 Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)". File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 102, Level 15, State 6, Line 2 Incorrect syntax near 'HONOR_BROKER_PRIORITY'. Msg 5120, Level 16, State 101, Line 2 Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)". File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect. Msg 945, Level 14, State 2, Line 2 Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 5120, Level 16, State 101, Line 2 Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)". File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect. Msg 945, Level 14, State 2, Line 2 Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 945, Level 14, State 2, Line 2 Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. Msg 15023, Level 16, State 1, Line 3 User, group, or role 'trading' already exists in the current database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Exchange' in the database. Msg 6246, Level 16, State 1, Line 2 Assembly "Ecng.Data.SqlServer" already exists in database "master". Msg 6249, Level 16, State 1, Line 1 The associated file "Ecng.Data.SqlServer.pdb" already exists for assembly "Ecng.Data.SqlServer". Msg 6249, Level 16, State 1, Line 1 The associated file "Properties\AssemblyInfo.cs" already exists for assembly "Ecng.Data.SqlServer". Msg 6249, Level 16, State 1, Line 1 The associated file "SqlExtendedProcedures.cs" already exists for assembly "Ecng.Data.SqlServer". Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38 Property cannot be added. Property 'AutoDeployed' already exists for 'Ecng.Data.SqlServer'. Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38 Property cannot be added. Property 'SqlAssemblyProjectRoot' already exists for 'Ecng.Data.SqlServer'. Msg 2715, Level 16, State 7, Line 1 Column, parameter, or variable #3: Cannot find data type time. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'HistorySession' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Strategy' in the database. Msg 2714, Level 16, State 3, Procedure usp_RethrowError, Line 26 There is already an object named 'usp_RethrowError' in the database. Msg 2715, Level 16, State 7, Line 1 Column, parameter, or variable #24: Cannot find data type datetime2. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Portfolio' in the database. Msg 2714, Level 16, State 51, Procedure PageSelect, Line 2 There is already an object named 'PageSelect' in the database. Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38 Property cannot be added. Property 'AutoDeployed' already exists for 'dbo.PageSelect'. Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38 Property cannot be added. Property 'SqlAssemblyFile' already exists for 'dbo.PageSelect'. Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38 Property cannot be added. Property 'SqlAssemblyFileLine' already exists for 'dbo.PageSelect'. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #3: Cannot find data type time. Parameter or variable '@WorkingFrom' has an invalid data type. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #4: Cannot find data type time. Parameter or variable '@WorkingTo' has an invalid data type. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #5: Cannot find data type time. Parameter or variable '@Interval' has an invalid data type. Msg 2714, Level 16, State 3, Procedure MarketDataSourceSettings_ReadBySourceId, Line 4 There is already an object named 'MarketDataSourceSettings_ReadBySourceId' in the database. Msg 2714, Level 16, State 3, Procedure HistorySession_Count, Line 3 There is already an object named 'HistorySession_Count' in the database. Msg 2714, Level 16, State 3, Procedure Exchange_Count, Line 3 There is already an object named 'Exchange_Count' in the database. Msg 2714, Level 16, State 3, Procedure Exchange_UpdateByName, Line 18 There is already an object named 'Exchange_UpdateByName' in the database. Msg 2714, Level 16, State 3, Procedure Exchange_ReadByName, Line 4 There is already an object named 'Exchange_ReadByName' in the database. Msg 2714, Level 16, State 3, Procedure Exchange_ReadAll, Line 6 There is already an object named 'Exchange_ReadAll' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'HydraSecurityInfo' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Order' in the database. Msg 2714, Level 16, State 3, Procedure HistorySession_ReadAll, Line 6 There is already an object named 'HistorySession_ReadAll' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Position' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Trade' in the database. Msg 2714, Level 16, State 3, Procedure Security_ReadAll, Line 6 There is already an object named 'Security_ReadAll' in the database. Msg 2714, Level 16, State 3, Procedure Security_Count, Line 3 There is already an object named 'Security_Count' in the database. Msg 2715, Level 16, State 3, Procedure Security_UpdateById, Line 1 Column, parameter, or variable #24: Cannot find data type datetime2. Parameter or variable '@LastTradeTime' has an invalid data type. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'OrderFail' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'MyTrade' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'HistorySessionOrder' in the database. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_HistorySessionOrder_Order' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_HistorySessionOrder_Session' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_HydraSecurityInfo_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_HydraSecurityInfo_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_MyTrade_Order' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_MyTrade_Trade' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_Order_Portfolio' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Order_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Order_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_OrderFail_Order' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_Portfolio_Exchange' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_Position_Portfolio' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Position_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Position_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 4902, Level 16, State 1, Line 2 Cannot find the object "dbo.Security" because it does not exist or you do not have permissions. Msg 4902, Level 16, State 1, Line 1 Cannot find the object "dbo.Security" because it does not exist or you do not have permissions. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Trade_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Trade_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 15151, Level 16, State 1, Line 1 Cannot find the object 'MarketDataSourceSettings_UpdateBySourceId', because it does not exist or you do not have permission. Msg 15151, Level 16, State 1, Line 1 Cannot find the object 'Security_UpdateById', because it does not exist or you do not have permission. Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.

и в папке c:\stocksharp\ пусто

как и где сделать "Run the RECONFIGURE statement to install." не могу никак вдуплить. SQL пока для меня совсем никак...

Когда запускаю скрипт trading.sql - вылазят ошибки Какие именно ошибки?

2011-06-06T05:17:50Z

Когда запускаю скрипт trading.sql - вылазят ошибки Какие именно ошибки?

Доброго времени суток, роботостроители! Случайно набрел на этот проект. Зачетная вещь, чего и говори...

2011-06-06T05:11:46Z

Доброго времени суток, роботостроители! Случайно набрел на этот проект. Зачетная вещь, чего и говорить. Хочется тоже присоединиться к вашему сообществу. С# освоил, т.к. програмлю на асм с детства. Одна проблема - не совсем понятно, как устанавливать базу данных. Когда запускаю скрипт trading.sql - вылазят ошибки Может в WIN7 хитрости какие-то ? С SQL раньше дел не имел, если не трудно - направьте на путь истинный. Где косяк ? И где порыть ?