Tuesday, July 31, 2018
Installing SQL Tools on Windows Web Server
Installing SQL Tools on Windows Web Server
If you tried to install SQL Client tools on your Windows 2003 Web Server edition you would have get an error says "Windows cannot open the program since it has been disabled". Because install SQL 2000 Server is not supported on Web Server edition of Windows Server. Even if you just want to install Client Tools, when you run sqlcli.bat from command prompt windows will say you the specified file is not exist or it couldnt find for the setup.sql exe.
But you can install and use SQL 2005s or 2008s Express Editions Management Tool Studio. Because as you can install MSDE on a Windows Server 2003 Web Edition , new Express Edition family can be installed.
You can download just management tool installation file from this link http://go.microsoft.com/fwlink/?linkid=65110
This setup will install SQL 2005 Express Edition Management Tool Studio which will allow you to administer old MSDE databases as well.
You can find more detail about SQL 2005 Express at : http://www.microsoft.com/express/2005/sql/download/default.aspx