Solved

SQL 7 on NT4.0

Posted on 1998-12-29
6
352 Views
Last Modified: 2011-09-20
I'm installing SQL7 on my NT4.0 laptop. When I try to configure the "Client Network Utility" for my tcp/ip OR trying to setup the Server Enterprise Manager. I got the ERROR 1067
What does this error mean and how can I solve this?

please explain me in brief

Regards,
0
Comment
Question by:nung
  • 3
  • 2
6 Comments
 
LVL 9

Expert Comment

by:david_levine
ID: 1092388
Have you checked the NT Event Log - application and system? There might be some information there that will help.

Also, make sure you are logged in as administrator when you are doing the installation.

David
0
 

Author Comment

by:nung
ID: 1092389
As i look in Event viewer, the error says something like the pipe was not ready or something?
Thanks for your solution , but could you please tell me in brief

appreciated
0
 

Accepted Solution

by:
rounded225 earned 10 total points
ID: 1092390
Make sure TCP/IP is installed as well as a network adapter of some type (ethernet,loopback,etc).  Do not select tcp/ip as a protocol, use only 'named pipes'.  Make sure to remove the \MSSQL key from the registry before attempting to reinstall.  
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 9

Expert Comment

by:david_levine
ID: 1092391
Are you installing the server on your machine or just the SQL client?

If you are just setting up a demo machine and will only be using the client to talk to the server on the same machine, try communicating via named pipes instead of tcp/ip.

By default it will use Named Pipes to communicate internally. I'm not sure if this is still true, but it used to *only* communicate locally using named pipes. They might have changed that.
0
 

Author Comment

by:nung
ID: 1092392
appreciated, I will try it
0
 

Author Comment

by:nung
ID: 1092393
I tried both namepipes and tcp/ip, but it stil didn't work.
I also try to add NAMEPIPE in my network, but I didn't see any?

other advices?

0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question