|
Home > Archive > microsoft.public.cert.mcdba > September 2003 > How to get the sample data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to get the sample data
|
|
| EVELYN 2003-09-14, 8:27 pm |
| Hi, all,
I download the SQL 2000 server evaluation version to practice. How do I get data to practice?
Thanks
Eve
| |
| Ray Higdon 2003-09-15, 6:28 am |
| You have the Northwind and Pubs sample databases to work with.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
---
"EVELYN" <tzuching@email.uophx.edu> wrote in message news:%23onGBvxeDHA.1748@TK2MSFTNGP10.phx.gbl...
Hi, all,
I download the SQL 2000 server evaluation version to practice. How do I get data to practice?
Thanks
Eve
| |
| EVELYN 2003-09-15, 8:26 pm |
| Thanks, Ray,
Sorry, I may be not be there it. Yes, there is Northwind in my personal PC.
But how I connect to it? What is the step to get the sample database to work with?
Import the data from Northwind? Set up a service?
--------------------------------------------------------------------------------
Evelyn Arpino
"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message news:%23Fkfxq2eDHA.2172@TK2MSFTNGP09.phx.gbl...
You have the Northwind and Pubs sample databases to work with.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
---
"EVELYN" <tzuching@email.uophx.edu> wrote in message news:%23onGBvxeDHA.1748@TK2MSFTNGP10.phx.gbl...
Hi, all,
I download the SQL 2000 server evaluation version to practice. How do I get data to practice?
Thanks
Eve
| |
| Ray Higdon 2003-09-15, 9:27 pm |
| I'm not sure I understand what you mean. Go to start menu
\programs\Microsoft SQL server\enterprise manager
That is your graphical tool for SQL Server. From there you can navigate
down to databases and should see Northwind and Pubs.
GL
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| EVELYN 2003-09-16, 8:25 pm |
| Ray,
Apparently the connection to the SQL Server fail. How do I connect to the NorthWind database in my own PC?
--------------------------------------------------------------------------------
Evelyn Arpino
"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message news:ONNQev%23eDHA.3248@tk2msftngp13.phx.gbl...
I'm not sure I understand what you mean. Go to start menu
\programs\Microsoft SQL server\enterprise manager
That is your graphical tool for SQL Server. From there you can navigate
down to databases and should see Northwind and Pubs.
GL
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| Ray Higdon 2003-09-17, 6:24 am |
| Guess I assume you had the evaluation edition installed on your machine.
Sounds like you have it installed on a remote machine. You might install
the client tools on your local machine and access SQL Server that way.
When you go to install you will have an option for client tools only.
HTH
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| Rick Byham, Microsoft Learning 2003-09-17, 12:24 pm |
| Perhaps your SQL Server service is not started. Do you have a green circle
with a white triangle showing for your server in SQL Server Enterprise
Manger? If not right-click the server name and then click Start.
--
Rick Byham (Microsoft Learning)
This posting is provided "as is" with
no warranties, and confers no rights.
"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message
news:%23WnqB7PfDHA.3204@TK2MSFTNGP11.phx.gbl...
> Guess I assume you had the evaluation edition installed on your machine.
> Sounds like you have it installed on a remote machine. You might install
> the client tools on your local machine and access SQL Server that way.
> When you go to install you will have an option for client tools only.
>
> HTH
>
> Ray Higdon MCSE, MCDBA, CCNA
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
| |
| Davin Mickelson 2003-09-17, 5:24 pm |
| I suspect Evelyn was trying to connect to the Access version of the
Northwind database.
I believe Evelyn thinks that SQL databases are separate files that you
connect to from SQL.
These are just guesses on my part based on the person's responses.
Davin Mickelson
"EVELYN" <tzuching@email.uophx.edu> wrote in message
news:eW7So8KfDHA.2356@TK2MSFTNGP12.phx.gbl...
Ray,
Apparently the connection to the SQL Server fail. How do I connect to the
NorthWind database in my own PC?
Evelyn Arpino
"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message
news:ONNQev%23eDHA.3248@tk2msftngp13.phx.gbl...
I'm not sure I understand what you mean. Go to start menu
\programs\Microsoft SQL server\enterprise manager
That is your graphical tool for SQL Server. From there you can navigate
down to databases and should see Northwind and Pubs.
GL
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| EVELYN 2003-09-17, 9:24 pm |
| Thanks to Ray and Rick,
The SQL server is red, but it is not Local.
Ray may be right about remote machine, however, I install in my local machine.
I did the same in the XP Home Edition machine at home, and the service engine cannot starts it.
I did the same in the XP profession version at work, and the service engine works, also I can find the Northwind database.
Can XP Home Edition cannot work with SQL 2000 server? Or I really install it wrong? If so, I should uninstall and reinstall again?
--------------------------------------------------------------------------------
Evelyn Arpino
"Rick Byham, Microsoft Learning" <rickbyh@microsoft.com> wrote in message news:%23SxBIPTfDHA.2320@TK2MSFTNGP12.phx.gbl...
Perhaps your SQL Server service is not started. Do you have a green circle
with a white triangle showing for your server in SQL Server Enterprise
Manger? If not right-click the server name and then click Start.
--
Rick Byham (Microsoft Learning)
This posting is provided "as is" with
no warranties, and confers no rights.
"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message
news:%23WnqB7PfDHA.3204@TK2MSFTNGP11.phx.gbl...
> Guess I assume you had the evaluation edition installed on your machine.
> Sounds like you have it installed on a remote machine. You might install
> the client tools on your local machine and access SQL Server that way.
> When you go to install you will have an option for client tools only.
>
> HTH
>
> Ray Higdon MCSE, MCDBA, CCNA
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
| |
| EVELYN 2003-09-17, 9:24 pm |
| Davin,
I thought that from "SQL Server Enterprise Manager", I should be able to connect to SQL server group with Service Engine. I am not able to connect any service engine. I don't know if my installation is wrong or it is XP home edition.
Thanks
--------------------------------------------------------------------------------
Evelyn Arpino
"Davin Mickelson" <corkwatchr@hotmail.com> wrote in message news:O0tuh9VfDHA.556@TK2MSFTNGP11.phx.gbl...
I suspect Evelyn was trying to connect to the Access version of the
Northwind database.
I believe Evelyn thinks that SQL databases are separate files that you
connect to from SQL.
These are just guesses on my part based on the person's responses.
Davin Mickelson
"EVELYN" <tzuching@email.uophx.edu> wrote in message
news:eW7So8KfDHA.2356@TK2MSFTNGP12.phx.gbl...
Ray,
Apparently the connection to the SQL Server fail. How do I connect to the
NorthWind database in my own PC?
Evelyn Arpino
"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message
news:ONNQev%23eDHA.3248@tk2msftngp13.phx.gbl...
I'm not sure I understand what you mean. Go to start menu
\programs\Microsoft SQL server\enterprise manager
That is your graphical tool for SQL Server. From there you can navigate
down to databases and should see Northwind and Pubs.
GL
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
|
|
| EVELYN 2003-09-18, 9:24 pm |
| Ray,
When I register SQL Service at Windows XP home, the only choice is my own Local machine. So I register it accordingly. However, the message shows "SQL server does not exist or access denied".
Please note that I have no problem to register at Windows Enterprise at work. I think that I know how and follow the exact procedure.
I am wondering if the service account or any setting at my computer needs to be changed.
Originally, I have a MSDE service engine in my XP HOME machine. I uninstall it and then install the SQL Developer version and set as "Server and Client" tool. I still cannot register any Server
--------------------------------------------------------------------------------
Evelyn Arpino
"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message news:%23bSHrTYfDHA.3204@TK2MSFTNGP11.phx.gbl...
SQL personal and developer edition work fine with Windows XP home. You
can use enterprise mgr to connect to other SQL machines by registering
them.
Maybe this page will help
http://msdn.microsoft.com/library/d...y/en-us/howtosq
l/ht_servpem_7jua.asp
HTH
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| EVELYN 2003-09-18, 10:24 pm |
| Hi, Ray and all,
I finally got it. I disable the Norton Firewall temporarily and is able to connect to my machine. Thanks for encouraging to confirm that Windows XP home edition indeed works.
I at least install/reinstall more than 10 times and isolate all possible things.
Thanks
--------------------------------------------------------------------------------
Evelyn Arpino
"EVELYN" <tzuching@email.uophx.edu> wrote in message news:uAXJ$UkfDHA.2172@TK2MSFTNGP09.phx.gbl...
Ray,
When I register SQL Service at Windows XP home, the only choice is my own Local machine. So I register it accordingly. However, the message shows "SQL server does not exist or access denied".
Please note that I have no problem to register at Windows Enterprise at work. I think that I know how and follow the exact procedure.
I am wondering if the service account or any setting at my computer needs to be changed.
Originally, I have a MSDE service engine in my XP HOME machine. I uninstall it and then install the SQL Developer version and set as "Server and Client" tool. I still cannot register any Server
------------------------------------------------------------------------------
Evelyn Arpino
"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message news:%23bSHrTYfDHA.3204@TK2MSFTNGP11.phx.gbl...
SQL personal and developer edition work fine with Windows XP home. You
can use enterprise mgr to connect to other SQL machines by registering
them.
Maybe this page will help
http://msdn.microsoft.com/library/d...y/en-us/howtosq
l/ht_servpem_7jua.asp
HTH
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
|
|
|
|
|