Re:Changed server admin pwd; can't connect to SQL

From: Vishal Parkar (vgparkar@hotmail.com)
Date: 12/11/02 

From: "Vishal Parkar" <vgparkar@hotmail.com>
Date: Wed, 11 Dec 2002 03:50:57 -0800

This has nothing to do with SQL Server service. Instead
check your connection with the database which must be
using windows NT authentication. If so, change the
password of DSN u are using in asp pages for connectivity.
You can also opt for SQL Server authentication but for
that your sql server should be configured to listen
to "Mixed authentication mode"

--Vishal.

>-----Original Message-----
>I would welcome any help on this issue: Recently, the
>windows 2000 server admin password was changed. After a
>server reboot, my web applications (.asp) can't access
the
>SQL 2000 DBs. (I get an ODBC access denied error). The
>SQL server installation was not set up with a separate
>account for the service, i.e., when I look at the
>properties for the MSSQLSERVER in the Services panel, it
>just says Local System Account (under Log on). If I re-
>establish the old password and reboot, all is well. If
>anyone can shed any light on this, I would be most
>grateful.
>.
>

Relevant Pages

  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: Bizzare SQL Network Error
    ... The bizzare thing is that, the same connection string, the same code to ... In a windows APP it works fine, in a Web APP I get ... >>I am trying to connect to a default instance of SQL Server 2000 Enterprise ...
    (microsoft.public.dotnet.framework.adonet)