Share via

SQLCMD cannot connect to local server

Antônio Isidro Gil Graça 1 Reputation point
2022-01-22T23:32:55.777+00:00

C:\Users\Lenovo>SQLCMD -S .\SQLEXPRESS
Sqlcmd: Erro: Microsoft ODBC Driver 13 for SQL Server : Nome da fonte de dados não encontrado e nenhum driver padrão especificado.

C:\Users\Lenovo>SQLCMD -?
Ferramenta de Linha de Comando do Microsoft (R) SQL Server
Versão 14.0.3335.7 NT
Copyright (c) 2017 Microsoft Corporation. Todos os direitos reservados.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,431 Reputation points Microsoft External Staff
    2022-01-24T02:24:20.87+00:00

    Hi @Antônio Isidro Gil Graça ,

    Please check user DSN and System DSN for this connection in the ODBC data source and check other suggestions from this similar thread [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

    If they all did not work, please feel free to let us know.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Was this answer helpful?

    0 comments
  2. Ronen Ariely 15,221 Reputation points
    2022-01-23T08:40:29.397+00:00

    HI :-)

    This is a very common issue, and there are multiple discussions with full explanation and solution, so we can save time

    check this please:

    https://learn.microsoft.com/en-us/answers/questions/227987/34error-im002-microsoftodbc-driver-manager-data-so.html

    If you did not succeed then please inform us and we'll go step by step

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.