Single login for multiple database.

[apking]

Hi to all,


How to create single login for access multiple databases in sql server 2008. i need to access 3 database using single connection.pls help me in that...


thanks in advance

[Rabbit]

You just have to add them to the security of each database. By database, I assume you mean a database on a database server. Meaning all three databases are on the same SQL server.