By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,078 Members | 2,159 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,078 IT Pros & Developers. It's quick & easy.

SQL Server 7.0 installation

P: n/a
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
"administrator" 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
Jul 20 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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" <73****@comcast.net> wrote in message
news:p_********************@comcast.com...
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
"administrator" 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

Jul 20 '05 #2

P: n/a
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" <al***@no-spam.sqldts.com> wrote in message
news:40***********************@lovejoy.zen.co.uk.. .
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" <73****@comcast.net> wrote in message
news:p_********************@comcast.com...
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
"administrator" 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


Jul 20 '05 #3

P: n/a
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" <gr*****@nospam.com> wrote in message
news:sb********************@comcast.com...
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" <al***@no-spam.sqldts.com> wrote in message
news:40***********************@lovejoy.zen.co.uk.. .
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" <73****@comcast.net> wrote in message
news:p_********************@comcast.com...
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
"administrator" 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



Jul 20 '05 #4

P: n/a
> If you are a member of the local administrators group on that box then you
should be able to log in through NT Authentication. Actually, the laptop is mine. Therefore, I guess that would make me the
administrator.
What OS are you using on your laptop? I am using Windows XP Professional.
The service is started right? Not sure what service you mean, here.
Do you actually have the Client Tools installed or the Engine as well.? 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" <al***@no-spam.sqldts.com> wrote in message
news:40***********************@lovejoy.zen.co.uk.. . 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" <gr*****@nospam.com> wrote in message
news:sb********************@comcast.com...
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" <al***@no-spam.sqldts.com> wrote in message
news:40***********************@lovejoy.zen.co.uk.. .
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" <73****@comcast.net> wrote in message
news:p_********************@comcast.com...
> 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 > "administrator" 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
>
>



Jul 20 '05 #5

P: n/a
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" <gr*****@nospam.com> wrote in message
news:39********************@comcast.com...
If you are a member of the local administrators group on that box then you
should be able to log in through NT Authentication. Actually, the laptop is mine. Therefore, I guess that would make me the
administrator.
What OS are you using on your laptop?

I am using Windows XP Professional.
The service is started right?

Not sure what service you mean, here.
Do you actually have the Client Tools installed or the Engine as well.?

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" <al***@no-spam.sqldts.com> wrote in message
news:40***********************@lovejoy.zen.co.uk.. .
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" <gr*****@nospam.com> wrote in message
news:sb********************@comcast.com...
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" <al***@no-spam.sqldts.com> wrote in message
news:40***********************@lovejoy.zen.co.uk.. .
> 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" <73****@comcast.net> wrote in message
> news:p_********************@comcast.com...
> > 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 > > "administrator" 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
> >
> >
>
>



Jul 20 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.