Login and authentication problem.

Login and authentication problem.

Currently, I have two seperate mssql db's, one of which supports the primary functions of my website, and another which is solely for a forum I have recently decided to add. I did this so that one db won't slow down the other.

My question is, how do I go about authenticating to both databases with only 1 login form, so that users are not forced to register twice?

1) If you're using msSQL you shouldn't need to be worrying about your website slowing down your servers, they can handle a lot more than what your website can dish out usually. And for that reason i'd just link the databases incase you need to join tables and the such.

2) Why are you using the users login and password to log them into the database? That's pretty unsecure. You should just have a general login and password for the web application to log in as and restrict that account to the permissions that they need.

3) If you're creating an account for them on SQL, you have all the information for them in the form, you couldn't just use that in one DB, and then turn around and create that account again on the second DB?

that's my 2 cents.