One login for multiple DBs

Stesvis 1,041 Reputation points

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!

A set of technologies in the .NET Framework for building web applications and XML web services.
3,358 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,045 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 103.1K Reputation points MVP

    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.

  2. Tom Phillips 17,716 Reputation points

    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.

    0 comments No comments

  3. Lan Huang-MSFT 27,716 Reputation points Microsoft Vendor

    Hi @Stesvis ,
    Maybe you can make the two databases trust each other,
    or combine two databases into one database.

    Best regards,
    Lan Huang

    0 comments No comments