Re: Issuses installing MSDE 2000 SP3a on Windows XP SP2
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 10/18/04
- Next message: Andreas: "Please Help!"
- Previous message: Andrea Montanari: "Re: Unable To Launch Enterprise Manager"
- In reply to: Dancer: "Issuses installing MSDE 2000 SP3a on Windows XP SP2"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 18 Oct 2004 19:19:00 +0200
hi,
"Dancer" <REMOVE THISdancer_yard@hotmail.com> ha scritto nel messaggio
news:u4wSXKTtEHA.1216@TK2MSFTNGP10.phx.gbl
>...
>
> I have also tried typing in the instance namely ClientName\VSDOTNET in
> Server drop list within SQL Server Service Manager. The Services
> work when i do this but the setting is not retained when system is
> rebooted.
>
> I have tried switching the firewall back to ON status but that does
> not solve this issue.
>
> ...........
> 1. Anybody know a solution for this issue?
please have a look at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;814132
>
> 2. What are the port settings that I need to open in the firewall and
> how do i do this ?
as you installed a named instance, it will not be listening on standard SQL
Server port, TCP/IP 1433, but usually it's port is dynamically assigned
based on a service listening on UDP 1434 port, which then redirects all
connections to the appropriate assigned port...
you can hae a look at http://support.microsoft.com/default.aspx?kbid=841249
for further info on how configure SQL Server (MSDE) running on Win XP Pro sp
2...
personally I had a test on a virtual machine...
assigned a static port to a named instance (say TCP/IP 666 as I do not have
a Doom server in my Lan =;-D)
closed UDP 1434 port
set exceptions on TCP/IP 666 port for both the subnet mask or specific IP
addresses of my lan
and all worked like a charm..
caveat:
specifying a static port implies that all remote clients have to set an
alias using Client Network Utility (cliconfg.exe) pointing to the specified
666 Doom TCP/IP port
>
> 3. I am planning to program with VS 2003 and need to use the MSDE,
> are there any gremlings to look out for ?
nope, just and advice... MSDE is intended for deployment and not for
development... you can find SQL Server Developer Edition at about $49.00,
which includes all dev tools you'll need to fine tune, troubleshoot and test
you MSDE based applications...
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
- Next message: Andreas: "Please Help!"
- Previous message: Andrea Montanari: "Re: Unable To Launch Enterprise Manager"
- In reply to: Dancer: "Issuses installing MSDE 2000 SP3a on Windows XP SP2"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
