I am learning Microsoft SQL Server...............learning in the sense................Implementing Relational Databases using MS-SQL Server.......................
I have installed the software........i.e. Query Analyzer........but when I run analyzer, a dialog appears which shows....SQL Server..................and.............connect using there are two options.......1)Windows Authentication & 2)SQL Server Authentication which asks for Login name & Password...........

Both options I cannot use for connecting to Databases..........Login & Password which I enter are not accepted.

please help me guys.....how can I make the software work....i.e., how can I access & modify DATABASES....

Also from where can I get Dummy Databases just for the sake of practicing....and how to install them separately

Download and install MSDE 2000 or Microsoft SQL Server Express 2005 from Microsoft's web site.

Thank You very much Sir for Replying.......

Actually I am going to install it on my home PC just for the sake of practicing commands...
like..
for eg:-
1)
SELECT *
FROM Publishers
WHERE Country LIKE'us_'

2)
SELECT Title, Ytd_Sales
FROM Titles
WHERE Ytd_Sales is NULL

just like these many other formatting commands which can used for query output........
&
what about "WINSQL"............................is it useful?

So sir, what do you recommend me to do...

You have to create databases. Then you can use tools like Query Analyzer to read them.

Thank You very much for Replying....Sir.......
I have Downloaded & installed Microsoft SQL Server Express 2005...
But in that there are...MICROSOFT SQL SERVER 2005---->
CONFIGURATION TOOLS-->1)SQL SERVER CONFIGURATION MANAGER 2)SQL SERVER ERROR & USAGE REPORTING 3)SQL SERVER SURFACE AREA CONFIGURATION
which one should I select which one.

also in other software which our sir has given me the only problem I get is that of databases....some kind error regarding accessing the databases.........how to access them?......

Can we Download & install Databases seperately or we have to create databases & only then use them.