Topic:Microsoft SQL Server Remainpoint:0
   
PostTime:12/15/2008 11:09:36 PM FloorTop
Lv is 1
Avatar
Level:
1
Professional point:
46
Experience:
6
Thread:
265
Post:
966
Total online time:
6M
Joined date:
4/29/2007 12:00:00 AM
Last Visit:
12/17/2008 12:21:04 AM
Status:
Offline
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
 
     
   
Gender PostTime:12/16/2008 2:13:11 AM Point:0 | Floor# 1
Lv is 1
portrait
Level:
1
Professional point:
48
Experience:
8
Thread:
292
Post:
962
Total online time:
8M
Joined date:
4/28/2007 11:08:00 PM
Last Visit:
12/17/2008 12:44:40 AM
Status:
Offline
Download and install MSDE 2000 or Microsoft SQL Server Express 2005 from Microsoft's web site.
 
     
   
Gender PostTime:12/16/2008 6:57:20 PM Point:0 | Floor# 2
Lv is 30Lv is 30Lv is 30Lv is 30
portrait
Level:
30
Professional point:
0
Experience:
27341
Thread:
272
Post:
945
Total online time:
27341M
Joined date:
4/24/2007 9:26:00 AM
Last Visit:
4/13/2009 10:45:15 PM
Status:
Offline
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...
 
     
   
Gender PostTime:12/16/2008 8:31:36 PM Point:0 | Floor# 3
Lv is 1
portrait
Level:
1
Professional point:
81
Experience:
32
Thread:
281
Post:
990
Total online time:
32M
Joined date:
4/29/2007 12:22:00 AM
Last Visit:
12/17/2008 12:54:30 AM
Status:
Offline
You have to create databases. Then you can use tools like Query Analyzer to read them.
 
     
   
Gender PostTime:12/16/2008 11:47:09 PM Point:0 | Floor# 4
Lv is 1
portrait
Level:
1
Professional point:
4
Experience:
3
Thread:
263
Post:
954
Total online time:
3M
Joined date:
4/29/2007 2:46:00 AM
Last Visit:
12/16/2008 11:21:46 PM
Status:
Offline
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.
 
     
1

Sorry, you are not login, click here to login

 

About us | Advertise | Contact us | Partner | Bug Report|Suggesting box|Donation
Home | Forum | Affiliate program| Remote help | Setting | Search | Document | Help | Download|Message

 

Start new topicAdvanced search
Your location: Database -> Sql server