SQL Server Login and CRM Roles
Tue, 8 Jul 2008 15:38:03 -0700
I'm trying to link to SQLServer instance that is hosting CRM database. I
need a login that allows me to access the 'filtered' CRM views. CRM needs to
be able to associate the SQL Login with an Active Directory entry for a CRM
user with appropriate role.
--
Lolt Proegler ...
|
SQL Server w/ Redundant Domain Controllers
Mon, 7 Jul 2008 07:44:01 -0700
We have an application that connects to SQL Server using Windows
authentication, and we have two AD Domain Controllers. Both DCs also run DNS,
and the SQL server is configured to point to both. However, if one of the
domain controllers becomes unavailable (the one configured first in the DNS
order), then aut ...
|
Revoke Table, Grant Execute on Proc, but still get Permission Deni
Mon, 7 Jul 2008 07:19:01 -0700
All,
I'm using SQL 2000 and have:
* created a role
* granted execute to my procs for that role
* revoked on tables being accessed via the procs
* added my db user to the role
When I try to exec the procs, I get problems accessing the underlying
tables. I don't want any db user to have direct access to the ...
|
Can't find SQL Server Management Studio after install SQL Server 2
Fri, 4 Jul 2008 21:33:00 -0700
I've installed SQL Server 2005 Developer edition and SQL SP2 on a PC running
Windows Vista Business SP1. The installation went okay (no error message
other than remind me to install SP2). However, after installation and reboot
the PC, I can't find the SQL Server Management Studio. Also, from the Server
Ex ...
|
Is there a way to determine who created a stored procedure?
Thu, 3 Jul 2008 15:22:00 -0700
I'm using SQL Server 2005 and am wondering if there is a way to determine who
created a stored procedure? I've looked in sys.objects, but all it gives me
is the original create date and the last modified date. ...
|
Application Security based on SQL Security
Thu, 3 Jul 2008 02:10:01 -0700
Hi
i was wondering instead of implementing my own security schema inside my
application code is it recommended to depend on SQL Security so a user will
connect with user name and password and if he dont have a permission on SQL
to delete or update he will egt an message i feel its more simple what you
t ...
|
report of users
Wed, 2 Jul 2008 12:15:00 -0700
Suppose I should know this answer, but I'm drawing a blank.
For auditing purposes, I need to "Obtain a system generated listing of users
with production access for the systems" .
Basically, I'm looking for a stored procedure or something that will give me
the users. If something gives more details and far ...
|
|
|
Audit Fails for DOMAIN\Administrator account on SQL server 2005 instance
Tue, 1 Jul 2008 16:43:24 +0200
Hi!
I have a WSS 3.0 running on SQL Server 2005 Standard. It was upgraded from
SQL Server 2005 Express edition. Everytime I restart server I have 4 events
in the event log as follows:
1)
SQL Database 'SharePoint_Config ' on SQL Server instance 'WEBSRV1\SQLEXPRESS
' not found. Additional error informatio ...
|
The server principal "dhtest" is not able to access the database "dhtest2" under the current security context. (Microsoft SQL Server, Error: 916)
Mon, 30 Jun 2008 10:40:30 -0400
Hi,
I am running into an issue that I really need resolved today. Simply put, I
am getting the error:
The server principal "dhtest" is not able to access the database "dhtest2"
under the current security context. (Microsoft SQL Server, Error: 916)
But, the details are a little fuzzy...
I have two ins ...
|
"login failed for user ..." appears in event viewer repeatedly
Mon, 30 Jun 2008 07:32:02 -0700
Hello.
I have messages in event viewer several times per minute that say "Login
failed for user ....". The errors rotate through all the accounts that I have
setup in SQL.
I need direction in how to determine what is trying to login and how to
correct it. Are these attempts to compromise my system?
Th ...
|
