Windows 10: SQL Server Database Connectivity Issues

Yukon_Cornelius1964 · Feb 24, 2022

Not sure if this is the appropriate place to ask, but I currently use MS SQL Server Management Studio v18.10 for work. Whenever I'm on WiFi, I have no issues connecting to SQL Server databases, but as soon as I plug in my ethernet cable, I can't connect and I get timeout errors. I would just stay on WiFi, but I'm currently using a docking station Dell WD19 and for some reason, this docking station is causing my wifi speeds to drop from ~500 Mbps to less than 5 Mbps. My local IT team knows about this issue, yet is a bit stumped as to what to do. Any insights are appreciated.

:)

AnilTalnikar · Feb 24, 2022

SQL Server 2017 Express Issue with 3 Tier database access.

Hi, I am facing an issue with SQL Server 2017 Express.

My client is on PC1, SQL server is configured on PC2 and the database is on PC3. I could successfully connect to SQL server on PC2 through client on PC1, but if I try to access the database on PC 3 using client on PC1, I get following error...

"Msg 5120, Level 16, State 101, Line 2

Unable to open the physical file "\\MD1Z549C.ad001.siemens.net\Database_DT\Products\ProductDB.mdf". Operating system error 5: "5(Access is denied.)".

Msg 1802, Level 16, State 7, Line 2

CREATE DATABASE failed. Some file names listed could not be created. Check related errors."

When i access the database on PC2 there is no Issue. or if i use other SQL server from PC1 then I could access database database on PC3 as well. (here no intermediate PC2 is used)

So issue is when I have Client, SQL Server and Database on 3 different machines. (it gives above errro message)

The same scenario used to work well with SQL server 2008 R2 Express.

The same issue is reproducible with SQL server 2017 full version and SQL server 2019.

All the three PCs, shared drives and SQL server are configured well, which used to work with SQL server 2008 R2 express.

Is there any limitation or restriction introduced with the latest version of SQL server ? OR anything I need to try out to make the scenario work on three different machine.

Thanks a lot in advance.

Brink · Feb 24, 2022

SQL Server + C#: What’s new

With the release of SQL Server v.Next public preview on Linux and Windows, the ability to connect to SQL Server on Linux, Windows, Docker or macOS (via Docker) makes cross-platform support for all connectors, including .NET Framework and .NET Core SqlClient, even more important. To enable C# developers to use the newest SQL Server features, we have been updating SqlClient with client-side support for new features.

In .NET Framework, we have provided client-side support for Always Encrypted and added Azure Active Directory as an authentication method. We’ve also added a new connection string parameter called “Pool Blocking Period.” It can be used to select the behavior of the blocking period when connecting to Azure SQL Database and SQL Server. Many applications that connect to Azure SQL Database need to render quickly, and the exponential blocking period can be problematic, especially when throwing errors. By adding the Pool Blocking Period parameter, we aim to improve the experience for connections to Azure SQL Database. Learn more about the new parameter here.

.NET Core is the cross-platform, open-source implementation of the .NET Framework. The project includes CoreFX, the foundational libraries of .NET Core. Cross-platform support allows developers to seamlessly run applications on their operating system of choice, regardless of the platform it was developed on. For example, an app developed on Windows can be deployed to macOS and Linux, without ever having to port any code. To connect apps written in .NET Core to SQL Server (hosted anywhere), developers can use System.Data.SqlClient available in CoreFX. By developing in .NET Core on GitHub, we have been able to get feedback quickly and are actively working to enable the breadth of application scenarios and workloads.

Get started today

Check out CoreFX on GitHub! Make pull requests and let us know what you think.

Try the new getting started tutorials that show you how to:

Install SQL Server on Linux/macOS/Docker/Windows

Create a simple app using C# and other popular programming languages with SQL Server

Create a simple app using popular web frameworks and Object Relational Mapping (ORM) frameworks with SQL Server

Try out some cool SQL Server features that can make your apps shine

Connect with us

Join the conversation at https://gitter.im/mssqldev.

Sign up to stay informed about new SQL Server on Linux developments.

Learn more

Visit the Connect(); webpage to watch overview, security, high-availability and developer tools videos about SQL Server on Linux on demand.

Visit the webpage for the next release of SQL Server.

Other videos in this series

SQL Server + Node.js: what’s new

SQL Server + Java: what’s new

SQL Server + PHP: what’s new

SQL Server + Python: what’s new

Watch the to see how to get started with SQL Server on Linux in less than a minute.

SQL Server on Linux: use SQL Tools with SQL Server

Click to expand...

Source: SQL Server + C#: Whats new | SQL Server Blog

Brink · Feb 24, 2022

SQL Server + Python — What’s new

Python is one of the most popular and fastest-growing languages used today. Pyodbc (Python-SQL Server Connector) is an open source Python module maintained by Michael Kleehammer that uses ODBC Drivers to connect to SQL Server. It allows you to connect from the platform of your choice to SQL Server on-premises and in the cloud. Pyodbc is also cross platform and can be installed using pip.

We recently announced SQL Server v.Next CTP1 on Linux and Windows, which brings the power of SQL Server to both Windows and — for the first time ever — Linux. You can now connect your applications to SQL Server running on Linux, Windows and macOS (with Docker).

For our Python developers, we have a few updates that will improve Python connectivity with SQL Server. Pyodbc is now:

Officially supported: You can contact Microsoft Customer Service and Support (CSS) via phone, email, Twitter, forums, etc., to report and get help with any issue.

Available in Jupyter Notebooks for SQL Server: The Jupyter Notebook is a web application that allows you to create and share documents that contain live code, equations and visualizations.Pyodbc and its dependencies ship out of the box with Juypter notebooks on Azure. To get started, go to notebooks.azure.com and create a new Python 2 notebook or follow the instructions here. Check out the code sample and paste it in your notebook’s interactive prompt to get started.

Compatible with Python 3.5 and Django 1.10 through Django-pyodbc-azure.

Get started today

Try the new getting started tutorials that show you how to:

Install SQL Server on Linux or Windows or run on Docker in multiple platforms.

Create a simple app using C#, Java, Node.js, PHP and Python with SQL Server.

Create a simple app using popular web frameworks like Django with SQL Server.

Try out some cool SQL Server features that can make your apps shine.

Get the latest v17.0 RC1 versions of SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT).

Get the mssql extension for Visual Studio Code and develop apps with SQL Server on Linux/macOS/Windows.

Connect with us

Join the conversation at https://gitter.im/mssqldev.

Sign up to stay informed about new SQL Server on Linux developments.

Learn more

Visit Connect(); to watch overview, security, high-availability and developer tools videos about SQL Server on Linux on demand.

Learn more

Go to the next release of SQL Server webpage to get started with interactive SQL Server on Linux hands-on labs for Linux administrators new to SQL Server and for existing SQL Server database administrators new to Linux.

Visit Connect(); to watch overview, security, high-availability and developer tools videos about SQL Server on Linux on demand.

Other videos in this series

Watch the to see how to get started with SQL Server on Linux in less than a minute.

SQL Server on Linux: use SQL Tools with SQL Server

SQL Server + Node.js: what’s new

SQL Server + Java: what’s new

SQL Server + C#: what’s new

SQL Server + PHP: what’s new

Click to expand...

Source: SQL Server + Python s new | SQL Server Blog

Windows 10: SQL Server Database Connectivity Issues

SQL Server Database Connectivity Issues

SQL Server Database Connectivity Issues

SQL Server Database Connectivity Issues

SQL Server Database Connectivity Issues - Similar Threads - SQL Server Database

Unable to connect to external database from sql server python script-Python Services

Unable to connect to external database from sql server python script-Python Services

SQL Server 2016 Issue

SQL Server 2016 Issue

SQL Server Database Connectivity Issues

SQL Server Database Connectivity Issues

Inplace upgrade of Server OS on a SQL 2012 Database server

Inplace upgrade of Server OS on a SQL 2012 Database server

SQL Server, Shrink Database Maintenance Task Failing