I can't connect to my servers SQL database via an IP Address
Mar 31, 2014 · Using SQL Server Express 2017, in addition to the answers above, when trying to connect using the port, ensure you use the comma syntax, not the colon syntax i.e: …
Unable to connect to SQL Server using Windows authentication - "The ...
May 2, 2024 · 0 I am logged in to Windows machine and connected to another environment through GlobalProtect VPN to connect SQL Server. SQL Server is configured to allow only Windows …
How to connect to a local SQL Server instance by IP Address in SQL ...
Nov 18, 2020 · In your SQL Server Configuration Manager if you scroll down to the bottom you will find the TCP dynamic Port that is being used by your local instance. With this information I can try and …
sql server - Error: Cannot Generate SSPI context - Database ...
Feb 20, 2015 · Even more odd is that you may be able to connect using SQL Server Management Studio but you can't connect via ODBC or OLEDB. There may be a temporary workaround that will …
Grant Permissions to all databases using server role
Apr 16, 2020 · Besides reading my answer look at this Q&A by Aaron Bertrand How to create a read-only server role on SQL Server 2012? This solution will work for SQL Server 2014 and above. …
How can I fix "Login failed for user sa" error in SQL Server?
Apr 30, 2021 · 8 I can access my databases through SQL Server Management Studio (SSMS) by using my Windows account no problem. I have two issues though: I want to enable sa and then try to log in …
How do I connect MySQL Workbench to SQL Server with System DSN
Jul 25, 2024 · I created a System DSN that connects successfully to the SQL Server and a specific database using Windows Authentication. How can I connect from Workbench to this SQL Database? …
PHP unable to identify sqlsrv_connect() function while trying to ...
Jan 4, 2022 · I'm trying to connect to my local MSSQL Server from a simple PHP file using the sqlsrv_connect() function, but every time I'm calling the file in the browser through localhost, it's …
SQL is not showing up when trying to connect to it via ... - Server Fault
Jan 31, 2024 · The new SQL Server/instance is not showing up in the ODBC client on a windows client. - What do you mean, exactly? It doesn't just show up in the client. How are you trying to connect? By …
SQL Server 2022 Docker image - can't connect after hard reboot
Feb 17, 2025 · The errorlog says it's listening on 1433. I can't run sqlcmd from my desktop and connect to the remote server, but I can enter the Docker container on the server and use sqlcmd to run …