.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Simplify SQL Server 2008 Security

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
We are in the process of an application rewrite from the DB level up.  Our current DB is SQL2000 and we have just purchased SQL2008 R2.  I've read through various articles regarding Login's, Users and understand the difference.  I am confused about Schema's and their benefits. I have created two Login accounts as WindowsLogin1 and WebLogin1.  I have also created a database called MyDB with two tables T1 and T2.  I’ve also created a WindowsUser1 and WebUser1 user accounts.  So far so go, now for some questions: 1.       If I want WindowsUser1 to have Select, Delete, Insert, Update and Execute permissions on both T1 and T2 tables, should this be done with a role or schema (and how). 2.       If I want WebUser1 to only have Select, Delete, Insert, Update and Execute permissions on the T2 table, should this be done with a role or schema (and how). 3.       If we are using Schema’s for questions #1 and #2, do we construct two distinct schemas? 4.       What about stored procedures?  Should they be added as part of the schema (i.e. Server.MyDB.Schema1.myStoredProc1? 5.       Should the tables T1 and T2 be contained by the schema? 6.       Does adding schema

View Complete Post

More Related Resource Links

Security of SQL Server 2008 R2


Hi everyone!

I want to build a db and that some people could use it in the Internet...

I have SQL Server 2008 R2, but I need to get permission to use it on the internet...

I wanted to know how secured is this, and if you can get  a link that explains the Security, because i need to improve this is secure...


Thank you very much

Best practises for web development, SQL server 2008 and IIS and network security



We are in the midst of developing WEB application using .NET. so, i would like to know the Best practises for ASP.NET development, SQL server db, IIS security and network security as well. Where to get the information?   Any URLs or sites?  thanks in advance. I googled for it, but i cannot get the complete set and the info was updated 7 years ago..  http://msdn.microsoft.com/en-us/library/ff649874.aspx    http://msdn.microsoft.com/en-us/library/aa302415.aspx  

 thanks in advance..


sharepoint security groups, ACL of site collection or subsite need to move in to sql server 2008 usi


HI Team,

I am new to sharepoint here is my query. i am working on MOSS 2007, SQL server 2008

I want to move the sharepoint security groups, ACL(access control list), user groups all the security and permission related data to sql server 2008 from a particular site collection or subsite. After getting the data in to sql server we should be able to update the users from sql server itself which should reflect in sharepoint sites.

Domain groups in Cluster Security policy during install of SQL Server 2008

I am trying to install SQL Server 2008 on Windows server 2003 and have a question about the stage of 'Cluster Security Policy'.

We need to select 2 groups here, one for SQL server database domain group and the other for SQL server agent domain admin group.

My question is, is it different from service accounts that we used to specify in previous versions? I remember the wizard asking for service account that the sql services need to run under. Is this domain group part a replacement for those individual service accounts? If yes, do I need to have the service account added to a separate group and select that group in this part of 'Cluster security policy'?


Cluster Security Policy -- Configuration in SQL Server 2008 R2 (Side by Side with SQL Server 2000


Hi all

Please I have SQL Server 2000 running on Windows 2003 SP2 (A/P) Cluster,Now we are adding new SQL Server 2008R2 Instance to Cluster.

I want know "Database Engine Domain Group","SQL Server Agent Domain Group" section,can I select excisting SQL Server 2000 Engine Domain group or I required to Configure  some thing else.


How to find out "Database Engine Domain Group","SQL Server Agent Domain Group" of  excisting SQL Server 2000.


Thanks in Adavnce




About SSAS security on Windows server 2008


Hi Experts:

I set up a role on SSAS cube, and only users in this role can see/process the cube.

And I tried to test it by removing my NT account from not only membership of role on this cube but also administrator group of Win Server 2008R2. The problem is, when I use Excel 2007 to connect the cube on my local PC, I can still see/process this cube...

My NT account is not longer in role's memebership list or Server's administrator group, but why I can still access it...

Any thoughts?  Your help would be greatly appreciated, thanks!

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

sql server 2008 adventureworks database


dear Friends

For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 

And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	

Please help me to overcome this issue and let me know where can I download that database too.

Thanking you

happy Coding

PostGreSQL to sql server 2008?



I am new to POSTGREsql.

I have a database built in POSTGresql and I have to migrate it to SQL SERVER 2008.

How can I do that?



Word Automation Issue in Windows Server 2008 Hosting



The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.

With Regards,


No ASPNET User in Windows Server 2008?


I have been looking everywhere online regarding this, but have not found a clear answer.


I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.


I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.


I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.


Did I set the server up wrong? or do I have to do something within ASP.Net to  create this user and then give it rights? 

Not working on Windows Server 2008




I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.

We are using SharePoint 2007.

Is there another work thru for 64bit environment.

I notice windows server 2008 has a directory  C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???

Please help!

Security Briefs: Add a Security Bug Bar to Microsoft Team Foundation Server 2010


Take a peek inside Microsoft's strict development security structure as Bryan Sullivan describes the objective security bug classification system?the "bug bar"?used by internal product and online services teams. He will show you how to incorporate this classification system into your own development environment using Microsoft Team Foundation Server 2010.

Bryan Sullivan

MSDN Magazine March 2010

Under the Table: Programming with FileStreams in SQL Server 2008


There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches.

Bob Beauchemin

MSDN Magazine May 2009

Under The Table: Spatial Data Support In SQL Server 2008


New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend