sql server login problem

Question

0.00/5 (No votes)

See more:

SQL-Server

sql server problem error:233 and 18456

please give the solution.

Posted 3-May-12 4:09am

amperayani

Add a Solution

Comments

jim lahey 3-May-12 10:13am

please give a more detailed description of the error, like the full contents of the error message, version of sql server, method of connection etc.

amperayani 3-May-12 10:22am

"A connection was successfully established with server but then an error occurred during the login procees (priovider:shared memory,error:0 ,No procees is on other end of the pipe )(microsoft sqlserver ,Error :233"

it is saying like this

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mantu Singh · Accepted Answer · 2012-05-03T04:53:00

Solution 2

The message you specify means SQL server service is not running on the system

Try the following:

Start ....> SQL SERVER 2005>SQL Server Configuration manager

And Start the Sql Server Service...............

If startup of service fails your installation may be corrupted....

Best of luck..........

Posted 3-May-12 4:53am

Mantu Singh

Comments

amperayani 3-May-12 11:05am

Thanks . i got it

Mantu Singh 3-May-12 11:10am

U r welcome......!

Sandeep Mewara · Accepted Answer · 2012-05-03T04:39:00

Solution 1

As per this discussion[^], the root cause is AUTO_CLOSE database option is turned on by default for SQL Express. Details here: MSDN: ALTER DATABASE SET Options[^].
Try:

SQL

ALTER DATABASE DBNAME SET AUTO_CLOSE OFF

Posted 3-May-12 4:39am

Sandeep Mewara

Comments

amperayani 3-May-12 10:46am

i am using sqlserver enterprise edition not sqlexpress
it is showing same on loging

Sandeep Mewara 3-May-12 11:32am

Did you try the above query and see?