Conexao com Sql Server

[ernaneSNcarvalho]

Bom Dia (agora com SO WINDOWS rsrs)

Iniciei o curso e fiz todas configuracoes que sao exigidas, wsl, docker (testei e rodou) e o azure e criei meu primeiro Localhost e funcionou tudo, igual no video. Tive que sair e desligar o pc e quando tentei conectar novamente com o BD criado, ele aparece o seguinte erro:

A network-related or instance-specific error occurred 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: TCP Provider, error: 0 - Nenhuma conexão pôde ser feita porque a máquina de destino as recusou ativamente.)

aparentemente o docker esta funcionadndo. Podem me ajudar ?

[ernaneSNcarvalho]

Pesquisei e testei algumas solucoes, como habilitar a porta TCP/IP nas configuracoes do SQL_SERVER. Por enquanto sigo sem solucao.

[andrebaltieri]

Bom dia @ernaneSNcarvalho como vai? Você iniciou o SQL depois de reiniciar?

Ele tem que estar rodando (verde) como imagem acima!

Em adicional, qual software está usando apra se conectar ao SQL Server? Se for o Management Studio, precisa habilitar o SSL nele:

Na tela inicial clica em OPTIONS ou OPÇÕES e depois habilita Trust Server Certificates em Connection Properties.

[ernaneSNcarvalho]

Estou usando o Azure Data Studio, ele não roda SQL ?
Ou estou confundindo as ferramentas?

[ernaneSNcarvalho]

Resolvido. Mais uma vez obrigado por responder um iniciante e leigo. Estou gostando do curso e agradeco a atencao.

[pedroMF1996]

Cara, fiz toda a configuração que me foi passada e mesmo assim deu esse erro aqui
Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred 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) ---> System.ComponentModel.Win32Exception (53): O caminho da rede não foi encontrado. at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, SqlAuthenticationMethod authType) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool) at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.<>c__DisplayClass48_0.<CreateReplaceConnectionContinuation>b__0(Task1 _)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>c__DisplayClass30_0.<<OpenAsync>b__0>d.MoveNext() in D:\a\1\s\src\Microsoft.SqlTools.ManagedBatchParser\ReliableConnection\ReliableSqlConnection.cs:line 312 --- End of stack trace from previous location --- at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.TryOpenConnection(ConnectionInfo connectionInfo, ConnectParams connectionParams) in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 559 ClientConnectionId:00000000-0000-0000-0000-000000000000 Error Number:53,State:0,Class:20

[andrebaltieri]

Consegue mandar sua connection string e um print do terminal depois de executar os comandos abaixo:

dotnet dev-certs https --clean
dotnet dev-certs https --trust

[pedroMF1996]

Consegue mandar sua connection string e um print do terminal depois de executar os comandos abaixo:

dotnet dev-certs https --clean
dotnet dev-certs https --trust

[pedroMF1996]

Consegue mandar sua connection string e um print do terminal depois de executar os comandos abaixo:

dotnet dev-certs https --clean
dotnet dev-certs https --trust

Não aparece as bases como aparece no seu video

[pedroMF1996]

Consegue mandar sua connection string e um print do terminal depois de executar os comandos abaixo:

dotnet dev-certs https --clean
dotnet dev-certs https --trust

Puts mb total, eu to acostumado a setar porta com 2 pontos (:) mas nesse é com virgula

[andrebaltieri]

💜