Hi,
Recently moved a few DBs from '00 to '05.  At that time our DBA changed the
security to all SP's so that the impersonating user only has access to
Execute the SP's.  This seemed all fine and dandy, except that some of our

I am developing a VS2005 C# application accessing a SQL Server 2005 database
with Windows Integrated Security.  Some of the users running this app are
connecting via login, e.g. Domain\ThisUser, with roles public and db_reader.  
When my app tries to execute a stored function ...

I've been posting in Programming as initially I thought this was a code
problem, but thought I would try here. I've included my script at the end.
Basically, when I run the script logged in as me, everything works as
expected. However, when I run the script logged in as the ...

How do I encrypt data during communications between the database and the
client?  What do all the encryptions, i.e. service master key, symmetric and
asymmetric keys, and certificates do? Is anyone of these methods good for
encrypting data during the communications process?

I'm having issues importing XML data using a distributed query with
the following statement which is run from an XP  workstation named A
connecting to SQL2005 Server B, the data is located on a server C at
the following UNC path \\SERERC\SHARE\PATH\DATAFILE.XML

Is there any way to secure data tables in a SQL database from viewing by an
external program.  We don't want the structure of our database be avilable
for viewing and possible reverse engineering of our application.  Thanks.

DATABASE1 is the default database. I'm using SQL2005 with SQL
authentication.
In a stored procedure I must query a table from a different database using
SELECT DATABASE2.dbo.MYTABLE. (DATABASE2 is readonly).

I am having trouble getting SQL 2005 to authenticate using Kerberos.
Regardless of what I try the authentication always goes through NTLM.
Following is the situation:
We have a test domain setup with a substantial amount of servers. I know

Hi. I have a SQL Server 2000 database,using Windows Authentication,
and have created some new roles and assigned permissions to the
various tables, views and sprocs.  However, the permissions are not
working.  When I log on as a user in one of the roles, i still have

My problem,
We have a few SQL databases on SLQ2005 and MSDE on the same machine with SBS
server 2003.
Every week i have some logs who tell that a compleet unknown user 'Login

We have one database with multiple schemas.
Different departments have their own schema, which only they should be able
to read/write.
We also have 1 reference data schema that all users of the database should

I have a test web server in a domain. The IIS identity as a domain account.
The website can access SQl Server (2005) using integrated security.
I have a production web server in DMZ out side the domain.  How can I setup
the webserver to use integrated security? The SQL server is ...

I have two SQL Server 2005 machines each running a default instance at
SP2.  Both servers are running Windows 2003 SP2.  On the first server,
S1, I have created a linked server definition to the second server,
S2.  The defintion has its security config set up as connections will

I have a customer who need to send us their database but wont do so because
of sensitive info contained in it.  They have tried deleting and truncatng
the data but you can still see the data if you open the mdf or backup with a
text editor?

We just revamp our application from Access to use SQL Express 2005 as
database engine, which is a standalone application running on client PC.
I'm now simulating the scenario when I deploy the DB to client, how can I
protect the database (or some tables) from being read by them?