Hydra. Первый запуск. Работа с БД

Hydra. Первый запуск. Работа с БД
Atom
4/22/2011
sunmoon


Здравствуйте!

БД создана, пользователь создан (MS SQL 2008 Standard).
При первом запуске Hydra выдаёт сообщение, ключевой (как я считаю) фразой является:
"... Сохранённая процедура "Exchange_Count" не существует."

Предполагаю, что Гидра сама создаёт все бизнесс-правила на сервере? Какова может быть причина ошибки?

Заранее благодарю за ответ.

Tags:


Thanks:


< 1 2 3 4  > >>
Sajan

Avatar
Date: 5/10/2011
Reply


Mikhail Sukhov
Что-то не так с БД. Подпробуйте к ней подключиться через Management Studio, указав логин и пароль Гидры.

Попробовал в Management Studio подключиться к базе (SQL Server Authentification), используя логин:trading, пароль:trading (взял из Hydra.exe.config).
Code
TITLE: Connect to Server
------------------------------

Cannot connect to LSX\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

Login failed for user 'trading'. (Microsoft SQL Server, Error: 18456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
Thanks:

Mikhail Sukhov

Avatar
Date: 5/11/2011
Reply


А вы скрипт запускали для создания БД и пользователя trading в Sql Server-е?
Thanks:

Sajan

Avatar
Date: 5/18/2011
Reply


Mikhail Sukhov
А вы скрипт запускали для создания БД и пользователя trading в Sql Server-е?
В SQL Server 2008 Management Studio. Может, я что-то не так понял?
Thanks:

Mikhail Sukhov

Avatar
Date: 5/18/2011
Reply


Sajan
Mikhail Sukhov
А вы скрипт запускали для создания БД и пользователя trading в Sql Server-е?
В SQL Server 2008 Management Studio. Может, я что-то не так понял?


Все правильно. А скрипт то запускали? Он отработал?
Thanks:

Sajan

Avatar
Date: 5/20/2011
Reply


Mikhail Sukhov
Все правильно. А скрипт то запускали? Он отработал?
Отработал.
Code

(0 row(s) affected)
Необходимо перезапустить SQL Server
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. Choose a different database name.
Msg 15023, Level 16, State 1, Line 2
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 "Trading".
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 37
Property cannot be added. Property 'AutoDeployed' already exists for 'Ecng.Data.SqlServer'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 37
Property cannot be added. Property 'SqlAssemblyProjectRoot' already exists for 'Ecng.Data.SqlServer'.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'MarketDataSourceSettings' in the database.
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 2714, Level 16, State 6, Line 1
There is already an object named 'Security' in the database.
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 37
Property cannot be added. Property 'AutoDeployed' already exists for 'dbo.PageSelect'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 37
Property cannot be added. Property 'SqlAssemblyFile' already exists for 'dbo.PageSelect'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 37
Property cannot be added. Property 'SqlAssemblyFileLine' already exists for 'dbo.PageSelect'.
Msg 2714, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 27
There is already an object named 'MarketDataSourceSettings_UpdateBySourceId' in the database.
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 2714, Level 16, State 3, Procedure Security_UpdateById, Line 148
There is already an object named 'Security_UpdateById' in the database.
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 2714, Level 16, State 4, Line 2
There is already an object named 'FK_HydraSecurityInfo_Security' 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_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 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Order_Security' 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_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 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Position_Security' 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_Security_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_Trade_Security' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
Thanks:

DT

Avatar
Date: 5/20/2011
Reply


Аналогичная ситуация.
Win 7 Pro 64Bit (Eng),
SQL Server 2008 R2 64Bit,(Eng).
Из Management Studio выполняю скрипт trading.sql. Получаю сообщения
Quote:
Msg 22002, Level 16, State 1, Line 0
RegCreateKeyEx() returned error 5, 'Access is denied.'
Необходимо перезапустить SQL Server
Msg 15025, Level 16, State 1, Line 41
The server principal 'trading' already exists.
Msg 5133, Level 16, State 1, Line 3
Directory lookup for the file "C:\StockSharp\Trading.mdf" failed with the operating system error 2(failed to retrieve text for this error. Reason: 15100).
Msg 1802, Level 16, State 1, Line 3
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'Trading', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 911, Level 16, State 1, Line 2
Database 'trading' does not exist. Make sure that the name is entered correctly.
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 37
Property cannot be added. Property 'AutoDeployed' already exists for 'Ecng.Data.SqlServer'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 37
Property cannot be added. Property 'SqlAssemblyProjectRoot' already exists for 'Ecng.Data.SqlServer'.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'MarketDataSourceSettings' in the database.
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 2714, Level 16, State 6, Line 1
There is already an object named 'Security' in the database.
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 37
Property cannot be added. Property 'AutoDeployed' already exists for 'dbo.PageSelect'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 37
Property cannot be added. Property 'SqlAssemblyFile' already exists for 'dbo.PageSelect'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 37
Property cannot be added. Property 'SqlAssemblyFileLine' already exists for 'dbo.PageSelect'.
Msg 2714, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 22
There is already an object named 'MarketDataSourceSettings_UpdateBySourceId' in the database.
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 2714, Level 16, State 3, Procedure Security_UpdateById, Line 160
There is already an object named 'Security_UpdateById' in the database.
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 2714, Level 16, State 4, Line 2
There is already an object named 'FK_HydraSecurityInfo_Security' 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_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 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Order_Security' 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_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 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Position_Security' 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_Security_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_Trade_Security' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.


Через Панель управления - сервисы перезапускаю SQL Server (MSSQLSERVER). Все остается то же самое.

Спасибо.

Спасибо!
Thanks:

Mikhail Sukhov

Avatar
Date: 5/21/2011
Reply


Quote:
Directory lookup for the file "C:\StockSharp\Trading.mdf"


Создайте руками директорию.
Thanks: DT

DT

Avatar
Date: 5/23/2011
Reply


База Trading создалась.

SQL Server под Windows Authentification,
Windows login = Dima.

В Management Studio -> Object Explorer сервер виден как
(local)(SQL Server 10.50.1600 - Dima-THINK\Dima)

При запуске Hydra.exe выдает ошибку
http://narod.yandex.ru/disk/137...6001/Hydra%20capture.PNG

пробовал разные варианты логина в hydra config-файле: Dima-THINK\Dimа...

Спасибо.









Thanks:

Mikhail Sukhov

Avatar
Date: 5/23/2011
Reply


DT
пробовал разные варианты логина в hydra config-файле: Dima-THINK\Dimа...

Спасибо.


В скрипте явно прописан пользователь (trading, одноименно с БД). Если вы хотите под другим, то нужно переделать скрипт.
Thanks:

DT

Avatar
Date: 5/26/2011
Reply


переставил SQL Server R2 c логином и паролем tading, запустил скрипт, БД Trading создалась (попросила перезапустить, перезапустил через сервисы). При запуске Гидры всне равно выдается ошибка
Гидра- ошибка БД

Any idea?
Thanks:
< 1 2 3 4  > >>

Attach files by dragging & dropping, , or pasting from the clipboard.

loading
clippy