open enterprise manager and open the sql server group.
in security you create one user which can access 2 or more db
with appropriate permission.
You can verify this permission for each database
exploding each database menu and selecting users menu.


-----Messaggio originale-----
Da: Carlos Pedro [mailto:cpedro@i...]
Inviato: giovedi 25 luglio 2002 12.20
A: ASP Databases
Oggetto: [asp_databases] sql


Hi,

  I'm doing a page o work with several sql server databese all in the
same server. and i have a problem, if i create a user in sql with "xpt"
login in "x" database when in "y" database when in trying the
same "xpt" login that give an error.

  Is possible to create equal logins for different database?? or not ???

thanks