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


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

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

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

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

Теги:


Спасибо:


< 1 2 3 4  > >>
Sajan

Фотография
Дата: 10.05.2011
Ответить


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

Попробовал в Management Studio подключиться к базе (SQL Server Authentification), используя логин:trading, пароль:trading (взял из Hydra.exe.config).
Код
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
------------------------------
Спасибо:

Mikhail Sukhov

Фотография
Дата: 11.05.2011
Ответить


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

Sajan

Фотография
Дата: 18.05.2011
Ответить


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

Mikhail Sukhov

Фотография
Дата: 18.05.2011
Ответить


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


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

Sajan

Фотография
Дата: 20.05.2011
Ответить


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

(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.
Спасибо:

DT

Фотография
Дата: 20.05.2011
Ответить


Аналогичная ситуация.
Win 7 Pro 64Bit (Eng),
SQL Server 2008 R2 64Bit,(Eng).
Из Management Studio выполняю скрипт trading.sql. Получаю сообщения
Цитата:
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). Все остается то же самое.

Спасибо.

Спасибо!
Спасибо:

Mikhail Sukhov

Фотография
Дата: 21.05.2011
Ответить


Цитата:
Directory lookup for the file "C:\StockSharp\Trading.mdf"


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

DT

Фотография
Дата: 23.05.2011
Ответить


База 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а...

Спасибо.









Спасибо:

Mikhail Sukhov

Фотография
Дата: 23.05.2011
Ответить


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

Спасибо.


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

DT

Фотография
Дата: 26.05.2011
Ответить


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

Any idea?
Спасибо:
< 1 2 3 4  > >>

Добавить файлы через драг-н-дроп, , или вставить из буфера обмена.

loading
clippy