I have two servers: srv1, srv2.
I created a linked server between of them from srv1 to srv2.
i create user1 on srv1 and srv2 which is not dbo.
I create proc2 on srv2 and gave it execute permissions for user1.

I'm trying to open the master database Properties window when running SSMS as
a local user (Run as) which I have only created a sql server login for it.  I
get the error below.   If I add the sql server login as a user to the master
database and assign any database role ...

On one of our Sql 2005 servers someone added a user to a server as a windows
power user with permission to log onto the server and have given them
permission to just read and write on one database.
They have been able to backup a database and view the list of tables on a

I'm using IE7 and have XP Media.  My Internet security will alert me that SQL
Browser Service EXE wants in.  The path is C:\ProgramFiles\MicrosoftSQL.  The
IP is 60.190.107.29:3111.  The connection is UDP.  The PID is 2288.  Is this
from Microsoft?

I am in the process of analyzing an existing SQL Server 2000 implementation.
I am currently looking at the security and have found something I can't
explain.
I see a standard SQL Server login.

SQL 2k5 sp3
If I want a group of developers to have access to see the variables in
stored procs, and be able to execute them, what permission do I need to give
the users?  I don't want to make them all dbo's, nor do I really want to

I have a database on SQL Server 2008 Express which I connect to over a
vpn via MS Access. The connection uses a login and password set in SQL
Server. When I or one of the other guys connect, then there is no
problem. However, when a new user connects, they are rejected.

Ok I have researched this error and none seem to apply to what is
happening to me!
From my Windows XP machine I am trying to create an ODBC connection to
an SQL 2000 server when I get the message SQLState 42000 SQL Server

Our company has 2 database servers running inside a workgroup. The
database servers are connected to a number of front end IIS machines
that are accessed over the internet. SQL Server 2008 has been
installed on both database machines with most of the services running

We had a vulnerability assessment and they apparently they scanned our SQL
server.  The 'sa' account was locked due to too many times trying to access
system.  I found I can login using windows authentication and I accessed the
'sa' login and unchecked the locked status.  Now ...

Has anyone installed this? Anything to watch out for?
http://www.informationweek.com/news/security/attacks/showArticle.jhtml?articleID
=212501876
TIA,
Abba

I am looking for a database auditing script that generate report to show
security loopholes in system like disable\deny all guest account, view and etc
I work for a financial institution and have to make database very secure.
instead of to do manually, i am wondering if anyone has ...

After some searching i've managed to add "read/write
servicePrincipalName" access for a "domain account" with ADSIEdit.
After restarting the SQLServer Service, the eventlog shows it is
listening on a specific dynamic port. Again back in ADSIEdit I see, I

Are there any specific guidelines to make SQL Server PCI Compliant, specially
if your company collects credit card information?

I have a SQL Server 2005 SP3 server that will not allow Active directory
group users to login.   I get this in the event log (names and addresses
changed to protect the innocent):
Login failed for user 'DOMAIN\user'. [CLIENT: 1.1.1.1].