Microsoft/mssql-developers

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

jclausius-sg

@jclausius-sg

What is the proper protocol for logging a possible bug within SQL Server 2019? ( I have some T-SQL which shows a problem with @@ROWCOUNT within a user function called while iterating thru a cursor. This T-SQL produces correct results within SQL Server 2017 or when Compatibility Level is set to SQL Server 2017 and prior within SQL Server 2019 ) TIA

David Engel

@David-Engel

@jclausius-sg The best/recommended route would be through Microsoft Support (https://support.microsoft.com/). They can more quickly help you find out if it's an actual bug or an expected behavior change. If you do not have a support contract with Microsoft, you can submit SQL feedback here: http://aka.ms/sqlfeedback But that's not going to be a fast way of getting an answer or getting it fixed.

jclausius-sg

@jclausius-sg

@David-Engel, I'll take a look at those resources. TY!

Tqmd1

@Tqmd1

hello

Int Class

@intclassproject

Hello,

I'm trying to install with docker on windows 10

I'm getting the following error:

Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Named Pipes Provider: Could not open a connection to SQL Server [2]. .
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login timeout expired.
Sqlcmd: Error: Microsoft ODBC Driver 13 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..

Could you please advice ?

Mixage51

@Mixage51

Hello, I am trying to install a sql server on my ubuntu 18.04 I followed the installation procedure but every time I load a .php file I get the following message : PHP Warning: PHP Startup: Unable to load dynamic library 'sqlsrv.so' (tried: /usr/lib/php/20190902/sqlsrv.so (/usr/lib/php/20190902/sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/sqlsrv.so.so (/usr/lib/php/20190902/sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'ssdeep.so' (tried: /usr/lib/php/20190902/ssdeep.so (/usr/lib/php/20190902/ssdeep.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/ssdeep.so.so (/usr/lib/php/20190902/ssdeep.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlsrv.so' (tried: /usr/lib/php/20190902/pdo_sqlsrv.so (/usr/lib/php/20190902/pdo_sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_sqlsrv.so.so (/usr/lib/php/20190902/pdo_sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
Configuration File (php.ini) Path => /etc/php/7.4/cli
Loaded Configuration File => /etc/php/7.4/cli/php.ini
Scan this dir for additional .ini files => /etc/php/7.4/cli/conf.d
Additional .ini files parsed => /etc/php/7.4/cli/conf.d/10-mysqlnd.ini,

David Engel

@David-Engel

@intclassproject Ensure SQL Server is installed and configured correctly for network access. If you are running SQL Server in a docker image on Windows, either the docker image is not running, or you did not map the network port Windows to the docker image. Here's a reference doc for a Linux docker container:
https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&preserve-view=true&pivots=cs1-powershell

I recommend these forums over this one for quicker community responses:
SQL Server on Microsoft Q&A
DBA Stack Exchange

@Mixage51 It sounds like your PHP configuration is incorrect. Assuming you have followed the instructions on the docs site, the test script at the end (https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15#testing-your-installation) should help identify problems. If you can't figure it out, try PHP-specific forums (https://www.php-forum.com/phpforum/, https://forums.phpfreaks.com/), or, if you can't get help there, file an issue in the PHP drivers for SQL Server repo: https://github.com/microsoft/msphpsql/issues.

qkr9595

@qkr9595

혹시 한국분

계십니까

Where communities thrive

People

Repo info

Activity