Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SqlFriend
Starting Member
26 Posts |
 Posted - 2004-08-14 : 06:31:11
|
| Thank you all for your advice. I hope someone else later reading these messages can also use it for getting started with MSDEI have been surfing the web for a while looking for getting started with MSDE and haven't found much yet. If you know of a pointer that could walk through just really simple stuff that would be helpful. (Or if you knew a reference book to buy)So the question is now: how can I get started? When I use osql from the command line prompt, I don't know what to do. If I tryosql ?It gives me a bunch of command line options.If I try osql -U sa -P passwordC:\Documents and Settings\Tom>osql -U sa -P password[Shared Memory]SQL Server does not exist or access denied.[Shared Memory]ConnectionOpen (Connect()).Thank you for any pointers! Also, if I could get help creating a simple database with a single table. |
|
|
SqlFriend
Starting Member
26 Posts |
Posted - 2004-08-14 : 07:29:43
|
| Okay, I have not figured out how to use OSQL. I have made some progress. I went and downloaded a trial version of MSDE manager from Vale Software.This tool allows me to log in and make queries! It costs $80 bucks though. However, if it is my only option I am strongly considering buying it- I want to be able to run SQL queries for goodness sakes!It also allows me to create users, and otherwise manage the database.It has a graphical GUI which works pretty well.So anyway- if someone else is stuck trying to use MSDE, this is an option for you.I figured out that DUH, you have to have SQL server running in another process. However, osql still won't let me access the database.If I try using osql -U sa -p password it says"Login failed for user 'sa". Reason: Not associated with a trusted SQL Server connection."Any tips still appreciated, although now I am not dead in the water. Thanks vale! |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-08-14 : 09:42:16
|
I don't think your system is running in mixed mode. That means that it will only accept a windows authenticated user, not a sql server user (the sa account is a SQL server account).Try connecting with this command instead:osql -E I suggest you also go to www.microsoft.com/sql and download the latest books online documentation (BOL).-ec |
|
|
|
|
|
|
Please help