Windows 10: Microsoft SQL server

Dylan Stephenson · Sep 18, 2021

While installing CAD software on a new laptop, the error "Microsoft SQL Server failed to install. Attempted to perform an unauthorized operation." came up. There was no error code.

:)

Brink · Sep 18, 2021

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

Brink · Sep 18, 2021

Released: Microsoft Kerberos Configuration Manager for SQL Server v3.1

We are pleased to announce the latest generally-available (GA) of Microsoft Kerberos Configuration Manager for SQL Server.

Get it here: Download Microsoft Kerberos Configuration Manager for SQL Server

Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network. To use Kerberos authentication with SQL Server, a Service Principal Name (SPN) must be registered with Active Directory, which plays the role of the Key Distribution Center in a Windows domain. In addition, many customers also enable delegation for multi-tier applications using SQL Server. In such a setup, it may be difficult to troubleshoot the connectivity problems with SQL Server when Kerberos authentication fails.

The Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server, SQL Server Reporting Services, and SQL Server Analysis Services. It can perform the following functions:

Gather information on OS and Microsoft SQL Server instances installed on a server.

Report on all SPN and delegation configurations on the server.

Identify potential problems in SPNs and delegations.

Fix potential SPN problems.

This release (v 3.1) adds support for SQL Server 2016.
Click to expand...

Source: Released: Microsoft Kerberos Configuration Manager for SQL Server v3.1 | SQL Server Release Services

Brink · Sep 18, 2021

SQL Server + PHP – What’s new

PHP is one of the most widely used programming languages for web developers today. The Microsoft PHP Connector for SQL Server is used to connect PHP applications to SQL Server, whether SQL Server is hosted in the cloud, on-premises or provided as a platform as a service.

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. Developers can now create applications with SQL Server on Linux, Windows, Docker or macOS (via Docker) and then deploy to Linux, Windows, or Docker, on-premises or in the cloud.

As part of this announcement, we have made some improvements to our PHP connector:

SQL Server v.Next Support: You can now use the PHP connectors to connect to SQL Server v.Next CTP1 of SQL Server running anywhere, including SQL Server on Linux, Windows or Docker.

Linux support: We’ve created Linux-native versions of sqlsrv and pdo_sqlsrv modules of the PHP SQL Server Connector. Now you can use the PHP Connector to connect to SQL Server on Ubuntu 15.04, 15.10, 16.04, Red Hat 6 and Red Hat 7.

PHP 7.0 and 7.1 support: We have added support for the latest PHP runtimes for Windows and Linux with our releases on GitHub.

PECL Install Experience for Linux: We have created native PECL packages for Linux. This enables developers to install, upgrade and uninstall the PHP SQL Server connector using the PECL package repository. This is explained in detail in our Getting Started tutorials.

Community input for prioritization: We have also started using surveys on GitHub to guide our prioritization for features and improvements. Check our latest survey and let us know what you think.

Get started today

Check out the PHP connector source code on GitHub and our packages (sqlsrv, pdo_sqlsrv) on PECL. 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 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 and Laravel 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 + Python: what’s new

Click to expand...

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

Windows 10: Microsoft SQL server

Microsoft SQL server

Microsoft SQL server

Microsoft SQL server

Microsoft SQL server - Similar Threads - Microsoft SQL server

sql server

sql server

Sql server Reporting Server activation with Sql server Core edition

Sql server Reporting Server activation with Sql server Core edition

SQL server

SQL server

Microsoft sql server 2005

Microsoft SQL Server

Microsoft SQL Server