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 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy