RE: SA Account Can't Access Views After Password Change

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 13:16:47 GMT

If an ASP is using the sa account to connect to the SQL Server, hae they
changed the password for the sa account in the connection string on the ASP
page? If this is not it what is the exact error that they are getting?

SQL Server does not cache standard login passwords locally so this cannot
be it.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • Re: Connect pocket pc (2003) to sql sever in trusted/integrated/ss
    ... it was SQL Server that was running in local system account. ... Here's connection string sample, note "Integrated Security=SSPI". ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: ASP and SQL
    ... run a stored procedure in an SQL server from a asp page. ... Is there a way to create a user on an SQL server from a ASP page, ... You will need to use an account with sysadmin privileges in order to execute ...
    (microsoft.public.inetserver.asp.db)
  • Unable to use Kerberos Delegation from IE6 --> IIS 5.0 (asp.net)--> SQL 2000
    ... When attempting to make a connection using ADO.NET connection string: ... W2K member Server SP3 ... SQL Server configured for TCP/IP Protocol Only ... COMPUTER\SQL_MYSQL is marked as Account is trusted for delegation NOT REQUIRED??? ...
    (microsoft.public.sqlserver.security)
  • Unable to use Kerberos Delegation from IE6 --> IIS 5.0 (asp.net)--> SQL 2000
    ... When attempting to make a connection using ADO.NET connection string: ... W2K member Server SP3 ... SQL Server configured for TCP/IP Protocol Only ... COMPUTER\SQL_MYSQL is marked as Account is trusted for delegation NOT REQUIRED??? ...
    (microsoft.public.inetserver.iis.security)
  • Re: SQL Server problem
    ... > between ASP .NET worker process and the SQL server. ... I could be wrong, but I believe that account is a local account, not a ...
    (microsoft.public.dotnet.languages.vb)