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.

Are you planning to install SQL 2008 Server?

If you hit a hard wall during SQL 2008 Server installation you may want to read this article. Starting with a clean state is the best approach and the next best is "Sweat & Struggle".

Visual Studio 2008 Installation could be taxing

Trying to install VS 2008 did not succeed as it failed in the first step of installing NET Framwork 3.5.



Looking at my Add/Remove progams I had the following listed which I assumed had direct bearing on VS 2008 Installation:



MSFT .NET Framework 1.1 -->35.97 MB

MSFT .NET Framework 2.0 SDK ENU-->418 MB

MSFT .NET Framework 2.0 SP1 -->185MB

MSFT .NET Framework 3.0 ---------->58 MB

MSFT FXCop--->6.99MB



My /Windows/MSFT.net/Framework folder had the following:

v1.0.3705

v1.1.1.4322

v2.0.50727

v3.0

v3.5.20404

-------------

I removed the 2.0 SDK ENU and 2.0 SP1

I reinstalled .NET Framework 2.0

Tried to install NET Framework 3.5 and failed

-----------------------

Tried removing the existing .NET 3.0 with cleanup tool

I had to run the cleanup tool twice to clean the Net 3.0 but looks like NET 2.0 installed in the previous iteration had also disappeared.

I confirmed using the NET Verifier tool.

I made sure that the Media Center App was still working as well as SQL 2008

--------------------

I tried to install NET Framework 3.5 [dotnetfx35.exe, Version:3.5.21022.08].

Voila! It succeeded.

Now I see the following new ones in my add/remove programs:

MSFT .NET Framework 2.0 SP1 185 MB

MSFT .NET Framework 3.0 SP1 184 MB

MSFT .NET Framework 3.5 29.1MB

--------------------------------

After this VS 2008 installed without any problem.
Log files are great if only I could use them effectively or I find a sympathetic MVP.

You were cleaning up NET Framework programs and your Media Center Program does not work anymore.

I had various versions of NET frame work installed on my Windows XP SP2 Media Center Edition Toshiba Satellite Laptop machine.

The problems started when I wanted to remove the pre-release Net 3.5 from my computer. The Microsoft recommended method was to use the Add / Remove programs tool. Although it works most of the time, if something in the program is missing or altered, it will be difficult to use this tool as it will not work.

I took the suggestion of Nick Doty to remove it using .NET Clean-up tool. This is a good tool however while removing Net 3.5 it removed some of the other files. I am not sure how it happened. Not only I could not remove Net 3.5 the Media Center program stopped working and threw many exceptions. Then I began to see some day light.

I used the Clean_up tool and methodically removed version of Net by version each time running the NET verifier tool. Sometimes I had to go back and remove using the Add / Remove program after repairing the .NET by reinstalling on top of the broken.

I went back to Aaron's blog and did everything suggested verbatim.

After removing all of the NET I reinstalled all of them back. When I brought back 1.1 and 2.0 then only I could recover the functionality of my Media Center application. Not that I care for this tool but simply I don't like something broken.

After this I installed SQL Server 2008 which went without a hitch.

I am now installing VS 2008 and the problems are not over....

For a complete transcript go to MSDN forum.

The verifier, clean up tools are great and I recommend Aaron's blog if you face problems similar to mine.

Sun plays its trump card

Sun might have beat Oracle in buying MySQL. I think this is a good thing for SUN to bet on this product which is a part of the growing [grown] LAMP community. However despite name change from SUNW to JAVA and its unit value, the bottom line has not improved. Hope this new acquisition brings in more business.

Good luck SUN.

Your Outlook Express is misbehaving --Don't Panic

You might have noticed that your Outlook Express does not behave as it used to in the recent past. You get messages such as this one,



Then you try to diagnose and try to run ipconfig from your command prompt and then you see something you had not seen in the past. You see a new interface such as this one:
Tunnel adapter Teredo Tunneling Pseudo-Interface:

What the heck is this?

This is required when the full iPv6 comes into existence. It probably came with the Window's update. I run Windows XP with SP2. When this [Tunnel adapter Teredo Tunneling Pseudo-Interface:] is seen your test for ipconfig /all shows this (some of the addresses have been tampered in the pasted result):

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Jay>ipconfig /all

Windows IP Configuration

Host Name . . . . . . . . . . . . : Hodentek
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Realtek RTL8139/810x Family Fast Eth
ernet NIC
Physical Address. . . . . . . . . : xx-xx-xx-xx-xx-xx
Dhcp Enabled. . . . . . . . . . . : No
IP Address. . . . . . . . . . . . : 192.168.1.100
Subnet Mask . . . . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . . . . : fe80::213:xxxx:xxxx:xxxx%4
Default Gateway . . . . . . . . . : 192.168.1.1
DNS Servers . . . . . . . . . . . : 192.168.1.1
fec0:0:0:ffff::1%1
fec0:0:0:ffff::2%1
fec0:0:0:ffff::3%1
Primary WINS Server . . . . . . . : 192.168.1.101

Tunnel adapter Teredo Tunneling Pseudo-Interface:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Teredo Tunneling Pseudo-Interface
Physical Address. . . . . . . . . : FF-FF-FF-FF-FF-FF-FF-FF
Dhcp Enabled. . . . . . . . . . . : No
IP Address. . . . . . . . . . . . : fe80::ffff:ffff:fffd%5
Default Gateway . . . . . . . . . :
NetBIOS over Tcpip. . . . . . . . : Disabled

Tunnel adapter Automatic Tunneling Pseudo-Interface:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Automatic Tunneling Pseudo-Interface

Physical Address. . . . . . . . . : xx-xx-xx-xx
Dhcp Enabled. . . . . . . . . . . : No
IP Address. . . . . . . . . . . . : fe80::5efe:192.168.1.100%2
Default Gateway . . . . . . . . . :
DNS Servers . . . . . . . . . . . : fec0:0:0:ffff::1%1
fec0:0:0:ffff::2%1
fec0:0:0:ffff::3%1
NetBIOS over Tcpip. . . . . . . . : Disabled

You may uninstall this feature, and there is extensive Microsoft Documentation for all sorts of Windows versions. The following command will uninstall this feature and will bring it back to how it used to be. After the command is run you will have to reboot for it to become effective.

C:\Documents and Settings\Jay>netsh
netsh>interface ipv6 uninstall
A reboot is required to complete this action.

How reliable are the Financial Institutions

Read this New York Times article:
Borrowers Face Dubious Charges in Foreclosures

The news article draws your attention to the ugly side of business. If you think your loan or investment is safe in the hands of business who is looking after it, you are mistaken.

I have an investment (401k) with one of USA's most visible brokerage companies who for the last ten or more years did not even have the correct date of birth on their records.
I have an investment in another very visible brokerage company who [trumpets every half hour about how good they are] gives me a 1099 with questionable entries, duplicated entries. They are not even ready to apologize.

As a home owner I would like to see the complete transactions from the day I took the loan to the day I am closing the account that should include dozens of mortgage providers and also look into the complete escrow management for property taxes and other miscellaneous expenses.

Commercializing the Gods

No comments just pictures taken at the Indo-American festival in Central New Jersey 2007.

You are invited to comment!!

About my new book on SSIS

About this book

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move on to more advanced ETL [Extraction, Transformation, and Loading]. The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. A majority of SSIS tasks are covered in this book and they are described fully in the summary of table contents section. You start building packages right from Chapter 2 and continue on to Chapter 20 gathering and building upon your knowledge in each step.






The book will give you step-by-step explanation of the examples in the book. In each chapter you will get a little background of the SSIS task that you are going to create. You will then step through the numbered steps, creating, configuring, executing, and reviewing the results. The book has minimal coding (only two chapters) and exclusively uses the Visual Studio 2005 Designer.

This book is written for beginners in the developer track who are looking to get an exposure to SQL Server Integration Services; DBA's who are testing water with the Visual Studio IDE but without a wide programming experience; SQL 2000 Data Transformation Services users who are trying to move into SQL Server 2005 Integration Services; Microsoft programming professionals in Small Businesses who wear multiple hats (jack of all) - developer, programmer, and dba with a little bit of experience in each of these.

Enabling Server data with native web service

Read the following article to see how it is carried out on a SQL Anywhere Server.

Web enabling data on a SQL Anywhere Server using a native web service

Exposing server data to intranet / internet, an attractive and much needed method has become possible due to the native web services, services that can be created on the database itself to which HTTP or Soap requests can be made. Microsoft Access in some of its versions provided this dynamic capability via Data Access Pages and this became possible from Microsoft SQL Server directly, only in its 2005 version. However MS Access 2007 does not support Data Access Pages instead recommends the use of SharePoint server. SQL Anywhere server, even in version 9.0 possessed this built-in capability.