What you need:
1. MSSQL 2005 Express Edition
2. SQL Server Management Studio Express
3. Server files
4. DB files to match the SQL version u are using.
5. Client
Step 1: Setup the Database and ODBC.
1) to setup db look at pictures below. NOTE When restoring Database insted of clicking Restore, Right click GunzDB, click "New Query" and drag the GunzDB.sql to the the blank window and then press F5
2) To setup the ODBC click Start -> Run and put in odbcad32. ok now a window should pop up
named
Code:
"ODBC Data Source Adminstrator"
If you see that then you got it if not go to Control
Panel -> Adminstrative Tools ( if you get the "Pick a category" window click "Performance
and Maintenance") -> Data Sources (ODBC). Ok so now you see the Tabs at the top where it
says
Code:
"User DSN, System DSN, File DSN"
it doesnt really matter what one you pick but lets go
with now click Add. Now a window should pop up and the name of that window
should be
Code:
"Create New Data Source"
In the Select box pick then click Finish.
now there should be a pop up with 3 text boxes. in the one named "Name" put "GunzDB", dont
put anything in the "Description" box and in the box named "Server" click the arrow and
look for your server name. if it doesnt come up in the box, open "SQL Server Management
Studio Express" and copy the "Server Name" Box from there. Click "Next" Now make sure that
the "With SQL Server authentication using a login ID and password entered by the user." is
checked. then put in the login and password at the bottem then hit next. now check "Change
the defult database to" and select the Gunz DB. then hit Next then Finished. and then your
done. But Click "Test Data Source" to make sure it works. the pictures are bellow.
heres the rest of the pic's.
![[Tutorial] How to setup Server with pictures](http://ragezone.com/hyper728.png)
Originally Posted by HaruKisa
