by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    cobinrox
    @cobinrox
    Greetings, i'd like to download SQLServer 2017 for a windows off-line installation, is there an off-line version that i can download?
    cobinrox
    @cobinrox
    nevermind, found it thanks
    AuroraKarow
    @AuroraKarow
    I'm a fresh of database development. I try to use the ODBC API, but It seems that VSCode doesn't support it. Is there any resolution? I just found a way that should alter task.json file's configuration at args to modify the compiler instruction.
    It might relate to .lib file, but I have no idea to import it on VSCode.
    ArlethVillanuevaEstrada
    @ArlethVillanuevaEstrada
    it's been doing all the steps but it won't let me intalte it.
    David Engel
    @David-Engel
    @ArlethVillanuevaEstrada Can you provide more context? What exactly are you doing?
    ArlethVillanuevaEstrada
    @ArlethVillanuevaEstrada
    @David-Engel I want to link php with sql server, I already follow all the steps it says on the page, download the plugins it asks for, but still not connect and sends me errors like the 18456 and 53.
    David Engel
    @David-Engel
    @ArlethVillanuevaEstrada Are you on Windows? Linux? Mac? How far into the getting started pages have you gotten? What command are you running that is producing an error? Can you paste the text of what you are doing along with the error or a screenshot?
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    i need help on connecting php to sqlserver...just can't connect
    I followed all the steps here https://www.microsoft.com/en-us/sql-server/developer-get-started/php/windows and nothing at the end ... what should i do?
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    In my case , I'm on windows 10 pro. trying to get PHP and MSSQLSERVER to run with IIS. I tried everything on docs.xxxx and failed. I get here https://www.microsoft.com/en-us/sql-server/developer-get-started/php/windows and followed the steps and still failed. Now I rest my PC and hoping to find help here.
    ArlethVillanuevaEstrada
    @ArlethVillanuevaEstrada
    image.png
    @David-Engel windows ,I can't make it work.
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    @ArlethVillanuevaEstrada Please try here: https://www.microsoft.com/en-gb/sql-server/sql-server-downloads
    ArlethVillanuevaEstrada
    @ArlethVillanuevaEstrada
    @fitzone if from there I followed all the installation steps, but it causes me problems not connection, and I do not know what the problem is.
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    @ArlethVillanuevaEstrada I just can't have php connect to sqlserver
    @ArlethVillanuevaEstrada are you using iis?
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    I guess Microsoft won't let people use php.
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    @ArlethVillanuevaEstrada If you are using windows home edition, i regret to say it never works; windows pro gives you more options.
    David Engel
    @David-Engel
    @ArlethVillanuevaEstrada The error indicates you are unable to log in to SQL Server using your current Windows credentials. There are many options for connecting to SQL Server. You can use database credentials (if configured) or Windows integrated security (which is what you are trying to use). You basically need to configure authentication in SQL Server. I assume you are trying to connect to a SQL Server instance you installed on your PC. Perhaps a Developer Edition? Do you remember the options you installed SQL Server with? If you just did the Basic install, it was supposed to add your user as an admin. If that didn't happen, it might be easier to uninstall (completely) and then reinstall than to try to walk you through how to fix it on here. When you reinstall, choose Custom. On the Feature Selection screen, you just need the Database Engine. On the Database Engine Configuration screen (https://i.stack.imgur.com/k9N2A.png), be sure to click the "Add Current User" button. You can take all the defaults for everything else. Note: If you don't completely uninstall the previous install, the new install will use different defaults and you will probably have problems connecting again for different reasons.
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    @ArlethVillanuevaEstrada try this: step1: select connect from the Object Explorer. step 2: from the drop-down arrow at the Server Name box, select browse more. step3: Select Local servers, select 'your-computer-name\SQLEXPRESS', click ok, select Windows Authentication, and finally click connect. you should be home.......
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    @ArlethVillanuevaEstrada Note: During SQL 2017 Setup > Data Engine Configuration > Server Configuration > Authentication Mode > PLEASE select Mixed Mode > type your password > confirm password > Add Current user > click Next. VERY IMPORTANT It will giver you the option of choosing Authentication method.
    @ArlethVillanuevaEstrada @David-Engel details it all.
    @ArlethVillanuevaEstrada To understand your question i had to reset this pc to get to the error you displayed, what i have written above was what I did to resolve it. you might have to reset your pc.
    Ramana Reddy
    @ramanareddyanamala
    Hi Everyone , I have one question, can anyone please help me ? I have MsSQL database in cloud windows machine but when i'm trying to access it from any windows machine it is working with windows authorization but when i try the same thing from MacOS/Ubuntu its not working
    I'm purely trying with JDBC.
    David Engel
    @David-Engel
    @ramanareddyanamala From non-Windows machines, it's more complicated to use Windows integrated authentication. You have to set up Kerberos on your client:
    https://docs.microsoft.com/en-us/sql/connect/jdbc/using-kerberos-integrated-authentication-to-connect-to-sql-server?view=sql-server-ver15#creating-a-kerberos-configuration-file
    If you are trying something else, it might help to share your connection string (with any private details obscured).
    Young Altair
    @young-altair
    Rustlang support please, Microsoft. Big Thanks
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    Help! How do I get user input from action.php into SQLSRV database?
    David Engel
    @David-Engel
    @fitzone I don't know what your action.php script looks like, but from a high level, you process the user input in your script and then use insert statements to insert it into your table you have created in your database.
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    @David-Engel - Any link for a sample? I can't sent scripts here.
    All the examples on Microsoft docs are run on command line and crafted to work only with adventureworks.
    I have tried almost all of them.
    Ghost
    @ghost~5e344dedd73408ce4fd856ed
    ghost town here.....
    David Engel
    @David-Engel
    @ghost~5e344dedd73408ce4fd856ed There are lots of PHP examples on the web. If you have a specific question about what you are trying to do, someone might be able to help you better.
    Sir Phillip Tubell
    @sirphilliptubell
    Hi all, I'm having an issue with getting "login failed for user 'theuser@thedomain'" every 10 hours
    The client application is a .net framework app and is continuously running as a windows service, running under the theuser@thedomain account
    The Sql server is on Azure
    The connection is newed up, used, and then disposed every 30s, so it stays in the pool continuously (the connection's lifetime is probably around 5 seconds)
    The connection is using "Active Directory Integrated"
    On the server we did see this in the event log: "There is a user error in FedAuth token parsing."
    I tried setting the ConnectionLifetime to 32400 (9 hours) but that didn't help
    Documentation as well as what I see inside SqlInternalConnectionTds.cs : OnFedAuthInfo() line ~2235 indicates the token should be refreshed 10 minutes before expiration.
    Given that the connection would be taken from the pool many times in the last 10 minutes, it doesn't appear that the token is refreshing
    Any ideas what I should try?
    Boong Ifeel
    @boongbungy_gitlab

    i have the problem

    Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired.
    Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2726.
    Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..

    David Engel
    @David-Engel
    @sirphilliptubell I suggest posting your issue here, where they can help troubleshoot: https://github.com/dotnet/SqlClient/issues
    I've heard rumors of tokens not getting refreshed for long-running processes, but I haven't seen a consistent repro from anyone (understandably so), so it's difficult to pinpoint the problem.
    @boongbungy_gitlab That error is pretty generic and just indicates the client can't connect to the server because it's not responding where you told it to look. You could have provided the wrong server name, the SQL Server could not be configured correctly on the server to listen to remote requests or it could be on a different port. It depends on what you have set up for the server.
    Sir Phillip Tubell
    @sirphilliptubell
    Thanks @David-Engel
    Fabrizio Leoncini
    @fabrizioleosanca
    where can I download the EFSampleDB database?
    Zahir Mohideen
    @zahirmohideen_twitter
    I installed SQL Server 2019 with ML for python and Visual Code . When I try to run the sample code for Python. It could not find revoscalepy. How do I add revoscalepy to the VS . I tried with Spyder IDE as well.
    David Engel
    @David-Engel
    @fabrizioleosanca You don't need to download it. It is created automatically by the sample code.
    alealpha2000
    @alealpha2000
    i have a sql question.i have a query like this. how can i change it so instead of counting one column in the group, it counts the combinations of two columns inside a group
    select column1,count(distinct column2)
from table
group by column1
    David Engel
    @David-Engel
    @alealpha2000 Append the columns in your count distinct:
    select column1,count(distinct column2 + column3)
from table
group by column1
    alealpha2000
    @alealpha2000
    ok thanks
    Bence
    @yelloweiffel_gitlab
    Hi all!
    aggshikha84
    @aggshikha84
    Hi..
    is there an example that tells how to make a secure encrypted connection to SQL Server using java cpde?
    Cheena Malhotra
    @cheenamalhotra
    @aggshikha84 It might be of your interest: https://docs.microsoft.com/en-us/sql/connect/jdbc/connecting-with-ssl-encryption?view=sql-server-ver15