"A valid database needs to exist on your SQL Server with proper permissions set so that YAF can access it. When you run YAF for the first time it will detect that the database is empty (or needs upgrading) and will automatically run you through the process required to create the SQL database structures needed."OK - So I'm now trying to set the Database up for the first time on a Test Azure Server, I have created an empty SQL Server Database and my connection string from the Code that I am running in Visual Studio 2022 is pointing at that DB and has the Correct permissions. I have this all working locally with SQL Express and it initially created the DB fine with the Wizard.
I get the following error like the code is expecting the DB to already have the Tables created? - Please Help
SqlException: Invalid object name 'yaf_AspNetUsers'.
ServiceStack.OrmLite.OrmLiteExecFilter.ExecIDbConnection dbConn, Func> filter) in OrmLiteExecFilter.cs
+
throw e;
YAF.Core.Data.DbAccessBase.ExecuteAsyncFunc> execFunc) in DbAccessBase.cs
+
var result = await execFunc(connection);
Microsoft.AspNetCore.Identity.SignInManager.ValidateSecurityStampAsync(ClaimsPrincipal principal)
Microsoft.AspNetCore.Identity.SecurityStampValidator.ValidateAsync(CookieValidatePrincipalContext context)
Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler.HandleAuthenticateAsync()
Microsoft.AspNetCore.Authentication.AuthenticationHandler.AuthenticateAsync()
Microsoft.AspNetCore.Authentication.AuthenticationService.AuthenticateAsync(HttpContext context, string scheme)
Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)
YAF.Core.Middleware.CheckBannedUserAgents.InvokeAsync(HttpContext context) in CheckBannedUserAgents.cs
+
await this.requestDelegate(context);
YAF.Core.Middleware.CheckBannedIps.InvokeAsync(HttpContext context) in CheckBannedIps.cs
+
await this.requestDelegate(context);
YAF.Core.Middleware.InitializeDb.InvokeAsync(HttpContext context) in InitializeDb.cs
+
await this.requestDelegate(context);
Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
YAF.Core.Middleware.AntiXssMiddleware.InvokeAsync(HttpContext context) in AntiXssMiddleware.cs
+
await this.next(context).ConfigureAwait(false);
Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context)