Re: SP3a won't install

From: Steve Thompson (SteveThompson_at_nomail.please)
Date: 04/27/04


Date: Tue, 27 Apr 2004 14:58:31 -0400

It's not clear to me whether you are using SQL or Windows Authentication?
Any error codes during setup?

Also, leaving your 'sa' password blank is a MAJOR security risk and asking
for trouble on any network that is used by more than one computer.

Steve
"Bobtcny" <rptNoSpam18@hotmail.com> wrote in message
news:507e01c42c7d$30509ca0$a001280a@phx.gbl...
> Full SQL Server 2000 installed on Windows 2000 with Named
> Pipes. SA password must be blank because the software ew
> install requires a blank password. MDAC is 2.7. SP3a
> installs on most machines with no problem. On some, SP3a
> will not install because it cannot verify user either in
> Windows Auth. or SQL Logon. Cannot log on using OSQL
> either. Enabling TCP/IP does not solve the problem. The
> software can connect to the database. Enterprise manager
> sees the database and we can set properties, such as
> authentication. Any ideas on why we cannot log on using
> either Windows Auth. or SA? Or how we can get SP3a to
> install?



Relevant Pages

  • Re: Configuring Full Text Search FOr SharePoint Web
    ... One instance is named SBSERVER (Windows NT) and the ... When you say "make sure that you have installed the SQL instance on ... sharepoint" are you referring to the instance that I have already installed ... > can refer the whitepaper below to install SQL instance on sharepoint: ...
    (microsoft.public.windows.server.sbs)
  • Re: Getting and Installing
    ... I'm a Windows CE guy. ... SQLServerCE 3.1 is not for your desktop computer; ... to install one of our small apps. ... our uses would be left to run the SQL setup on their own. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL and SBS2003
    ... each service', 'auto start sql service', 'use a domain user account' (e.g. ... > under "To install SP3a to a new instance of SQL Server") ... >>> password is invalid and if I try to use the Windows authentication it ...
    (microsoft.public.backoffice.smallbiz)
  • Re: Cant connect to SQL server
    ... and so I put a new hard drive in and installed Windows XP with SP2. ... Then I installed SQL ... server 2000 but Enterprise Manager only recognized XP\SQLEXPRESS as my ... As I understood from your previous post, you tried to install SQL 2000, ...
    (microsoft.public.data.oledb)
  • Re: connection options to yukon
    ... If you use TLS you can increase the security of your SQL auth ... Windows auth is slower as the domain must ... >> My recommendation would be to use Windows authentication over sql Auth ...
    (microsoft.public.dotnet.framework.adonet)