0
votes
1answer
612 views

Added a custom SQL Server login to Microsoft Dynamics CRM 4.0, getting empty resultsets

At work we have Microsoft Dynamics CRM 4.0 installed and employees use their LAN login to log into CRM's web interface. We've added a SQL Server-based custom login (to the server and db *_MSCRM) with ...
1
vote
1answer
190 views

SQL 2005 AD Group permission levels

I'm trying to give permissions to a (sql 2005) database app based on AD groups. The general idea is to require a user to have a membership to "app_users" to view anything, and membership to other ...
1
vote
1answer
524 views

Help with SQL Server 2008 permissions

Today I migrated a database from SQL Server 2005 to SQL Server 2008 R2 using the backup/restore method which went fine and did not generate any errors. I can log into SQL Server 2008 through the SQL ...
4
votes
1answer
183 views

SQL 2005 Security - Users: What are they used for? (and other various questions)

I am not a DBA and so dont really know anything about SQL 2005 security settings, etc. I am attempting to set up an empty copy of our database by generating the full database from SQL Management ...
2
votes
1answer
363 views

SQL 2005 user denied SELECT permission

A domain user (User1) belonging to the roles public, db_datareader, and db_datawriter on a particular database is getting the following message when he attempts to select from any tables on that ...
0
votes
1answer
937 views

How to DENY access for a particular database for login “sa” and grant access for another login? (SQL Server 2005 Express)

I have the SQL Server 2005 Express edition with "Mixed Mode authentication". So I want to create a database called "ActivityLogs" where I want to DENY access for the "sa" login. I want to create ...
2
votes
1answer
249 views

SQL Server 2005 windows group permissions overriding individual server logins

Hi, I was wondering if someone knows a way round this. I have a database which needs to be accessed by a Windows Group with read only access. Some individuals in this group need write access. I ...
0
votes
1answer
123 views

What is the performance impact of changing the DB Owner in SQL Server 2005?

If I have two accounts, where: both accounts have DBO level access (use the DBO schema to log in, and are part of the owner group) one of the accounts is listed as the "actual owner" both accounts ...
0
votes
2answers
295 views

SQL Server 2005 access using Windows Authentication

I have a staging SQL Server that is not joined to the domain. When I access the server, I log into remote desktop as a local user on that machine. However, I can connect to the SQL Server instance ...
1
vote
1answer
1k views

Regarding SQL Server DENY permission on a table

RDBMS: SQL Server 2005 I am connecting to SQL Server through Windows Authentication. My account(domain\me) belong to a group, "domain\alert" The problem is that, even after denying a select ...
1
vote
1answer
2k views

What permissions might be missing on error 229 from 'tables' node on SSMS object explorer

I have just added a login to test an ETL process on a database and I get the error described below when connect using the account I click on the 'Tables' tab on the object explorer on SSMS on a ...