@David-Engel
in line to the link to GORM should be corrected: https://gorm.io/
in the first code window this code doesn't work
go install github.com/denisenkom/go-mssqldb
Error:
go install: version is required when current directory is not in a module
Try 'go install github.com/denisenkom/go-mssqldb@latest' to install the latest version
But even if this code is used it doesn't work
Maybe something has changed in golang. I know that this works because I found one working open-source-golang-project working with mssql. And that's why I wanted to follow these instructions. But the first code produces some errors and it would be a good idea to provide some code working "out-of-the-box" fo golang newbies like me :-)
Scroll down a little to the "Or, download a free specialized edition" and download the developer edition.
Be sure to check the support matrix to see if your version of Ubuntu is supported, too: https://docs.microsoft.com/en-us/sql/connect/php/microsoft-php-drivers-for-sql-server-support-matrix?view=sql-server-ver15
/opt/homebrew/include/sql.h
$PATH variable is set to: /opt/homebrew/opt/php@7.4/sbin:/opt/homebrew/opt/php@7.4/bin:/opt/homebrew/bin:/opt/homebrew/sbin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin
If you still face issues, you can reach out to https://github.com/Microsoft/msphpsql for additional support.
platter:site paul$ docker login
Login with your Docker ID to push and pull images from Docker Hub. If you don't have a Docker ID, head over to https://hub.docker.com to create one.
Username: pjungwir
Password:
Login Succeeded
platter:site paul$ docker pull microsoft/mssql-server-linux:2017-latest
Error response from daemon: pull access denied for microsoft/mssql-server-linux, repository does not exist or may require 'docker login': denied: requested access to the resource is denied
You can also specify the named instance via the connection string: jdbc:sqlserver://localhost\SQLSRVTRAIN
But that method requires the SQL Server Browser service to be running and the driver will make an extra round-trip to lookup the port number to connect to.
Doc reference: https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver15
Note: the JDBC driver only supports TCP/IP connections (versus named pipes), so any instance you want to connect to must be configured to listen on a TCP/IP port.
I am developing a Java-based proxy middleware that sits in from of a SQL Server instance and communicates with it using TDS protocol (as defined by Microsoft). I am facing issues with the way SQL server does SSL-over-TDS handshake in the initial phase of creating an ecrypted connection: SQL Server fails to execute the SSL handshake protocol. There is nothing in the SQL Server logs to hint to what is going on and why this is happening. This is a fairly low level, TDS/SSL handshake issue - is there any way I can get developer support for this issue, most likely from Microsoft SQL server engineers?
lsof: WARNING: can't stat() tracefs file system /sys/kernel/debug/tracing
Output information may be incomplete.
phpdbg 180804 tom cwd DIR 253,3 4096 17828168 /data/tom/Downloads/software/php_sqlsrv
phpdbg 180804 tom mem REG 253,0 413320 7998555 /usr/lib/php/20200930/sqlsrv.so
phpdbg 180804 tom mem REG 253,0 421528 7998564 /usr/lib/php/20200930/pdo_sqlsrv.so
I don't know why my message was split. The env is ubuntu 20.04 with
@tombay I recommend filing an issue in the msphpsql repo. They should be able to help you troubleshoot your issue there.
https://github.com/Microsoft/msphpsql
@hrstoyanov I don't know if you'll find anyone in this forum who can answer your question about getting official developer support. However, I would direct you to the many open source TDS implementations available, including the first two directly from Microsoft:
https://github.com/Microsoft/mssql-jdbc (Java)
https://github.com/dotnet/SqlClient (C#)
https://github.com/tediousjs/tedious (JavaScript/NodeJS)
https://github.com/denisenkom/go-mssqldb (Go)
https://github.com/milesibastos/jTDS (Java)
https://github.com/FreeTDS/freetds (C++)
Have you analyzed how the mssql-jdbc driver accomplishes the TLS handshake?
If you are truly stuck, you can ask on one of the above forums (file an issue). Since you aren't asking about an issue directly related to one of those product, I assume you won't be the highest priority for them. But I know the top two owned by Microsoft will try to be helpful if they have the time. The SqlClient community and developers are more active than mssql-jdbc, and even though it's not Java-based, they might be more responsive to requests for tips/pointers in the SSL-over-TDS flow.
I have a query getting sqlsrv/pdo_sqlsrv working through apache2 webserver. Php from the command line works with both sqlsrv.so and pdo_sqlsrv.so installed.When I enable the module (pecl config-set php_ini /etc/php/8.0/apache2/php.ini && phpenmod -v 8.0 sqlsrv && service apache2 restart) the apache server crashes trying to dl_open sqlsrv.so. It is reporting an error in free. I know the shared libraries are as php itself works. install.e.g. lsof -p 180804|grep sqlsrv
phpdbg 180804 tom cwd DIR 253,3 4096 17828168 /data/tom/Downloads/software/php_sqlsrv
phpdbg 180804 tom mem REG 253,0 413320 7998555 /usr/lib/php/20200930/sqlsrv.so
phpdbg 180804 tom mem REG 253,0 421528 7998564 /usr/lib/php/20200930/pdo_sqlsrv.so The env is ubuntu 20.04 with deb [arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/20.04/mssql-server-2019 focal main Apache2/2.4.41 (Ubuntu) Php works within the web server - it is only with the sqlsrv stuff it fails. I can provide the crash stack but maybe someone has seen this before. Please excuse my previous mucked up stuff as I was in chat mode.
https://techcommunity.microsoft.com/t5/sql-server/tds-ssl-issues/m-p/2728482#M1187
I am the original creator of the database and I am a user listed in the database. The connection string is: "jdbc:sqlserver://localhost:1433;instanceName=SQLSRV19TRAIN;databaseName=master;user=rwylie;integratedSecurity=true"; (MLC_NT1) is our domain and I am on the domain network. Any other ideas of what to setup to get this to work?
@duncanmuthomi7 Your solution will involve much more than just a database. This probably isn't the best forum to discuss your broad concept.
@BgR8 Sorry, it sounds like you need more help than can be provided via this forum. With that kind of behavior, I would guess there is an underlying problem with your laptop, like a virus or corruption on your hard drive.
@bwylie Ensure you have added your account as a Windows account. See this page for example: https://docs.microsoft.com/en-us/sql/relational-databases/lesson-1-connecting-to-the-database-engine?view=sql-server-ver15#additional
@David-Engel I tried adding another user as my PC name and my user name and I got the following error: TITLE: Microsoft SQL Server Management Studio
Create failed for Login 'OCLPF2H20JA\rwylie'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Windows NT user or group 'OCLPF2H20JA\rwylie' not found. Check the name again. (Microsoft SQL Server, Error: 15401)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-15401-database-engine-error
BUTTONS:
OK
Since my login on my PC is a domain based login the local user is not available. I do have the domain user login setup as a valid user. That is how I created the SQLServer instance to begin with. Is there a way around this?
