September 15, 2009 at 9:48 am
I am using SQL Server 2005, and i have a password to get in the SQL server. when i tried to log in using SQL server authentication i get the below error. any help is really appreciated.
Thanks.
Additional Information:
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)
September 15, 2009 at 9:54 am
Did you try and search google on this???
You probably don't have named pipes enabled. Try connecting using TCPIP or enable named pipes.
September 15, 2009 at 10:04 am
yes i have named pipes and TCP/IP enabled.and also in server properties in security SQL Server and windows authentication is selected.
September 15, 2009 at 10:06 am
Is this Default instance on the server?
September 15, 2009 at 10:09 am
yes
September 15, 2009 at 10:12 am
can you try giving port number along with instance IP.
I once had this issue and giving port number solved it.
September 15, 2009 at 10:27 am
i am a newbie. i don't know how to give port number
September 15, 2009 at 10:34 am
xx.xxx.xx.xx,1433
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply