Activities of "Anjaneyulu"

Im using dockersektop with wsl2 in windows machine. I believe this has nothing to do with that because im able to connect from ssms with external port 1434 from host machien when i run individually based on the micrsoft documentation.

The error logs from container :

2025-02-06 05:30:00 05:09:54.54 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1] 2025-02-06 10:39:54 2025-02-06 05:30:00 05:09:54.59 Logon Error: 18456, Severity: 14, State: 8. 2025-02-06 10:39:54 2025-02-06 05:30:00 05:09:54.59 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1] 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:54.98 Logon Error: 18456, Severity: 14, State: 8. 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:54.98 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1] 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:54.99 Logon Error: 18456, Severity: 14, State: 8. 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:54.99 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1] 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:55.13 Logon Error: 18456, Severity: 14, State: 8. 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:55.13 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1] 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:55.17 Logon Error: 18456, Severity: 14, State: 8. 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:55.17 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1]

Inspect sql container configuration

"Env": [ "ACCEPT_EULA=Y", "SA_PASSWORD=myPassw@rd", "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin", "BUILD_VERSION=16.0.5100.7245", "PAL_BOOT_WITH_MINIMAL_CONFIG=1", "PAL_ENABLE_PAGE_ALIGNED_PE_FILE_CREATION=1", "LD_LIBRARY_PATH=/opt/mssql/lib"

let me try to create an new project and check again.

Ohh that my bad, i have attached a wrong screenshot , I have changed the password for testing,incase that works.

I confirm the password was myPassw@rd when tried to run the applications

This the error that im getting with services and similar to authserver as well.

SqlException has been thrown. The operation will be tried 2 times more. Exception: Login failed for user 'sa'.. Stack Trace: at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool) at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen() --- End of stack trace from previous location -

I have tried connecting to sql server running in docker from ssms host machine localhost,1434 -

Hi, can you check your container and inspect it to ensure about the password and also confirm it's same in your microservice application?

Yes, In the docker desktop, i could inspect the docker container and see the password same as which im trying to login

To be more specific it is the default password that comes with the microservice template architute using abp studio

Hi, can you check your container and inspect it to ensure about the password and also confirm it's same in your microservice application?

Yes, In the docker desktop, i could inspect the docker container and see the password same as which im trying to login

• ABP Framework version: v9.0.0
• UI Type: MVC
• Database System: EF Core (SQL Server)
• Tiered (for MVC) or Auth Server Separated (for Angular): Microservice
• Exception message and full stack trace: Login error for SA. Password mismatch - sql server - azure sql edge docker image
• Steps to reproduce the issue: Create a sample application with microservice architectue.
• Do run docker compose up and i see all the infrastruture containers running.
• Try to run the authserver application from visual studio, and it say login failed for sa .
• When run the docker following https://learn.microsoft.com/en-us/azure/azure-sql-edge/disconnected-deployment . Im able to login to db.
• Im using docker deskop on windows with wsl2

Can you help solve the issue

• ABP Framework version: v9.0.1
• UI Type: MVC
• Database System: EF Core (SQL Server)
• Tiered (for MVC) or Auth Server Separated (for Angular): yes
• Exception message and full stack trace:
• Steps to reproduce the issue:

My server i see the for web and APIhost that scope as profie,email etc and MyprojectName - which i believe acts as the scope for complete project resources(apis,pages etc).

Now i have two questions: 1. How can i create a scope for certain resources like to a specific controller 2. I have a machine to server communication, where i dont have userlogged in and i need to handle the secure api communication/authorization based on the machine identity. How can i user openid/autheserver to handle this scenario in abp.

hi

openid client credentials are not created in the tenant

The openiddict application/client should always store on Host database.

Tommorow if i create a tenant for customer, Should i not give the tenant admin provision to add openid applications/clients ??

showing invalid certificate but it is showing as valid certificate for web.xyx.com

Your HTTPS certification should contain the *.web.xyx.com.

Rather than having multilevel subdomains, if i use three certificates for api,authserver and web and create a tenant test, will abp support test.api.com -> test.authserver.com -> test.web.com tenant resolution?

acme.sh --issue --dns dns_cf -d getabp.net -d '*.getabp.net' -d '*.api.getabp.net' -d '*.ids.getabp.net' -d '*.ng.getabp.net' -d '*.web.getabp.net'

I have configured the widl card i.e., *.xyz.com to my server as follows

API Host - api.xyz.com AuthServer - auth.xyz.com WebServer - web.xyz.com

I have observerd two issues here

1. When add tenant lets say 'test1' - I couldn't login to test1.web.xyz.com as the openid client credentials are not created in the tenant ,so it is redirecting to auth.xyz.com rather than t1.auth.xyz.com
2. Also when i do t1.web.xyz.com the certificate is showing invalid certificate but it is showing as valid certificate for web.xyx.com

• ABP Framework version: v8.3.3
• UI Type: MVC
• Database System: EF Core (SQL Server)
• Tiered (for MVC) or Auth Server Separated (for Angular): yes
• Exception message and full stack trace:
• Steps to reproduce the issue:
• 1. Currently i have my server with using ABP framework which in not Tiered(No seperate auth server and api Host)
• I able to configure multitenancy using *.myproduct.com
• But now i want to move to tired architecture and im confused about handling multi tenenacy. And how does tenant url be formatted?

Should i take three different certiifcate like *.apimyproduct.com , *.authmyproduct.com etc.

Can you help us what should be the preffered way to host the applications in the multi tenant context.