Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Connection Error

Author  Topic 

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-05-15 : 09:23:01

Hi Gurus,

I am facing issue as Cannot Connect to AML-DB
while iam connecting to SQL SERVER 2005.
using sa login

It says as
A connection was sucessfully estsblished with the serverbut then as error occured 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)

Your help is much apperciated.


Thanks,
ServerTeam

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-15 : 09:36:30
did you enable TCP/IP?
Go to Top of Page

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-05-15 : 09:41:58
yes..

Yesterday no issue while connecting..
Iam facing this today..

Thanks,
ServerTeam
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-15 : 22:39:38
Try connect with tcp/ip or named pipes, shared memory is for local connection only.
Go to Top of Page
   

- Advertisement -