Database Location

Got a couple of questions

1. If you are managing databases in SQL Express with SQL Server Managment Express CTP, why doesnt VBE place the database there where you can see them? I can create a database inside SQL Server Managment Express CTP and view its tables, relations,etc. from within SQL Server Managment Express CTP, but when I make a database with VBE it does not show up in SQL Server Managment Express CTP. Also the database that was made inside SQL Server Managment Express CTP cannot be seen from VBE. Why? what did I do wrong, or is it supposed to be like that? Is that where you would want to place a database for multiple pc to share?

2.Login Question ;--shouldnt post this here but,

Is there a reason why you dont want to use SQL Authetication over Windows? The are a few pcs here that doesnt have user accounts installed(I know that not a good practice, but when you have multiple people needing different data quickly- switching users is not preferred, its a time thing for what I would call dummy terminals).

How do you take an instance of SQL and change to SQL Authetication over windows?

Curious?

David

Scratch not finding the file, I just learned how to connect to a database by chance, but if you can answer the rest, that fine!!|||

When using the Express IDES the system uses User instances for the database and these are dynamicly attached to the engine when you make a connection to the database in you code. (Have a look at the attach command inside you connection String)

For your logon problems, to allow sql athentication you will have to change the way that the database servers security model is difined. You can do this at setup by passing parameters to it, or as you have the Management studio set up you can connect to the engine and go to the properties for the database server. Then go to the security tab and change it there.