Apache Friends Support Forum

Sorry if this question has been asked numerous times before, but I have XAMPP installed, how do I create an MSSQL database?

Hello and welcome aldo.

XAMPP comes bundled with phpMyAdmin, with which you can create/delete databases, users and import/export data etc etc.

Get to this by starting Apache and MySQL and the either:
- press the Admin button on the XAMPP Control Panel Application, then on the welcome page, take the Tools / phpMyAdmin link, or
- type http://localhost/phpmyadmin/ into your browser

Not that the initial root password is blank/empty.

You could also work on MySQL via the command prompt. Yuk!

http://www.phpmyadmin.net/
http://dev.mysql.com/

An alternative: SQLyog - http://www.webyog.com

how do I create an MSSQL database?

You really mean "MSSQL"?

For PHP you have to enable the extension "php_mssql.dll" in "php.ini".

And about your main question:
IMHO there is an admin tool for the Microsoft SQL server (SQL Server Management Studio).

Yeah, I mean MSSQL.

So I enabled that (php_mssql.dll) in the php.ini in the apache folder, restarted Apache, and it is now in the PHP Info...

So, I have another question, whats the default MSSQL user? Or do I need to use that MSSQL Manager, if so, what would the "host" be? Thanks!

>So, I have another question, whats the default MSSQL user?

There is neither "default MSSQL user" nor any MSSQL Database, as Xampp comes without any MSSQL Data.

It *all* depends on your local MSSQL installation.

Ah! MS....

What another reason to love MySQL and PostgreSQL so much easier