• Home
• Tutorials
• Forums
• Reference
• Developers
• Advertise
• About Us

Creating Databases in MS SQL2000

Starting with MS SQL Server 2000
--------------------------------

Here is my tutorial for the easiest way to start with MS SQL 2000

Firstly We are going to assume you have made your database already in Microsoft Access, as this is the easiest way.

ok firstly make sure your Access file is on the server.

1. Go to Start -> Program Files -> Microsoft SQL Server -> Import/Export Data
   
2. First it will give you an introduction, click Next
   
3. Click the first drop down box, and select Microsoft Access
   
4. Select the file and put in the username and password, click next
   
5. Keep everything as the same, and drop down the database menu, click New
   
6. It will then ask for a name, put in your database name and hit ok, click Next
   
7. Keep the next page as is, just confirming you want to copy everything, click Next
   
8. Press Select all to make sure all your tables go across, click next
   
9. Keep it select to run immediately, click next
   
10. This page is just an overview of all the options, if you are happy with it, click Finish
    
11. You should have transported all your data over without problems, click Done
    
12. goto Start -> Program Files -> Microsoft SQL Server -> Enterprise Manager
    
13. Click + Microsoft SQL Servers
                + SQL Server Group 
                + ServerName (Windows NT)
    
14. You should now see a list that includes
                + Databases
                + Data Transformation Services
                + Management 
                + Replication
                + Security
                + Logins 
                + Support Services 
                + Meta Data Services
    
15. Right Click Logins (Under Security) and click New User
    
16. Give a Username, then click SQL Authentication and put in your password
    
17. Drop down the database and click the Database you created and 
    
18. Click Database Access and then Tick the database name 
    
19. When you hit OK it will ask you to confirm the password, click OK
    
20. Now you've set up your database and your usernames, there are a couple of things you must do, as they dont properly transform across, they are Primary Keys and AutoNumbers
    
21. Click the Plus next to 'Databases' and then the plus next to your Database
    
22. Click Tables then in the left hand side, click one of your tables (its all listed in alphabetical order)
    
23. Right Click your table and goto Design Table 
    
24. You will then be presented with a screen very much like the Access Design table
    
25. To Set AutoNumber, click Identity, and Select Yes (their can only be ONE Identity per table)
    
26. Right click your Column Name and then select Primary key to where you need it
    
27. If you have anything Unticked in Allow Nulls or do not wish that to be, remember to add a Default Value into the column
    
28. when you want to exit, it will prompt you to save, click ok
    
29. Once you have all your tables in order you can close Enterprise Manager (be aware that you aren't constrained like Access and can have more than 255 chars)
    
30. Close MTS and goto your Coldfusion Administrator

THE NEXT PART IS FOR COLDFUSION MX, PLEASE READ YOUR DOCUMENTATION IF YOU HAVE A PREVIOUS VERSION

1. Goto Data Sources, and at the top, type in your DSN name
   
2. Drop down the box and click MS SQL Server click Add
   
3. You will then have a form in front of you that will have
   
   CF Data Source Name : (you already added this) 
   Database : put the Database name you created in MTS
   Server : put your machine name or 127.0.0.1 or localhost, whichever :)
   Username : The username that you created in Enterprise Manager
   Password : Same as above
   Description : Purely optional
   
4. You then should get a big OK!
   
   This brings us to the end of our tutorial,
   I really hope this helps,
   there are ALOT of things you can do with MS SQL2000
   but this is just to get your foot in the door,

Hope this helps you all!!!