Studio Express connect failed (SQL Server 2008)

Question

I got this error

A network-related or instace-specific error occurred while establishing a connection to sql server . the server was not found or was not accessible.

verify thai the instance name is correct and that sql server is configured to allow remote connections.

(privider: Named Pipes Provider,error:40 - Could not open a connection to SQL server)

My resource are - visual studio 2010 express version - studio management express

Last time I install vs2010 ex and I develop some application but I need to some data in database I downloaded studio management and installed on my pc

And I got some error "connect failed" I find any solution to solve it but not work

please help , Thank you

capture error photo files http://i621.photobucket.com/albums/tt294/thikon/error-pipes.png

Answer 1

Start->Programs->SQL Server 2008 (or SQL Server 2008 R2)->Configuration Tools->SQL Server Configuration Manager

on Left Pane - Click on SQL Server Services. Check whether SQL Server on the Right Pane is 'Running'

on Left Pane - Click on SQL Server Network Configuration and expand it. You should find Protocols for SQLEXPRESS - click on that. On the Right Pane, right click TCP/IP and click 'Enable'.

Tweak around a little bit - you should get it

Answer 2

Your image shows "Cannot connect to (local)". You should connect to (local)\SQLEXPRESS instead of (local)

Also make sure (in SQL ServerConfiguration) Manager that Shared memory protocol is enabled and have Order 1 both in SQL Server Network Configuration and and in Client Protocols.

Update
Your 2nd scan, th one from comment, shows the error explicitly explaining that it is SQL Server Management Studio Express 2005 but yous should have used 2008

Answer 3

Thank you all of answer , i solved my solution . The problem was come from version.

if another person use solution same me .

• vs 2010 express
• studio management 2008

please download this link for studio management 2008

because first time i downloaded from studio management 2005 ,i not completable with that version

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b