Got an error when installing SP2.

From: M. Kim (myungkim@u.washington.edu)
Date: 02/20/03 

From: "M. Kim" <myungkim@u.washington.edu>
Date: Thu, 20 Feb 2003 10:06:41 -0800

To fix SQLSLammer virus.
tried to install SP2.

error

"Setup was unable to verify the state of server for an
upgrade. Verify if server is able to start and that you
provided a valid sa password and restart setup'

I chose 'Windows Authentication' instead 'SQL Server
Authentication'.

My SQL is

Product Version 8.00.194
                Personal Edition.
                Service Pack 3. (even though I can't
remember that
I installed Service Pack 3).

I got this information by SQL.

SELECT @@VERSION
---------------
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
        Aug 6 2000 00:57:48
        Copyright (c) 1988-2000 Microsoft Corporation
        Personal Edition on Windows NT 5.0 (Build 2195:
Service Pack 3)

(1 row(s) affected)

SELECT SERVERPROPERTY('ProductVersion')

8.00.194

(1 row(s) affected)

SELECT SERVERPROPERTY('Edition')

Personal Edition

(1 row(s) affected)

I used to login the computer using Novell.
Our office is using Novell(sorry!!).
When I login in Novell that looks like remember windows
login information, too.

but my company network
disabled my wallport because my PC was running a version
of Microsoft SQL server that is vulnerable to a remote
compromise.

so, I can login Novell as only workstation only.

Thanks for any help in advance.

Kim,

Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
    ... > file while you do changes, so the script file in the end contains the ... >> Server, doesn't have the right to grant DB access to Domain Groups. ... > Tibor Karaszi, SQL Server MVP ... >> site where they let me login as Domain Admin. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server role or right click on it and choose properties from the popup menu, ... Login is a member of the "sysadmin" fixed server role now. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server ... Mark the "sysadmin" checkbox to make this Login a member of this Server ...
    (microsoft.public.sqlserver.setup)
  • network path that is not supported for database files??
    ... administer selection of the login control: ... an invalid server name or credentials, ... that is not supported for database files. ... The remote server is a win 2000 server and the db is sql server 2000. ...
    (microsoft.public.vsnet.general)