can’t open any of my coldfusion pages

Hello,

I am using MS SQL as a backend for a webbased application made with dreamweaver.
Doing some testing on a local host, I've discovered that I can’t open any of my coldfusion pages that touch the databases and they run, without a username/password?

Any direction greatly appreciated.

Thank in advance

PS.: I am very new at using all those tools

You mean you have to enter a user name and password in your browser? Or you have to enter a user name and password into your cfquery tag for the query to run?

You shouldn't have to do this, and if it's saying something about authentication, this means that your DSN is probably not set up correctly. Take a look at your ODBC manager on your server and make sure the tests are running okay.
If the above is over your head, then you may want to look at some tutorials on DSNs and ODBC for Windows.

Hope that helps.

Thank you very much for your answer.
I run the ODBC test and it is running okay.
However, here is the new error message I got when I try to display on my Explorer browser a page touching a database.

<CFAPPLICATION NAME="Name"
SESSIONMANAGEMENT="Yes" >

Error Occurred While Processing Request
CFLock cannot be used to lock the application or session shared scopes without these scopes being established through the use of the CFApplication tag. If you want to use the session scope you need to enable session management. Application and/or Session variables must also be enabled in the ColdFusion Administrator
The error occurred in C:\Inetpub\wwwroot\ClearWeb-CF\admin_edit_page.cfm: line 11 : <cflock scope="Session" type="ReadOnly" timeout="30" throwontimeout="no">
2 : <cfset MM_Username=Iif(IsDefined("Session.MM_Username"),"Session.MM_Username",DE(""))>
3 : <cfset MM_UserAuthorization=Iif(IsDefined("Session.MM_UserAuthorization"),"Session.MM_UserAuthorization",DE(""))>
Please try the following:
• Check the ColdFusion documentation to verify that you are using the correct syntax.
• Search the Knowledge Base to find a solution to your problem.

I went in Memory Variables in coldfusion administrator and I enabled Session Variables and Application Variables but still, I have the above error message.

Thank you in advance for any help

Claude