I have spent megabucks buying a book called MSDE Bible and they have started the book by not telling how you create a database (with all the exact steps required so you can actually work with it. I find this highly unprofessional, and wonder if the authors David C Walls and Denise M Gosnell actually know anything about teaching. (One enormally teaches step 1 before step 2 where I come from - obviously not in some places). Anyway, later on in the book there is an example on creating a database.
My problem is that it does not work because I do not understand what is required in terms of security clearance / user names / passwords / user authority. (They also assume you know all about that too).
All I have done is installed MSDE 2000 Rel A and am now trying to use it. The only question I was asked during the install was to define a "Strong Password" and thats all.
I am now attempting to
1) Create a Database
2) Create a table with some fields
3) See if I can access the database
Now is that too much to ask ?
Here is the code that supposedly creates the database:
The problem is in the connect - something to do with security of some sort that is completely overlooked.
set oMSDEserver = CreateObject("SQLDMO.SQLServer")
set oDatabase = CreateObject("SQLDMO.Database")
set oDataFile = CreateObject("SQLDMO.DBFile")
set oLogFile = CreateObject("SQLDMO.LogFile")
That's trying to connect using sql server security and a blank sa password. (did you define a password at installation?)
The blank password is very bad and it has probably been installed for windows security only.
To change to mixed security change the registry entry
All I have done is installed MSDE 2000 Rel A and am now trying to use it.
The only question I was asked during the install was to define a "Strong Password" and thats all.
There must be a logical next step to take.
I can understand one may need to get in and change registry settings, but all I can say is that in 30 years of installing systems, I have never had to go to the registry immediately as the next option.
Is this because there is a massive limitation in administrering MSDE?
I think the step you might be missing is that you need to connect to an existing database server to create your new database. The MSDE doesn't include a database server, it just lets you connect to an existing one and create/modify databases.