Friday, December 28, 2012

Connect to SSMS through other domain-user's Windows Authentication

Usually we have only two options to run the SQL Server Management Studio (SSMS):
1. Windows Authentication
2. SQL Authentication
Ofcourse everyone knows this :)

Obviously, Windows Authentication works with currently logged-in user.
But sometimes, we need to run SSMS with other domain user i.e who had little more permissions than us.

To do so the trick is to Create a shortcut for SSMS as follows:

C:\WINDOWS\system32\runas.exe /user:DOMAIN-NAME\USERNAME /netonly "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

Provisw domain and username of the user specifically. While opening SSMS, it opens command prompt and concern user's password to be entered.

Thats it, now we can have SSMS opened in another user's Windows Authentication mode.

Hope it helps you too.

Friday, December 21, 2012

Load IIS configured web projects while IIS is not installed in your system

Hi Guys.. 

There could be situation where web applications would be created under IIS and while opening the projects if IIS is not configured or respective virtual directories are not created then we encounter with following error message:

The Web Application Project XXXXXXX is configured to use IIS. The IIS Web server is not installed on this computer.


1. If IIS is installed then create a virtual directory and reload the project.
2. If IIS is not installed in your system , then open the respective .csproj/.vbproj in notepad and modify an XML attribute. i.e. Modify from <IISUrl> to <CustomServerUrl>

<IISUrl> http://localhost/MyWebPrj</IISUrl>
<CustomServerUrl> http://localhost/MyWebPrj </CustomServerUrl>

Now, reload the project. From now on it will work through file system. i.e. http://localhost:xxxx/MyWebPrj

where xxxx = port no.

Hope it helps you.


Thursday, December 13, 2012

Return user control from web service and performance boost details

Great article from Encosia.

1. Boost ASP.NET performance with deferred content loading
2. Creating usercontrol and adding to page control at server from web service method and returning it to consumer.

Parsing of XML in C# - 5 ways

Parsing of XML in C# - 5 ways

1. Using XmlTextReader class
2. Using LINQ to XML methods
3. Using the XmlReader.Create Method
4. Using the XmlDocument.GetElementsByTagName Method
5. Using Dataset and DataTable Object

For detailed explanation please refer