File Permissions

Aug 28, 2007

I've been having problem in my asp.net 2 web when using the "User Instance=true" style connections to databases.

I would get ASP.NET event log errors like this:
Exception information:
Exception type: SqlException
Exception message: An attempt to attach an auto-named database for file c: empdnndnndnn455App_DataDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

After I used ProcessMonitor it showed that the user ASPNET was trying to access C: directly after trying to open the database.mdf file I wanted open.

I had to give the ASPNET account read/execute permission to c:, which was very scary.

Could someone please enlightenment me as to the correct file permissions needed to use databases in user instances?

Thanks,
Alex

View 1 Replies

SQL Server 2008 :: SSIS Copy File From SharePoint Library Using File System Task Permissions?

Jun 19, 2015

Historically I've always written a VB script to copy a file from a sharepoint library. I don't like this method because I have to input a username & password in the script and maintain a config file.

Yesterday I was playing around with using a file system task. The sharepoint file has a UNC path so why not? I created a simple test package with a single file system task that copies the sharepoint file (addressed via UNC) to another network location. Package runs fine locally.

I try running on our utility server but am getting a "The file name [SHAREPOINT UNC PATH] specified in the connection was not valid" error. Package is running with a proxy on the server and the proxy account has the same permissions to the sharepoint site (so far as I can tell) as me.

View 0 Replies View Related

Backup Master Key, Cannot Write Into File 'c: Empmaster'. Verify That You Have Write Permissions, That The File Path Is Valid.

Jul 12, 2006

Hi,

I tried to backup the master key by the following syntax :

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'mypassword'

BACKUP MASTER KEY TO FILE = 'c: empmaster' ENCRYPTION BY PASSWORD = 'mypassword'

but it failed and i got the following message:

Cannot write into file 'c: empmaster'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.

NB: I am using the "sa" user to execute this command.

I know that we have a security permission issue , but where and how ?

Regards,

Tarek Ghazali

SQL Server MVP

View 12 Replies View Related

Sql Server File Permissions

Feb 25, 2008

Writing a desktop application that uses Express I needed to add a backup feature for the end user.
(The database server runs on the same machine)

It uses Windows auth so I thought the user should be able to create a backup in the directories he has access.
But it didn't work because the SQL Server has only write permissions in his own directories

As a workaround I also gave "sqlserver2005browseruser$..." write permissions in C:ackup

Can I configure SQL Server that way that it runs with the file grants of the executing user?
Of cause this makes no sense in a real client/server situation, but for the user it looks very strange if he can't make a backup
for his own local database.

View 1 Replies View Related

Custom Source Extension && File Permissions

Sep 26, 2007

I programmed a Source extension, that accesss a text file. In my code I have the following code to open a file:

protected override void reader(PipelineBuffer buffer)
{
TextReader reader = File.OpenText(_filename);

The komponnet works well. How do I grant permissions to access this text file? Because I got problems when I try to run my package using a task created in the SQL Server Agent.

View 3 Replies View Related

Table Permissions Versus View Permissions

Aug 2, 2006

Using SQL Server 2k5 sp1, Is there a way to deny users access to a specific column in a table and deny that same column to all stored procedures and views that use that column? I have a password field in a database in which I do not want anyone to have select permissions on (except one user). I denied access in the table itself, however the views still allow for the user to select that password. I know I can go through and set this on a view by view basis, but I am looking for something a little more global.