Microsoft SQL Server 2008 Error:233

Microsoft SQL Server 2008 Error:233 - Solution

Error in Sql Server 2008 R2 Error : 233 - Solution

Previously I was Explained about Unable to connect SSMS, Microsoft SQL Server, Error: 53 ,

SQL Server 2008 R2 Setup Error - is not a valid login or you do not have permission .

A connection was successfully established with the server, but then an error occurred during the login process.

(provider: Shared Memeory Provoder, error: 0 - No Process is on the other end of the pipe.)Microsoft SQL server error:233

After several frustrating attempts to get this resolved, I completed the following steps to resolve the "Microsoft SQL Server 2008 R2, Error:233.

1. Log into an administrative account that has access to both the machine and sql server 2005 database
2. Open up SQL Server Management studio with "Windows Authentication"
3. Click on the security folder
4. Click on "logins" - Sa
5. Then click on the account that is not working (Sa or any other user Names)
6. Answer - Make sure there is a database within the "Database Default" specified "I placed the admin account to master"

In my case there was no database specified within the default which put the login into limbo causing the Error:233

( or )

Answer : In Sa Login Properties dialogue box Under Security Tab you need to set login Enabled if it was Disabled mode .

Comments

ASP.NET e-Commerce website GridView with Product Listing

Introduction : E-Commerce web applications are everywhere these days, and many share a common set of functionality. In this article, I will show how to use the GridView and ListView controls to build a powerful product page with many of the features found on today's e-commerce sites. We'll build a bicycle store product grid using some free clip art bicycle images. The example files are user controls which can be easily added to a page. We're only using three images here to keep the size of the sample application small. In previously I was explained about Sending Email from Asp.net With Dynamic Content , How To Export gridview data to Excel/PDF , CSV Formates in asp.net C# , How to print Specific Area in asp.net web page How To- Search records or data in gridview using jQuery . A shopping cart application would require to display the products in a multi column grid, rather than a straight down list or a table. The each item in a product grid would have

How to hide url parameters in asp.net

There are different ways to Hide the URL in asp.net , you can choose any one from bellow options . Previously I was Explained about the Difference between Convert.tostring and .tostring() method Example , Reasons to use Twitter Bootstrap , How to Register AJAX toolkit in web.config file in asp.net a) Using Post Method b) Using Of Session . c) URL Encoding & decoding process . d) Using Server.Transfer() instead of Response.Redirect() method (1)Use a form and POST the information. This might require additional code in source pages, but should not require logic changes in the target pages (merely change Request.QueryString to Request.Form). While POST is not impossible to muck with, it's certainly less appealing than playing with QueryString parameters. (2)Use session variables to carry information from page to page. This is likely a more substantial effort compared to (1), because you will need to take session variable checking into account (e.g. the

Nested GridView in ASP.NET Using c# with show/hide

In This example shows how to create Nested GridView In Asp.Net Using C# And VB.NET With Expand Collapse Functionality. Previous post I was Explained about the ASP.NET e-Commerce website GridView with Product Listing , How To Export gridview data to Excel/PDF , CSV Formates in asp.net C# , Sending Email from Asp.net With Dynamic Content , SQL Server- Case Sensitive Search in SQL Server I have used JavaScript to Create Expandable Collapsible Effect by displaying Plus Minus image buttons. Customers and Orders Table of Northwind Database are used to populate nested GridViews. Drag and place SqlDataSource from toolbox on aspx page and configure and choose it as datasource from smart tags Go to HTML source of page and add 2 TemplateField in <Columns>, one as first column and one as last column of gridview. Place another grid in last templateField column. Markup of page after adding both templatefields will like as shown below. HTML SOURCE < a

Asp.net,C#.net,Sql Srver problems and solutions Blog

Search This Blog