I have a stored procedure which includes the "Execute As [user]" statement
where [user] is a sql server login.  This login has the appopriate
permissions to the database objects.  The db was created with a domain user
that uses windows authentication to log into the server.  The ...

I have a client that has been running 2 separate domains (same subnet).  An
NT4 domain and a W2K3 domain.  All clients have been added to the W2k3
domain.  The NT domain now consists of a PDC, a BDC and 2 SQL 2000 servers
running W2k.  My plan is to simply downlevel (remove from ...

Hi people
I'm trying to change the SQL Server service account to a domain account and
got error 0x80070534. I explain a little...
I have three servers, a DC, another DC with SQL Server installed and a

SQL Server 2000, SP4. I have this login MyLogin which has access in both msdb
and master. The account is public in master and db_owner in msdb. I have the
same settings on 10 servers. I attempt to create a job, steps and schedule.
When it comes to msdb.dbo.sp_add_jobserver I got ...

Guys
Can anyone recomment me a good place to start in terms of looking at how to
protect SQL data that is accessed via a web application.
Thanks

I don't have any experience working with existing databases and am having
trouble fathoming what SQL Server 2005 Schemas would be named and what
exactly they would represent.  I found this in the books online 'conceptual
object containing tables, views and permissions.'  What ...

Am developing a WinForms -.net application which will connect to SQL Server.
The authentication is going to be Windows integrated. Application will
connect to the database with user's windows security context. How does
authentication happen at SQL Server end? Does it again ...

I'm trying to use my domain credentials within SQL Server Mgmt. Studio
to connect to our devel server (in the same domain) from an XP Pro
machine that isn't part of any domain. I keep seeing the following
errors in the Event Log:

Hi, I have a server running sql server 2000 sp3. In this sql server we
use windows authentication to allow users to use the applications that
were developed in house.
At this moment we have some users that are using excel to get data from

Is it possible to deny a person/group direct access to tables in a DB, but
allow them to access the data in the tables through a query or stored
procedure?
This way, I can make the query accessible to other client applications for

Does anyone know of documentation that could explain to a customer how to set
up SQL Server2005 for windows authentication?  I'm running a DB upgrade
application that needs to run as a dbo.  In addition, after a new database is
built, the app detaches the db and executes ...

I setup my SQL 2000 Server to use C2 auditing.  It is working.
My only problem is that my trace file does not get populated while I am
inserting/updating/select data or anything.
However, when I stop SQL server then my trace file gets populated.

I tried to build a certifictae based endpoint to mirror databases.
However all the time I try to create the endpoint I got the Message:
"The certificta e'MyCert' is not valid fer endpoint authentication. The
certificate must have a privare key encrypted with the database master key ...

I came across the issue where NT Authority\System Account is been
removed from SQL Server 2000 (Security) & i have to add this back. SQL
Server Services is running under SYSTEM ACCOUNT. Any help how to add
back NT Authority\System Account will be appreciated & thanking in

I am having a complete nightmare of a time trying to setup an SSL certificate
to secure the connection between a web site (hosted externally) and a machine
within the network in our office with the SQL server database. I am using a
connection string like the following: