Groups | Blog | Home
all groups > sql server new users > march 2006 >

sql server new users : SQL Server 2005 and MSDE


Serge Myrand
3/17/2006 9:41:41 AM
Hi,

In MS online books for SQL Server 2005 express it is written that (in my
words) there is a possibility of port number confusion when connecting
to the server if MSDE is installed and the MSDE sp3 is not installed.

How to know the last service pack installed?


When googling for MSDE sp3 it leads to SQL Server sp3a. Is it the same
service pack?
Is it the one to install?


thank you in advance
serge
Sue Hoegemeier
3/19/2006 4:55:51 PM
To determine the service pack level, execute: select
@@version
You can check the version against the list here:
http://www.aspfaq.com/show.asp?id=2160

The fixes are the same but the install files are different
for MSDE SP 3 and SQL Server SP 4. You can download SP 3 for
MSDE from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3&DisplayLang=en
The file you want is: SQL2kdesksp3.exe

-Sue

On Fri, 17 Mar 2006 09:41:41 -0400, Serge Myrand
[quoted text, click to view]
Serge Myrand
3/20/2006 1:02:33 PM
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<body text="#000000" bgcolor="#F1E9D9" link="#0000EE" vlink="#551A8B" alink="#FF0000">
&nbsp;
<br>Thank you very much.
<p>serge
[quoted text, click to view]
<blockquote TYPE=CITE>To determine the service pack level, execute: select
<br>@@version
<br>You can check the version against the list here:
<br><a href="http://www.aspfaq.com/show.asp?id=2160">http://www.aspfaq.com/show.asp?id=2160</a>
<p>The fixes are the same but the install files are different
<br>for MSDE SP 3 and SQL Server SP 4. You can download SP 3 for
<br>MSDE from:
<br><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3&DisplayLang=en">http://www.microsoft.com/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3&amp;DisplayLang=en</a>
<br>The file you want is: SQL2kdesksp3.exe
<p>-Sue
<p>On Fri, 17 Mar 2006 09:41:41 -0400, Serge Myrand
[quoted text, click to view]
<p>>Hi,
<br>>
<br>>In MS online books for SQL Server 2005 express it is written that
(in my
<br>>words) there is a possibility of port number confusion when connecting
<br>>to the server if MSDE is installed and the MSDE sp3 is not installed.
<br>>
<br>>How to know the last service pack installed?
<br>>
<br>>
<br>>When googling for MSDE sp3 it leads to SQL Server sp3a. Is it the
same
<br>>service pack?
<br>>Is it the one to install?
<br>>
<br>>
<br>>thank you in advance
<br>>serge</blockquote>

</body>
</html>
AddThis Social Bookmark Button