CF Username & Password

[ITGL72]

I recently discontinued using one of my web hosts, and grabbed the SQL database from there and imported it into a local SQL7 Server I have here. I have the database imported locally now and it works fine. I also have CF Server 4 running on the same machine.

On the webhost, every query required a USERNAME and PASSWORD and its on every CF template. I have the imported DB in the CF ADMIN on my local server and it verifies.

I am not quite certain where to put the "USERNAME" and "PASSWORD" though to make the CF pages work with this database.

I see in the CF ADMIN page under ODBC/(My SQL DB) theres a section for USERERNAME and PASSWORD but I dont think that is the right place because when I enter the username/password combo on that section then click up it no longer can verify the DB connection.

Where do I put this USERNAME/PASSWORD combo to make these pages come up with out error?

Thanks!

PS: I'm running a W2K Server, with SQL7 Server, and CF Server 4.0

 

[Guest_imported]

You didn't say what the error was, so I have to guess here. There are only two possiblities:

(1) Since the username and password are used in the queries to the database, you need to create user accounts in the database. The "username" in the code is the account name in the database, and the "password" is the one for the database account. If you already have accounts in your database, then maybe the error occurs because

(2) you need to provide some way for the user to enter his username and password. Usually that is done using ColdFusion's <cfauthenticate> tag withing your code, where you ack the user to login to your application. It's possible that your code uses the Web server's authentication, although that is not generally very secure. What web server are you using? Is it the same web server as you used on your previous web host?

It would help me a LOT if you would post the error message that you are getting.

 

[ITGL72]

Its #1

I have never done that before. Ill look to see if I can add that, unless you can tell me quickly.

Thank You!

 

[Guest_imported]

Sorry, I don't know SQL Server (or any other DB). It's easy to forget when you haven't used one lately. It should be easy to find out how to add a user.