i was doing a program which connects to and retrieves info frm database.
i was doing program using vs 2005 , and i had to create a database .
i clicked on server explorer---data connections--add new database.

i used (.) as server and windows authentication, and database name as "stud".


"an error has occured while establishing connection to server.When connecting to sql server 2005,this failyre may be caused by fact that under default settings,SQL server does not allow remote connections.(provider named pipes provider,error:40 , could not open connection to sql server"
is there any change needed in SQL server config manager(start-all progs--sql server2005-config mngr.)

any help greatly appreciated.



prrao

all my programming in ado.net has come to a standstill because i cannot to sqlserver2005
plz moderator, or fellow programmer , help me out.

thanks in advance.

prrao

For new installation of SQL server 2005 you need to set it to permit external connections.

Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager

SQL Native Client Configuration
  -> Client Protocols

Choose the protocols you want to enable. I have TCP/IP and Named Pipes enabled and I can connect to my server.

-Peter