Re: Install Northwind SQL Database?

Hi Gail,
Thank you for responding. I can't get any help from Microsoft because I
don't have a subscription. I don't see the .mdf and .ldf files. The files in
C:\SQL Server 2000 Sample Databases are: ReadMe SQL Sample Db Scripts, Pubs
Log Transaction, SQL Server Database Primary Data File for Pubs, Northwind
LogTransaction, SQL Server Database Primary File for Northwind, instPubs SQL
File, instnwnd SQL File. I followed the instructions in the readme file for
installing the databases. I don't see SQL Query Analyzer in my list of tools
or programs for SQL Server 2005. So, I followed instructions for attaching
the Pre-built Files by Using osql to attach the Northwind database to a
default instance on the same computer. I receive this error message:

[SQL Native client] Named Ppes Provide: Could not open a connection to SQl
Server[2]. [SQL Native client] Login timeout expired. [SQL Native client]
Error connecting to SQL Server 2005 under default settings SQL Server does
not allow remote connections, Error 40.

I opend the SQL Configuration manager, and under the services it said SQL
Server 2005 Express is running and SQL Server browser is stopped. The SQL
Server Express Protocols had Shared memory enabled only. So, I enabled the
named pipes to see if that helped and it didn't. In the SQL Native Clients
(32 bit); Shared memory, TCP|IP, Named Pipes are all enabled. I am working
with Windows XP Professional, a Dell Precision 670 Workstation 64 bit OS and
using Visual Studio 2005 Professional, coding in Visual Basic 2005. I am not
sure if all of the needed components are installed or not. In my installed
programs list for SQL 2005 I have SQL Server 2005, Native Client, Mobile
[EDU] Developer Tools, SetUp Support (English), VSS Writer. I don't know if I
should try unistalling SQL Server 2005, or put my disc in and try to install
some components or what. I've looked in Microsoft's website and did a
practice install on a virtual machine. I have printed out instructions on how
to install SQL Server 2005 and read alot of information on some issues
regarding SQL Server 2005. I hope this is enough information to help you
understand my problem. I really, really, hope you can help me. It is probably
something very easy and stupid on my part. I am brand new to the programming
environment. I started using this computer and software after the first week
of January this year. I am trying to develop an application that works with
credit companies info for credit scores, and automobile trade values of
customers of the car sales industry. Thank you again for any help you may
offer.

John Chilson

"Gail Erickson [MS]" wrote:

I went to the download center and downloaded Northwind and Pubs database
scripts but I can't open them

More information is needed please.
What does "I can't open them" mean? Were you successful in extracting the
files? That is, can you see the install scripts and .mdf and .ldf files for
the databases in C:\SQL Server 2000 Sample Databases (or where ever you
downloaded the files too?)?

Did you try to follow the instructions in the readme to either run the
install scripts or attached the databases and get an error? If so, what is
the error?
It would also be helpful to know what version of SQL Server you're using.
SQL Server 2000, SQL Server 2005, SQL Server 2005 Express, etc.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

"John Chilson" <JohnChilson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3347273E-20E7-468B-9BE5-2321E3345F65@xxxxxxxxxxxxxxxx
I went to the download center and downloaded Northwind and Pubs database
scripts but I can't open them. I'm not sure what to do. Can anyone help?



.

Relevant Pages

  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)
  • Re: No Local instance with SQLServer2005 Dev. Ed.
    ... On a 2nd test box I have Sql Server 2005 Developer Edition ... Server box successfully on our network. ... thought I could install SQLServer Express to get my local databases to ...
    (comp.databases.ms-sqlserver)
  • Re: Critical Alert Update - W32.Slammer
    ... The .net SDK 1.0 sp1 comes with a very basic SQL Server engine for testing ... >> Microsoft SQL Desktop ... >>>cumulative SQL security patch, is completely safe from ... >> may install SQL ...
    (microsoft.public.security)
  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)
  • Re: How to generate SQL server script programmatically?
    ... Do you know any Java solution for this? ... > Looking for a SQL Server replication book? ... The install package basically will consist of scripts ... >> every objects in the databases, like all the tables, stored procedures, ...
    (microsoft.public.sqlserver.server)
Quantcast