Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

SQL Server

Microsoft SQL Server powers your entire data estate by supporting structured and unstructured data sources. It builds on previous versions of SQL Server, which have been industry leading for four years in a row and a leader in TPC-E. It scales to petabytes of data and allows customers to process big data through PolyBase using T-SQL over any data. SQL Server has also been the least vulnerable database during the last seven years. SQL Server brings data insights with business intelligence capabilities that provide analytics at a fraction of the cost on any device along with advanced analytics with support for R and Python.


More details about SQL Server are available in the SQL Server documentation.
If you have a technical issue, please open a post on the developer forums through Microsoft Q&A or Stack Overflow

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. SSMS 18.5 Setup Error

    I encounter an error while trying to setup SSMS 18.5 :
    Error 0x800b010c: Failed to verify signature of payload: HelpViewer2_3

    pls. fix that issue ! thx !

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  2. SSMS: Don't install Azure Data Studio if it's already installed!

    Most recent SSMS upgrade (18.7.1) incredibly, installed Azure Data Studio in program files. It was already installed in user directory. With the exception of unins000.dat and product.json the files are IDENTICAL., Both copies access the same set of plug-ins and settings. What is the point of this? Surely SSMS could detect that it's already installed and skip that step?

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  3. SQL Server 2019 Express - Invalid Class - error 0x84B10001

    Hi! I'm trying to install sql server 2019 express but it fails. The error message shown is 'invalid class - error 0x84B10001. My OS is Windows 10.

    What should I do?

    Thank you!

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  4. whats the license (and where is the text for it) for sqlcmd on redhat??

    whats the license (and where is the text for it) for sqlcmd on redhat??

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  5. FIx your reliance on reboots

    Setup needing a reboot, before or after, is an absurdity in this day and age.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add ability to run msodbcsql (unixODBC) in FIPS mode

    In order to use the BCP tool in an application running on FIPS mode, the connection to the database needs to be on FIPS mode as well. However, there doesn't seem to be any way to enable FIPS mode on msodbcsql17.

    See example for Sybase: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc20155.1600/doc/html/ske1383132729026.html

    Can the SQL Server driver be enhanced to allow for such mode of operation?

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  7. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  8. Azure AD domain name or tenant ID parameter not available in ODBC 17 driver

    Trying to set up a DSN for Azure SQL DB with Integrated authentication with MFA support using ODBC version 17.10.06.315. Cannot connect to Azure DB using Azure AD authentication. No place to enter the "Azure AD domain name or Tenant ID" parameter, like the Microsoft SQL Server Management Studio has when creating a new connection.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  9. is Azure site recovery available for use with windows clustering and FCI with premium file shares for sql 2014+

    is Azure site recovery available for use with windows clustering and FCI with premium file shares for sql 2014+

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  10. Provide SSMS installer that runs.

    Actually update SSMS when the [UPDATE] button is clicked instead of going to a web page to initiate a download to install manually later.
    I've downloaded the "current" version 4 times, but the installer that downloads will not run, even with Admin credentials.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  11. ubuntu 20.04

    SQL Server 2019 para Linux soporta oficialmente a Ubuntu Server 20.04? En la página solo aparece soporte para 18.04 y 16.04.

    Existe alguna guia oficial de como instalarlo en esta versión?

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  12. Xin khắc phục sự cố

    Bạn đã gửi
    15 phút trước
    Trình điều khiển Microsoft OLE DR cho Máy chủ SOL: Đã xảy ra sự cố với gói Windows cuối cùng này. Không thể chạy DLL cần thiết để cài đặt này hoàn tất. Liên hệ với nhân viên hỗ trợ của bạn hoặc nhà cung cấp pachage.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  13. SQLPackage - No simple way to hold environment specific data

    We currently use SQLPackage to deploy all our databases (as much as possible)

    We have multiple applications which are spread over multiple different azure regions for each application. These in turn then have Staging, Development and production environments

    Because our applications and regions have different requirements this means they have different configurations and setup.

    To allow for this we have to hold a huge amount of static data.

    For each application we hold thousands of different lines of static data. These range from:

    Table population for Staging/Development environments holding config data

    Specific db config such as dbowner and advanced sql…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  14. SQLPackage - Unable to deploy Agent Jobs without sysadmin

    We want to be able to continuously deploy our databases as well as our database instances including SQL Agent Jobs. We want to do this securely.

    Currently SQLPackage and Database Projects do not have a specific object to store Agent Jobs. We tried storing our SQL Agent jobs in a script file and running it post deployment, however we were unable to do this unless the user carrying out the deployment was sysadmin. This isnt ideal as we do not want our user having more permissions than it needs, as it increases risk of a mistake being made.

    We would…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  15. 在中国,使用Linux系统安装MSSQL太慢了,5kb/s ,能有办法提到500kb/s 嘛?

    在中国,使用Linux系统安装MSSQL太慢了,2kb/s ,能有办法提到500kb/s 嘛?

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  16. ACABOU MEU LIMITE EM DO BANCO DE DADOS, SQL SERVER 2012 EXPRESS.

    Prezados bom dia, estou enfrentando um erro com o meu BD, meu BD já atingiu 10 GB, como meu SQL estúdio está na versão server 2012 express,e esta estância e limitada, gostaria de saber se tem como atualizar minha versão para uma estancia sem limitações.
    Could not allocate space for object 'dbo.GRELBATCH'.'PKGRELBATCH' in database '............' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  17. You've got to be kidding with SAS. I've fooled around with it for hours. Do something less error-prone

    You've got to be kidding with SAS. I've fooled around with it for hours. Do something less error-prone

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  18. SSMS self update/installation

    It would be nice if SSMS 18 not only checked for updates, but could also start the download/installation. Currently it prompts me that a new version is available and then opens a web-browser to show me.

    The problem is that I then need to scan the web page looking for the proper download link. When a week has gone by the download announcement is no longer the first entry on the blog. Scroll scroll scroll.

    Other versions of VS directly launch an updater.

    It would be even nicer if it updated behind the scenes and prompted me to restart to…

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  19. Provide a mechanism to SSMS autoupdate or being done by one-click only

    It is so annoying that I have to download another installer to keep my SSMS up-to-date. It should be by one-click or a self-update process, such as is Visual Code Editor.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  20. Missing SQL Server Nativve Client 11.0 to MSAccess 365 for creating Linked table

    A table in SQL Server - create a Linked Table in MSAccess 365 using VBA automation.
    strConnectionString = "ODBC;DRIVER=(SQL Server Native Client 11.0);" & _

        "SERVER=MyDSERVER\MSSQLSERVER=" & DatabaseName & ";" & _
    
    "UID=" & UID & ";" & _
    "PWD=" & pwd & ";" & _
    "Table=DBO." & sLocalName & ";Option=3;"

    Need proper syntex for Native Client 11.0

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base