Re: Install Northwind SQL Database?

Hi John,
You've got a couple of issues here, the first is getting the network
connectivity set up correctly for Express and the second is getting a data
connection going between Visual Studio and Espress. A .mdf file is a
primary data file and a ldf file is a transaction log file, so given the
information you provided, you've actually got the Northwind and pubs files
you need, you just need to get connected.

[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.

Hang in there, you're almost there. To complete this, from SQL Configuration
Manager, enable and start the SQL Server
Browser. Also stop and start the SQL Express service while you're there.
The following article contains some useful information about SQL Express and
Network connectivity.
(http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sseoverview.asp#sseover_topic6)

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.

SQL Express and the related components you list are installed with Visual
Studio 2005. By itself, SQL Express does not come with a User Interface
tool for creating and using databases. However, you have Visual Studio, so
you can use that to attach the pubs/northwind databases and create your own
databases. Here's the information you need to get going.

From Visual Studio, you need to create a data connection to SQL Express.

1. From the toolbar click Tools, and select Connect to Database. (Or from
Server Explorer, right-click Data Connections and then click Add a
Connection).
2. From Add a Connection, type .\SQLEXPRESS (the period in front of the \
is vital). Click Test Connection to verify the status. It should return a
success message.
3. From Connect to a Database, you can select one of the system databases
from the drop down list, or since you know you want to attach Northwind, you
can also do that now.
4. To attach Northwind, click Attach a database, click Browse and point to
the C:\SQL Server 2000 Sample Databases folder.
5. From Select SQL Server Database Files, select either NORTHWND.MDF or
PUBS.MDF and click OK.
If all has gone well, you should see the Northwind or pubs database in
Server Explorer. You can expand the folder and start poking around.


Books Online and other resources
By default, the SQL Server Books Online (reference documentation) do not
install by default with SQL Express. I strongly recommend that you download
Books Online from here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en .
Books Online has all the conceptual and reference topics you'll need for
creating and modifying the databases you create as well as
creating/modifying the data you want to put in the database.

There's a lot to learn, so you might also want to look at these sites for
getting started information and samples from here.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sse_manmusiccoll.asp
http://msdn2.microsoft.com/en-us/library/5ekc8at3.aspx

Please report back any problems you encounter. Exact error messages are the
most useful.

Good luck. There's a lot to learn, but you sound like you're the type to dig
in and do the reading and experimenting it takes to learn all of this.
--
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:67CED5D8-06C0-4DFF-9E9B-286F34650246@xxxxxxxxxxxxxxxx
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

  • Re: VS 2008 Team - Database not supported / Cant load file or ass
    ... Visual Studio 2008 Team Database Edition ... SQL Server 2005 Enterprise SP2 ... Unable to add data connection. ... Install the following from Microsoft SQL Server 2008 Feature Pack RC0, ...
    (microsoft.public.vstudio.general)
  • Re: Connection to SQL Server from within the emulator - newbie que
    ... 'Personal' edition of SQL Server 2000 installed. ... using the IP address with another application apart from the emulator? ... to install it, then use ipconfig.exe to see what IP address the loopback ... connection but is not plugged into a physical network connection. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Help Please Wit Error
    ... Occasionally I receive the error you are mentioning when the SQL Server ... I have had to completely remove the MDAC and re-install it as well ... see an example of the connection string you are using. ... Please install Microsoft Data Access Components ...
    (microsoft.public.dotnet.csharp.general)
  • Re: Connecting to sql server
    ... I hate Visual Basic .NET Standard. ... > I am trying to get a row of data from a SQL Server on our network. ... > I have gone to tools> connect to databases and set up a connection to ... When I test the connection, ...
    (microsoft.public.dotnet.framework)
  • 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)
Loading