in SQL profiler, we see some activity from ClientProcessID = 980
(malicious commands) , how do I figure out what is causing this
security breach.

I get this error when I run my ado query object which in turn runs a stored
proc.
CREATE PROCEDURE sp_InsertUserLogonDateTime
@UserNRI INT = NULL,

Can someone tell me if there is a proc out there that will repair orphaned SQL 2005 users (Windows and SQL)?  I have already transferred all the logins to a new server.  Ideally I'd like for it to repair this for all databases, but I am fine with repairing this on an individual ...

I got stuck in the SQL Server 2005 security dependencies and can't find out.
Here's my problem:
I am using the service broker for running asynchronous stored procedures and
have created a queue with

I have a problem where a logon account is denied access to SQL Server 2005.
The server log:
Login failed for user 'Domain\User' [Client: xx.xx.xx.xx]
Error: 18456, Severity: 14, State: 11

We're seeing ton of these error on our test server. Before this
meesage appears, we're seeing following thing:
Login failed domain\username [client:<ip_address>]
Any help appreciated.

I'm looking for a whitepaper for the best practices for using encryption in
SQL Server 2005. Our PCI Assessor said that there was some sort of whitepaper
Microsoft put out detailing both encryption and key management. I appreciate
any and all help available.

I have a varchar column that I would like to encrypt and store within
the same column. Encryption functions return binary.  I would change
the column datatype , but certain parties will not change the datatype
to varbinary.  I can store the value after explicitly converting the

I am trying to create a certificate in SQL Server 2005 using the CREATE
CERTIFICATE TSQL statement, however, the certificates that I have are in CER
and PFX format - for some reason, SQL Server 2005 is requiring a PVK file
rather than the Microsoft standard private key exchange ...

We have two build servers running Windows Server 2003 R2 SP2 and default
instances of SQL Server 2005 SP2, I'll refer to them as ServerA and ServerB.
Both servers are members of our only domain (MyDomain) and each SQL service
runs as a domain account (ServerASqlUser and ...

My event viewer offers up an error each and every minute with a source of
MSSQLSERVER: "Failure Audit: Login failed for user 'NT AUTHORITY\SYSTEM'
[Client: <local machine>.
Can anyone suggest a possible source and a possible solution? Clearly it is

I'm trying to set up a SQL Server Agent account and I just hit a wall.  I was
following these instructions.
http://msdn.microsoft.com/en-us/library/ms187901.aspx
and

Is there any way to tell if a SQL 2005 has SSL enabled?
Thanks,
Eric Sabo

Can someone explain why I am unable to do this now on my SQL Database.
Suspect it is some settings / collation or the like but when I say
GRANT EXECUTE ON functionname TO DOMAIN\Fred.bloggs
I get Incorrect syntax near \

any step by step procedures that lead me to upgrade sp2k sp4 standard
edition to sql2k enterprise edition without prod databases retoring...
thanks,