Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    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
    sourabh2291
    @sourabh2291
    having trouble to connect to mssql in node using ubuntu
    Robert Wylie
    @bwylie
    I am connected via jdbc to a mssql database. When I execute a prepared statement on a table, I get the following error.
    Feb 04, 2022 11:12:05 AM com.microsoft.sqlserver.jdbc.TDSParser throwUnexpectedTokenException
    SEVERE: ConnectionID:1 ClientConnectionId: f0fd795d-1e39-4da6-9c6a-e4ca979cabe2: getNextResult: Encountered unexpected TDS_FEATURE_EXT_UTF8SUPPORT (0x0A)
    Feb 04, 2022 11:12:05 AM com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDSToken
    SEVERE: ConnectionID:1 ClientConnectionId: f0fd795d-1e39-4da6-9c6a-e4ca979cabe2 got unexpected value in TDS response at offset:364
    Exception in thread "main" java.lang.IndexOutOfBoundsException: Index 65535 out of bounds for length 0
    1 reply
    Anyone know how to resolve this?
    blineraibrahimi
    @blineraibrahimi
    Hello, I have a question. I am working on a .NET project, and I need to have a database that runs Mac too because the rest of the team are on Windows, and they run the database on SQL Server Management Studio, while that isn't available on macOS. Is it possible for the same database to run on both Azure Data Studio and SQL Server Management Studio?
    Africa
    @fast1man1_twitter
    Hello, I have a problem please help
    So when I working on etap 19 so I need server
    This is the problem (there is no local DB ODB setup for ETAP please setup local DB DSN)
    Satish Chand
    @SatishC88683499_twitter
    Hi, I am getting error during the installation of SQL server after uninstalling.
    pepskiller
    @pepskiller
    hy
    how are you
    i want to predictor aviator code and tell me how i run with the online game aviator
    >
    pepskiller
    @pepskiller
    ?????