185 questions
2 answers
MSSQL connection in Visual Studio Mac->(Socket Exception)
HI Community! I am facing the following problem and it is driving me crazy. I was creating a SQL Server in Azure, and I was trying to connect via Visual Studio Code, but using the exactly same configuration n Mac I am getting this error…
SQL Server Database Engine
asked 2025-05-03T20:21:38.7133333+00:00
moialbla
5
Reputation points
commented 2025-05-18T17:43:25.6166667+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(12.8, 67%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Polunin, Roman
0
Reputation points
0 answers
How to fix oledb timeout connection errors
ChatGPT Log in You said: Hello all, I'm facing an issue with an OLED linked server timeout errors,this issue is facing especially when an index job is running for a example testdb(this db tables related to application logs etc)and we are using SQL server…
SQL Server Database Engine
185 questions
asked 2025-05-18T14:44:53.4066667+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(131.20000000000002, 78%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Madhavi Mankena
0
Reputation points
commented 2025-05-18T15:03:14.1233333+00:00
Erland Sommarskog
120.6K
Reputation points MVP
Moderator
1 answer
Migrate Alwayson DB with less down time
We have 8TB database which is part of alwayson , how to migrate this database to new VM with less down time
SQL Server Database Engine
185 questions
asked 2025-05-18T11:02:17.06+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(57.599999999999994, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
ALETI, SUNEEL KUMAR
0
Reputation points
answered 2025-05-18T11:50:38.87+00:00
Erland Sommarskog
120.6K
Reputation points MVP
Moderator
1 answer
Error - FOR XML could not serialize the data for node 'NoName'
I am using FOR XML to concatenate varchar data. The data came from user input so it could have garbage characters. Getting the "Error - FOR XML Could Not Serialize the data for node NoName". Not really picky about what to do with the bad data,…
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
185 questions
asked 2025-05-17T22:00:51.08+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, 35%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
brenda grossnickle
206
Reputation points
answered 2025-05-18T09:46:12.0933333+00:00
Erland Sommarskog
120.6K
Reputation points MVP
Moderator
8 answers
Unable to open the physical file. Operating system error 5: “5(Access is denied.)”
I am trying to work on a query to attach a database (UNC path) remotely. I have SQL Server management studio (SSMS) installed in SQL Server machine (machineSQL) and also in another machine (machineRemote) in same domain. Query:: CREATE DATABASE…
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,493 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,705 questions
asked 2020-09-24T01:18:45.57+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(230.39999999999998, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nishant Kumar
1
Reputation point
answered 2025-05-17T18:42:24.1733333+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)
75,871
Reputation points
Moderator
0 answers
SSRS subscrption SMTP is not working
Somehow our SSRS subscription is not sending emails and we are getting below errors Message delivery to the host '52.96.183.226' failed while delivering to the remote domain 'mediamaxnetwork.com' for the following reason: The remote SMTP service rejected…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,044 questions
asked 2025-05-17T17:08:36.4533333+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(217.60000000000002, 98%, 31%)' 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)
Subbu Devalla
0
Reputation points
asked 2025-05-17T17:08:36.4533333+00:00
Subbu Devalla
0
Reputation points
1 answer
How to make a SSRS report subscription available to a domain user?
On one SSRS system, I was able to easily subscribe to a report after I added my domain account as a System Administrator in the Security section of the SSRS Site Settings. Now on a different but identical SSRS system, with the same account, I cannot…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,044 questions
asked 2025-05-15T16:42:59.85+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(252.8, 78%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Corey Behrens
0
Reputation points Microsoft Employee
answered 2025-05-16T12:57:47.5833333+00:00
Corey Behrens
0
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Issue creating Service-Based SQL Database in Visual Studio 2022
I am attempting to create an SQL Database in visual studio 2022: I get the following error: even though sql client has been added as a package reference: Any thoughts? thanks
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,449 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,493 questions
asked 2024-07-27T06:44:54.7333333+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(38.4, 56.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
John Dyson
45
Reputation points
answered 2025-05-16T08:45:34.12+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(131.20000000000002, 72%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
saeed mardani
0
Reputation points
1 answer
SSIS Data Conversion Redirecting Rows to Error Output Despite Valid Data
I have a Data Conversion component in SSIS that keeps redirecting rows to the error output despite the data being valid. The FIRE_SIZE_CLASS column only contains single characters A-G, confirmed through inspection, and the conversion is set to DT_STR…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,689 questions
asked 2025-05-15T15:52:02.09+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(144, 84%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Cuamsia
0
Reputation points
answered 2025-05-16T05:53:08.09+00:00
Olaf Helper
46,946
Reputation points
1 answer
One of the answers was accepted by the question author.
Running SSIS both using command or using SQL Server Agent keeps failing
Hello everyone, I am running an export of our SQL Database using SQL Server Management Studio and it fails when I try to automate it Manually running the export by Right Click>Tasks>Export Data will work fine and I will be able to get the output…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,689 questions
![](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(246.4, 96%, 33%)' 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)
0 answers
SQLserver2022 standard edition to SQLserver2022 1dvice CAL
お客様番号：契約番号利用開始日記載のMicrosoft software inCSPサービス開通通知は頂いているのですが、https://www.office.comの管理センターで商品が記載されない状況でダウンロードも出来ない状態です。記載させる方法、手法を知りたいです。 宜しくお願い致します
SQL Server Database Engine
185 questions
asked 2025-05-15T03:16:33.3233333+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(284.8, 95%, 37%)' 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)
外園
0
Reputation points
commented 2025-05-15T21:12:45.5233333+00:00
Erland Sommarskog
120.6K
Reputation points MVP
Moderator
2 answers
One of the answers was accepted by the question author.
Table locked
Good day, My colleague was using Import/Export wizard and the package got stuck. He since killed SSMS, but the table got locked somehow. We're unable to truncate it or rename it. What can be done to unlock it? Thanks in advance.
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
185 questions
asked 2025-05-15T18:02:46.8333333+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(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Naomi Nosonovsky
8,411
Reputation points
answered 2025-05-15T21:05:44.94+00:00
Erland Sommarskog
120.6K
Reputation points MVP
Moderator
1 answer
SQL Server Database Mirroring Configuration Error - Database Not Configured for Mirroring
Subject: SQL Server Database Mirroring Configuration Error - Database Not Configured for Mirroring Dear Microsoft Support, I am writing to request assistance with a database mirroring issue I'm encountering in our SQL Server environment. Environment…
SQL Server Database Engine
185 questions
asked 2025-05-14T14:47:24.9866667+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, 45%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Deepak Kumar | Veracity
0
Reputation points
commented 2025-05-15T20:59:59.27+00:00
Erland Sommarskog
120.6K
Reputation points MVP
Moderator
1 answer
One of the answers was accepted by the question author.
Restore Database from .MDF and .LDF files in Sql Server 2019
Hello, We have Sql Server 2019 and we need to restore the database using .MDF and .LDF file into existing database. We have received .MDF and .LDF file from another server which is also Sql 2019 and our current server which has already database which is…
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
185 questions
![](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(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
0 answers
Microsoft SQL Server Migration Assistant for Oracle Extension Pack missing SSMA for Oracle Data Migration Assistant.dll
We installed SSMA for Oracle 10.1 and were trying to use the client side migration but it is calling for too much ram, so we tried to use the server side migration. However that fails immediately without much info as to why. We installed the…
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
566 questions
asked 2025-05-15T13:41:37.1833333+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(70.4, 79%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Straughn, Wayne
0
Reputation points
asked 2025-05-15T13:41:37.1833333+00:00
Straughn, Wayne
0
Reputation points
1 answer
publication having 2 subscribers
We have transactional replication configured. We have a publication having 2 subscribers. If snapshot is generated on 1 subscriber, will it generate snapshot on the second subscriber?
SQL Server Database Engine
185 questions
asked 2025-05-14T14:37:29.3066667+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, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
801
Reputation points
commented 2025-05-15T13:37:04.02+00:00
Chaitanya Kiran
801
Reputation points
1 answer
Free SQL Server Editions for Commercial Use.
What free SQL Server editions am i allowed to use in a production environment (for commercial use) in Windows where i both use .NET web-applicationa as well as desktop applications? I have investigated some of this but it's not clear - i do know that i…
SQL Server Database Engine
185 questions
asked 2025-05-15T11:42:17.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(51.2, 34%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Staffan Vinsa
0
Reputation points
answered 2025-05-15T12:25:17.7666667+00:00
Olaf Helper
46,946
Reputation points
2 answers
Failure to instal SQL Server 2022
Everytime I try to instal SQL server, keeps on showing this Oops ... Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893607Error description: Could not find the Database Engine startup handle. C:\Program Files\Microsoft SQL…
SQL Server Database Engine
185 questions
asked 2025-05-14T09:42:53.31+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, 64%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Joshua Mworia
5
Reputation points
answered 2025-05-14T20:54:37.6633333+00:00
Erland Sommarskog
120.6K
Reputation points MVP
Moderator
0 answers
database currently unavailable
database on server is not currently available please retry the connection later. if the problem preseists contact customer support and provide them the session tracid ID SQL error 40613
SQL Server Database Engine
185 questions
asked 2025-05-14T11:24:44.49+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(307.2, 89%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Diane Roy
0
Reputation points
commented 2025-05-14T20:53:10.6166667+00:00
Erland Sommarskog
120.6K
Reputation points MVP
Moderator
2 answers
What is the performance cost of using PIVOT in Microsoft SQL Server
I'm using PIVOT in my query, but it's resulting in high logical reads and performance degradation. Could you recommend a more optimal alternative approach.
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
185 questions
asked 2025-05-14T15:07:42.86+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(83.2, 11%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
RajeshKumar Tuta
0
Reputation points
answered 2025-05-14T20:39:00.74+00:00
Erland Sommarskog
120.6K
Reputation points MVP
Moderator