Error connecting SQL server

2

Hello, I downloaded SQL Server Express 2014 with tools from the Microsoft website. I did the installation however when I start the error

Error description:

TITLE: Connect to Server
------------------------------

Cannot connect to willian.

------------------------------
ADDITIONAL INFORMATION:

 Erro de rede ou específico à instância ao estabelecer conexão com o SQL     Server. O servidor não foi encontrado ou não estava acessível. Verifique se o nome da instância está correto e se o SQL Server está configurado para permitir conexões remotas. (provider: Named Pipes Provider, error: 40 - Não foi possível abrir uma conexão com o SQL Server) (Microsoft SQL Server, Error: 2)

 For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

 ------------------------------

 O sistema não pode encontrar o arquivo especificado

------------------------------
BUTTONS:

OK
------------------------------

I looked in some places but I did not find anything that solved and I tried to reinstall

    
asked by anonymous 13.12.2015 / 23:42

1 answer

1

I solved it as follows:

  • check if the service is working

      

    SQL Server (SQLEXPRESS) - start it.

    2nd go to start menu > control panel > tools administrative > ODBC data sources

    3rd add a new > select "SQL SERVER"

    4th place your name, description, and server name

    Note: Server name follows a pattern eg in my case WILLIAN \ SQLEXPRESS

    Computer user name.

    5th Leave authentication with windows 6th Select the first checkbox master 7th conclude > test data sources > ok > ok

    Open SQLSERVER on behalf of the server, open combobox, and select what was created and started.

  • Explanation video: youtube

        
    14.12.2015 / 00:24