Stored Procedure / GrantDbAccess
Tue, 23 Sep 2008 06:49:00 -0700
We have 2 servers, one being the production server and the other an alternate
where we allow users to extract data for their own needs. During the night,
the database on the production server is backed up, and then restored to the
alternate server. A database on the alternate server contains users that
nee ...
|
how do I turn on the audit for users login and logout
Tue, 23 Sep 2008 06:45:02 -0700
Hi,
I want to turn on the audit log for users login/logout in which database in
sql 2005, how do I do this?
Thanks so much,
sg ...
|
Domain users group in sql 2005
Sun, 21 Sep 2008 12:06:34 -0700 (PDT)
On our production system we have this NT group called as [Domain Name
\Domain Users]. In our team none of us recall adding this group on our
production and moreover; this group is sysadmin on production system,
which scares me because, if, no one added this group on our runtime
system then how did it become sysa ...
|
sql injection question
Fri, 19 Sep 2008 07:55:00 -0700
Using SS2005 and Windows2003 and a Linux web server in another location.
Would having the web server and database server in the same location, behind
the same firewall, make sql injection any less likely. Or is the prevention
of sql injection more about programming (i.e. using stored procedures vs raw
sql in ...
|
Securing System Tables
Fri, 19 Sep 2008 05:15:00 -0700
In light of the recent sql injection attack that iterates through system
tables, we are tightening down security for our Application Logins.
I am not able to deny select on views in the "sys" & "INFORMATION_SCHEMA
"schemas for a role I have created called "DenySystemTableSelect". I used
this statement:
...
|
how to change the owner of the existing maintenance plan
Thu, 18 Sep 2008 07:11:01 -0700
Hi,
We are using sql 2005 and I created a few maintenance plan. Because I logged
in as my windows account and the owner of maintenance plans is my account, I
wanted to change to the sql service account. I changed it throught job
properties, it goes back to my account again. I also went into the
maintenanc ...
|
Login failed for user 'domain\Administrator' Microsoft SQL Server
Thu, 18 Sep 2008 06:01:01 -0700
I'm using remote desktop from a VISTA PC to connect to a Windows 2003 server
as the domain administrator. Using Studio Management I'm connecting to a
local instance of SQL Server.
I can login to that instance without error. But if I try looking at the
properties of any user or database I receive this erro ...
|
|
|
Login via Anonymous Authentication via IIS
Thu, 18 Sep 2008 04:36:01 -0700
Hi
I have an ASP.Net based application, running under IIS6 via Anonymous
Authentication, using the "IUSR_<Machine Name>" account.
The connection string in the web.config to SQL Server uses windows
authentication.
I have the following line in web.config:
<authentication mode="Windows">
I do not hav ...
|
0xC0000005:Security Update for SQL Server 2005 SP2 KB948109
Thu, 18 Sep 2008 01:01:01 -0700
I am going mad trying to fix this.
I have just installed a complete Upgrade copy of MS Office Ultimate 2007
over a copy of Office 2003. Windows Update has done a couple of updates
automatically and then tried to do this one. For a week now.
I get error 0xC0000005 : KB948109
I have tried KB948109.
I ...
|
message digests and sql server
Wed, 17 Sep 2008 12:35:00 -0700
Hello,
I have been searching for hashes that SQL server database 2005 uses. It
appears that only checksum functions are used for computing hashes on columns
of a table. I am wondering whether some other hashes such as MD5sum and SHA-1
are used as well. Also, can the checksum functions be calculated for an ...
|
