Re: Install Northwind SQL Database?
- From: John Chilson <JohnChilson@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Mar 2006 09:41:02 -0800
Hi Gail,
Thank you for the information! I had an idea that the info you sent was what
I should do, but I didn't want to screw anything up so I needed some
confirmation before I made any changes. The procedure you sent me worked
perfectly, and I am now in business with SQL Server and the Northwind
Database. So many of the walkthroughs, and test examples in my Microsoft
books I've bought are described using the SQL Server to connect to the
databases. Hence, the code used was different than what I could enter using
OLE Jet. It makes everything easier to follow along entering the code and not
having to make any changes. Thank you very much for your help. Thank God for
these community groups because trying to find the information just using the
Help feature in VS2005 is tedious and often fruitless. Once our company (and
myself) get our application completed we will be able to afford a
subscription to Microsoft. Until then this is the only viable resource out
there. Thanks again, and have a wonerful day!
"Gail Erickson [MS]" wrote:
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?
.
- References:
- Re: Install Northwind SQL Database?
- From: Gail Erickson [MS]
- Re: Install Northwind SQL Database?
- From: John Chilson
- Re: Install Northwind SQL Database?
- From: Gail Erickson [MS]
- Re: Install Northwind SQL Database?
- Prev by Date: Cannot install sql 2000 onto WIndows 2003 std
- Next by Date: Re: Collate
- Previous by thread: Re: Install Northwind SQL Database?
- Next by thread: Re: Install Northwind SQL Database?
- Index(es):
Relevant Pages
|
