Re: PHP connecting to MSSQL
| From: | Sascha Meyer | Date: | Mon, 30 Mar 2009 17:16:54 +0000 |
| Subject: | Re: PHP connecting to MSSQL | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-29231@lists.php.net to get a copy of this message | ||
Hi Alf,
your local SQL Server is probably listening on another port ... perhaps you could try the following
in a DOS prompt:
netstat
and
netstat -n
The first should give you all open local ports with descriptions to the port if a default port was
used. The second will give you all open ports with port numbers instead of protocol names. This
could help you check if your server is listening on another port.
Alf wrote:
> BTW How can I reinstall MSSQL without loosing existing databases?
You can export your local databases on various ways before reinstalling, i.e.:
a) use the osql (located in MSDE's binn folder) command tool from MSDE (or MSSQL Server
Editions)
http://www.rs-freeware.org/osql/#dumping
b) Copy your data Dir (could be "C:\Program Files\Microsoft SQL Server\MSSQL\Data") and
attach the database to a full MS SQL Server
c) Install MS SQL Server Client Connectivity and connect to your database
Good luck!
Regards, Sascha
--
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger01