Azure SQL Database
An Azure relational database service.
5,998 questions
3 answers
Error when connecting to Sql Server using Microsoft Sql Server Management Studio
Hi, Team I got an error when connecting to Sql Server using Microsoft Sql Server Management Studio. There was no problem before. Can you help me find out the reason? The following is the detailed error information TITLE: Connect to Server Cannot…
asked 2025-02-07T07:56:36.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 25%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Allen F MAO
0
Reputation points
answered 2025-02-14T08:55:38.0266667+00:00
Allen F MAO
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Please clarify the behaviour of ARITHABORT on database with database compatibility level >= 90
I would like to check if the ARITHABORT setting might be negatively affecting my database performance. In the article https://learn.microsoft.com/en-us/sql/t-sql/statements/set-arithabort-transact-sql?view=sql-server-ver16 the following is stated: …
asked 2025-02-13T08:56:09.2566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 26%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPW%3C/text%3E%3C/svg%3E)
Philipp Weber
0
Reputation points
accepted 2025-02-14T07:58:28.8666667+00:00
Philipp Weber
0
Reputation points
2 answers
Problem with SqlParameterCollection.Add method to make SqlDbType all NVarChar
I am trying to access a SQL Server table with a program created in C# to update and register data. I am thinking of parameterizing the query and using the SqlParameterCollection.Add method to create a SQL statement. In this case, if I set SqlDbtype to…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,435 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,470 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,294 questions
asked 2025-02-14T01:02:27.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 76%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
那由多
40
Reputation points
commented 2025-02-14T07:49:24.7566667+00:00
SurferOnWww
3,816
Reputation points
1 answer
unable to use bcp_init or bcp_initA bulk copy functions when using odbc driver 18 as data source
Sir/Madam, I am unable to use bcp_init or bcp_initA bulk copy functions when using odbc driver 18 as data source. I know for sure that bcp_initA is there in the odbc driver 18 dll. but the function returns failure code. The same bcp_init function returns…
asked 2025-02-13T10:29:56.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 8%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
mani s
0
Reputation points
edited an answer 2025-02-14T06:46:06.7333333+00:00
ZoeHui-MSFT
40,511
Reputation points
0 answers
Azure DevOps deploy pipeline SSIS Catalog Configuration task fails with a missing file error
I have built a deployment pipeline in Azure DevOps that deploys an SSIS project to a SQL Server 2019 instance using an Azure Pipelines agent running on the same server. The pipeline has two tasks: Deploy the SSIS project using the SSIS Deploy task…
asked 2025-02-13T08:25:09.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 32%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Julian Hicks
20
Reputation points
edited the question 2025-02-14T06:20:27.9333333+00:00
ZoeHui-MSFT
40,511
Reputation points
1 answer
Does SQL Server Reporting Services Report Builder application support forms authentication to SSRS?
I have configured my SQL Server Reporting Services server to use Forms authentication to work with a custom SSO identity provider. The web experience works fine, but the Report Builder client application is not able to connect. Is there documentation…
asked 2025-02-13T17:29:57.4266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 63%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP6%3C/text%3E%3C/svg%3E)
PaulGibson-6972
1
Reputation point
answered 2025-02-14T06:06:52.82+00:00
ZoeHui-MSFT
40,511
Reputation points
1 answer
One of the answers was accepted by the question author.
When I am running a long running query or stored procedure on Azure Sql databse, I am getting "A transport-level error has occurred when receiving results from the server" error. I have tried same query from portal as well but
When I am running a long running query or stored procedure on Sql databse, I am getting Msg 64, Level 20, State 0, Line 0 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified…
asked 2025-02-08T12:03:27.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 49%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Pankaj Sharma
0
Reputation points
commented 2025-02-14T05:24:52.1466667+00:00
Pankaj Sharma
0
Reputation points
2 answers
SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI
I’m encountering an SSL certificate chain issue when trying to connect to my SQL Server from a Power BI server. The server connects, but when I click refresh, this error appears. Below are the details: Error Message: Microsoft SQL: A connection was…
asked 2025-02-13T08:46:38.4433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 24%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Suchith D
0
Reputation points
answered 2025-02-14T02:02:17.32+00:00
ZoeHui-MSFT
40,511
Reputation points
0 answers
Why did this error occur in Event Viewer at that time when the application was unable to connect to the database?
The configuration information of the performance library 'perf-MSSQL$SQLEXPRESS-sq|ctr14.0.1000.169.dII' for the 'MSSQL$SQLEXPRESS' service does not match the trusted performance library information stored in the registry. The functions in this library…
asked 2025-02-13T16:24:48.48+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 23%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYE%3C/text%3E%3C/svg%3E)
Yasantha Ekanayake
0
Reputation points
commented 2025-02-14T02:01:02.4766667+00:00
LiHongMSFT-4306
30,666
Reputation points
1 answer
Sql server 2022 unable to install. Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
Hi, Ive been stuck trying to download SQL server 2022 for my pc. Summary_LAPTOP-SGOLUAOI_20230913_220637.txt Please help me
asked 2023-09-13T20:11:12.5933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 57.99999999999999%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Daniel Bao Duy Nguyen
0
Reputation points
commented 2025-02-14T01:57:19.59+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 15%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Malaika Shabbir
0
Reputation points
1 answer
SQL gaps and island issue
Greetings!!! We're working on migrating data from a legacy application and have a requirement to get all the consecutive SESSION START_DATE & END_DATE. For the SESSION_ID - 8642, SESSION_TYPE - 3256, based on the requirement using sql server query…
asked 2025-01-21T05:59:20.4966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 20%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Raj D
611
Reputation points
commented 2025-02-13T22:34:30.36+00:00
Erland Sommarskog
116.8K
Reputation points MVP
1 answer
SQL gaps and island issue
Greetings!!! We're working on migrating data from a legacy application and have a requirement to get all the consecutive SESSION START_DATE & END_DATE. For the SESSION_ID - 8642, SESSION_TYPE - 3256, based on the requirement using sql server query…
asked 2025-01-21T05:59:20.4966667+00:00
Raj D
611
Reputation points
commented 2025-02-13T22:34:30.36+00:00
Erland Sommarskog
116.8K
Reputation points MVP
8 answers
SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services
Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…
asked 2023-02-20T09:37:55.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 97%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Alessandro Di Pasquale
15
Reputation points
commented 2025-02-13T22:18:09.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 30%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jindra
0
Reputation points
8 answers
SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services
Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…
asked 2023-02-20T09:37:55.24+00:00
Alessandro Di Pasquale
15
Reputation points
commented 2025-02-13T22:18:09.2833333+00:00
Jindra
0
Reputation points
0 answers
Region-specific drives for a VM located in Azure AU region
Hi Team, We have a requirement from clients to have the data in the respective data drives, for example - client from US wants to have their data in a drive which is physically located in the azure data centre in US region. We are looking at partitioning…
asked 2025-02-06T23:25:40.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 57.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Berchmans Marcelline
10
Reputation points
commented 2025-02-13T18:51:37.44+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Keshavulu Dasari
3,270
Reputation points Microsoft Vendor
0 answers
How can I connect to my SQL server from my VM using a .NET application.
I have a .NET application on my azure virtual machine that will not connect to my azure SQL database. I can otherwise connect to the db on my vm using SSMS. My .NET application will connect from my local laptop. I am using ENTRA ID authentication.
.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,103 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,779 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,470 questions
asked 2025-02-07T23:50:29.9033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 93%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Nicholas Pallotta
0
Reputation points
commented 2025-02-13T17:06:38.9466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
71,506
Reputation points
3 answers
One of the answers was accepted by the question author.
Sortable MVC Tables with Stored Procedure
Hello everyone and thanks for the help in advance. I am developing a MVC application that requires a sortable table. The issue is that the tables utilize queries that are best suited for stored procedures. While researching, I cam across older…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 34%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
Does SQL server hostname supports hypen?
Hi, I Am trying to install SQL server 2019, since the beggining I faced a lot of problems (to install SQL Server and to configure DBs on Mirroring) A new error I got says something about the hostname, my hostname is something like: hostname-01. Is hypen…
asked 2025-02-12T22:30:06.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 57.99999999999999%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
abraham flores
251
Reputation points
accepted 2025-02-13T16:16:38.07+00:00
abraham flores
251
Reputation points
1 answer
Can I to hide or disable Document Map SSRS?
I created a report in SSRS with two Tablix, firts Tablix needs groups elements, but when I create the groups the Document Map appears but I dont need the document Map, How can I disable de Document Map?, I dont need see it! Just need see the Document…
asked 2021-07-05T17:28:25.813+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 18%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
YAVER MONTES HERNANDEZ
1
Reputation point
commented 2025-02-13T15:59:33.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 12%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Alistair Francis
0
Reputation points
3 answers
Document for Backup Restore
Any document/link about backup and restore of MS SQL Server database using Visual Studio Code? Similar to the below one for azure data studio. https://learn.microsoft.com/en-us/azure-data-studio/tutorial-backup-restore-sql-server Thanks!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)