I'm running MSDE on Windows 2k Pro, and a netstat reveals that port 1433 (ms-sql-s) *is* open. I haven't done any testing to verify that I can actually connect to it, though.
I also have SQL 7 installed on this box, but only the management components (it wouldn't let me install the SQL7 db server. I don't know if this was because it already found MSDE...?) I'm not sure how you would go about changing the sa password on MSDE, as I've only used it with SQL7 Enterprise Manager... makes administration much easier. Glenn Pearl Lantec, Inc New Orleans, LA [EMAIL PROTECTED] -----Original Message----- From: Dan Irwin [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 6:23 PM To: 'Francois Pepin' Cc: '[EMAIL PROTECTED]' Subject: RE: Stupid MSDE question My Experience: Windows 98 SE2 MSDE (Office 2k Pro CD-ROM) Despite telling MSDE to use TCP/IP, port scans indicated 1433/tcp was closed. As far as i could tell, msde only supported named pipes. I have no idea the effect of the OS in question.. i didnt test MSDE on an NT/2K box, so your mileage may vary. -- Dan Irwin - Systems Administrator Jackie's Wholesale Nurseries Pty Ltd Email: [EMAIL PROTECTED] Phone: 07 3888 2481 Fax: 07 3888 2530 Postal: 10 Gleeson Road Burpengary Queensland 4505 Email: [EMAIL PROTECTED] Web: http://www.jackies.com.au -----Original Message----- From: Francois Pepin [mailto:[EMAIL PROTECTED]] Sent: Monday, 26 November 2001 1:54 PM To: [EMAIL PROTECTED] Subject: Stupid MSDE question Hi, Is there anyone who could tell me if MSDE can be accessed by TCP/IP like MS-SQL (in the view of the recent worm)? If so, is there any way to tell it to change the sa password in it? I tried to find how it is, but I'm far from being a DBA and we need MSDE here (for SharePoint Team Services, and it needs to be accessible from the web). Any information would be very appreciated. Thanks, François
