An IT Solution

How to create User Login in Sql Server 2005/2008 Note - You must be a member of "system admin" to create a new user or database. Following is the steps to create user login in database for database level security :- Step 1 . Open Sql Server >> Enter User Name >> Enter Password >> Click Connect Step 2 . Open Security >> Logins >> Right Click >> New Login Step 3. Enter login name >> Select Radio button "Sql Server Authentication" >>Enter password>>Enter confirm password>> Un-Check Enforce password policy >> Click Ok Step 4. Right click on Databases >> Click new database Step 5. Enter Database name>> Owner "<default>" >> Click Ok Step 6 . Open Newly created database (My Case it is Test)>> Security>> Users>> Right click on dbo >> New users. Step 7. Enter user name>> Login name >> default schema...

Task - Expose Sel Server to Internet or Remote Access via IP OS - Windows Server 2008 R2 Sql Version - Sql Server 2008 R2 To expose the server to internet we need open port for sql server (default port is 1433) To open a port in the Windows firewall for TCP access 1. On the Start menu, click Run, type WF.msc, and then click OK. 2 . In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane (upper right corner). 3. In the Rule Type dialog box, select Port, and then click Next. 4. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, In my case we are using the default which is 1433. Click Next. 5. In the Action dialog box, select Allow the connection, and then click Next. 6. In the Profile dialog box, I am going to Leave Domain turned on and turn private and public off. Then click Next. 7. In the Name d...

Generally the cause of Server Application Unavailable is the .net framework. Error Snapshot For ex. one of our site is in version 1.1 and the recently added site is in 2.0 or later or any other different versions running on the IIS. How to Resolve:- We need to create a new application pool on the IIS and assign the same to the version of the site. Following image illustrates how to check the version of site. For ex. Pool3_5 for version 3.5 and  Pool4_0 version 4.0 . Following image illustrates how to create new Pool. Step 1: Step 2: Step 3:  You can also verify the IIS logs to locate the issue.

While setting up an new Web server with Windows Server 2003 and IIS 6. I have to set up my own custom domain (for ex. myname.com) as the default site on IIS. Means if I will run the server from IP my custom domain has to run. The process is so, easy we need to setup few things in custom site. Right click on Site>>Properties>>WebSite>>Click on Advnaced Button>>Leave the "Host header value" to be blank. Please refer the image..

Configuration:- Windows Server 2003 R2 32 bit Sql Express 2008 R2 While checking for server event as a part of maintenance we a information which is occuring after every 1-10 seconds the information is Event "Starting up database DatabaseName" We found the solution and implemnted the same. You need to open "Sql Express Management Studio>>Database>>Properties>>Options>>Auto Close" and set it to false. For more information on this property, please refer http://blogs.msdn.com/b/buckwoody/archive/2009/06/24/sql-server-best-practices-autoclose-should-be-off.aspx http://msdn.microsoft.com/en-us/library/ms135094%28SQL.90%29.aspx

We are developing Application for Google Smart TV and all is going well. We are using Table, Div or some other elements which cannot be focused on using .focus() of java script. We have used Table to show data in one of our page. Our target is to set the focus on first element of table i.e. first row. We tried different solutions suggested on web but nothing worked. All the posts are suggesting to use focusable controls like text box, check box etc. Finally we found solution on http://groups.google.com/group/mozilla.dev.tech.css/browse_thread/thread/42591922d95c6399 In the post "Stanimir Stamenkov" has used a term "if you just define a 'tabindex' on the element it becomes focusable" I assigned "tabindex" property to table row and then used .focus() and the focus reached to row. Hope this will help all who are looking for such nice solutions.

I am using asp.net 4.0 with Sql server. I have an requirement to pass special characters in URL query string. for example my URL need to be like http://mysite.com/default.aspx?a=xyx(abc) In the above URL my special character is "(" and ")". While development I have not faced any issue but as I uploaded the files to serve it start giving error 404 (page not found) where ever I have use "(" or ")" special characters. When I started searching I have tried many solutions. but nothing works for me. Then on some site some one has sugested to check IIS log. When I checked the log I found that I have Installed Microsoft URL Scan 3.1 on my server which is filtering the URL. So, I need to allow "(" and ")" on my server so, I decided to allow there characters in my URL. So, to add exception to URL Scan 3.1 you need to open urlscan.ini which you can find in "%windir%\system32\inetsrv\urlscan\" You can use 2 section...