.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

Hackers Beware: Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

Get a peek at the new security features in SQL Server 2005 from a developer's point of view. While there are lots of admin enhancements, there are also plenty of dev-specific security improvements you can take advantage of, such as endpoint authentication and support for the security context of managed code that executes on the server. Here Don Kiely elucidates.

Don Kiely

MSDN Magazine June 2005

View Complete Post

More Related Resource Links

SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005


In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004

Load Balancing/Load Sharing features in SQL Server 2005/2008

Is there any load balancing features in SQL Server? My understanding is that SQL Server Clustering is not a load balancing feature.  Other features seem to be more like load sharing features: Degrees of Parallelism Table Partitioning Resource Governor seems to be more like a resource allocation feature.          

SQL Server 2005 Express (Advanced) warning msg. Requires 32-.bit ASP.net

Received the following warning error message while installing SQL Express Advanced. Now when I log onto Management Studio I was expecting to see Reporting Services but only have the database enginge and SQL Compact Edition. Do I need to download and install the 32-bit ASP.NET?  I'm on Windows 7 64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).

Security Update for SQL Server 2005 Service Pack 3 (KB970892) could not be installed


Auto updates picked up this update to install but it wouldn't install. I tried doing it manually with no success. Anyone run across this?I have the service pack 2 with updates already. What would cause this?

what are features included/ comparision between sql server 2000, 2005 and 2008



Could anyone tell me the features comparision between sql server 2000, 2005 and 2008 in the table format like below.

sql server 2000   features |    Extra features added/supported in 2005 |   Extra features supported in 2008

Note: Please do not give any links.




Security Update for SQL Server 2005 Service Pack 2 (KB960089)

Each time I attempt to install the above update it fails.   I am on Windows 7.   Can anyone help please. 

Security Update for SQL Server 2005 Service Pack 2 (KB970895) - Error Code: 0x733F -


Thie above update fails to install at every attempt. I've looked around and found others with the same problem, but many of the "solutions" are way too technical for me. I've been asked to post the "summary.txt" file from the hotfix folder in this forum, and it appears below. Please help.

Time: 11/27/2009 14:51:37.449
KB Number: KB970895
Machine: ASUS
OS Version: Microsoft Windows XP Professional Service Pack 3 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3080
Command-line parameters specified:
Cluster Installation: No

Prerequisites Check & Status
SQLSupport: Passed

Products Detected                         Language  Level  Patch Level       Platform  Edition
SQL Server Database Services 2005 (SQLEXPRESS)  ENU       SP2    2005.090.3077.00  x86       EXPRESS
SQL Server Tools and Workstation Components 2005  ENU       SP3           9.3.4035  x86       EXPRESS

Products Disqualified & Reason

Unable to install SQL Server 2005 Express Edition with Advanced Services Service Pack 4 (KB2463332)



Rookie here. Using SQL for an eBay software program we have been running for two years. There were simple step by step instructions to install -- point being, I really dont understand this stuff.

Running Windows XP SP3.

Automatic Updates is trying to install the version shown in the Title of this message. It fails to install and gives me the error: SQL BPA command line has encountered a problem and needs to close.

I do not know where to access the error log. I will post if someone can tell me the correct one to find. In the following directory, C:\Program Files\Microsoft SQL Server\, there are directories for MSSQL.1, MSSQL.2 and MSSQL.3. Two of them show log directories with today's date.

Any and all help is very much appreciated.

Thank you!

SQL Server 2005 Try and Catch Exception Handling

I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:

sql server 2000 vs 2005


i would like to ask what the difference between sql server 2000 and 2005 

How to save Unicode in SQL Server 2005

I am using google transliteration to display the text in Hindi/Tamil

I tried to store the text appear as Hindi from textarea in an nvarchar
field of database (SQL Server 2005) , the text saved as "???????".

After retireving text from the same it display the text as "???????".

Can anyone help me how to store and retrieve the actual data from SQL
Server 2005?

I am using ASP.net,VB.Net and SQL Server 2005

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

sql server 2005 enterprise edition is required


sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks


need help: HTMLEditor, Sql-Server 2005 and CrystalReport


Hi All,
i use the Ajax Control Toolkit HTMLEditor in VS 2008 web-project and save the formated text/content in Sql-Server 2005 - it works fine!

Now, i want print the formated text in a Report, with CrystalReport...??? is this possible?

How do i handle the process? i thing, i see the forest based on all the trees not more...

Can anyone help me? how to do?


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

SQL Server 2005: Regular Expressions Make Pattern Matching And Data Extraction Easier


Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.

David Banister

MSDN Magazine February 2007

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

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