i have os server 2003 and i desigin my database on sqlserver 2005 and application on vb.net 2005 during design aplication i add sqldataadapter to forms when i try to configure dataadapter i choose my database when i click test connection or click ok this is message appear
my application is(windows application not web applicatin)
i need to solve problem very quickly
******************************************************
this is the error that appear to me
an error has occurred while establishing connection to the server when connecting to sql server 2005 this failure may be caused by the fact that under default setting sql server does not allow remote connections
(provider sql network interface ,error 26 error location server/instance specified)
***************************************************
when i check enable remote connections in sql server 2005 i found it is check
what is the problem and what is the soulation