SQL Server Performance Forum – Threads Archive

SQL2kdesksp3

I have SQL-Server 2000 and I have run sql2ksp3.exe. Do I need to run SQL2kdesksp3.exe, too?
Farhad R
[email protected]

---

Sql2ksp3.exe – Updates for database components.
Sql2kdesksp3.exe- Updates for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000). Not required as SP3 for current SQL server has been applied. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Hey Satya, What’s usage of MSDE? Is it on SQL Server CDs and we install it? Thanks,

Farhad R
[email protected]

---

In MS terms :
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, redistributable version of SQL Server that#%92s ideal for client applications that require an embedded database, new developers learning how to build data-driven applications, and Web sites serving up to 25 concurrent users.
http://www.microsoft.com/sql/msde/default.asp for more information. Yes CD will have the installation, and BOL refers to install:
Open a command prompt window From the command prompt, use the cd command to navigate to the folder containing the MSDE 2000 SP3a setup utility:
cd c:MSDESP3aFolderMSDE where c:MSDESP3aFolder is either the path to the folder into which you extracted the MSDE 2000 SP3a files, or the Desktop Engine SP3a folder on the SQL Server 2000 SP3a CD. Execute one of the following commands:
To install a default instance configured to use Windows Authentication Mode, execute:
setup SAPWD="AStrongSAPwd"
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>