SQL Server

How to install Reporting Services in an Azure SQL VM

Hello, I have an Azure SQL VM and i need to install SQL Reporting Services. I downloaded the setup but it asking for a serial number that i don't have. How do i know the serial number of SQL to insert in the instalation process? Or there is another way…

In Visual Studio Code, I cannot connect SQL Tools Microsoft SQL Server/Azure to the Azure SQL DB.

"SQL Tools Microsoft SQL Server/Azure", the driver for SQL Tools in Visual Studio Code, seems unable to connect with my Azure SQL Database account's sole logical server. I am able to make connection from Visual Studio Code (VSC) to Azure SQL…

Missing Tables in AdventureWorksWD 2020 Database

I am currently working through the Power BI training and following the provided instructions to connect to the AdventureWorksWD2020 database. However, I have encountered an issue where several expected tables, including DimEmployee are missing. Here’s…

tại sao khi kết nối với máy chủ SQL 2022 Azure lại không có Restore Database

Khi tôi cài đặt Azure Data Studio kết nối với SQL bản 2022 và muốn restore advanturework 2022 để thực hành thì không có mục Restore dữ liệu khi nhấn chuột phải vào Database mà chỉ có mục Filter và Refesh. Làm thế nào để sửa lỗi này?

SSMS connection to database - Cannot generate SSPI context

Hello, I've got a problem with connection to my MSSQL 2019 Standard instance. Some of symptoms: it happens only for one domain account and on one laptop (Windows 11) happens on excel, SSMS when user runs "runas /user:domain\username…

Restrict file type while uploading in ssrs

Hi, I am using SSRS and giving sysadmin permission to the user so that they can upload reports but with that they can also enable cmd prompt. Can you help me with file type restrictions during upload in SSRS through that the user can upload only rdl,jpg…

Why do no nodes appear in summary

I thought it would have at least one node, but it didn't. Did I misunderstand its concept

How Do I Connect to SQL Server?

How do I connect to a SQL server using my home computer? I ultimately just want to connect SQL to several CSV files that are on my desktop. Please let me know if you need additional information.

Table Name: Order1 OrderId: Order's id OrderItemId: Item ids of the purchase orders. QuantityOrdered: Number of items Ordered for an order. ItemPrice: Order total value PromotionDiscount: Discount of an Order. batch_id: Batch id of the order. (Note: Us

Click on "Console" at the top right corner. Agree to the terms of service and click Continue. Search for "bigquery" on the search bar at the top. Click on "Create Project" Give the project a name you like. Click on…

Need hands on help with SQL server availability

I need on hands help diagnosing SQL server availability

Get list of current active sessions and info

Hello, am aiming to set up a SQL 2016 Agent job that runs say every 15 mins and would like to email me if the Sessions count is greater > 10 where each Sessions have statuses IN ('RUNNING', 'RUNNABLE', 'SUSPENDED') and provide at least the following…

SSMS Query Store Regressed queries - buttons don't have tooltips

Hi, I'm trying to analyze information in the Query Store. I started from the top report Regressed Queries which showed nothing for me, but I noticed that several buttons on the right don't have tool tips and it's hard to figure out what they are for. My…

Please Help me - How can I fix the 'Culture is not Supported' error when importing an Excel file to a database in SQL Server Management Studio

I have tried countless times to import an Excel file via the SSMS application interface and keep getting the below error. Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [dbo].[CovidDeaths$] ( iso_code] NV . "…

Operand type clash nvarchar

Testing our web app after column encryption is giving us the error below when we try to update an encrypted table. The error message refers to nvarchar(4000) being incompatible with nvarchar(20). In the table being updated we do not have an…

Cannot install SQL Server Integration Project in SQL Server 2019

Running Windows 11 Enterprise, version 23H2, OS Build: 22631.4890. Running new installation of "Visual Studio Professional 2019" v16.11.45 SQL Server Integration Services Projects extension - Setup Failed. "Fatal error during installation…

Msg 15871, '@@FETCH_STATUS' is not supported.

I am running a query and have @@Fetch_Status while loop, but the query stops at the while loop and gives the error: Msg 15871, Level 16, State 6, Line 43 '@@FETCH_STATUS' is not supported. Not sure what the problem could be. Please assist.

SQL server collation issue while doing replication

SSMS Startup. Package did not load correctly.

I have installed SQL server and SSMS. Upon starting SSMS i get the following error message. This is followed with about 4 other popup boxes saying things like “visual studio common IDE package” did not load correctly. Please help me diagnose this error.

Unknown token received from SQL Server [SQLSTATE HY000] (Error 0)

Ever since the last patching window, we have some scheduled jobs on SQL production that are intermittently failing, producing the error "Unknown token received from SQL Server [SQLSTATE HY000] (Error 0)" The jobs run fine if they are not…

Unable to update connection credentials. Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller

facing issue with connecting sql server to power bi service, in desktop this is working properly and also able to refresh but in service getting error.