Microsoft SQL Server 2008 R2 connection problem?

Question

I'm trying to connect to Microsoft SQL Server 2008 R2 and this is showing up...

Server type : Database Engine
Server name : /SQLSERVER2008
Authentication type: Windows Authentication

A network related or instance specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 67)

What should I do ?

Answer 1

I've answered this recurring question many times.



Mind reading my earlier posts !? -



https://answersrip.com/question/index?qid=20130220135600AAPMghL



-- In 'thoughts'...

Lonely Rogue

Answer 2

Sql Server Error 40

Answer 3

Sql Server Error 67

Answer 4

Check this fix : http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/



It's about your connection issue..

Answer 5

1) copy the server name form the server and paste and don't use windows authentication but use sql authentication

2)change the privileges in the database

Answer 6

For the best answers, search on this site https://shorturl.im/avyta



open sql server configuration manager and right click the browser and select start.