6 replies
by hal 9000
This site should give you the answers in a better manner that I can type them in.
http://www.microsoft.com/technet/prodtechnol/isa/2004/help/CMT_H_Install.mspx?mfr=true
Col
by ksa54321
by cg it
my question is what does MSDE [the desktop version of SQL server] have to do with installing ISA server 2004. ISA Server is Firewall/proxy server which can be installed as a stand alone Firewall/proxy server at the perimeter of a network or in a cluster of ISA Servers[for large Enterprises]that protect many nodes.
It doesn't need MSDE [desktop SQL] for installation.
So is your question a 2 part question? #1 How to install ISA Server 2004 and #2 why or what would cause MSDE not to install?
by cg it
by cg it
by peter.levin
Most likely the problem is caused by a port conflict. SQL Server uses port 1433 by default, the same as MSDE. If MSDE starts up first, it will bind to 1433, preventing SQL Server from doing so. This will result in a non-bind for SQL Server. This can be a bit tricky to see, as the services on the local computer where SQL Server is installed work normally as they will use named pipes, in contrast to TCP/IP.
To work around this, assign another port to SQL Server, e.g. 2433. You do that by using the Enterprise tool, add the server (on the local machine) open properties and click Network configuration. Change TCP/IP to 2433. Then you have to use the Client configuration tool on the clients to se the port to 2433 and you are up an running. If you use ISA server, you have to make new SQL protocolls to match the newport number.
If you look in the Event log you will most likely see the complaint that SQL server can't bind to the port. A good idea is to configure the report tool of SBS to send you a report every day and closely look on any critical error or notice in the event log.
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending