BPA Vs. Security Best Practices Paper

Jul 17, 2007





I would like to refer to the following technical article



SQL Server 2005 Security Best Practices - Operational and Administrative Tasks

http://www.microsoft.com/technet/prodtechnol/sql/2005/sql2005secbestpract.mspx



Among best practices for SQL Server service accounts on page 8, it is recommended to 'use a separate account for each service'. I created separate account for each service as advised and assign account to relevant Windows group created for each SQL Server service during SQL setup.



Now when I run Best Practices Analyzer, its report seemed to contradict what the above article said. For example, BPA reports excerpts:

"We recommend that the service SQLBrowser on host MachineName be run under Network Service Account". I get similar recommendation for SQLSERVERAGENT account as well. Most importantly, it recommends that MSFTESQL be run under SQL Server Service Account.



Can anyone of you shed some light on it?



Thanks,

Asaf

View 8 Replies


ADVERTISEMENT

Best Practices White Paper On Pre-Installation Server Setup

Oct 17, 2007

Evening,

I am very well versed in the proper way to set up a SQL Server server prior to installation.

In this I mean, the proper process in placing your MDF, LDF and NDF(s) on seperate spindles/discs and also to place TempDB on its own spindle/disc and such.

There are numerous other points to cover in setting up the server based on memory, security, processor and such but I am sure you understand.

What I am looking for is the link(s) to the whitepapers discussing these Best Practices methodologies for pre-installation setup.

I looked on the Best Practices page but did not seem to find a doc that contains all the Best Practices that should be followed, if possible of course, in setting up a server prior to the SQL Server 2005 installation process.

Can anyone please point me to a link(s)/doc(s) that describe what I am looking for.

I need to pass this information down to other members of my team.

Thanks and have a great day!

View 4 Replies View Related

Programmatically Set The Paper Size And And Paper Layout

May 15, 2006

how can i set the paper size and paper layout programmatically in RS. im using c#.net as prog. lang. for this. Pls help thanks!

View 11 Replies View Related

SQL Server 2005 Min/Max Security Best Practices

Jun 13, 2007

Does anybody have a link to either of these two documents. My company is getting ready to go through an audit and we need some firepower and to know what is expected. Any help with obtaining microsoft SQL Server 2005 best practices documents is appreciated.

-Kyle

View 3 Replies View Related

SQL Express Offline Security Best Practices

Apr 8, 2008

Is there anyway to really keep replicated SQL Server 2005 Express data secure when it is on a laptop and the laptop is stolen or lost. What would prevent someone from just reinstalling SQL Server on the laptop and attaching your database, or just attaching your mdf file to their own SQL Server. Is there anyway to keep that data secure in that scenerio?
Thank you

View 3 Replies View Related

Paper About SQL Server 2005

Jul 23, 2005

Hey,did anyone know a good paper or a good ms link about SQL Server 2005 -because I have problems to install the Beta Version..thanks very much

View 1 Replies View Related

We Have A New White Paper On Connectivity!

Jan 10, 2007

Dear Forum Members,

We've been working on a white paper targeting SSIS connectivity which we hope will help answer some of the key questions in the following areas :



What are the SSIS components and their support level for ADO.NET, ODBC, and OleDB?


How to deal with 64-bit connectors? what is supported, what is not?


Special sections on popular data sources such as SAP, Oracle, DB2, Flat File, XML.


A comprehensive list of data sources and available connectors from Microsoft and other 3rd parties.

You'll also find answers to why some of the things are the way they are today.

Note that this white paper is currently under official editing and publishing in Microsoft. It'll be a while before it goes public officially, but I wanted to share it with you, as the rich content it offers can't really wait. You'll find the paper in my blog, which is really a wiki site about SSIS connectivity fully open to public, so feel free to add/update content in there as you feel proper, and help the SSIS community with your wisdom!

A lot of feedback went into this white paper not only from Microsoft, but also from some of our partners and MVPs. I'd like to extend special thanks to Bob Beauschemin for authoring this challenging white paper.

Enjoy!

Deniz Erkan

Program Manager - SSIS

 

View 7 Replies View Related

Printing To Different Paper Trays

Sep 10, 2007

I'm trying to find out if there is any way I can embed anything in a report to tell it which paper tray to print to. So far, the only references I've found to such a capability are involved in using the Printer Delivery Extension. Does anyone know if this is indeed possible with that, or by any other means? Thanks!

View 3 Replies View Related

Display Paper Co Authored From Same Department

Nov 27, 2006

How to display the paper number that is co authored by authors from the same department?
The database structure:
Department(DeptNum, Descrip, Instname, DeptName, State, Postcode)
Academic(AcNum, DeptNum, FamName, GiveName, Initials, Title)
Paper(PaNum, Title)
Author(PaNum, AcNum)
Field(FieldNum, ID, Title)
Interest(FieldNum, AcNum, Descrip)
Thanks for help a lot

View 3 Replies View Related

Published Paper For Db Performance Strategies?

Jul 20, 2005

I am looking for some published paper regarding database performancetunning performance strategies. This is for academic purpose so itneeds not to be any commerical database specific. It will be evenbetter if the paper has some kind of methods to quantify/measureperformance. Has anyone come across with any interesting paper aboutthis?Thanks,ewong

View 2 Replies View Related

Margin And Paper Orientation Programmatically

Aug 16, 2007

Hello.
I have a report but by default it prints Portrait and 1.0inch Margin. I would like to programmatically set the values of my report to 0.2 inch margin and Landscape. I am using RDLC (Local Report).
Does anyone has an idea how to achieve this?

Jose

View 4 Replies View Related

Setting Paper Size To Be Default A4

May 30, 2006

Hi,

I have been trying to configure the Paper Size to be default "A4" instead of "Letter".
My Report is configured to 21cm x 29,7cm and margins 1,5cm.
The Body is configured to 18cm x 26,7cm.

Everything looks fine in the Preview but the Size is always "Letter". The printers are all configured for A4 printing.

Is there a way to set these default values in the Page Setup Toolbar or is it supposed to figure it out?

Thanks,
steinar

View 4 Replies View Related

Print Reports On Legal Paper

Jun 30, 2006



While working in the report project in Visual Studio, I set my Report Layout to 14w x 8.5h with .25 margins on all sides, and the page size to be 13.5in (to take into account the margins). When I print from the report viewer control in Preview mode, the report prints as it should, in Landscape on Legal paper without me changing any settings.

When I deploy the same report to the report server, and print from there, the report prints in Landscape on Letter paper (which causes some columns to print on a second page).

Why is there a difference in the two environments? Is there something I'm missing?

The goal is for the users to be able to print the report correctly without having them change any print settings in the dialog.

View 9 Replies View Related

Microsoft's Decision Tree Paper

Dec 6, 2007

Hi all,

I am searching for days for a paper explaining in details the decision tree algorithm that Microsoft uses. It would be very nice if parameters are described in details and the theory basis illustrated. I will be very happy to know in depeth fro this algorithm and how its parameter it affects the results.

Thank you in advance
Manolis

View 1 Replies View Related

Print Out Report By A4 Size Paper

Jul 31, 2007

Hi,

I have create a report with A3 size as there are too many fields., but i
wanna to print out on A4 paper properly. is that possible to do?


Cheers

Nick

View 3 Replies View Related

Print Stored Procedure In Color On Paper

Jul 18, 2007

I am trying to print a stored procedure in color to read it on paper.
But it prints in BW even on a color printer with color options.

I have printed the code in color using Rapid SQL. All I have now I query analyzer (SQL SERVER 2000)

any way to do this in SQL SERVER 2000

Ashley Rhodes

View 3 Replies View Related

Choose Paper Source By PDF Page Size

Jul 31, 2007

Does anyone know how to get SQL Reporting Services, when it runs a report, to tell Adobe Acrobat to "Choose Paper Source by PDF page size", which is an option in the print dialog box?

When I, or a user, runs a report in Visual Studio or live:


The report is set to render on 8.5" x 14" paper (legal)

The report is exported to a PDF

The report opens in Adobe Acrobat

The report is formatted on the screen to fit 8.5" x 14" paper (legal)

When "Print" is selected, the Preview has it on 8.5" x 11" paper (letter)

If I select "Choose Paper Source by PDF page size", then it fits it to the 8.5" x 14" paper (legal)
How do I tell it to "Choose Paper Source by PDF page size"?

View 1 Replies View Related

Reporting Services :: Print On Continuous Paper On SSRS

Aug 21, 2015

Paper is 21cm x 9cmPrinter is Epson LX-300..When I set this paper size, SSRS turns orientation to landscape and prints as if clockwise right rotated!I tried creating custom paper on print server options without success. I also tried setting the same paper size in Report Builder and Print Server but failed again.

View 3 Replies View Related

Microsoft's Connectivity White Paper Is Officially Published

Feb 14, 2007

Hello All!

Many of you have seen the draft version, but we finally have it out the door. You can download the new version directly from Microsoft's official site.

The momentum in our connecitivty wiki is growing! so check back and see if you can get useful information on 64bit, Office 2007 connecitivity, and samples.

Some of the recent activity in our connectivity portal:

***************

The new connectivity white paper is now officially available, click here (http://download.microsoft.com/download/2/7/c/27cd7357-2649-4035-84af-e9c47df4329c/ConnectivitySSIS.doc) to download.

***************

There's a new article from Deniz Erkan on Office 2007 Connectivity (Data Sources/Microsoft Office (2007)).

***************

Bob Beauschemin provided us a sample package to connect to Excel 2007.

***************

Microsoft's Partner ETI has a new separate page for connectivity offerings for SSIS (Data Sources/ETI High Performance Data Integration).

***************

Microsoft's Partner Persistent (Data Sources/Persistent Systems Products for SSIS) has put together a list of options for SSIS connectivity.

********************************************************************

View 4 Replies View Related

Automatically Print Multiple Copies Of The Same Report With Different Label On Letter Size Paper

Dec 31, 2006

Hi,

I am new to reporting services and I'm really stuck on a design problem. Can someone please help me?

I would like to design my own print function. When a user clicks on the print icon (preferably the one that came with reporting services), the report is automatically printed twice, once with "For Person A" and the second time with "For Person B" on it. It doesn't matter where these two labels are placed on the page. These two reports need to be printed on letter-size paper regardless of user's selection. How do I do this with minimum amount of code?

Any help would be greatly appreciated!

View 8 Replies View Related

QN Best Practices

Sep 18, 2007

Hi everyone,

I wonder if somebody here could recommend a good article about MS Service Broker. I'm looking for some advice and tips in designing applications using SQL Service Broker, mainly QN. For instance, maintenance routines and common faulty scenarios I might find later when my solution is implemented. I have googled for a while but all I can find are recopied examples of QN.

Thanks

View 3 Replies View Related

SQL 2012 :: Persist Security Info And Integrated Security In Connection String

Dec 4, 2014

I use from sql server 2008. and c#

what is the best connectionstring?

I don't know if i use Persist Security Info and Integrated Security or not?

And if yes then their value must be true or false?

View 1 Replies View Related

Code Access Security Across Multiple Assembly Security Extension

Oct 14, 2005

Hello there I have trying to figure out for days how to enable FullTrust for my Reporting Services security extension.

View 9 Replies View Related

SSRS -- Security Filter And Model Item Security Setting

Jul 31, 2007



Hi,


I have posted this issue for a week, haven't got any reply yet, I posted it again and desperately need your help.


The article http://msdn2.microsoft.com/en-us/library/ms365343.aspx says:
Model Item Security can be set for differnt security filters, but when I use SQL Server Management Studio to set Model Item Security, it seems "Permissions" property surpass "Model Item Security" property. -- My report server is using Custom Authentication.



For example, in "Permissions" property of the model, if I checked "Use these roles for each group or user account" without setting any user or group, no matter what users I added to "Model Item Security" with "Secure individual model items independently for this model" checked, NO one user can see the model on report manager and report builder;

in above situation, if I added "user1" and gave role such as "Browser" role to "user1" in "Permissions" property, if I checked "Secure individual model items independently for this model" in "Model Item Security" property, even I did NOT grant "user1" to root model and any entities under the model, the "user1" is able to access the model and all entities in report builder.



My question is on the same report model, how to set "AdminFilter" (empty security filter) for administrator permissions and set "GeneralFilter" (filtered on UserID) for general user based on their UserID?


The article also says:

"Security filters are always applied, even for users who have Content Manager or Administrator permissions to the model. To allow administrators or other users to see all rows of an entity on which row-level security is defined, you can create an empty security filter (which always returns True) and then use the filter to grant those users access to all the rows."



So I defined 2 filters "GeneralFilter" and "AdminFilter" for "Staff" entity for my report model "SSRSModel", I expect after I deployed the report model, the administrator users use report builder to build reports with all rows available, and the non-admin users can only see rows based on their UserID.



I can only get one result at a time but not both:

either the rows are filtered or not filtered at all, no matter how I set the "SecurityFilter" for the entity: I tried setting both "AdminFilter" and "GeneralFilter" for SecurityFilter at the same time, combination of "DefaultSecurityFilter" and "SecurityFilter", or one at a time.



Your help is highly appreciated!

Desperate developer

View 1 Replies View Related

SqlDataSource Best Practices

Jun 20, 2008

Hi I use data presentation controls like gridview, formsview in my application. In many of the webforms i also use multiple datasources mainly for the purpose of 2 way data binding for controls within data presentation controls.I am concerned about the performance issues this might cause as users using these pages increase.What is the likely performance impact ?Once the databind is done and values are populated in the respective controls, does the database connection of datasource control get closed, or is it open?What are the best practices while implementing datasource controls? 

View 2 Replies View Related

SQL 2000 Best Practices

Nov 16, 2001

Hi all. Thanks for taking the time to read this.

I'm looking for some documentation on SQL 2K Installation tips on a Windows 2000 Member Server platform as well as best practices for ongoing maintenance .

Real world experience as well as Microsoft propaganda are all welcome.

Thanks again.

View 1 Replies View Related

Best Practices ( Installation )

Dec 7, 2001

Could some one give best SQL 2000 install practices such as -
1) SQL app, should this be in OS drive or not ( pros, cons )
2) Should OS be on Raid 1

etc

Thanks,

View 3 Replies View Related

Best Practices To Optimize A DB ?

Sep 1, 2004

What are the best pactices to optimize performance accsiing an SQLServer DB ?

commands, mantenance plan...

Thanks

View 1 Replies View Related

DDL Best Practices Question

Jul 20, 2005

I am looking for some examples of how to manage DDL scripts amongvarious versions of a production db and development and testing. Ihave tried a few things in the past, and it always gets very muddledand cumbersome.I need to be able to build any version of the database from scratch,BUT I also need to maintain an upgrade path from any version to anylater version. So it is not enough to just maintain a master buildscript, but I don't want to maintain 2 different things (modify themaster build scripts AND create a new "ALTER" script for each versionchange).I thought I had seen an article somewhere that layed out a process formanaging this, but I can't find it now (I thought it was in SQL ServerMag). Does anybody know of this article or have a resource they couldpoint me to that outlines best practices in this area?Thanks,Jason Wood, DBA in training.

View 1 Replies View Related

Best Practices For Large DB

Jul 20, 2005

Hi All,My question is what are the best practices for administering largeDBs. (My coworker is the DB administrator. I'm more of thedeveloper. But slowly being sucked in.) My main concern is that wehave some DBs that take approx 3 hrs a night just to rebuild theindexes. I know that with MSSQL 2000, I can use partitioned views tobreak out the table(s) into smaller databases and tables. But we alsohave an older server that runs MSSQL 7. Lastly how do you handledrive space issues? Do you spread out the DB across multiple MDFfiles on different drives? Thanks in advance.

View 1 Replies View Related

Encryption Best-Practices

May 31, 2006

Please forgive me if I have overlooked a thread that answers this question, but I assure you that I have looked.

I would really appreciate a guide of sorts that would tell me the correct steps to take to properly secure a column in my database. I don't need specifics on how to do each step, I either have those already or can find them myself. In fact, I have already successfully encrypted and decrypted some data. I just want to make sure that I create the right keys and certificates and that I follow best-practices as far as backups and stuff is concerned.

Thanks,

Todd Sparks

View 1 Replies View Related

Best Practices Question

Jun 13, 2007

Environment is SQL Server 2005 x64 Enterprise running under Windows Server 2003 x64 Enterprise with four processors and 16GB of ram.

I have 28 data copy routines I would like to add to a SSIS package. They use the Data Reader Source to an ODBC database (InterSystems Cache) and copy the table contents to a SQL2005 database for reporting needs. The data rows in these 28 routines range from only 100 rows to over 6 million rows depending on the table. I have tested these individually and they work fine. My question is, is it a good practice to have all of these routines in a single package or can I expect performance degragation?

View 4 Replies View Related

Tracking Changes Best Practices

Nov 5, 2007

I've got a table that has frequent updates to it. I want 100% change tracking on this table though, so we can rollback to any previous version, or just see any changes people make.

Is there a best practice for things like this? Currently, I'm using a trigger on UPDATE to take the previous values and store them in a history table. This keeps track of who changes what, and when. Plus the most recent data is seperate and more performant to access.

I've also heard about putting an 'IsActive' flag on the main table and any changes that are made just get marked as In-Active and a new record gets added.

Any input?

Thanks!

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved