Need help with installation of SQL 6.5 SP 4

Need help with installation of SQL 6.5 SP 4

Post by Leigh Meredit » Tue, 27 Oct 1998 04:00:00



I have SQL 6.5 installed on NT 4.0 (SP 4).  This is the version that came
with Visual Studio 97 (Enterprise edition).

My computer is a stand alone NT 4.0 server connected to an ADSL line to the
Internet.

When I go to install the Service pack (SP 4), logged in as Administrator,
it asks for my password, which I then type.

However, it then gives me the following message:

The entered password failed verification, please check your password.

Any idea what this messsage is?  Iasume that I need to be an administrator
to install the SP, but as far as I can tell I am.

Any help would be appreciated.  Thanks.


Cheers

Leigh

 
 
 

Need help with installation of SQL 6.5 SP 4

Post by Neil Pik » Wed, 28 Oct 1998 04:00:00


Leigh,

Quote:> I have SQL 6.5 installed on NT 4.0 (SP 4).  This is the version that came
> with Visual Studio 97 (Enterprise edition).
> When I go to install the Service pack (SP 4), logged in as Administrator,
> it asks for my password, which I then type.
> The entered password failed verification, please check your password.

Q.      I am having problems installing a SQL Service pack.
(v1.0   23.10.1998)

A.  Try the following checklist :-

1.  Make sure you have administrator level permissions on the machine in
question, as SQL needs to create registry entries, services etc.

2.  SQL Server is dependent on network functionality - even for the set-up
routines.  Specifically it needs to use named-pipe/mailslot functionality.  
These usually require a network card to be present.  If you don't have a
network card then go to control panel/networks, choose add adapter and then
add the Microsoft loopback adapter - which is just a dummy driver, no
hardware involved.  This needs to have working network protocol(s) bound to
it.  Let whichever protocols you have use default parameters, EXCEPT for
tcp-ip.  If you are using this then do NOT specify dhcp assigned address, use
192.168.1.1 as the IP address and 255.255.255.0 as the subnet mask.  This is
a standard RFC1918 non-routed IP address so shouldn't clash with any dial-up
address you may be given by an ISP.

3.  Because a named-pipe, used by the set-up routine, is effectively a file
as far as the operating system is concerned, real-time Virus scanners can
cause problems.  Most of these have been fixed so they don't interfere with
SQL's named-pipes, but make sure you're running the latest version of
whichever virus package you use.  But if in doubt, then disable the virus
software for the duration of the install.

4.  Other software packages can also interfere with SQL's install - typically
they interfere with named-pipes/mailslot connectivity and setup will
terminate with an error like 'unable to write to mailslot.....'.  Shut-down
any of these for the duration of the install.  Packages that are known to
interfere with SQL's setup routines include :-

    IIS - Internet Information Server - the web parts, not FTP
    PWS - Personal Web Server
    Exchange Server

5.  If the dial-up networking icon/window appears and tries to make a network
connection, then stop and disable the "Remote Access Autodial Manager"
service via control panel/services.  This is an NT issue rather than a SQL
one, but disabling auto-dial is the easiest way around it.

6.  If it still isn't installing then check the *.OUT files in the
<sql>\install directory for clues as to what is going on.

7.  If the .OUT files indicate that ISQL cannot connect to the SQL Server to
run scripts then you can try the following unsupported hack (it's worked for
me though) by modifying the servicepack's setup.inf.  After modifying the
setup script run "setup /t Local = Yes"

    Make a backup of the setup.inf first, then find the following line

    set !ServerName = $(!ComputerName)

    Now add the following 3 lines after it

    ifstr(i) $(!Local) == "Yes"
    set !ServerName = "."
    endif

 Neil Pike MVP/MCSE
 Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)

 
 
 

1. Problem with SP - Needs to be re-saved to work in SQL-server 6.5

This happens in Microsoft SQL-server 6.5 with servicepack 4.
The server runs on a Windows NT 4-server with servicepack 3.

I have a stored procedure containg an update statement.
My problem is that sometimes the sp does everything it should, but when it
runs the update statement no update occurs.
If I then make a little change to the sp and save it and the remove the
change so that it is as it was originally and the save it again, it works
just fine.

Anyone having any thoughts about this?

Any help would be much appreciated.

I heard a rumour saying that this can be a bug in SQL-server 6.5, if so, is
this solved in SQL-server 7?

Carl Almquist

2. Implementing Simple Read-Only ODBC Driver.

3. Install SQL Server 6.5 SP 4 : Please Help!!!

4. Returning a ResultSet from Oracle to Java

5. Please HELP!! SQL Server 6.5 installation

6. ISQL invocation question and varchar length ??

7. Installation of SQL 6.5 hangs Help !

8. Configuring the time-slice, memory etc.

9. Help!!!, SQL Server 6.5 Installation

10. Problem on Installation of SQL Server 6.5 HELP

11. SQL 6.5 SP 4 Install Error - Please Help

12. Help ...SQL Server 6.5 Installation problem..... from Khushhal

13. REQ: Help on Installation of SQL 6.5 Evaluation