Sorry...I missed your last edit. What permissions are you changing?

And I forgot to ask, are you also looking at who is the owner of the files?

Sue

The only thing I've ever seen like that is the file attributes getting marked as read only. But I've often seen the security changes, ownership changes on files when moved...

A couple of things to try, check would be:

Double check the permissions and make sure the effective permissions have the service account has full control.

Make sure the file attributes didn't...

theresa.ravens (8/16/2016)

---

The following error is received whenever attempting to remote connect to the machine and connect to the SQL instance. I can successfully connect to the database from my local...

How did you connect to SQL Server initially to create your own login? You'd need to connect to the instance somehow to create a login.

Sue

You answered your own question. ALTER LOGIN requires ALTER ANY LOGIN permission.

Refer to: https://msdn.microsoft.com/en-us/library/ms189828(v=sql.110).aspx

Sue

If the failures are something with database mail, you can query the catalog views to see if there are issues showing up. You could take a look at these:

SELECT *...

It sounds like you might not be a system administrator in SSRS. Can you access Report Manager, view any of the site settings or security from there? You many need...

I though the number of row mods needed was based on the number of rows in the table, and was either a fixed number or a percentage of the...

You can deploy reports using BIDS, Report Manager or using rs.exe. Probably other ways as well (e.g. Posh script). How you do it for each is fairly different.

This article...

You can't do it with a view since you want this parameterized. You can use a function or a stored procedure when you want something similar to what would behave...

Andrew Causon (8/12/2016)

---

I'm hoping that someone can answer this as I have scoured the internet for something relevant to no avail.

As a developer coming into an organisation where data security...

The advantage to setting it up would be that SQL Agent could use Database mail for jobs, alerts, etc.

I'm not sure what the disadvantage would be to setting it...

Take a look at sp_altermessage. You can set the Is_event_logged value in sys.messages with something like:

EXEC sp_altermessage

@message_id = NNNNN, --Your message number

@parameter = 'WITH_LOG',

@parameter_value = 'True'

Sue

Duh...sorry about that. Pasted the same link to the stairway article instead of the forum.

This is the Posh forum:

http://www.sqlservercentral.com/Forums/Forum1351-1.aspx

Sue