Newbie Spellweaver
- Joined
- Aug 24, 2007
- Messages
- 66
- Reaction score
- 3
I found myself falling down over a couple things while setting up my server on a dedicated server. Most of the thing where already posted on ragezone but not really awnserd clearly, thats why I decided to make this guide. This guide is for most Windows 2003 Servers
I will divide this guide in 3 parts:
- Website/xampp
- Mssql2005/odbc
- Connecting/ports
We start off with a list of the things you need:
- Microsoft SQL Server 2005 Express Edition
- SQL Server Management Studio Express http://go.microsoft.com/fwlink/?linkid=65110
- Xampp http://www.apachefriends.org/en/xampp.html
- xampp fix
- Your own server/website files
WEBSITE/XAMPP
Step 1: Shutting down standard webserver.
Start --> Programs --> Administrative Tools --> IIS Manager
Open the local computer tab, and open the web sites tab.
Now rightclick Default SMTP Virtual Server and stop it,
do the same for all websites.
Step 2: Install Xampp
This shouldn't be to hard, you can install it with your own preferences.
Replace the ntwdblib.dll (xampp fix) in Xampp/php/ and in xampp/apache/bin/
Now start/restart xampp and make sure apache is running.
Step 3: Website
Open htdocs in your xampp and delete all files. Now put your webfiles in it.
You might want to rename your phpmyadmin folder in xampp to something like nfc75t8nf5mt7yn7fm7nny5m7 for security issues.
MSSQL2005/ODBC
Step 1: Installing
Install Microsoft SQL Server 2005 Express Edition and make sure you set an password.
Install SQL Server Management Studio Express
Step 2: Setting up Databases
You will see that you can logonto the database with 2 different accounts:
- Administrator (without password)
- Sa, with the password you set.
Now open SQL management studio, and connect.
Rightclick database and click new database. Put in kal_auth and click on OK.
Do the same only then name it kal_db.
Next open the database tab and rightclick kal_auth --> tasks --> restore --> database
Select "From device" and hit the ... behind it. Next click add and locate your kal_auth database.
Once you have done that close screens until youget back to the restore database screen. Go to Options,
click "overwrite existing database" and you might wanna set another path for your databases(optional)
Note: If you cannot select your database or get an error, close the sql manager. Start-->programs-->SqlManager, right click it
Properties --> security tab. Here just give access to everyone until you setup the database.
Step 3: ODBC
Start --> Programs --> administrative Tools --> ODBC
Go to the system DSN tab and click on add.
Select SQL Server, name: kal_auth optional description and server: PCNAME\SQLEXPRESS (you can see this when you start sql server manager)
Click next, and next again. Here you tick the "Change the default database to" and select kal_auth. Hit next until your done.
Next do the same for Kal_db.
CONNECTING/PORTS
Start --> Settings --> network connections --> rightclick local Area network (the one connected) --> Properties --> Internet Protocol --> Properties --> Advanced --> Options TAB --> click TCP/IP Filtering --> Properties --> Enable TCP/IP Filtering --> Add --> TCP PORT: 30001 and 50003(update server) and 80 if not already in.
Close all screens.
Start --> Settings --> Control panel --> Firewall --> click ON --> Exeptions TAB --> Add PORTS 30001 and 80 (50003)
Close All screens again, you might have to restart the server now.
In your website you can connect with $connect = mssql_connect('PCNAME\SQLEXPRESS','sa','yoursetpwd') or die('Wrong Info');
If you start your kal servers you probably get an firewall popup, click on Allow or something like that when it appears.
This should do the trick.
TimmeY
I will divide this guide in 3 parts:
- Website/xampp
- Mssql2005/odbc
- Connecting/ports
We start off with a list of the things you need:
- Microsoft SQL Server 2005 Express Edition
You must be registered to see links
- SQL Server Management Studio Express http://go.microsoft.com/fwlink/?linkid=65110
- Xampp http://www.apachefriends.org/en/xampp.html
- xampp fix
You must be registered to see links
- Your own server/website files
WEBSITE/XAMPP
Step 1: Shutting down standard webserver.
Start --> Programs --> Administrative Tools --> IIS Manager
Open the local computer tab, and open the web sites tab.
Now rightclick Default SMTP Virtual Server and stop it,
do the same for all websites.
Step 2: Install Xampp
This shouldn't be to hard, you can install it with your own preferences.
Replace the ntwdblib.dll (xampp fix) in Xampp/php/ and in xampp/apache/bin/
Now start/restart xampp and make sure apache is running.
Step 3: Website
Open htdocs in your xampp and delete all files. Now put your webfiles in it.
You might want to rename your phpmyadmin folder in xampp to something like nfc75t8nf5mt7yn7fm7nny5m7 for security issues.
MSSQL2005/ODBC
Step 1: Installing
Install Microsoft SQL Server 2005 Express Edition and make sure you set an password.
Install SQL Server Management Studio Express
Step 2: Setting up Databases
You will see that you can logonto the database with 2 different accounts:
- Administrator (without password)
- Sa, with the password you set.
Now open SQL management studio, and connect.
Rightclick database and click new database. Put in kal_auth and click on OK.
Do the same only then name it kal_db.
Next open the database tab and rightclick kal_auth --> tasks --> restore --> database
Select "From device" and hit the ... behind it. Next click add and locate your kal_auth database.
Once you have done that close screens until youget back to the restore database screen. Go to Options,
click "overwrite existing database" and you might wanna set another path for your databases(optional)
Note: If you cannot select your database or get an error, close the sql manager. Start-->programs-->SqlManager, right click it
Properties --> security tab. Here just give access to everyone until you setup the database.
Step 3: ODBC
Start --> Programs --> administrative Tools --> ODBC
Go to the system DSN tab and click on add.
Select SQL Server, name: kal_auth optional description and server: PCNAME\SQLEXPRESS (you can see this when you start sql server manager)
Click next, and next again. Here you tick the "Change the default database to" and select kal_auth. Hit next until your done.
Next do the same for Kal_db.
CONNECTING/PORTS
Start --> Settings --> network connections --> rightclick local Area network (the one connected) --> Properties --> Internet Protocol --> Properties --> Advanced --> Options TAB --> click TCP/IP Filtering --> Properties --> Enable TCP/IP Filtering --> Add --> TCP PORT: 30001 and 50003(update server) and 80 if not already in.
Close all screens.
Start --> Settings --> Control panel --> Firewall --> click ON --> Exeptions TAB --> Add PORTS 30001 and 80 (50003)
Close All screens again, you might have to restart the server now.
In your website you can connect with $connect = mssql_connect('PCNAME\SQLEXPRESS','sa','yoursetpwd') or die('Wrong Info');
If you start your kal servers you probably get an firewall popup, click on Allow or something like that when it appears.
This should do the trick.
TimmeY
Last edited:
tho xampp O.O I find it suxs an Abyss Web Server is way better than xampp.
