How to setup CM for Corsair

[hack2u]

Please help me There is a problem here How to fix it? This is my config You can come and help me Your very much

My-MKs

[bernix81]

Hello good evening:

I followed the step by step guide but I couldn't get it to work.
I have configured the Web.config and XML file.
I put my logs and configuration files here in case someone comes up with something.

https://mega.nz/file/LAkSmA6C#h27mnh...Z3U9zcfKKrAkqc

Thank you very much in advance and sorry for my english

[bernix81]

Hello good morning (again XD):
I have made new tests with the files that seramyu put in the post (central market working).
In this case I have only changed the IP since the subdomains that I have used are the same.
Now what happens is the same thing that happens to Hack2u, when I try to access trade.local-bdo.net via web I get the same message that I can't access the central market from that browser, from the game it tells me no the central market is accessible at the moment, I have modified the IP in the XML.
When I try to access game.local-bdo.net via web I get a message that says ERR_TOO_MANY_REDIRECTS and no access.

Greetings and thank you

- Sorry for my english XD

[seramyu]

The "trade.local-bdo.net" has a redirect to a login page which we do not have so it leads to nothing. If you open the web.config you can disable it which is this line right here, just comment it out XML Style

<!-- <add key="authRedirectDomain" value="http://account.local-bdo.net/Member/Login?_returnUrl=https%3A%2F%2Ftrade.local-bdo.net%2FauthCallback" /> -->

all i did was add "<!--" at the beginning of the line and "-->" at the end which is a basic XML comment, then just save and wait a few moments and it should no longer redirect. The "use another browser problem" i have as well. if i use Chrome it then opens a very broken webpage, but if i use firefox or something else it gives me that error. It has a filter list for browser and i tried to add all kinds of browser names, even the user agent of firefox to it, but it still does not allow me.

    <add key="AllowBrowserList" value="chrome|" />

This line it is in the same file which prevents you from opening it. I tried removing it but it then just defaults to chrome and gives the same error message.

Okay tested a bit, try this and it now opens on firefox

    <add key="AllowBrowserList" value="chrome|mozilla|gecko|firefox|" />

Okay to everyone getting a broken webpage, check the CDN Link inside the web.configs.

    <add key="cdnDomain" value="http://trade.local-bdo.net/Content/TradeMarket" />

This one works if you use my setup but you will get blasted with an Error Message that says something went wrong, please login again.

This is what i get now when i stop the page from constant refreshing itself
https://imgur.com/tor22Ab
Now we would need a login page or some other way to auth.

[fitnessguy0]

https://imgur.com/tor22Ab

how come i cannot get into this page??,,,but my CM is working in the game...

The "trade.local-bdo.net" has a redirect to a login page which we do not have so it leads to nothing. If you open the web.config you can disable it which is this line right here, just comment it out XML Style

<!-- <add key="authRedirectDomain" value="http://account.local-bdo.net/Member/Login?_returnUrl=https%3A%2F%2Ftrade.local-bdo.net%2FauthCallback" /> -->

all i did was add "<!--" at the beginning of the line and "-->" at the end which is a basic XML comment, then just save and wait a few moments and it should no longer redirect. The "use another browser problem" i have as well. if i use Chrome it then opens a very broken webpage, but if i use firefox or something else it gives me that error. It has a filter list for browser and i tried to add all kinds of browser names, even the user agent of firefox to it, but it still does not allow me.

    <add key="AllowBrowserList" value="chrome|" />

This line it is in the same file which prevents you from opening it. I tried removing it but it then just defaults to chrome and gives the same error message.

Okay tested a bit, try this and it now opens on firefox

    <add key="AllowBrowserList" value="chrome|mozilla|gecko|firefox|" />

Okay to everyone getting a broken webpage, check the CDN Link inside the web.configs.

    <add key="cdnDomain" value="http://trade.local-bdo.net/Content/TradeMarket" />

This one works if you use my setup but you will get blasted with an Error Message that says something went wrong, please login again.

This is what i get now when i stop the page from constant refreshing itself
https://imgur.com/tor22Ab
Now we would need a login page or some other way to auth.

[bernix81]

The problem I have is that the CM does not work for me either via the web or in the game.

I connect via the web to check if it is really working, I also try in the game but at the moment I have no success.

Now I'm testing to see if I can fix it.

Thank you very much for the help

[seramyu]

If you go to your C drive there will be a new folder and in there are all the logs for the web, just make sure to scrub your IP out of there if its a public one. That way you can see what exactly is not working.
"C:\palog" and there will be subfolders for each web. If they are not there they might be in "C:\Data\WebLog" and there will be subfolders.
In theory we have all the website stuff we need but three DBs are missing, from which i guess we would at least need one to make outside auth work, unless you completly make your own, which i have no idea of how to pull that off^^

[fitnessguy0]

Do u have dice game web.config file or detail tutoirial?thx

通过我的 NOH-AN00 上的 Tapatalk发言

[bernix81]

Hi there:After doing several tests via the web it already seems to work, I had a problem related to the sql listening port.
Now the problem I have is that when I try to open the central market from the game it doesn't work.

In the log of trade.local-bdo.net this appears:


{"EventTime":"2022-10-14T13:02:02.7526173+00:00","Severity":"INFO","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"9","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"[WorldMarketItemInfoManager] Open Complete \uC11C\uBE44\uC2A4 \uC624\uD508\uC744 \uC644\uB8CC\uD588\uC2B5\uB2C8\uB2E4! \n\t\t\t\t\t\t-----\uCC98\uB9AC \uC644\uB8CC \uC2DC\uAC04 [Processing ms = (29)]------\n","LogException":"System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.\r\n en GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:02.7526173+00:00","Severity":"INFO","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"9","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"[WorldMarketServantInfoManager] Open Start \uC11C\uBE44\uC2A4\uB97C \uC2DC\uC791 \uD569\uB2C8\uB2E4! ","LogException":"System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.\r\n en GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:02.7526173+00:00","Severity":"INFO","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"9","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"[WorldMarketServantInfoManager] Open Complete \uC11C\uBE44\uC2A4 \uC624\uD508\uC744 \uC644\uB8CC\uD588\uC2B5\uB2C8\uB2E4! \n\t\t\t\t\t\t-----\uCC98\uB9AC \uC644\uB8CC \uC2DC\uAC04 [Processing ms = (0)]------\n","LogException":"System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.\r\n en GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:02.7682575+00:00","Severity":"INFO","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"9","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"[CategoryInfoManager] Open Start \uC11C\uBE44\uC2A4\uB97C \uC2DC\uC791 \uD569\uB2C8\uB2E4! ","LogException":"System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.\r\n en GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:02.7682575+00:00","Severity":"INFO","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"9","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"[CategoryInfoManager] Open Complete \uC11C\uBE44\uC2A4 \uC624\uD508\uC744 \uC644\uB8CC\uD588\uC2B5\uB2C8\uB2E4! \n\t\t\t\t\t\t-----\uCC98\uB9AC \uC644\uB8CC \uC2DC\uAC04 [Processing ms = (1)]------\n","LogException":"System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.\r\n en GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:02.7682575+00:00","Severity":"INFO","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"9","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"[FamilySkillManager] Open Start \uC11C\uBE44\uC2A4\uB97C \uC2DC\uC791 \uD569\uB2C8\uB2E4! ","LogException":"System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.\r\n en GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:02.7682575+00:00","Severity":"INFO","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"9","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"[FamilySkillManager] Open Complete \uC11C\uBE44\uC2A4 \uC624\uD508\uC744 \uC644\uB8CC\uD588\uC2B5\uB2C8\uB2E4! \n\t\t\t\t\t\t-----\uCC98\uB9AC \uC644\uB8CC \uC2DC\uAC04 [Processing ms = (0)]------\n","LogException":"System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.\r\n en GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:02.7682575+00:00","Severity":"INFO","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"9","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"[ServerControlManager ViewServer] Open Complete \uC11C\uBE44\uC2A4 \uC624\uD508\uC744 \uC644\uB8CC\uD588\uC2B5\uB2C8\uB2E4! \n\t\t\t\t\t\t-----\uCC98\uB9AC \uC644\uB8CC \uC2DC\uAC04 [Processing ms = (1600)]------\n","LogException":"System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.\r\n en GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:02.7682575+00:00","Severity":"INFO","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"9","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"[ServerControlManager ViewServer Service Start!!!] All Open! \uBAA8\uB4E0 \uC11C\uBE44\uC2A4\uAC00 \uC624\uD508 \uB418\uC5C8\uC2B5\uB2C8\uB2E4. \uC11C\uBE44\uC2A4\uB97C \uC2DC\uC791\uD569\uB2C8\uB2E4! ","LogException":"System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.\r\n en GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:12.7838457+00:00","Severity":"WARN","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"32","NDC":"(null)","Message":{"HttpMethod":"POST","RequestUrl":"http://trade.local-bdo.net/Trademarket/GetMyBiddingList","Headers":{"Content-Length":"79","Content-Type":"application/json","Host":"trade.local-bdo.net","User-Agent":"BlackDesert"},"FormData":null,"Ip":"192.168.1.34","AuthInfo":null,"LogMessage":"[Http Error]CheckAuthKeyToView({"nationCode":0,"worldNo":0,"userNo":0,"result":{"resultCode":2,"resultMsg":"TRADE_MARKET_WEB_ERROR_eWorldTradeMarketErrorNo_HttpException"}}) - HttpRequest CheckAuthKeyToView result : resultCode 2","LogException":null,"ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:12.7838457+00:00","Severity":"WARN","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"32","NDC":"(null)","Message":{"HttpMethod":"POST","RequestUrl":"http://trade.local-bdo.net/Trademarket/GetMyBiddingList","Headers":{"Content-Length":"79","Content-Type":"application/json","Host":"trade.local-bdo.net","User-Agent":"BlackDesert"},"FormData":null,"Ip":"192.168.1.34","AuthInfo":null,"LogMessage":"[Http Error]GetMyBiddingList(1, D9F47730-44BE-466F-901D-17D508255780) - errorCode : 2","LogException":null,"ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}
{"EventTime":"2022-10-14T13:02:12.7838457+00:00","Severity":"WARN","SourceName":"/LM/W3SVC/3/ROOT-6-133102261208776218","Logger":"JsonLogger","Thread":"9","NDC":"(null)","Message":{"HttpMethod":"POST","RequestUrl":"http://trade.local-bdo.net/Trademarket/GetMyWaitNoticeList","Headers":{"Content-Length":"79","Content-Type":"application/json","Host":"trade.local-bdo.net","User-Agent":"BlackDesert"},"FormData":null,"Ip":"192.168.1.34","AuthInfo":null,"LogMessage":"[Http Error]CheckAuthKeyToView({"nationCode":0,"worldNo":0,"userNo":0,"result":{"resultCode":2,"resultMsg":"TRADE_MARKET_WEB_ERROR_eWorldTradeMarketErrorNo_HttpException"}}) - HttpRequest CheckAuthKeyToView result : resultCode 2","LogException":null,"ProjectName":"bdo-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-tradeweb"},"Properties":{"log4net:UserName":"IIS APPPOOL\\trade","log4net:Identity":"","log4net:HostName":"WIN-CONOEC08F4I"}}

Where 192.168.1.34 is the game client.

My Full CM Folder and palog here:

https://mega.nz/file/TccmCQrT#EdX0om...Ml-GCHZc9uDWdc

I also put my IIS configuration in case there is something wrong or something activated that does not have to be activated

https://imgur.com/a/q25mI8H

I'm actually a bit stuck getting this to work...

Maybe it's some nonsense that I'm not realizing

Sorry for my english

Greetings and thank you

[seramyu]

Is your field and Client in NA or NA_Alpha cause you get "CheckAuthKeyToView" Error which basically means you are offering the wrong auth. I think someone had a similar issue and it was because their field and client where NA_Alpha which seem to use another AuthKey.

[bernix81]

I have it Posted as in the images, but NA I have it in the client and in field

The order of images is

1 - corsair field
2 - game config ini
3 - corsair Login

https://imgur.com/a/mq1XkV6

The only one I have in NA_Alpha is the Corsair Login, if I don't put it like that BDO Manager closes

[seramyu]

Auth and Manager in NA_Alpha is correct, rest in NA, try another Market Version, maybe the one i uploaded, that also seems to be an issue with auth. It was a huge mess of files and i uploaded those that worked for me.

[Nopey]

Good stuff!
Got a tiny issue tho and I can't get it fixed for some reason.

{"EventTime":"2022-10-14T16:51:18.6463313+01:00","Severity":"ERROR","SourceName":"/LM/W3SVC/1/ROOT-1-133102362550638603","Logger":"JsonLogger","Thread":"13","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"uspListTickCount open Exception : System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.) ---> System.ComponentModel.Win32Exception: The remote computer refused the network connection\r\n   --- End of inner exception stack trace ---\r\n   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)\r\n   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)\r\n   at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext)\r\n   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass1.<Execute>b__0()\r\n   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)\r\n   at System.Data.Entity.Core.EntityClient.EntityConnection.Open()\r\n   --- End of inner exception stack trace ---\r\n   at System.Data.Entity.Core.EntityClient.EntityConnection.Open()\r\n   at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions)\r\n   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)\r\n   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass47`1.<ExecuteFunction>b__45()\r\n   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)\r\n   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ExecutionOptions executionOptions, ObjectParameter[] parameters)\r\n   at GB.BlackDesert.Trade.Web.Lib.Manager.TickCountManager.open(ServerType serverType)","LogException":"System.NullReferenceException: Object reference not set to an instance of an object.\r\n   at GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-api-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-api-trade"},"Properties":{"log4net:UserName":"IIS APPPOOL\\api-trade","log4net:Identity":"","log4net:HostName":"WIN-XXXXXXXXXXXX"}}
{"EventTime":"2022-10-14T16:51:18.6553261+01:00","Severity":"ERROR","SourceName":"/LM/W3SVC/1/ROOT-1-133102362550638603","Logger":"JsonLogger","Thread":"13","NDC":"(null)","Message":{"HttpMethod":null,"RequestUrl":null,"Headers":null,"FormData":null,"Ip":null,"AuthInfo":null,"LogMessage":"[ServerControlManager] TickCountManager open Slack_Alarm error!! \uCC98\uB9AC\uC911 \uC624\uB958\uAC00 \uBC1C\uC0DD\uD588\uC2B5\uB2C8\uB2E4!!\n\t\t\t\t\t\trv = (-1)","LogException":"System.NullReferenceException: Object reference not set to an instance of an object.\r\n   at GB.BlackDesert.Trade.Web.Lib.Util.LogUtil.WriteLog(String Message, String Level, LogDetailFlag logDetailFlag, AuthenticationInfo user)","ProjectName":"bdo-api-trade","ServiceType":"NA","Branches":"LIVE","PlatformIndex":"live-web-api-trade"},"Properties":{"log4net:UserName":"IIS APPPOOL\\api-trade","log4net:Identity":"","log4net:HostName":"WIN-XXXXXXXXXXXX"}}

Is that familiar to you?
Re did the whole process a few times to make sure everything is set up just right but that always gets in my way..

UPDATE:
My problem was that my SQL Server assigned some weird Dynamic Port to itself.
Removing that and making sure it uses 1433 OR changing the port in the web.configs should get rid of that issue.
I'll just show what the fix looked like:

You have to make sure the Dynamic Ports are all blank.

[seramyu]

Thank you for pointing that one out. I have done this now so many times that i configure that on autopilot every time i install an MSSQL. That should also help some people out.

[bernix81]

Hello good morning:

I'm in a case similar to Nopey, I did the mysql thing, which was one of the errors I had.

I'm trying other versions of the central market as Seramyu suggested, for the moment without success.

I have even thought that it could be some failure of the operating system, I have made a clean installation of Windows Server and I have carried out the whole process from the beginning, for the moment I have not been successful either.

If I find out why it doesn't work, as soon as I know something I'll post it.

Hopefully we all get this to work.

Sorry for my english ;)

A greeting and thank you very much for the help and suggestions.