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.
2,845 questions
1 answer
Unable to reach/access SSRS when trying to access outide report server
Set up: Application server connected to report server Issue: User unable to view the reports when access through application ui screen but when access inside report server itself can access it. It seems it totaly cannot reach the report server. thanks.
asked 2021-02-26T08:09:18.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(51.2, 28.000000000000004%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MJID
1
Reputation point
answered 2021-03-01T06:29:42.823+00:00
ZoeHui-MSFT
34,346
Reputation points
3 answers
One of the answers was accepted by the question author.
How to skip space in a query
Hello, I am trying to alter credentials using a SQL query "ALTER CREDENTIAL credential_name WITH IDENTITY = 'identity_name' [ , SECRET = 'secret' ]" And the issue is that my credential_name has a space in it. so that would make my…
asked 2021-02-26T20:23:45.757+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(147.20000000000002, 90%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Paria k
21
Reputation points
answered 2021-03-01T06:08:53.427+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, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,611
Reputation points
0 answers
Azure SQL Server
Hi Team, I am having a base table in sql server (say node), which has a foreign key for attribute. In another table which stores values as per attributes (using attribute foreign key), i have a reference of the base table. For a single row of base table,…
asked 2021-02-25T05:00:28.287+00:00
salilsingh-9961
346
Reputation points
commented 2021-03-01T02:33:47.203+00:00
CathyJi-MSFT
21,106
Reputation points Microsoft Vendor
2 answers
Sending emails conditionally based on totals in SSRS reports
We have an SSRS reports like below CompanyA Currency Amount GBP 100 USD 70 Total <> in GBP CompanyB Currency Amount GBP 200 USD 10 Total <> in GBP .. .. .. With many…
asked 2021-02-26T10:51:55.687+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, 69%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
swanand bagve
1
Reputation point
answered 2021-03-01T02:09:33.537+00:00
Joyzhao-MSFT
15,566
Reputation points
2 answers
error 1639 durante la instalación del Motor de base de datos al instalar sqlserver 2019
Overall summary: Final result: Error: vea los detalles a continuación Exit code (Decimal): -2068052377 Start time: 2021-02-16 03:14:43 End time: 2021-02-16 03:15:18 Requested action: Install Setup completed with required actions for features.…
asked 2021-02-22T12:19:28.103+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, 42%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
Iratxe De Osa
6
Reputation points
commented 2021-03-01T02:01:11.697+00:00
Cris Zhan-MSFT
6,611
Reputation points
2 answers
Kerberos Issue - Anonymous Login
I have a linked server that connects one SQL Server to another SQL Server. For two weeks now there has been an error when testing the connection; Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (.Net SqlClient Data Provider) I have posted…
asked 2021-02-22T16:48:31.037+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(166.4, 34%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SQLLover21
201
Reputation points
commented 2021-03-01T01:58:13.09+00:00
Cris Zhan-MSFT
6,611
Reputation points
2 answers
SELECT NEWID(): what is the mechanism to ensure it is unique
hi all I'd like to ask what is the mechanism to ensure it is unique for SELECT NEWID(). I am using C# DAPPER to call SELECT NEWID() to generate unqiue Id, since my C# program is multi-thread, so maybe it is possible that in the same time(let's imagine…
asked 2021-02-23T02:52:57.917+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(25.6, 94%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Martin Wang
106
Reputation points
commented 2021-03-01T01:56:35.833+00:00
Cris Zhan-MSFT
6,611
Reputation points
1 answer
How do I change the credentials for connecting to a data source?
Good afternoon! How do I change the credentials used to connect to the data source? To use a non-current Windows user, enter another Windows user and their password. I use SQL Server 2014 and Visual Studio 2015.
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,741 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.
13,005 questions
asked 2021-02-24T23:17:59.797+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(128, 69%, 22%)' 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)
Konstantin
41
Reputation points
commented 2021-03-01T01:53:04.837+00:00
Cris Zhan-MSFT
6,611
Reputation points
3 answers
Querying ODBC databases via SQL Server
I want to make selects, updates, inserts, etc in a database from a linked server in MS SQL Server. I connected the linked server [SQLITE3] to a sqlite3 database with SQLite3 ODBC Driver (www.ch-werner.de/sqliteodbc). I accomplished to run selects…
asked 2021-02-25T17:44:07.35+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(246.4, 21%, 33%)' 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)
JDias
71
Reputation points
commented 2021-03-01T01:32:13.157+00:00
MelissaMa-MSFT
24,176
Reputation points
2 answers
Using SQL Alias in SharePoint Workflow Manager Installation
Background for this question - refer to this link migrating-workflow-manager-databases-to-new-server.html Was the above issue avoided in the first place by having SQL alias? If so, for some reason, the SQL Server to be moved, can we just update the…
![](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, 8%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Microsoft.Data.Sqlite SqliteTransaction question
Hi, I'm experimenting with converting some Sqlite code to Microsoft.Data.Sqlite, including this: using (SqliteTransaction transaction = con.BeginTransaction()) { //for (int j = 0; j < _totalItems; j++) …
![](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(28.799999999999997, 1%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
SSRS report builder 3.0. SQL recordset help
I’ve simplified this set of data and here’s my goal. For each EVENT with more than one EMP (Employee), I want just a record set just showing the EVENT, EMP and DATE of just the EMP with the first Date assigned. So, one line for each EVENT listing just…
![](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, 74%, 22%)' 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)
1 answer
One of the answers was accepted by the question author.
Error upon editing a remote database table
Hi I have logged in to a remote SQL Server as <ip address>\SQL2K14 using the sa login. When I try to edit a table (right click on table and select 'Edit Top 1000 Rows') on this remote SQL Server I get below error; Attempted to read or write…
![](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(25.6, 47%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
2 answers
how do I write data that is not deleted with database when the form is closed and opened? | SQL
private void btnPublish_Click(object sender, EventArgs e) { Sqlbaglan.NesneVer().thisConn = new SqlConnection(@"Data Source=(localdb)\mssqllocaldb;initial catalog = ManagerPanel;integrated security = true"); …
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,502 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.
13,005 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.
10,448 questions
asked 2021-02-27T20:38:37.557+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(163.2, 0%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOU%3C/text%3E%3C/svg%3E)
Oğulcan Akca
196
Reputation points
answered 2021-02-28T16:09:03.78+00:00
Karen Payne MVP
35,201
Reputation points
1 answer
One of the answers was accepted by the question author.
SSMS runs failed on inexitent information!!!
Hello, I have a query running in SSMS the server name and the list of patches applied with their status successful, failed, waiting reboot etc... How do I get an error on SMS00001? Thanks, Dom
asked 2021-02-27T00:31:39.203+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, 92%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Dominique DUCHEMIN
831
Reputation points
accepted 2021-02-28T01:54:07.813+00:00
Dominique DUCHEMIN
831
Reputation points
1 answer
One of the answers was accepted by the question author.
Ad Hoc Distributed Queries
Hi, We are using SQL Server 2017 in our production environment. We got following requirement from our security team. Ensure 'Ad Hoc Distributed Queries' Server Configuration Option is set to '0' Is there any impact for database connection if we…
asked 2021-02-27T09:59:33.367+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, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kazi Ariful Haq
161
Reputation points
accepted 2021-02-27T12:28:51.877+00:00
Kazi Ariful Haq
161
Reputation points
3 answers
SFTP Script task not Working in Azure Integration service
Hi All, I create a ETL package to download data from SFTP server to Azure blob and load that file into a data warehouse. To complete this task i create a C# script task with SSH.net DLL file. when i run this application from my local machine its work…
asked 2021-02-09T03:53:45.743+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(195.2, 37%, 28%)' 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)
Md. Muzahid Sarker
1
Reputation point
answered 2021-02-27T04:41:25.387+00:00
Md. Muzahid Sarker
1
Reputation point
4 answers
One of the answers was accepted by the question author.
DBCC check DB on SQL Server 2016
Currently we are using hallengren for Database integrity (DBCC). EXECUTE [dbo].[DatabaseIntegrityCheck] @Databases = 'USER_DATABASES', @PhysicalOnly = 'Y', @LogToTable = 'Y' Which is working fine with no issue. taking 5 hours in prod envi.…
asked 2021-02-22T23:29:10.363+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(16, 46%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijay Kumar
2,016
Reputation points
accepted 2021-02-27T03:42:37.05+00:00
Vijay Kumar
2,016
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server does not kill queries that Dynamics NAV does
Hello, I have the following scenario, I have Dynamics NAV 2017 working in a Virtual Machine in Azure, everything is fine until a search is made for a record in Dynamics NAV, the SQL service increases the use of RAM memory up to 96% and the search on…
asked 2021-02-26T20:27:10.04+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(169.60000000000002, 42%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHF%3C/text%3E%3C/svg%3E)
Hugo Fernando Miranda Morin
26
Reputation points
commented 2021-02-27T00:31:28.94+00:00
Hugo Fernando Miranda Morin
26
Reputation points
1 answer
SSRS Subscription privileges
I have created a lot of subscriptions (as administrator). Then i used powershell scripts to modify the owner of these subscriptions. None of the new owners are administrators. If a new owner wants to change anything in their subscription, they…
asked 2020-11-12T07:29:47.417+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(182.40000000000003, 57.99999999999999%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVJ%3C/text%3E%3C/svg%3E)
Volkmar Jaeger
21
Reputation points
commented 2021-02-26T20:50:56.677+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(19.2, 5%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lovejoy, Ashley
1
Reputation point