Be sure to do that before anything else and do it slowly:
Creating/Connecting the Database
Open Server Management Studio Express* (SMSE). Within the Object Explorer Panel you will notice the 'Database' folder, right click it, click 'New Database...'.
A 'New Database' form will open, and in the text input type 'GunzDB' and click OK, your database has been created.
The next thing you are going to want to do is open the Database. Click File> Open> File... and locate your GunzDB.sql file and open it.
In the toolbar there is a drop-down menu with the 'master' database selected, click on the arrow and select the 'GunzDB' database and click the button next to the drop-down menu, 'Execute'. A message showing 'Command(s) completed successfully.' should notify you that you have done this all correctly.
Creating the ODBC
Click Start> Run> and in the windows input type 'odbcad32'(or just type odbcad32 in seach bar for vista/7 users. You should already be in the 'User DSN' tab so change it to 'System DSN' then click on 'Add'. Another window should pop-up. You'll have to scroll all the way down to the bottom and select 'SQL Server' then click 'Finish'.
Another window/form will pop-up needing information for your new Data Source. For the name, type 'GunzDB', for the description you may type whatever you like, but for the SQL server you which to connect to, you must go back into SMSE*, look in the SQL Editor tool bar and click the 2nd icon which will disconnect you from data engine. Now click the 1st icon which will re-connect you, but make sure to copy the 'Server name' this time, then click 'Connect'.
Now having that in hand, you can go back to creating your ODBC and in the 'Server' text input, paste in your server name. Click next since the settings are currently fine. Now in the next part, click on the tick box and select 'GunzDB' from the drop-down menu and click 'Next' and finally click 'Finish'.
If you would like to check your data source, click 'Test Data Source...' in the window or you can just click 'OK' to finish. Now to completely finish it, click 'OK' again.
The DB is the basic thing in server making ifit's wrong u can't make a server.
You must be registered to see links
Follow it and u got it ! By ragezone, thnx if ihelped