7
votes
1answer
666 views

Why can NT AUTHORITY\SYSTEM create SQL Server database backups?

I have a scheduled task (in Windows Task Scheduler) that connects to SQL Server using SMO (Windows Authentication) and creates a database backup. So far, this task was running under the Administrator ...
1
vote
2answers
542 views

Weird behavior using Active Directory group mapped to SQL Server user/login

I've run across a very odd behavior on SQL Server 2008R2. I have a third-party application which acts as a SQL Server client. I have a subset of my users who should have access to this application. ...
1
vote
1answer
83 views

sql server 2008 express, how login as admin

I am pretty newbie on sqlserver. I just want to logon by Management Studio on a sqlserver just for backup a db. But it seems that I haven't enough permissions because I am guest. Anyone could explain ...
0
votes
2answers
562 views

In sql-server, how do I give server-level permission to user to make backups on any database

I need to give a user server-level permissions, once and for all time, to back-up any existing or future database on the server instance, without making the user sysadmin. How can I do that? I've ...
0
votes
1answer
273 views

Get permissions in fixed or user-defined server roles in SQL Server 2012

I'd like to know how to get a list of permissions that belong to fixed and/or user-defined server roles in SQL Server 2012. In previous versions there was an sproc sp_srvrolepermission but this is ...
1
vote
1answer
882 views

SQL Agent Powershell Job Failing with Non-Admin Proxy

I'm attempting to create a SQL Agent job that will run a PowerShell script that is saved on my system. However, the job fails with the following error: A job step received an error at line 1 in a ...
0
votes
1answer
402 views

Package run on SQL Server Job Agent - Login failed for user

I created a package on my SQL Server (2012) through the import/export data wizard which exports data to another SQL Server (2008). I set up a job which runs this package but I get an error: ...
1
vote
1answer
126 views

How do I configure a stored procedure wrapper and security settings to provide safe access to command-line operations?

I'm ultimately trying to find a way to allow the safe use of BCP and selected other command-line functionality from within SQL Server. The organisation I am in currently have xp_cmdshell disabled ...
0
votes
1answer
98 views

All users can read SSAS all Cubes

I found that all my domainusers can read the cubes in my Microsoft Analasys Services. I have no roles specifying that. Neither the domain admins nor the local admins contain any group that would ...
0
votes
1answer
877 views

where can I find the user in this IIS error 'Login failed for user 'IIS APPOOL\Web2'

I encounter the following error: Cannot open database "testbase" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\Web2'. Description: An unhandled exception occurred ...
0
votes
1answer
454 views

SQL Server NETWORK SERVICE account permissions

My SQL Server Windows service is set to use the NETWORK SERVICE account. The server is installed to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL. However looking at the ...
3
votes
2answers
286 views

Preventing users from deleting SQL data

We just purchased a program that requires the users to have an account in the MS SQL server, with read/write access to the program's database. My concern is that since these users will now have write ...
3
votes
2answers
1k views

Can't Connect w/ SQL Management Studio After Domain Change

Our old Small Business Server 2003 (acting as our domain controller) was on the fritz, so we replaced it with a new Windows Server 2008 box and set the server up as our new domain controller. In ...
2
votes
1answer
1k views

What is the default account/group for SQL 2008 R2 cluster permissions and can you create/add them?

Last night we had an issue where the permissions were altered a SQL 2008 R2 Cluster Instance, such that the instance could no longer access the shared drives where the system databases were installed. ...
0
votes
2answers
732 views

How to setup Database Permissions on SqlServer Express 2008

I'm using a code-first approach of using the Entity Framework. When I first run the application it will try to create the database matching my MVC models. However, it doesn't have permission to ...
0
votes
2answers
1k views

How to enable a SQL Server 2008 login to access a directory on another server

I need a sql server login (not a windows login) to be able to perform bulk inserts using a file on another server. using bulk insert \\path\to\server\c$\path\to\dir does not work because of ...
1
vote
1answer
6k views

Permission error during installation of Microsoft SQL Server 2008 R2

During setup I get several errors like the one bellow and none of the service for SQL server get installed. I did quick google search but it seems like the only solution for resolving this issue is ...
3
votes
1answer
77 views

SQL Server revoking a select

Let's suppose a user, "Bob", gets SELECT permission from John and Bob also gets SELECT permission from another user, Joe, but this time with GRANT option. What happens if someone revokes the select ...
1
vote
2answers
1k views

Minimum access rights for generating schema creation scripts

In SQL Server 2008, it am running the "Generate SQL Server Scripts Wizard", attempting to create a script for all of the tables and views within a schema. When I do this, I get an error: Property ...
2
votes
4answers
10k views

The database myDb is not accessible. (ObjectExplorer)

I'm developing an ASP.NET MVC3 web app, which connects to a SQL Server 2008 R2 database. Everything was working fine, until I started getting this error: The database myDb is not accessible. ...
11
votes
4answers
22k views

With SQL Server (2008), can you grant create table permission within a schema?

Working with security in SQL Server 2008, I'm trying to grant a user CREATE TABLE permissions, but only within a specific schema. Does CREATE TABLE permission only apply at the database level? Can I ...
0
votes
1answer
115 views

Block SQL 2008 R2 Insert Access on anything for user in MS ACCESS on AD Group

Hi I would like to block access to insert any data on SQL when a User from a determined Active Directory Group access SQL from MS ACCESS. Is this possible? if not is there any alternative? I've ...
0
votes
1answer
3k views

The server principal “sa” is not able to access the database “MyDb” under the current security context

We're getting this error and nothing we've tried so far has worked: TRUSTWORTHY ON exec sp_change_users_login 'Auto_Fix', 'sa' sa is mapped to user dbo and dbo is the database owner. Any help ...
0
votes
1answer
42 views

Setting up individual accounts to a SQL Server

I am attempting to setup a MS 2008 sql server that would allow many users access to there own private databases. I would like the adventure works databases installed on all of these as well. My ...
0
votes
1answer
148 views

Application Compatibility Clients do not show in MSSQL database, but do show in \AppCompat\

Application Compatibility Clients are denied access to the central MSSQL database, but are able to leave their own files in the \AppCompat\ share. The only computer that shows up in the "Microsoft ...
1
vote
1answer
501 views

GRANT PERMISSIONS ON SQL Server 2008,

I got the following issues while querying a database, and somehow I am not yet able to resolve it. 1. The SELECT permission was denied on the object So I executed the following command on SSMS ( I ...
0
votes
1answer
518 views

SQL 2008. How to let user to create/alter sprocs in only one particular schema?

I have a user which can read and write but now he needs to be able to create/alter a sproc but giving him ddl_admin will make it too unsecure. I dont trust him that much. What can I do about it? Can ...
0
votes
2answers
4k views

How can I grant read-only access to my SQL Server 2008 database?

I'm trying to grant read-only access (in other words: select queries only) to a user account on my SQL Server 2008 R2 database. Which rights do I have to grant to the user to make this work? I've ...
1
vote
3answers
6k views

How do I grant a database role execute permissions on a schema? What am I doing wrong?

I am using SQL Server 2008 Express edition. I have created a Login , User, Role and Schema. I have mapped the user to the login, and assigned the role to the user. The schema contains a number of ...
9
votes
1answer
16k views

What can user do with VIEW SERVER STATE permissions?

In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
3
votes
2answers
641 views

Map sql's BUILTIN\Administrators to Windows Administrators Group

Logged on as 'Administrator' (and a member of just one Group - Administrators) i am seen as God (ok ... god) to the SQL install. Where do I bestow the same level of permission to all members of the ...
1
vote
1answer
129 views

Giving permissions to objects called in stored procedures

We've got about 55 vendor databases running in SQL Server 2000 compability mode on a SQL Server 2008 server. Cross database ownership chaining is enabled. We also have our own in-house reporting ...
0
votes
2answers
179 views

How to define user as dbo of a specific schema

I'm creating a multi-tenant application that will utilize a single database with multiple schemas. Each tenant will have their own respective login/password. I was able to restrict view permissions to ...
0
votes
1answer
66 views

Only allow certain processes to connect to MS SQL

I've lost the source code for a very old application that connects to a MS SQL-server for some SQL queries. Since the login is hard-coded in the application I can't change the username/password on the ...
1
vote
3answers
515 views

Where are granted permissions stored in SQL Server?

When a user is granted rights to something in SQL Server using the GRANT function where is it recorded?
0
votes
1answer
930 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
2answers
443 views

MSSQL - Hide databases

I have a MSSQL 2005 server set up and running. I would like to be able to have the following setup: database_one with user_one as db_owner and database_two with user_two as db_owner The tricky part ...
1
vote
2answers
212 views

Using IIS With Visual Web Developer

I am trying to launch a web service from Visual Web Developer using IIS. When I open the .asmx file in a web browser, I get an error that I do not have permission to access that page. I am using ...
1
vote
2answers
2k views

What is the proper way to grant stored proc execute permissions for a SQL Server user?

I have just moved a SQL Server 2000 DB over to SQL Server 2005 Express (which will be upgraded soon) and in the process I am cleaning up some bad habits from the previous owner. For one, the old ...
0
votes
2answers
1k views

Only allow ability to read the views for a particular SQL Server user over ODBC

Newbie question: I have a designer who reads information from a SQL Server [2008] database. I've setup a few views for him to pull his data from and granted his user a member of the db_dataread ...
0
votes
3answers
603 views

Deny SQL rights to all system stored procs

Following up on my original StackOverFlow question, we're trying to create a SQL user (on many 2000, 2005, and 2008 servers) with the minimum possible permissions for doing a simple "heartbeat check" ...
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 ...
2
votes
2answers
424 views

Secure user setup in Sql Server 2000

I'm looking to setup a user account in Sql Server 2000 in the most secure manner. The criteria is as follows: No access to the master database (db_denydatareader & db_denydatawriter on master) ...
0
votes
1answer
1k views

403 FORBIDDEN Error in SharePoint with SQL Server datasource

I have created some custom WebParts on my SharePoint site through the use of SmartParts. My custom web parts look at 2 diff. SQL Server Datasources. When i run my code from Visual Studio 2008 is ...
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 ...
2
votes
3answers
778 views

How can I tell what user account is being used to perform an action (in context of SQL Server)?

For example, when installing SQL Server 2008, I had to pick an account for the database engine to run as. When I went to attach a 2005 database file with SQL Server Management Studio, there was a ...
1
vote
3answers
466 views

Why can the Network Service account select rows in a SQL Server 2005 DB without granting permissions

We have some Web Apps running in IIS 6. They are running in the Default AppPool which identitiy is Network Service. The Apps connect to a local SQL Server 2005 Express Instance (SP2) and use a ...
4
votes
3answers
213 views

Permissions for shipping SQL Server 2005 transaction logs

I'm trying to ship transaction logs from Server A to Server B. I keep getting permission denied errors when the agent tries to run because it isn't using the right credentials to connect to the backup ...