MSDE patching

If I do a windows update, would MSDE get updated along with it or should I
download MSDE patches separately?
Thanks,
hi,
sai wrote:
> If I do a windows update, would MSDE get updated along with it or
> should I download MSDE patches separately?
>
at the moment, Windows Update does not provide a SQL Server/MSDE update
too... you have to manually install all required available service packs/hot
fixes..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Installation error message

Thanks in advance for any assistance. I am trying to install a defaul instance of MSDE server on a 2003 Standard server. I have installed and updated MDAC 2.8. I have searched this forum and searched the web for clues. Any help would be appreciated.
Thanks
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
Specified driver could not be loaded due to system error 126 (sql server).
driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
Specified driver could not be loaded due to system error 126 (sql server).
driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
Specified driver could not be loaded due to system error 126 (sql server).
SQL Server configuration failed.
################################################## #############################
126 translates to "module not found" (OS error - NET HELPMSG gets). Maybe a
missing / mismatched DLL
1. I would recommend running the MDAC Compnent Checker as per
http://www.microsoft.com/downloads/d...displaylang=en
2. Maybe check for exisitance of SQLSRV32.dll (SQL ODBC Driver) in
WINDOWS\SYSTEM32
and also run DEPENDS.exe on the SQLSRV32.dll to see if its missing any
modules(Dll's) it needs - in various Resource kits but also here
http://www.dependencywalker.com/
3. Check registry to see if
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server\ Driver and Setup
keys point at the right DLL in System32
cheers.
Andy.
"IseriesBuff" <IseriesBuff@.discussions.microsoft.com> wrote in message
news:7CFCD995-CF88-4D83-8324-6BA6D52BE297@.microsoft.com...
> Thanks in advance for any assistance. I am trying to install a defaul
instance of MSDE server on a 2003 Standard server. I have installed and
updated MDAC 2.8. I have searched this forum and searched the web for
clues. Any help would be appreciated. Thanks
>
################################################## ##########################
###
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
> Specified driver could not be loaded due to system error 126 (sql
server).
> driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
> Specified driver could not be loaded due to system error 126 (sql
server).
> driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
> Specified driver could not be loaded due to system error 126 (sql
server).
> SQL Server configuration failed.
>
################################################## ##########################
###

MSDE Installation error message

Thanks in advance for any assistance. I am trying to install a defaul insta
nce of MSDE server on a 2003 Standard server. I have installed and updated
MDAC 2.8. I have searched this forum and searched the web for clues. Any h
elp would be appreciated.
Thanks
########################################
####################################
###
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=SVRDC1;UID=sa;PWD=;databa
se=master
Specified driver could not be loaded due to system error 126 (sql server).
driver={sql server};server=SVRDC1;UID=sa;PWD=;databa
se=master
Specified driver could not be loaded due to system error 126 (sql server).
driver={sql server};server=SVRDC1;UID=sa;PWD=;databa
se=master
Specified driver could not be loaded due to system error 126 (sql server).
SQL Server configuration failed.
########################################
####################################
###126 translates to "module not found" (OS error - NET HELPMSG gets). Maybe a
missing / mismatched DLL
1. I would recommend running the MDAC Compnent Checker as per
4332ef092c9&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en
2. Maybe check for exisitance of SQLSRV32.dll (SQL ODBC Driver) in
WINDOWS\SYSTEM32
and also run DEPENDS.exe on the SQLSRV32.dll to see if its missing any
modules(Dll's) it needs - in various Resource kits but also here
http://www.dependencywalker.com/
3. Check registry to see if
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINS
T.INI\SQL Server\ Driver and Setup
keys point at the right DLL in System32
cheers.
Andy.
"IseriesBuff" <IseriesBuff@.discussions.microsoft.com> wrote in message
news:7CFCD995-CF88-4D83-8324-6BA6D52BE297@.microsoft.com...
> Thanks in advance for any assistance. I am trying to install a defaul
instance of MSDE server on a 2003 Standard server. I have installed and
updated MDAC 2.8. I have searched this forum and searched the web for
clues. Any help would be appreciated. Thanks
>
########################################
####################################
###
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=SVRDC1;UID=sa;PWD=;databa
se=master
> Specified driver could not be loaded due to system error 126 (sql
server).
> driver={sql server};server=SVRDC1;UID=sa;PWD=;databa
se=master
> Specified driver could not be loaded due to system error 126 (sql
server).
> driver={sql server};server=SVRDC1;UID=sa;PWD=;databa
se=master
> Specified driver could not be loaded due to system error 126 (sql
server).
> SQL Server configuration failed.
>
########################################
####################################
###

MSDE Installation error message

Thanks in advance for any assistance. I am trying to install a defaul instance of MSDE server on a 2003 Standard server. I have installed and updated MDAC 2.8. I have searched this forum and searched the web for clues. Any help would be appreciated. Thanks
###############################################################################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
Specified driver could not be loaded due to system error 126 (sql server).
driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
Specified driver could not be loaded due to system error 126 (sql server).
driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
Specified driver could not be loaded due to system error 126 (sql server).
SQL Server configuration failed.
###############################################################################126 translates to "module not found" (OS error - NET HELPMSG gets). Maybe a
missing / mismatched DLL
1. I would recommend running the MDAC Compnent Checker as per
http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en
2. Maybe check for exisitance of SQLSRV32.dll (SQL ODBC Driver) in
WINDOWS\SYSTEM32
and also run DEPENDS.exe on the SQLSRV32.dll to see if its missing any
modules(Dll's) it needs - in various Resource kits but also here
http://www.dependencywalker.com/
3. Check registry to see if
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server\ Driver and Setup
keys point at the right DLL in System32
cheers.
Andy.
"IseriesBuff" <IseriesBuff@.discussions.microsoft.com> wrote in message
news:7CFCD995-CF88-4D83-8324-6BA6D52BE297@.microsoft.com...
> Thanks in advance for any assistance. I am trying to install a defaul
instance of MSDE server on a 2003 Standard server. I have installed and
updated MDAC 2.8. I have searched this forum and searched the web for
clues. Any help would be appreciated. Thanks
>
############################################################################
###
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
> Specified driver could not be loaded due to system error 126 (sql
server).
> driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
> Specified driver could not be loaded due to system error 126 (sql
server).
> driver={sql server};server=SVRDC1;UID=sa;PWD=;database=master
> Specified driver could not be loaded due to system error 126 (sql
server).
> SQL Server configuration failed.
>
############################################################################
###