Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Germo Görtz
    @aisbergde
    https://www.microsoft.com/en-us/sql-server/developer-get-started/go/windows/step/2.html has some wrong code examples. where can I post / open issues?
    David Engel
    @David-Engel
    @aisbergde You can share here and I’ll make sure they get fixed.
    Germo Görtz
    @aisbergde

    @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 :-)

    David Engel
    @David-Engel
    @aisbergde Yeah, looks like there were significant changes a few months ago. I'll try and get the basic examples correct again. Thanks for the heads up!
    s360mcummings
    @s360mcummings
    On the sql server/python/ubuntu/step 3 page, it should be µs not ms. It's pretty funny to be off by three orders of magnitude on a page that's all about measuring query speed. You actually make yourselves look a thousand times slower than you are.
    BostonChuckduncan
    @BostonChuckDuncan
    I'm trying to get a developer edition of SQL 2019. I understand it has restrictions, which are obviously fine during development. But all I can find is a 180 day trial. Help
    David Engel
    @David-Engel
    @BostonChuckDuncan If you are downloading from this page: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
    Scroll down a little to the "Or, download a free specialized edition" and download the developer edition.
    iceten2011
    @iceten2011
    please am looking for MYSQL MS generic driver to integrate Splunk.
    abik50000
    @abik50000
    Where to find 'sqlsrv' module for php 7.1 to install on Ubuntu? New version requires >7.3, but I can't upgrade php to newer version
    David Engel
    @David-Engel
    @iceten2011 This forum is for MS SQL Server, mot MySQL. I recommend asking in a MySQL forum.
    @abik50000 Version 5.6 will be the newest one you can use with PHP 7.1. You can find downloads here: https://docs.microsoft.com/en-us/sql/connect/php/release-notes-php-sql-driver?view=sql-server-ver15#561
    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
    David
    @much-rebel

    hey, having problems on installing pdo_sqlsrv on big sur with pecl,
    getting: /private/tmp/pear/install/sqlsrv/shared/xplat.h:30:10: fatal error: 'sql.h' file not found

    include <sql.h>

    any ideas? would really appreciate cause loosing my sanity here...

    sql.h file can be found via symlink here:
    /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
    Cheena Malhotra
    @cheenamalhotra
    @much-rebel Instructions are here: https://docs.microsoft.com/en-ca/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15#installing-on-macos
    If you still face issues, you can reach out to https://github.com/Microsoft/msphpsql for additional support.
    jeisson333
    @jeisson333
    Hello
    ph3ll3r
    @ph3ll3r
    I would like to setup docker containers for SQL Server 2019 SSIS & SSRS
    Also, a way to run SSIS in a cross platform environment
    Hello
    Is anybody home?
    Cheena Malhotra
    @cheenamalhotra
    This is SQL Client drivers support channel - not SQL Server support.
    Paul A Jungwirth
    @pjungwir
    Hi, I'm trying to set up mssql for a ruby app following the steps here: https://www.microsoft.com/en-us/sql-server/developer-get-started/ruby/mac
    But pulling the image fails:
    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
    David Engel
    @David-Engel
    @pjungwir The Microsoft container registry moved a while back. You can use this command to install the docker image: sudo docker pull mcr.microsoft.com/mssql/server:2019-latest
    Robert Wylie
    @bwylie
    I am following the example to connect to my sqlserver database on my local machine. I get a connection error "com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host OCLPF2H20JA, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". I have checked my firewall but that can't be the issue because it is an internal connection. Is there a setting in sqlserver I need to open up this type of connection from jdbc?
    David Engel
    @David-Engel
    @bwylie You need to make sure SQL Server is configured to listen to TCP connections on port 1433. You can do this by running SQL Server Configuration Manager.
    Robert Wylie
    @bwylie
    I finally got the connection to work on port 1433, now it gives the "An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only" error. I checked the setup and it allows both windows and SQL Server authentication. The error message shows it connecting to the MSQLSERVER while I have a second server called SQLSRVTRAIN which I am trying to connect to. How would I specify the http connect string to access that server directly?
    David Engel
    @David-Engel
    @bwylie To connect to named instances listening on a different TCP/IP port via the JDBC driver, you should specify the port like: jdbc:sqlserver://localhost:1434
    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.
    Akshay Bhuradia
    @akshaybhuradia2020
    Connection string? For windows authentication in linux
    I have added entry of spn in ad
    I am using jdbc client in logstash
    tombay
    @tombay
    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 install.
    Hristo I Stoyanov
    @hrstoyanov
    Hello,
    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?
    tombay
    @tombay
    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.
    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 install.e.g. lsof -p 180804|grep sqlsrv
    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
    @tombay
    deb [arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/20.04/mssql-server-2019 focal main
    David Engel
    @David-Engel

    @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.

    tombay
    @tombay

    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.

    Cheers David. I'll check it out. I saw someone mention an unlrelated apache issue so it must me something wrong with my setup. %-)
    Hristo I Stoyanov
    @hrstoyanov
    @David-Engel thanks for the response! Actually, I think I have TDS under control. It is just the SSL-over-TDS handshake part that is the issue. Once SSL-encrypted connection is established, it flows OK. Fortunately, Microsoft has open-sourced the JDBC driver code, so I do have some clues (although this is not modern Java code!). However, the MS SQL server is closed source, and there are no useful logs emitted that can help me with this particular issue - I ma testing against a black box that just goes silent. I posted the issue details here, in case anyone can help:
    https://techcommunity.microsoft.com/t5/sql-server/tds-ssl-issues/m-p/2728482#M1187
    duncanmuthomi7
    @duncanmuthomi7
    i need to create a predictive model that can predict soccer games
    Buğra
    @BgR8
    Hi,
    I'm getting mssql registry error.
    computer then restarts
    how can I fix it
    Buğra
    @BgR8
    this is the video.
    https://streamable.com/6kt9y4
    Robert Wylie
    @bwylie
    I apparently have the connections correct but now when I try to connect I get the following:
    Login failed for user 'MLC_NT1\rwylie'. Reason: Could not find a login matching the name provided. [CLIENT: 127.0.0.1]
    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?
    David Engel
    @David-Engel

    @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

    Robert Wylie
    @bwylie

    @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)

    For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.46437.65+(SMO-master-A)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476


    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?

    Sairat
    @devilsuraj
    sql server 2012 developer edition download link