I need to be able to add users to roles in serveral databases and if one of
the inserts fails I need to be able to roll back the whole transaction. I am
getting the following error:
The procedure 'sp_grantlogin' cannot be executed within a transaction.

I am having an authentication issues with all my SQL2005 servers when using
double-hop Kerberos authentication.  The user I am authenticating is a domain
admin.
The problem occurs when I tried to connect from a client PC, to a SQL

I am not sure whether this should be posted on VB.net group or here but here
goes. I am creating a VB2005.net project using Express Edition SQL Server
database. When I try to make the connection to the db I get an error telling
me the user instance needs enabled. I have found the ...

How do I, in SQL 2005, determine for a database whether the guest user has
been GRANTed CONNECT?

I am capturing SQL Server trace log activity (daily basis) on a generic
RDBMS production server.  It captures ordinary user traffic just fine.  
However, it fails to capture certain types of known RDBMS activity.
Is it possible for an administrator to sidestep SQL Server activity ...

I need to have my web server IIS 6 access our database SQL2005. Our web
server holds other web sites so I would like to leave it in the DMZ and the
SQL in the lan. From what I have heard this is not the best method. Has
anyone done this. Is there a better way.

I know that a couple of years ago I read a Microsoft recommendation that SQL
server shoudl not run on the same machine as IIS.
We are looking at taking a managed hosted server for an app. and I wondered
if the same reccomendation applies. Does it depend on the way the hosting

I have a person in my IT dept. that I suspect is using the SA account for a
SQL server that holds employee information(salary, etc.) that she should not
be accessing it. Is there a way that I can track where the Actual SA account
is coming from by IP address or machine name? I ...

I'm trying to create a new user ID for a database on my box, I keep getting
the message
'Login failed for user 'ID'. The user is not associated with a trusted SQL
Server connection.

I have an SQL Server 2000 database with access project (.adp) front end
(client).
I have a security role that has the permission to run a stored procedure.
The stored procedure does a select and an update on a table. To make the

From time to time the linked servers we have set up cannot be accessed. When
I click on the tables node under the linked server within enterprise manager
the session hangs and no error message is displayed. When querying the data
via an openquery no error is thrown, the query ...

Our developers have been given dbcreator rights on the server and have dbo
rights for a given database.   This is a slight change from what was
previously dolled out as rights on the database.   When the developer creates
a view, rather than the view being created as dbo.myview, ...

Does the SQL Service engine account need administrative rights on SQL Server
2005? I know that it is not required on SQL 2000 but not sure on SQL 2005
(not a cluster).
Thanks

Is there a lockdown document for SQL Server 2005 to tighten security? (For
SQL 2000 there are suggestions/recommendations such as: Modifying folder
permissions for SQL folders, recommended extended SPs to disable, removing
guest account from DB...)

we have built a new w2003 sp2, sql 2005 sp2 with hotfix server. Scanning with
Nexus tells us it is vulnerable to the hello overflow, CVE-2002-1123. How can
I find out for certain whether the server is vulnerable or not? need to be
able to show documentation to our security guy b4 ...