Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    David Engel
    @David-Engel
    @darrix_twitter If you are doing integrated auth, you need an additional DLL installed on the machine:
    The DLL is available in the download package on Microsoft's website.
    darrix
    @darrix_twitter
    @David-Engel Ah, I see. Thanks much for your help.
    Stefan
    @stefanhk31
    Hi, I'm new to SQL Server Express, and trying to go through Microsoft's "Create C# apps using SQL Server on Windows" tutorial. How do I find what port to set the builder.DataSource to? I'm getting a "server was not found or was not accessible" exception when I try to apply the code given in the tutorial.
    David Engel
    @David-Engel
    @stefanhk31 SQL Server Express, I believe, by default only listens to named pipe connections. You can simply use a connection string like "<computer_name>\sqlexpress", or configure SQL Express to listen for TCP connections (https://web.synametrics.com/sqlexpressremote.htm) if you want to be able to specify a port.
    Stefan
    @stefanhk31
    Thanks @David-Engel !
    djabber2019
    @djabber2019
    hi
    this is Engineer Dhaif Jabber
    is it possible to us it with sql server 2012
    djabber2019
    @djabber2019
    hi all
    djabber2019
    @djabber2019
    hey there
    djabber2019
    @djabber2019
    hiii
    hi
    Pavel Kohout
    @pkohout_twitter
    Hi, does anyone can recommend MacOS MS SQL client tools?
    swa
    @swa256_gitlab
    Hi, I am planning to do certifications related to .net and sql
    any suggestions please
    David Engel
    @David-Engel
    @djabber2019 Yes. You can use SQL Server 2012.
    @pkohout_twitter The mssql-tools package is available on macOS and includes the sqlcmd and bcp command line tools.
    Yas Mohammed
    @_wrapme_twitter
    After doing Step1.3( running command for SQLCMD), its is again showing
    sqlcmd: command not found
    what i have to do next..
    am using Ubuntu 16.04, php7.1 in VirtualBox
    David Engel
    @David-Engel
    @_wrapme_twitter What was the output from the commands you ran to install mssql-tools (which contains sqlcmd) in step 1.3? It sounds like it may not have completed successfully.
    sudo su
    curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
    curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
    exit
    sudo apt-get update
    sudo ACCEPT_EULA=Y apt-get install msodbcsql17 mssql-tools
    echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
    echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
    source ~/.bashrc
    sudo apt-get install unixodbc-dev
    陈沛林
    @a0215cpl
    Connecting to SQL Server 2000 , ConnectionError ESOCKET Socket error. How to deal with it?
    有人知道 连接 SQL Server 2000 的时候出现 ESOCKET 错误如何解决吗?
    Stefán Jökull Sigurðarson
    @stebet
    Hi everyone
    Was wondering, is there a new preview release scheduled soon for the Microsoft.Data.SqlClient? Looking forward to trying out the SQL Command text changes.
    Tverskaya
    @Tverskaya
    do we have to use python27 or can we use the newest version python37 with sql server?
    David Engel
    @David-Engel
    @stebet Look for another one in a few weeks.
    @Tverskaya You can use Python 3.7.
    Tverskaya
    @Tverskaya
    Thanks @David-Engel ! You would think that microsoft would keep their pages up-to-date...
    for step 1.2 should remove reference to any specific version: https://www.microsoft.com/en-us/sql-server/developer-get-started/python/windows
    David Engel
    @David-Engel
    @Tverskaya It works with Python 2.7, too. I'll make a note to go through the pages and update to all the latest versions.
    Eugene
    @JohnyL
    Does anyone know where Debug menu had gone in SSMS 18.3.1?
    chakriganap
    @chakriganap
    Hello all i am new in this world, can some please help how to create a SQL stored procedure in linux from script file or python
    ابراهيم عبد الصبور
    @yosefpc2_twitter
    hi
    how i start
    Hédel Nuñez Bolívar
    @hedelnb_twitter
    Hi, I'm creating a report in SSRS using ODBC driver for Informix Database. When I run the query in the query designer, I get the results I want, but in the sql panel the query is jumping continuosly like a loop. In the result panel I have a warnging icon, and in the bottom right another warning icon with the legend 'query changed'. I never saw this issue before, but also never use ODBC in SSRS
    Hédel Nuñez Bolívar
    @hedelnb_twitter
    mjm, I started to use the 'graphic' interface for generate the query and I have a better idea how to use the parametrs with ODBC, I think this was the problem
    chakriganap
    @chakriganap
    @David-Engel Thank you Appreciated
    Dayashankar Prajapati
    @Oliverq755
    hello guys, I am trying to connect dbeaver community with mssql server but unable to connect. Any help?
    David Engel
    @David-Engel
    @Oliverq755 It would help to post any specific error messages you get when you have problems. In lieu of that, here is a link that might help you troubleshoot some different connection problems: dbeaver/dbeaver#3377
    Evgeniy Pavlovich Demyanov
    @Ormadont
    Hi. I need help with "Create Node.js apps using SQL Server on Windows"
    On step 2.1 I was expecting a result: "Connected". But got it: "
    PS E:\evgen\Documents\web\testSql> node connect.js ConnectionError: Failed to connect to localhost:1433 - Could not connect (sequence)
    at ConnectionError (E:\evgen\Documents\web\testSql\node_modules\tedious\lib\errors.js:13:12)
    at Connection.socketError (E:\evgen\Documents\web\testSql\node_modules\tedious\lib\connection.js:1258:56)
    at E:\evgen\Documents\web\testSql\node_modules\tedious\lib\connection.js:1084:21
    at SequentialConnectionStrategy.connect (E:\evgen\Documents\web\testSql\node_modules\tedious\lib\connector.js:83:14)
    at Socket.onError (E:\evgen\Documents\web\testSql\node_modules\tedious\lib\connector.js:96:12)
    at Socket.emit (events.js:209:13)
    at emitErrorNT (internal/streams/destroy.js:91:8)
    at emitErrorAndCloseNT (internal/streams/destroy.js:59:3)
    at processTicksAndRejections (internal/process/task_queues.js:80:21) {
    message: 'Failed to connect to localhost:1433 - Could not connect (sequence)',
    code: 'ESOCKET'
    }
    "
    David Engel
    @David-Engel
    @Ormadont You need to make sure SQL Server is installed locally and that it is configured to listen for TCP connections on port 1433 (which is the default TCP port).
    Evgeniy Pavlovich Demyanov
    @Ormadont
    @David-Engel Thanks! You helped me. Protocol for TCP connections was disabled
    ivanthewebber
    @ivanthewebber
    Hello I'm running into some trouble. If I don't provide username/password credentials the sqlcmds work, but otherwise I get a failed login error. I also tried to make a Application Role (my understanding is that it's a login that can be used by a program), but login fails for this as well. Running connect.go fails because of the login problem. Any pointers would be greatly appreciated.
    ivanthewebber
    @ivanthewebber
    Okay so I've found that I can login with COMPUTER-NAME\\username. However, any pointers to help me avoid including my password in the source code would be greatly appreciated. (I have to turn in my code for a comparative programming language course; I'm teaching myself Golang).
    David Engel
    @David-Engel
    @ivanthewebber go-mssqldb supports SQL Server Authentication, Windows Authentication in the DOMAIN\User format, and on Windows, if user id is empty or missing Single-Sign-On is used (login is the context of your logged in Windows user account). So the only option you have for not including a password it the last one where you do not specify a user id.
    https://github.com/denisenkom/go-mssqldb#connection-parameters-and-dsn
    ivanthewebber
    @ivanthewebber
    @David-Engel Thanks, I was unaware that was an option
    Oasis
    @oasisfleeting
    I have a scheduled database redesign task coming up next month.. Hoping to split the database up over 4 drives of 500GB a piece and take advantage of some of the IO benefits from asynchronous reads.
    Not sure how virtualization will impact that IO.
    Anyone have any input or recommendations on this topic?
    David Engel
    @David-Engel
    @oasisfleeting I can confirm that virtualization will be an important consideration during configuration as you will want to be careful about exactly how the database has access to the drives (block size and alignment for example). You'll want to do your research about it.
    Watcharathat.pho@gmail.com
    @Charathat_gitlab
    Create Java apps using SQL Server on Windows, Have you got for gradle ?