Re: PHP connecting to MSSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux