Microsoft/mssql-developers

Ghost

@ghost~5e344dedd73408ce4fd856ed

@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

Erika Dahan

@egdahan_gitlab

I am trying to download the microsoft sql to my mac. I downloaded docker but can't figure out how to download microsoft sql onto it . Would appreciate help :)

David Engel

@David-Engel

@egdahan_gitlab You can simply reference one of the docker base images that Microsoft publishes that already has SQL Server on it.
https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15

EdManMagic

@EdgarRSSA

How can solve this? - message: 'Failed to connect to localhost:1433 - self signed certificate',
code: 'ESOCKET' WITH mssql(module) and sqlcmd(cmd) the conecction is success.. i use NodeJs v12.16

David Engel

@David-Engel

@EdgarRSSA What's the code you are using to try and connect?

account0123

@account0123

i'm on get started, how i can know my username and password of my sql server?

David Engel

@David-Engel

@account0123 Did you install it locally? What options did you specify during installation? Did you configure an sa account and password? If yes, username = sa and password = the password you specified. If you did not configure an sa account, you can try integrated authentication (I'm assuming you are on Windows) by removing the lines setting the UserID and Password properties and add one that sets builder.IntegratedSecurity = true;

Tracey-Davis

@Tracey-Davis

Hi all, I am getting an incorrect syntax in my sqlcmd code to connect to sql server. I put "sqlcmd -S localhost -U sa -P mypassword". The error I'm getting is "Msg 102, Level 15, State 1, Server MyServerName, Line 1 Incorrect syntax near 'S'". Can someone please tell me what I am doing wrong. I have connected to sql server many times with no issue.

sandeep11823

@sandeep11823

I want to ask something

我不会算命

@wobuhuisuanmin_gitlab

shuo

说？？

fitzone

@fitzone

@Tracey-Davis Follow this>>>>> https://www.microsoft.com/en-us/sql-server/developer-get-started, @David-Engel may have more simpler suggestion for you later.

David Engel

@David-Engel

@Tracey-Davis If you can post a screenshot of what you are doing for context, that might help.

@sandeep11823 Go ahead and ask.

wobuhuisuanming

@wobuhuisuanming

那个文档的

我发给你你们

muhammadikhan

@muhammadikhan

I have written a code in node.js code that is connected to MS-SQL server. It's working perfectly fine. Now i want to deploy it on my LIVE IIS server .

Need a guidance in this regard
I have "https://github.com/tjanczuk/iisnode" but its not working and i am not in intention to do any more experiments on live server.

Anybody plesae help me. i am bady stuck ...
need help ---> muhammadikhan@live.com

David Engel

@David-Engel

@muhammadikhan You might want to try an IIS-specific forum. You'll find people much more experienced with IIS there. I recommend https://forums.iis.net/

muhammadikhan

@muhammadikhan

@David-Engel thanks for your help and response. No doubt this is a unique task and i have leant a new thing which is not common.

I did my task from the help of below-mentioned link.

https://dev.to/massivebrains/deploying-node-express-app-on-a-windows-server-2l5c

If anyone need help regarding IIS or any .net framework, node.js integration with .net. please do me a query.

many thanks
have peace and stay blessed.
:smiley:

Gerard Naughton

@naughtong

Is there any good MS C++ api for SQL server? I can see that MS has an ODBC example but sqlapi looks easier to use.

gitte lindgren

@gittewebmus_twitter

after pasting the first block of code I end up with 5 errors. I do not knoe what to update: builder.DataSource = "localhost"; // update me
builder.UserID = "sa"; // update me
builder.Password = "your_password"; // update me
builder.InitialCatalog = "master"; with vere do I get these information from?

isabelpebaque

@isabelpebaque

Hello! I need some help, first time with docker and I made a little console program with docker for MAC. And everything is working on my Mac, but when I try to open my program on another Mac I get error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 35 - An internal exception was caught).

What have I missed or what do I Need to do?

Thanks in advance for the help! :)

David Engel

@David-Engel

@naughtong The ODBC standard has been around for a long time and is likely the most popular for C++ apps. I'm not familiar with sqlapi.

@gittewebmus_twitter You get those values from the database you configured for use with your application.

@isabelpebaque That depends on where your program is trying to connect to the database. Both Macs will need a database installed if you have specified "localhost" for your server. If you have a separate database server, you can point your program to that specific server name and the program can work from either machine (assuming they have appropriate network access to each other).

Where communities thrive

People

Repo info

Activity