Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to connect to mssql server #2446

Closed
avifatal opened this issue Dec 26, 2019 · 4 comments
Closed

Unable to connect to mssql server #2446

avifatal opened this issue Dec 26, 2019 · 4 comments
Labels

Comments

@avifatal
Copy link

avifatal commented Dec 26, 2019

Info:

  • Docker version 19.03.5, build 633a0ea
  • Laradock commit 8203e5d
  • System info PC:
  • System info disto/version: 10 pro

Issue:

PDOException::("SQLSTATE[28000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'sa'.")

Relevant Code:

this is the laradock config:

ADM_INSTALL_MSSQL=true
WORKSPACE_INSTALL_MSSQL=true
PHP_FPM_INSTALL_MSSQL=true
....
MSSQL_DATABASE=master
MSSQL_PASSWORD=RTGDFER453edrr4!!!
MSSQL_PORT=1433

this is that laravel config

DB_CONNECTION=sqlsrv
DB_HOST=mssql
DB_PORT=1433
DB_DATABASE=master
DB_USERNAME=sa
DB_PASSWORD=RTGDFER453edrr4!!!

I can see that the password is read correctly because I see in the error:
PDO::__construct("sqlsrv:Server=mssql,1433;Database=master", "sa", "RTGDFER453edrr4!!!", [])

this is how I run my app:
docker-compose up nginx mssql workspace


I am mentioning that I have temporarly changed the mssql docker image from mcr.microsoft.com/mssql/server:2017-latest-ubuntu to mcr.microsoft.com/mssql/server:2017-CU11-ubuntu

What am I doing wrong?

Thanks

@pokemonhan
Copy link

I also got same problem.

@dgbrown
Copy link

dgbrown commented Mar 28, 2020

Hi, late to the party but I hope this other thread and my comment there might help you: #2462 (comment)

@stale
Copy link

stale bot commented Jun 26, 2020

Hi 👋 this issue has been automatically marked as stale 📌 because it has not had recent activity 😴. It will be closed if no further activity occurs. Thank you for your contributions ❤️.

@stale stale bot added the Stale label Jun 26, 2020
@stale
Copy link

stale bot commented Jul 17, 2020

Hi again 👋 we would like to inform you that this issue has been automatically closed 🔒 because it had not recent activity during the stale period. We really really appreciate your contributions, and looking forward for more in the future 🎈.

@stale stale bot closed this as completed Jul 17, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants