Can't find AdventureWorksDW

I did see a post from early Oct saying that there would be a link on
msdn to download this.
But I wondered if anyone else has this database and where they found
it. It's used in the AS tutorial.
No one in my shop has seen it -- we've been through the June and Sept
CTP's and now we're on the final release.Have you tried following the installation instructions in the Books Online
topic "Running Setup to Install AdventureWorks Sample Databases and
Samples"?
Alternatively, you can download the sample databases from this site:
http://msdn.microsoft.com/sql/downloads/samples/
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
<jhcorey@.yahoo.com> wrote in message
news:1133188697.921791.84240@.g47g2000cwa.googlegroups.com...
>I did see a post from early Oct saying that there would be a link on
> msdn to download this.
> But I wondered if anyone else has this database and where they found
> it. It's used in the AS tutorial.
> No one in my shop has seen it -- we've been through the June and Sept
> CTP's and now we're on the final release.
>

Can't connect remotely

I installed MSDE SP2 from the MSDN. I can connect to it using sa on the
local machine but can't connect remotely.
If I try telnet xxx.xxx.xxx 1433 it doesn't connect. Not even if I try it
from the local machine as telnet localhost 1433.
The server is Win Web 2003.
Any ideas?
-Joe
Additional info:
I have the following in the setup.ini file:
DISABLENETWORKPROTOCOLS=0
SAPWD="xxx"
SECURITYMODE=SQL
if I run netstat -a on the machine it doesn't show port 1433 to be listening
"Joe" <jbassking@.noemail.noemail> wrote in message
news:elAJsVa0FHA.460@.TK2MSFTNGP15.phx.gbl...
>I installed MSDE SP2 from the MSDN. I can connect to it using sa on the
>local machine but can't connect remotely.
> If I try telnet xxx.xxx.xxx 1433 it doesn't connect. Not even if I try it
> from the local machine as telnet localhost 1433.
> The server is Win Web 2003.
> Any ideas?
> -Joe
>
|||For anyone who reads this...
In order to fix the problem I had to apply a security patch called:
SQLCritUpdPkg_ENU.exe from MS.
It fixed the problem and now I can connect.
"Joe" <jbassking@.noemail.noemail> wrote in message
news:elAJsVa0FHA.460@.TK2MSFTNGP15.phx.gbl...
>I installed MSDE SP2 from the MSDN. I can connect to it using sa on the
>local machine but can't connect remotely.
> If I try telnet xxx.xxx.xxx 1433 it doesn't connect. Not even if I try it
> from the local machine as telnet localhost 1433.
> The server is Win Web 2003.
> Any ideas?
> -Joe
>
|||hi Joe,
Joe wrote:
> For anyone who reads this...
> In order to fix the problem I had to apply a security patch called:
> SQLCritUpdPkg_ENU.exe from MS.
> It fixed the problem and now I can connect.
this is not clear to me... the "fix" you installed is a a kit of security
tools provided in order to fix Slammer vulnerability
(http://www.microsoft.com/downloads/d...displaylang=en)
... all the included fix are already available in sp3/sp3a and sp4, that are
all available for a long time.. but this is another story... and of course
you are invited to apply latest sp (sp4 from
http://www.microsoft.com/sql/downloads/2000/sp4.mspx)..
but again, it's not clear to me what all this has to do with you problem..
can you provide details about what and where you find the information that
guided you to this "solution"?
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I know this doesn't make sense but it worked. I was searching google NGs for
a similar problem and found someone who had the same problem, installed the
update and it fixed his. So, I figured I would give it a shot and it worked
for me as well.
Here's the thread:
http://groups.google.com/group/micro...4514b439a44fd1
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3rev0qFioh2lU1@.individual.net...
> hi Joe,
> Joe wrote:
> this is not clear to me... the "fix" you installed is a a kit of security
> tools provided in order to fix Slammer vulnerability
> (http://www.microsoft.com/downloads/d...displaylang=en)
> ... all the included fix are already available in sp3/sp3a and sp4, that
> are all available for a long time.. but this is another story... and of
> course you are invited to apply latest sp (sp4 from
> http://www.microsoft.com/sql/downloads/2000/sp4.mspx)..
> but again, it's not clear to me what all this has to do with you problem..
> can you provide details about what and where you find the information that
> guided you to this "solution"?
> thank you
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>