March 6, 2009 at 6:34 am
Hello All,
I have created a ssis package (Task: Transfer SQL Server objects) which was transferring all objects from one database to another database on the same instance then I executed that package. Unfortunately that package was not executed successfully. But the issue is after executing that package when I tried to login the instance it gave me below message.
A connection was successfully established with the server, but then an error occurred during the login process. (provider:Shared Memory Provider, error:0 - N0 process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
Shared memory and TCP/IP is enabled.
I tried with other ID's but got same error.
I have bounce the SQL services and server also but no luck.
If anyone is aware of this problem. Please let me know the resolution.
Thanks in advance.
Regards,
Austin
March 6, 2009 at 6:54 am
What is the edition of sql server? Also, check sql error logs.
MJ
March 6, 2009 at 7:15 am
Hi,
In your client tools change the protocol to TCP with priority 1 instead of Named Pipe. It will work!
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply