Coolskool : Kola Oyedeji's Cool Technology Blog
Installing MSDE for use with CFMX
posted Tuesday, 19 July 2005
For some reason, everytime I set up a new machine with SQL server - MSDE I forget something so I'm jotting some rough notes down here.
1. Download MSDE
2. Edit setup.ini, enter the following values:
[Options]
INSTANCENAME="myInstanceName"
TARGETDIR="C:\myInstanceNameFolder"
SAPWD="somePassword"
SECURITYMODE=SQL
(note if accessing it across the network also include the following line to enable network support as it is disabled by default)
DISABLENETWORKPROTOCOLS=0
3. Run setup at the command line with the following:
setup /settings "setup.ini" /L*v setuplog.log
4. Check setuplog.log to ensure installation completed succsessfully
5. Go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn and run the SVRNETCN.exe tool. This tool allows you
to change the port number if required by selecting the 'hide server' checkbox for the instance. Ensure that named pipes and TCP/IP are enabled for the instance respectively.
6. Finally, go into the coldfusion administrator and enter the datasource details. Where prompted to
enter a server name, enter: ipaddress\\instanceName as shown in the SVRNETCN utility.
Oh and if using XP SP2 remember to ensure that the firewall isn't blocking anything
One other thing I forgot to mention, if running locally - when registering the server you will need to enter (local) in brackets: i.e. (local)\instancename
1. Download MSDE
2. Edit setup.ini, enter the following values:
[Options]
INSTANCENAME="myInstanceName"
TARGETDIR="C:\myInstanceNameFolder"
SAPWD="somePassword"
SECURITYMODE=SQL
(note if accessing it across the network also include the following line to enable network support as it is disabled by default)
DISABLENETWORKPROTOCOLS=0
3. Run setup at the command line with the following:
setup /settings "setup.ini" /L*v setuplog.log
4. Check setuplog.log to ensure installation completed succsessfully
5. Go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn and run the SVRNETCN.exe tool. This tool allows you
to change the port number if required by selecting the 'hide server' checkbox for the instance. Ensure that named pipes and TCP/IP are enabled for the instance respectively.
6. Finally, go into the coldfusion administrator and enter the datasource details. Where prompted to
enter a server name, enter: ipaddress\\instanceName as shown in the SVRNETCN utility.
Oh and if using XP SP2 remember to ensure that the firewall isn't blocking anything
One other thing I forgot to mention, if running locally - when registering the server you will need to enter (local) in brackets: i.e. (local)\instancename
comments