Here is what I use all the time. Just set the database, schema and table names. Hope it helps.

/* =================================================================================================================================================== */

/* Create column name list...

Stefano:

Backups are carried out using the SQL Server Service Account. In order to save to a UNC path, you have to use an AD user as the logon for...

No idea if this is what you are talking about, but hope it helps someone.

I have posted this previously to several forum topics. Been busy for past year, so haven't...

"You may as well keep the SP in cleartext"

While some people know how to decrypt encrypted stored procedures, I personally subscribe to bad guys the same way I subscribe to...

Some additional notes to those that may not know.

TDE is available only in SQL 2008 and above, and only in the Enterprise Edition.

Column-level encryption is available in SQL 2005 and...

I've only created one database with column-level encryption for a live database so far, but I have done it by putting all code to decrypt and encrypt in stored procedures....

You are doing fine. It is definitely a learning process. I'm certainly learning. I don't do it everyday, so I'm definitely not a guru.

The user would use...

Creation of an actual account named SA is unnecessary. What I meant was to find out if your Windows Authenticated login to the database server was assigned sysadmin fixed...

Confirm that you are at the proper website address.

User:

http://<servername&gt;:80/ReportServer

Admin:

http://<servername&gt;:80/Reports

Use the Admin one to set up permissions.

Do you see the "New Folder", "New Data Source", "Upload File"...

Oops.. As far as permissions, I put it in a SPROC and set the WITH EXECUTE AS OWNER clause to the CREATE PROCEDURE statement and made the owner dbo.

Then gave...

I had to do this just recently. Here is what I used to get a list of users and all the roles they belong to. They are listed...

I can hopefully answer the first one. As long as you have the proper data provider installed on the server, you should be able to connect to any Oracle...

Glad I could help. Please let us know how it works.

Just to clarify:

This means that the users accessing the URL must have permissions on the server

This means that they have URL access through SSRS permissions for the main page,...

One thing to keep in mind is that SSRS report access is Windows Authentication only. This means that the users accessing the URL must have permissions on the server...