all groups > sql server connect > september 2003 >
You're in the

sql server connect

group:

SA Trusted connection fail after critical update


SA Trusted connection fail after critical update greg
9/28/2003 7:36:38 PM
sql server connect:
Hi All, I had posted this is security, but this looks
like the right group for this.

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
SA Trusted connection fail after critical update greg
9/29/2003 5:29:48 PM
Problem was fixed by logging on with nt account and
running sp_changedbowner for each database

weird/


[quoted text, click to view]
AddThis Social Bookmark Button