MSSQL? How do I use it?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MSSQL? How do I use it?

Postby aldo » 17. July 2008 08:12

Sorry if this question has been asked numerous times before, but I have XAMPP installed, how do I create an MSSQL database? :oops:
aldo
 
Posts: 13
Joined: 17. July 2008 08:10

Postby LooseCannon » 17. July 2008 12:48

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! :P

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

An alternative: SQLyog - http://www.webyog.com
User avatar
LooseCannon
 
Posts: 162
Joined: 18. September 2007 12:07
Location: Hampshire, UK

Postby Wiedmann » 17. July 2008 13:03

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).
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby aldo » 17. July 2008 18:41

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!
aldo
 
Posts: 13
Joined: 17. July 2008 08:10

Postby Nobbie » 17. July 2008 20:55

>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.
Nobbie
 
Posts: 8775
Joined: 09. March 2008 13:04

Postby LooseCannon » 18. July 2008 10:23

Ah! MS.... :oops:
User avatar
LooseCannon
 
Posts: 162
Joined: 18. September 2007 12:07
Location: Hampshire, UK

Postby das7002 » 19. July 2008 19:43

What another reason to love MySQL and PostgreSQL so much easier :lol:
das7002
 
Posts: 3
Joined: 18. July 2008 21:21


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 80 guests