SQL Server 7.0 installation

[Grim Reaper]

My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I have
never setup a server from the beginning, so I am a little new at creating
server groups.

Alright, I am trying to create a server group. I right click on the "SQL
Server Group" and make a name of "TEST" and put in the subgroup of "SQL
Server Group".

Next, I try to register the "TEST" server group. I right click on the "TEST"
server group and New Server Group Registration. (Someone told me I need to
know the name of my computer (LAPTOP) and the workgroup name (WORKGROUP) for
the next part.) On the following part, for selecting a SQL Server, "LAPTOP"
automatically comes up as the available servers, so I add it to the "Added
Servers" list. On the next step, I choose the SQL Server authentication and
type in the login name as "sa" and the password as "password" (I was told
that is the default, but I tried "sa" and "(no password)" and I tried
"administra tor" and no password.) Then, I add the server group to an
"existing SQL Server Group" - group name: "SQL Server Group". Finally, when
I try to connect or finish, the following message comes up: "LAPTOP - SQL
Server does not exist or access denied, Connection Open".

I am not sure what I am doing wrong, I was told that I should setup an ODBC
that is SQL Server, but it asks for a database to connect to, and there are
none. Please, I hope someone could help me, I am trying to learn SQL Server
7.0 for work.

Thanks, in advance, for any help,
Grim Reaper

[Allan Mitchell]

Re: SQL Server 7.0 installation

Very few servers will/should have the sa account with either of those two
choices of password. See your SQL Server admin about that. Also maybe the
SQL Server you are trying to register is set up fpr NT authentication only
in which case you will need tobe allowed access by virtue of your Windows
Account.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Grim Reaper" <73matt@comcast .net> wrote in message
news:p_ednTs-9t86R-Dd4p2dnA@comcas t.com...[color=blue]
> My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I have
> never setup a server from the beginning, so I am a little new at creating
> server groups.
>
> Alright, I am trying to create a server group. I right click on the "SQL
> Server Group" and make a name of "TEST" and put in the subgroup of "SQL
> Server Group".
>
> Next, I try to register the "TEST" server group. I right click on the[/color]
"TEST"[color=blue]
> server group and New Server Group Registration. (Someone told me I need to
> know the name of my computer (LAPTOP) and the workgroup name (WORKGROUP)[/color]
for[color=blue]
> the next part.) On the following part, for selecting a SQL Server,[/color]
"LAPTOP"[color=blue]
> automatically comes up as the available servers, so I add it to the "Added
> Servers" list. On the next step, I choose the SQL Server authentication[/color]
and[color=blue]
> type in the login name as "sa" and the password as "password" (I was told
> that is the default, but I tried "sa" and "(no password)" and I tried
> "administra tor" and no password.) Then, I add the server group to an
> "existing SQL Server Group" - group name: "SQL Server Group". Finally,[/color]
when[color=blue]
> I try to connect or finish, the following message comes up: "LAPTOP - SQL
> Server does not exist or access denied, Connection Open".
>
> I am not sure what I am doing wrong, I was told that I should setup an[/color]
ODBC[color=blue]
> that is SQL Server, but it asks for a database to connect to, and there[/color]
are[color=blue]
> none. Please, I hope someone could help me, I am trying to learn SQL[/color]
Server[color=blue]
> 7.0 for work.
>
> Thanks, in advance, for any help,
> Grim Reaper
>
>[/color]

[Grim Reaper]

Re: SQL Server 7.0 installation

The laptop is mine, so I am the "Server Admin". I set up the SQL Server and
I set up Windows XP Professional on my laptop.

I have tried the NT authentication, but it did not work, either.

So, seeing as though I own the laptop, is there anyway that I can setup the
SQL Server on my laptop so that I can use it? If so, how?

Thanks,
Grim Reaper

"Allan Mitchell" <allan@no-spam.sqldts.com > wrote in message
news:407e190b$0 $31701$fa0fcedb @lovejoy.zen.co .uk...[color=blue]
> Very few servers will/should have the sa account with either of those two
> choices of password. See your SQL Server admin about that. Also maybe[/color]
the[color=blue]
> SQL Server you are trying to register is set up fpr NT authentication[/color]
only[color=blue]
> in which case you will need tobe allowed access by virtue of your Windows
> Account.
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "Grim Reaper" <73matt@comcast .net> wrote in message
> news:p_ednTs-9t86R-Dd4p2dnA@comcas t.com...[color=green]
> > My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I[/color][/color]
have[color=blue][color=green]
> > never setup a server from the beginning, so I am a little new at[/color][/color]
creating[color=blue][color=green]
> > server groups.
> >
> > Alright, I am trying to create a server group. I right click on the "SQL
> > Server Group" and make a name of "TEST" and put in the subgroup of "SQL
> > Server Group".
> >
> > Next, I try to register the "TEST" server group. I right click on the[/color]
> "TEST"[color=green]
> > server group and New Server Group Registration. (Someone told me I need[/color][/color]
to[color=blue][color=green]
> > know the name of my computer (LAPTOP) and the workgroup name (WORKGROUP)[/color]
> for[color=green]
> > the next part.) On the following part, for selecting a SQL Server,[/color]
> "LAPTOP"[color=green]
> > automatically comes up as the available servers, so I add it to the[/color][/color]
"Added[color=blue][color=green]
> > Servers" list. On the next step, I choose the SQL Server authentication[/color]
> and[color=green]
> > type in the login name as "sa" and the password as "password" (I was[/color][/color]
told[color=blue][color=green]
> > that is the default, but I tried "sa" and "(no password)" and I tried
> > "administra tor" and no password.) Then, I add the server group to an
> > "existing SQL Server Group" - group name: "SQL Server Group". Finally,[/color]
> when[color=green]
> > I try to connect or finish, the following message comes up: "LAPTOP -[/color][/color]
SQL[color=blue][color=green]
> > Server does not exist or access denied, Connection Open".
> >
> > I am not sure what I am doing wrong, I was told that I should setup an[/color]
> ODBC[color=green]
> > that is SQL Server, but it asks for a database to connect to, and there[/color]
> are[color=green]
> > none. Please, I hope someone could help me, I am trying to learn SQL[/color]
> Server[color=green]
> > 7.0 for work.
> >
> > Thanks, in advance, for any help,
> > Grim Reaper
> >
> >[/color]
>
>[/color]

[Allan Mitchell]

Re: SQL Server 7.0 installation

If you are a member of the local administrators group on that box then you
should be able to log in through NT Authentication.

The service is started right?

What OS are you using on your laptop?

Do you actually have the Client Tools installed or the Engine as well.?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Grim Reaper" <grimrpr@nospam .com> wrote in message
news:sbSdnb6VkM fB-uPdRVn-gw@comcast.com. ..[color=blue]
> The laptop is mine, so I am the "Server Admin". I set up the SQL Server[/color]
and[color=blue]
> I set up Windows XP Professional on my laptop.
>
> I have tried the NT authentication, but it did not work, either.
>
> So, seeing as though I own the laptop, is there anyway that I can setup[/color]
the[color=blue]
> SQL Server on my laptop so that I can use it? If so, how?
>
> Thanks,
> Grim Reaper
>
> "Allan Mitchell" <allan@no-spam.sqldts.com > wrote in message
> news:407e190b$0 $31701$fa0fcedb @lovejoy.zen.co .uk...[color=green]
> > Very few servers will/should have the sa account with either of those[/color][/color]
two[color=blue][color=green]
> > choices of password. See your SQL Server admin about that. Also maybe[/color]
> the[color=green]
> > SQL Server you are trying to register is set up fpr NT authentication[/color]
> only[color=green]
> > in which case you will need tobe allowed access by virtue of your[/color][/color]
Windows[color=blue][color=green]
> > Account.
> >
> > --
> > --
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.SQLDTS.com - The site for all your DTS needs.
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> >
> > "Grim Reaper" <73matt@comcast .net> wrote in message
> > news:p_ednTs-9t86R-Dd4p2dnA@comcas t.com...[color=darkred]
> > > My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I[/color][/color]
> have[color=green][color=darkred]
> > > never setup a server from the beginning, so I am a little new at[/color][/color]
> creating[color=green][color=darkred]
> > > server groups.
> > >
> > > Alright, I am trying to create a server group. I right click on the[/color][/color][/color]
"SQL[color=blue][color=green][color=darkred]
> > > Server Group" and make a name of "TEST" and put in the subgroup of[/color][/color][/color]
"SQL[color=blue][color=green][color=darkred]
> > > Server Group".
> > >
> > > Next, I try to register the "TEST" server group. I right click on the[/color]
> > "TEST"[color=darkred]
> > > server group and New Server Group Registration. (Someone told me I[/color][/color][/color]
need[color=blue]
> to[color=green][color=darkred]
> > > know the name of my computer (LAPTOP) and the workgroup name[/color][/color][/color]
(WORKGROUP)[color=blue][color=green]
> > for[color=darkred]
> > > the next part.) On the following part, for selecting a SQL Server,[/color]
> > "LAPTOP"[color=darkred]
> > > automatically comes up as the available servers, so I add it to the[/color][/color]
> "Added[color=green][color=darkred]
> > > Servers" list. On the next step, I choose the SQL Server[/color][/color][/color]
authentication[color=blue][color=green]
> > and[color=darkred]
> > > type in the login name as "sa" and the password as "password" (I was[/color][/color]
> told[color=green][color=darkred]
> > > that is the default, but I tried "sa" and "(no password)" and I tried
> > > "administra tor" and no password.) Then, I add the server group to an
> > > "existing SQL Server Group" - group name: "SQL Server Group". Finally,[/color]
> > when[color=darkred]
> > > I try to connect or finish, the following message comes up: "LAPTOP -[/color][/color]
> SQL[color=green][color=darkred]
> > > Server does not exist or access denied, Connection Open".
> > >
> > > I am not sure what I am doing wrong, I was told that I should setup an[/color]
> > ODBC[color=darkred]
> > > that is SQL Server, but it asks for a database to connect to, and[/color][/color][/color]
there[color=blue][color=green]
> > are[color=darkred]
> > > none. Please, I hope someone could help me, I am trying to learn SQL[/color]
> > Server[color=darkred]
> > > 7.0 for work.
> > >
> > > Thanks, in advance, for any help,
> > > Grim Reaper
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Grim Reaper]

Re: SQL Server 7.0 installation

> If you are a member of the local administrators group on that box then you[color=blue]
> should be able to log in through NT Authentication.[/color]
Actually, the laptop is mine. Therefore, I guess that would make me the
administrator.
[color=blue]
> What OS are you using on your laptop?[/color]
I am using Windows XP Professional.
[color=blue]
> The service is started right?[/color]
Not sure what service you mean, here.
[color=blue]
> Do you actually have the Client Tools installed or the Engine as well.?[/color]
I installed everything on the disk for SQL Server 7.0. When everything came
up that it asked me if I wanted to install, I said everything because I was
not sure what I needed.

Grim Reaper

"Allan Mitchell" <allan@no-spam.sqldts.com > wrote in message
news:407e6876$0 $31673$fa0fcedb @lovejoy.zen.co .uk...[color=blue]
> If you are a member of the local administrators group on that box then you
> should be able to log in through NT Authentication.
>
> The service is started right?
>
> What OS are you using on your laptop?
>
> Do you actually have the Client Tools installed or the Engine as well.?
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "Grim Reaper" <grimrpr@nospam .com> wrote in message
> news:sbSdnb6VkM fB-uPdRVn-gw@comcast.com. ..[color=green]
> > The laptop is mine, so I am the "Server Admin". I set up the SQL Server[/color]
> and[color=green]
> > I set up Windows XP Professional on my laptop.
> >
> > I have tried the NT authentication, but it did not work, either.
> >
> > So, seeing as though I own the laptop, is there anyway that I can setup[/color]
> the[color=green]
> > SQL Server on my laptop so that I can use it? If so, how?
> >
> > Thanks,
> > Grim Reaper
> >
> > "Allan Mitchell" <allan@no-spam.sqldts.com > wrote in message
> > news:407e190b$0 $31701$fa0fcedb @lovejoy.zen.co .uk...[color=darkred]
> > > Very few servers will/should have the sa account with either of those[/color][/color]
> two[color=green][color=darkred]
> > > choices of password. See your SQL Server admin about that. Also[/color][/color][/color]
maybe[color=blue][color=green]
> > the[color=darkred]
> > > SQL Server you are trying to register is set up fpr NT authentication[/color]
> > only[color=darkred]
> > > in which case you will need tobe allowed access by virtue of your[/color][/color]
> Windows[color=green][color=darkred]
> > > Account.
> > >
> > > --
> > > --
> > >
> > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > > www.SQLDTS.com - The site for all your DTS needs.
> > > I support PASS - the definitive, global community
> > > for SQL Server professionals - http://www.sqlpass.org
> > >
> > >
> > > "Grim Reaper" <73matt@comcast .net> wrote in message
> > > news:p_ednTs-9t86R-Dd4p2dnA@comcas t.com...
> > > > My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I[/color]
> > have[color=darkred]
> > > > never setup a server from the beginning, so I am a little new at[/color]
> > creating[color=darkred]
> > > > server groups.
> > > >
> > > > Alright, I am trying to create a server group. I right click on the[/color][/color]
> "SQL[color=green][color=darkred]
> > > > Server Group" and make a name of "TEST" and put in the subgroup of[/color][/color]
> "SQL[color=green][color=darkred]
> > > > Server Group".
> > > >
> > > > Next, I try to register the "TEST" server group. I right click on[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > "TEST"
> > > > server group and New Server Group Registration. (Someone told me I[/color][/color]
> need[color=green]
> > to[color=darkred]
> > > > know the name of my computer (LAPTOP) and the workgroup name[/color][/color]
> (WORKGROUP)[color=green][color=darkred]
> > > for
> > > > the next part.) On the following part, for selecting a SQL Server,
> > > "LAPTOP"
> > > > automatically comes up as the available servers, so I add it to the[/color]
> > "Added[color=darkred]
> > > > Servers" list. On the next step, I choose the SQL Server[/color][/color]
> authentication[color=green][color=darkred]
> > > and
> > > > type in the login name as "sa" and the password as "password" (I was[/color]
> > told[color=darkred]
> > > > that is the default, but I tried "sa" and "(no password)" and I[/color][/color][/color]
tried[color=blue][color=green][color=darkred]
> > > > "administra tor" and no password.) Then, I add the server group to[/color][/color][/color]
an[color=blue][color=green][color=darkred]
> > > > "existing SQL Server Group" - group name: "SQL Server Group".[/color][/color][/color]
Finally,[color=blue][color=green][color=darkred]
> > > when
> > > > I try to connect or finish, the following message comes up:[/color][/color][/color]
"LAPTOP -[color=blue][color=green]
> > SQL[color=darkred]
> > > > Server does not exist or access denied, Connection Open".
> > > >
> > > > I am not sure what I am doing wrong, I was told that I should setup[/color][/color][/color]
an[color=blue][color=green][color=darkred]
> > > ODBC
> > > > that is SQL Server, but it asks for a database to connect to, and[/color][/color]
> there[color=green][color=darkred]
> > > are
> > > > none. Please, I hope someone could help me, I am trying to learn SQL
> > > Server
> > > > 7.0 for work.
> > > >
> > > > Thanks, in advance, for any help,
> > > > Grim Reaper
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Allan Mitchell]

Re: SQL Server 7.0 installation

EE will not install the Engine on XP professional. It should have given you
a message about "Client tools only can be installed on this OS"
The service should be MSSQLServer

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Grim Reaper" <grimrpr@nospam .com> wrote in message
news:39adnQ-FQOs87ePd4p2dnA @comcast.com...[color=blue][color=green]
> > If you are a member of the local administrators group on that box then[/color][/color]
you[color=blue][color=green]
> > should be able to log in through NT Authentication.[/color]
> Actually, the laptop is mine. Therefore, I guess that would make me the
> administrator.
>[color=green]
> > What OS are you using on your laptop?[/color]
> I am using Windows XP Professional.
>[color=green]
> > The service is started right?[/color]
> Not sure what service you mean, here.
>[color=green]
> > Do you actually have the Client Tools installed or the Engine as well.?[/color]
> I installed everything on the disk for SQL Server 7.0. When everything[/color]
came[color=blue]
> up that it asked me if I wanted to install, I said everything because I[/color]
was[color=blue]
> not sure what I needed.
>
> Grim Reaper
>
> "Allan Mitchell" <allan@no-spam.sqldts.com > wrote in message
> news:407e6876$0 $31673$fa0fcedb @lovejoy.zen.co .uk...[color=green]
> > If you are a member of the local administrators group on that box then[/color][/color]
you[color=blue][color=green]
> > should be able to log in through NT Authentication.
> >
> > The service is started right?
> >
> > What OS are you using on your laptop?
> >
> > Do you actually have the Client Tools installed or the Engine as well.?
> >
> > --
> > --
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.SQLDTS.com - The site for all your DTS needs.
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> >
> > "Grim Reaper" <grimrpr@nospam .com> wrote in message
> > news:sbSdnb6VkM fB-uPdRVn-gw@comcast.com. ..[color=darkred]
> > > The laptop is mine, so I am the "Server Admin". I set up the SQL[/color][/color][/color]
Server[color=blue][color=green]
> > and[color=darkred]
> > > I set up Windows XP Professional on my laptop.
> > >
> > > I have tried the NT authentication, but it did not work, either.
> > >
> > > So, seeing as though I own the laptop, is there anyway that I can[/color][/color][/color]
setup[color=blue][color=green]
> > the[color=darkred]
> > > SQL Server on my laptop so that I can use it? If so, how?
> > >
> > > Thanks,
> > > Grim Reaper
> > >
> > > "Allan Mitchell" <allan@no-spam.sqldts.com > wrote in message
> > > news:407e190b$0 $31701$fa0fcedb @lovejoy.zen.co .uk...
> > > > Very few servers will/should have the sa account with either of[/color][/color][/color]
those[color=blue][color=green]
> > two[color=darkred]
> > > > choices of password. See your SQL Server admin about that. Also[/color][/color]
> maybe[color=green][color=darkred]
> > > the
> > > > SQL Server you are trying to register is set up fpr NT[/color][/color][/color]
authentication[color=blue][color=green][color=darkred]
> > > only
> > > > in which case you will need tobe allowed access by virtue of your[/color]
> > Windows[color=darkred]
> > > > Account.
> > > >
> > > > --
> > > > --
> > > >
> > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > > > www.SQLDTS.com - The site for all your DTS needs.
> > > > I support PASS - the definitive, global community
> > > > for SQL Server professionals - http://www.sqlpass.org
> > > >
> > > >
> > > > "Grim Reaper" <73matt@comcast .net> wrote in message
> > > > news:p_ednTs-9t86R-Dd4p2dnA@comcas t.com...
> > > > > My work let me put SQL Server 7.0 Enterprise Edition on my laptop.[/color][/color][/color]
I[color=blue][color=green][color=darkred]
> > > have
> > > > > never setup a server from the beginning, so I am a little new at
> > > creating
> > > > > server groups.
> > > > >
> > > > > Alright, I am trying to create a server group. I right click on[/color][/color][/color]
the[color=blue][color=green]
> > "SQL[color=darkred]
> > > > > Server Group" and make a name of "TEST" and put in the subgroup of[/color]
> > "SQL[color=darkred]
> > > > > Server Group".
> > > > >
> > > > > Next, I try to register the "TEST" server group. I right click on[/color][/color]
> the[color=green][color=darkred]
> > > > "TEST"
> > > > > server group and New Server Group Registration. (Someone told me I[/color]
> > need[color=darkred]
> > > to
> > > > > know the name of my computer (LAPTOP) and the workgroup name[/color]
> > (WORKGROUP)[color=darkred]
> > > > for
> > > > > the next part.) On the following part, for selecting a SQL[/color][/color][/color]
Server,[color=blue][color=green][color=darkred]
> > > > "LAPTOP"
> > > > > automatically comes up as the available servers, so I add it to[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > "Added
> > > > > Servers" list. On the next step, I choose the SQL Server[/color]
> > authentication[color=darkred]
> > > > and
> > > > > type in the login name as "sa" and the password as "password" (I[/color][/color][/color]
was[color=blue][color=green][color=darkred]
> > > told
> > > > > that is the default, but I tried "sa" and "(no password)" and I[/color][/color]
> tried[color=green][color=darkred]
> > > > > "administra tor" and no password.) Then, I add the server group to[/color][/color]
> an[color=green][color=darkred]
> > > > > "existing SQL Server Group" - group name: "SQL Server Group".[/color][/color]
> Finally,[color=green][color=darkred]
> > > > when
> > > > > I try to connect or finish, the following message comes up:[/color][/color]
> "LAPTOP -[color=green][color=darkred]
> > > SQL
> > > > > Server does not exist or access denied, Connection Open".
> > > > >
> > > > > I am not sure what I am doing wrong, I was told that I should[/color][/color][/color]
setup[color=blue]
> an[color=green][color=darkred]
> > > > ODBC
> > > > > that is SQL Server, but it asks for a database to connect to, and[/color]
> > there[color=darkred]
> > > > are
> > > > > none. Please, I hope someone could help me, I am trying to learn[/color][/color][/color]
SQL[color=blue][color=green][color=darkred]
> > > > Server
> > > > > 7.0 for work.
> > > > >
> > > > > Thanks, in advance, for any help,
> > > > > Grim Reaper
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]