talking to msde 2k from java

• Previous message: Andre: "Database restore question"
• Messages sorted by: [ date ] [ thread ]

Date: 4 Jun 2004 13:28:27 -0700

I am completly new to sql servers (but not sql). I have a msde
installed on my machine (however i did not install it so can't tell
you much about it). I can connect to it via java if i don't specify a
database that i wrote (So i can only connect to master, model, etc)
and only use the sa account. Why can i not use the other databases
and usernames? Also, in terms of instances, i am completly lost.

I have been doing my work on the database with the web admin tools,
and my all my dbs are stored basically at c:/mydbsqlmssql. This
folder has your normal binn, data, log, and other expected things in
it. My self made databases exist in the data folder.

However, in c:/program files/ms sql server, there is an 80 directory
(I assume the actual msde installation) and then 2 more folders,
db$mssql and db2$mssql.

If i do not specify a db and use the sa username, i was successfully
able to connect, and run a select query of @@version and obtain back
what i had expected :

--------------------
MS SQL verson 8 blah blah blah
etc etc
--------------------

And if i specify the databasename as master, model, etc, i can do the
same. However, if i specify either a custom dbname or username, i
get errors. Any help, clues would be appreciated. I have been stuck
here for 2 days, and am not sure where to go from here. Thanks again.

confused james

• Previous message: Andre: "Database restore question"
• Messages sorted by: [ date ] [ thread ]