Encrypted Connection
Fri, 6 Jun 2008 09:12:35 -0500
We have just enabled encryped connections on a SQL server by following the
steps on Books Online "How to: Enable Encrypted Connections to the Database
Engine (SQL Server Configuration Manager) ". We install a certificate on the
server, configured the server to accept encrypted connections by selecting
the sertif ...
|
Access to database through application only
Wed, 4 Jun 2008 14:10:36 -0700
I need to restrict my users to accessing the application to using Cognos
only. Anyway I can get that done? ...
|
lsass cpu usage
Tue, 3 Jun 2008 15:16:06 -0700 (PDT)
Hi, I have microsoft sql server 2000 on windows server 2003 for small
business.
It's linked to a web server which register more than 5000 unique
visitors every hours.
The connection to sql server is more than 20 contemporary.
I would like to know if is it normal that lsass.exe keep from 1% to
50% of the cpu. I ...
|
linked server and sys views
Tue, 3 Jun 2008 09:07:21 -0400
I have a SQL Server 2000 Server that is configured for a linked server to a
SQL Server 2005 server. When I expand the views folder for the linked
server I see ths sys views and I can query these views. From my
understanding you only see a subset of the data from the view, only see what
you have been assi ...
|
SQL 2000 user not inheriting permissions from role
Mon, 2 Jun 2008 07:36:11 -0700 (PDT)
In my dbs, the dbo account is assigned to a windows login (I'll call
it corp\toomuchaccess) for each db and the corp\toomuchaccess account
has SA permission on the server. So, I removed the SA permission on
the server, reassigned dbo to have sa as the owner, created a new role
in each db with read/write/execute ...
|
SQL Profiler - What is ClientProcessID ?
Sat, 31 May 2008 12:00:00 -0700 (PDT)
in SQL profiler, we see some activity from ClientProcessID = 980
(malicious commands) , how do I figure out what is causing this
security breach. ...
|
SQL Authentication
Fri, 30 May 2008 17:52:45 -0400
Sorry for the cross posting. I also posted this on
microsoft.public.sqlserver.server by accident!
---
The company I work for has 4 Microsoft SQL clusters (running SQL 2000 & SQL
2005) with 3 SQL instances per cluster (so 12 instances total). Historically
we've used the "sa" account for pretty much all access ...
|
|
|
Certificate Requirements for SQL Data Encryption
Fri, 30 May 2008 15:04:02 -0400
We are in the process of attempting to issue certificates from our
Enterprise CA to use in SQL encryption. I can not find documented anywhere
what the key attribute requirements are (Key Usage and Application Policies,
etc.) for the Certificates. I understand that SQL Server can issue it's own
certificates ...
|
multiple-step ole db operation generated errors? (Member of proble
Thu, 29 May 2008 12:43:03 -0700
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,
@Type INT = NULL
AS
INSERT INTO UserLogs
(UserLog_DateTime,
LogType_NRI,
User_NRI)
VALUES
(GETDATE(),
@Type,
@UserNRI)
GO
multipl ...
|
xp_logevent and service broker queues
Thu, 29 May 2008 01:03:05 +0200
Hi,
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
CREATE QUEUE AsyncTargetQueue WITH STATUS = ON, RETENTION = OFF,
ACTIV ...
|
