November 26, 2010 at 9:03 am
i have installed sql server 2005 installed. it was working good.but today when i am trying to login. it shows following error.
an error has occurred while establishing connection to server.when connecting to sql server 2005 , this failure may be caused by the fact under the default setting sql server does not allow remote connections.(provider:names pipes provider, error 40, could not connect to sql server)(microsoft sql server :error 2)
i have installed sql server on my local machine.
please help me.
November 26, 2010 at 9:14 am
Is the SQL Server service started? You can check it in "SQL Server Configuration Manager"
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 26, 2010 at 9:34 am
i just checked it. serviced was stopped . Then i started it. now i am able to login.
thanks for your help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply