Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Tek-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...Keep up the good work - excellent site - i'd been looking for something like this for ages !..."
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!

Tek-Tips Shirts!

Get Tek-Tips Swag
Get your
Tek-Tips Forums
SWAG here!
Home > Forums > Programmers > DBMS Packages > Microsoft SQL Server: Setup and Administration Forum

Cannot connect to SQL Server 2008Helpful Member! 

thread962-1688284
Read More Threads Like This One
endhey (Programmer)
16 Jul 12 0:45
Dear all,

i've a problem with my database sql server 2008,,
when i trying connect to database engine with sql server authentication, occurred this error :
" A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) "
i've try to enable shared memory and named pipes on sql configuration tool and restart the services,but the error still occurred,,

NB : - i was disable account windows authentication so i can't login with windows authentication,,
- this error occurred after i disable services on start up and when i manualy start the service the error occured,,

any answer would be appreciated,,

Thanks,,
SQLBill (MIS)
16 Jul 12 17:46
Are you positive the services are running?

What is the service account log on as? Is it a Windows Account? If so, you've shut off access to Windows Accounts and that might be keeping SQL Server from actually starting up.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875: What should I know before I post?

endhey (Programmer)
17 Jul 12 22:33

Quote (-SQLBill)

Are you positive the services are running?
yup,i'm sure the services are running..

Quote:

What is the service account log on as? Is it a Windows Account?
i log on using SQL Server Authentication,coz i've been disable Windows Account.

thanks for your response..
Helpful Member!  SQLBill (MIS)
18 Jul 12 10:53
Not YOUR account....what is the account used by SQL Server and SQL Server Agent services? If they are Windows accounts, I'm not sure SQL Server will be able to start up.

Connect to the server itself. Go to Start>Administrative Tools>Computer Management. Find Services and click on that to expand it. Find the SQL Server services. The ones we care about right now are the SQL Server one and the SQL Server Agent one.

1. Are they started?
2. Are they set for Automatic?
3. What login do they use?

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875: What should I know before I post?

endhey (Programmer)
18 Jul 12 21:26
Yes,they are started and set for automatic,, i've been set up SQL services automatic and my SQL server has work well..

Thanks a lot for your answer and help
Read More Threads Like This One

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft SQL Server: Setup and Administration

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close