Yesterday, I got a call from a customer.  It seems my application had stopped
working.  This application monitors equipment and stores data in an instance
of SQL Server 2005.  For single devices, we use SQL Server 2005 Express
Edition.

I added a new domain group as a SS2000 server Login. Do I have to add the
individual Domain Logins to the server as well?  In other words, if Joe and
Sally are members of Domain Group "AppUsers" and I add "Mydomain\AppUsers" to
my SS2000 server do Joe and Sally gain access by way ...

CREATE LOGIN [wep-2\ccc]] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
Error Message
Windows NT user or group 'wep-2\ccc' not found. Check the name again.
How do I make SQL server trust a computer in the DMZ?

We setup a linked server pointing to an Oracle instance.  The Link's
connection is configured to use the "Login's current security context."  We
setup a new SS2005 login/password identical to the login/password of an
Oracle User.  This way, the new SS2005 login/pw will ...

I have SQL server installed on a cluster enviroment, current verison of the
SQL Server is (Microsoft SQL Server 2005 - 9.00.3152.00 (X64)).
Cluster enviroment is setup on Microsoft Windows Server 2003 R2 Ent. x64
Edition with SP2.

   I'm having a problem has none of my admin login (Windows or SQL base)
are able to perform system administration like maintenance plan, add a login,
etc. I'm running a SQL 2000 SP4 on a W2K3 enterprise server. This is my
production server and my data manipulators are ...

I am trying to secure 2 tables within a db.  
I have secured the db by creating 2 User Groups on the server and then
allowing the user groups as logins on the SQLServer/DB.  In an attempt to
secure the tables in question I have tried two different ways to do so:

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 ...

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

Hi. In SQL Server 2005 with Windows Authentication mode activated, I have a
user who is a member of an AD group which has been assigned as a database
User, but this user's login has also been associated with another User
account directly.

Hi!
To better contextualize my question please take a moment to read the
following. As a dept we are transitioning out of Access and into SQL Server
2005. I am the "reporting guy", and our "data guy" has said that all my

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

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 ...

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 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 ...