I have just nstalled VS 2005 and Sql 2005 developer edition.. The problem is , I can't see my Sql server neither in Computer Managment window nor in server explorer window in VS...When I try to create a new connection , I says :
"An errror has been occured while establishing a connection to SQL server..When connecting Sql server 2005 , this failure may be caused by the fact that under the default settings SQL Does not allow remote connections.
Provider : Named Pipes Provider , error : 40 - could not open a connection to Sql Server"
I checked what it says , but the tick was there ... So What could be the problem :(
problem about VS 2005 and Sql Server 2005
ewhizz
Your firewall might be preventing named pipe connections.
If your server is running on the same machine as SSMS or VS, you could try using shared memory connections, which would circumvent any firewall issues.
If the server is running on a different machine, you could try using TCP/IP connections instead and make sure your firewall has the SQL Server port open (1433 by default). You would have to configure SQL Server to allow TCP/IP connections, of course.