I guess that you could simply try both logins and see what you can access. But there many unknowns (for me) here, so my reply may be completely off base.
One login for multiple DBs
![](https://techprofile.blob.core.windows.net/images/WmBD9oL6a0-0MJb9XowEMg.png?8D95C2)
I am looking for some advice, not for code snippets etc but just some help with the right approach.
We have two projects, PA and PB that we created for different audience and purposes.
Now our clients realized that they can use both our apps after we implemented some integration between the two.
So the current situation is that some users only use PA, some only use PB, and some use both.
We are building a "dashboard project" where users can go and log in.
Requirement: once they log in, this dashboard is supposed to detect if their credentials are valid for PA or PB or both.
Problem: users most likely have different credentials for PA and PB, so one common login would not work.
Question: how would you approach this?? Is it even possible?? They're asking me to implement it but i have no clue how to achieve that...thx!
3 answers
Sort by: Most helpful
-
-
Tom Phillips 17,721 Reputation points
2021-08-31T03:43:26.047+00:00 Normally, users do not login to the SQL Server. The APPLICATION logs into SQL Server as a generic user, and user security is handled by your APPLICATION, not SQL Server.
-
Lan Huang-MSFT 28,841 Reputation points Microsoft Vendor
2021-08-31T06:40:20.947+00:00 Hi @Stesvis ,
Maybe you can make the two databases trust each other,
or combine two databases into one database.Best regards,
Lan Huang