After MS Critical updates, getting sa errors - HELP

From: greg (sql.25.gmon72_at_spamgourmet.com)
Date: 09/27/03 

Date: Fri, 26 Sep 2003 16:16:10 -0700

Hi All, I just put the blaster patches on our SQL servers
and now all kinds of problems have appeared.

When trying to connect as SA using Enterprise Admin, the
error appears

Reason: Not associated with a trusted SQL Server Connection

I saw one post on sept 11 th from someone here, but the
replay from 9/15 is unavailable!

We have a whole bunch of stored procedures on a certain
database that give the trusted SQL error when trying to
run. If I create a new stored procedure it works ok. The
permissions all look the same. any ideas?

<btw my email is valid, just dont like the bots harvesting
email addresses and getting spammed. I will get all
emails sent to that address.> thanks

Relevant Pages

  • Stored Procedure Fails Only When Called By Agent
    ... connect to and add logins for 12 remote SQL servers ... remote server, one at a time, for 5 tables. ... These stored procedures work fine when run from Query Analyzer, ... I get an error message of "Msg 17, ...
    (microsoft.public.sqlserver.replication)
  • Webservice SQL logon fails on production IIS server
    ... I recently created some intranet web sevices to expose stored procedures on ... our SQL Servers. ... When I move the services to production IIS servers, the database connection ...
    (microsoft.public.dotnet.framework.webservices)
  • After MS Critical updates, getting sa errors - HELP
    ... I just put the blaster patches on our SQL servers ... Not associated with a trusted SQL Server Connection ... We have a whole bunch of stored procedures on a certain ... database that give the trusted SQL error when trying to ...
    (microsoft.public.sqlserver.security)
  • Help on code in a SP
    ... I'm currently auditing some SQL servers to have an overview on what's ... running/existing in the different databases. ... I found User's Stored Procedures in MSDB databases ...
    (microsoft.public.sqlserver.server)