Creating a Credential in SQL 2008 Server

Introduced in SQL Server 2005 Credentials is a new security feature on top of the security
policies to address the issue of privileges one can have while accessing a resource outside the
boundary on the network. Net Framework makes the outside access very easy with procedural code and credentials provide the security backup. This is continued in SQL 2008 as well. This short note shows how you may create credentials in SQL Server 2008 .

Step 1:

In MS SQL Server Management Studio expand the Security node and right click on the Credentials folder and from the pop-up click on New Credentials... as shown.

Step2:

This opens up the New Credential window. You provide a name for this, for this note

' mysorian' is used.

Step3:

Click on the ellipsis button along the field 'Identity'. The identity has a login to the local
server. This opens the Select User or Group window. The Object Types button will bring up the accessible Object Types. Here the USER or Built-in security prinicpal has been brought in. The location is the local computer. Insert a local identity such as the one shown. Click on the OK button.

Step4:

This will bring you back to the New Credential window. Now provide a password and confirm it by entering it again, it better be strong. If you need to encrypt this, you may choose to do so and finally click on the OK button. A credential gets added to the Credentails folder.

That's all folks.

HTH

Jay

Fascination with "Gone with the Wind"

Is it really going to be so?

Review this quoted text from New York Times,

"She was impossible to miss in the sea of dark suits and Supreme Court dark robes. Like Scarlett O’Hara after a public humiliation, Hillary showed up at the gathering wearing a defiant shade of red."

Multi-version support in VS 2008

Multi-version targetting is a new feature in VS 2008 that makes it easier to target applications to different NET Framework versions from a single IDE. Of course this does not include 1.1. You choose the version you want to target while creating a project. Notice the top right drop-down in the next figure which allows you to choose the version. The IDE and all related code will be applicable to that version. In this new project window targeting the 2.0 version you see the templates for VS projects applicable to this version.



When you choose 3.0 the window changes as shown in the next figure.



You see lot more templates and the WPF and WCF related templates.
All aspects of the IDE to support the chosen version will be active.

This one is for the 'Data' in version 2.0



This one is for Data in version 3.5



For developers this makes it easier to handle user complaints about version problems.
VS2008 Professional Edition with Visual Basic as the chosen language were used.

My articles on Microsoft Reporting Services

Review of these articles may help in understanding Microsoft SSRS (Vs 2003 & VS 2005; SQL 2000 and SQL 2005) in a reasonable amount of time.

On Importing an Access Parametric Report into SQL 2000 Reporting Services

ASP.NET and SQL 2000 Reporting Services

SQL Server 2000 Reporting Services: Creating a report from scratch

Creating a Chart with SQL 2000 Reporting Services

Building a Multi-table Report with SQL 2005 Reporting Services

Generating and Hosting a SQL Server Reporting Services Report Using SQL Server 2005 Business Intelligence Development Studio

This reader liked the article and he was kind enough to communicate to me:(name is masked)

Feedback sent from IP: 193.188.161.31
Referring URL: http://aspalliance.com/819Thankyou for providing such beautifully documented/illustrated mini tutorial on Reporting Services. Had purchased a book to learn RSS, but your tutorial although short was very precise and you spoke to the point. I really liked your method of exposing the basic intricacies in the Reporting Server. I now find it more easy to approach the Reporting Server.Thankyou once again for your efforts.Best Regards,XXXXXXX
"

Microsoft makes a bundle. No Wonder

No wonder Microsoft is good at making lots of money.

You know what, I was flying from Tokyo to Minneapolis on 1/1/08 and midway pops up on the display monitor a short ad on Microsoft SQL Server 2005. They leave no one, not even the travel weary Northwest passengers.