Actually i have 2 work with sql server.for connecting i have also gone through MS ODBC administrator.there also 'TEST COnnection' failed.
My database name is 'BINDU'
the tablename i have created in sqlplus is-'emp1'
what will be file extension for that emp1?


When i want 2 connect to datasource from windows application i did like this.

in props window
connect to data source--->database---->Next---->New connection----->Microsoft Sql server---->Continue----->(Server name)==Local system------->windows authenication--->(attach to database)===Bindu-------->(database file)----->In browse option how to find emp1 file bcoz i dont know the extension?------>Test connection----->
the foloowing message is displayed in the window-----

-----> An error has occured while establishing a connection 2 the server.when connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQl server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open a connection to SQl Server).


plz tell me why it's happening like that?