473,699 Members | 2,388 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server 7.0 installation

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
Jul 20 '05 #1
5 2739
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_******** ************@co mcast.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
"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

Jul 20 '05 #2
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_******** ************@co mcast.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
"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


Jul 20 '05 #3
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******** ************@co mcast.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_******** ************@co mcast.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
"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



Jul 20 '05 #4
> 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******** ************@co mcast.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_******** ************@co mcast.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 > "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
>
>



Jul 20 '05 #5
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******** ************@co mcast.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******** ************@co mcast.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_******** ************@co mcast.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 > > "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
> >
> >
>
>



Jul 20 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
15221
by: Ken Lindner | last post by:
I have a need to become familiar with SQL Server 2000 for work. Needless to say I am new to SQL Server any version, but not IT in general. My employer has provided me with the SQL Server 2000 Personal disk from the SQL Server 2000 Enterprise kit as this is reported here on the MSDN web site to be the version that is supported on Windows XP. In fact so many of you kind people confess to having succeeded in doing it. I have tried...
1
3195
by: Hai-Chu Hsu | last post by:
Hi, I want to restore my databases from the old SQL Server installation into a new installation of SQL Server. My new installation of SQL Server has different data path from the old installation. In addition, the data owners of some databases in the old SQL Server installation are not dbo. I have backups for all the databases in the old installation SQL Server. Can anyone tell me how to restore my databases from the old SQL Server
1
8096
by: srihari | last post by:
Hai, I am trying to install IBM DB2 8.1 on Red Hat linux 8.0. My machine is Intel XEON 64bit. The installation went well except for the creation of tools catalog. When I tried to install the tools catalog as a post installation task I get some java error. $ db2 CREATE TOOLS CATALOG SYSTOOLS USE EXISTING DATABASE TOOLSDB FORCE SQL22209N The DB2 Administration Server encountered an unexpected Java error on host "". I have jdk1.3 already...
4
7300
by: coosa | last post by:
Hi, I was installing SQL Server on my machine and during installation my PC freezed. It happens frequently on my machine. So i tried after restarting to install it again and since then i always get the same error message: "An error occurred while creating one or more registry entries. Please see C:\WINDOWS\sqlstp.log for details. The problem could be caused by a low registry quota condition" I have tried to clean the registry and i...
3
2228
by: datapro01 | last post by:
I am a DB2 DBA that has been asked to become familiar enough with SQL Server in order to become actively involved in its installation, implementation, and to review database backup/recovery procedures. SQL Server will be used by a vendor packaged application. The problem is that we are awaiting word on whether it will be SQL Server 2000 or 2005 we will be working with. I have been told that there are considerable differences between the...
16
2316
by: Jeremy S. | last post by:
I'm about to install VS.NET 2005 and SQL Server 2005 on a new/clean development machine (XP Pro/SP2 etc). Is the order of installation important (i.e., which product should I install first)? Thanks!
0
8842
by: Kris Mattheus | last post by:
A little background: I've been using web services successfully for a while now. My web server is a Windows CE 4.2 device and my client is a windows C# application created with Visual Studio 2003. My web server has both NTLM and Basic authentication. By providing the Credentials for my web service call, my application can access the web service without any problems. The problem: I recently created a new application with Visual Studio...
20
3144
by: piggy | last post by:
I have developed an application using C# under .NET 2.0 framework. It is almost done and it is time for me to think about deploymnet to all users. I don't have any background about this and would like to see if anyone can help me get started. I have read some about clickonce deployment and not sure much about this yet. Thanks for your help.
10
6094
by: =?Utf-8?B?UHVuaXQgS2F1cg==?= | last post by:
Hi, I am developing a windows application in VS.NET 2005. The application is database driven and I need to deploy it on a client's pc. How should I go about developing such an application. I remember I did something once long back .. like including .mdf files into my project in the solution explorer of VS 2005 and then used Click Once deployment tool ... to make sure that the database and tables were created when the client installed my...
0
3952
by: Toralf Kirsten | last post by:
Hi all, we have installed DB2 V9.5 Trial on a Fedora 6 Linux box (32bit). Since the box is included in a NIS we have manually created db2 users db2inst, dasusr and db2fenc on this box (not in the NIS). The installation process is carried out by using the root user (as root, not using sudo or something else). We selected the custom installation and de-selected the SA MP option but enabled the option to build the TOOLSDB (catalog db as I...
0
8623
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9185
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8893
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7773
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5879
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4389
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3069
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2015
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.