Viewing 15 posts - 1 through 15 (of 321 total)
I tend to configure a SQL Login on Server B (rather than Windows Login). The Linked Server on Server A is configured with this SQL Login (simple username and password)...
October 26, 2022 at 7:09 am
Suggest you try a different configuration in your Linked Server Properties: link both of your "Local Login" names to the same "Remote User", with the same "Remote Password" configured for...
October 25, 2022 at 7:44 am
As far as I know: you can host the two Reporting Services databases on SQL MI; but as you say, this doesn't get you the Reporting Services themselves!
SSRS needs to...
September 6, 2022 at 4:11 pm
We have a tag for "environment" which we use to specify the workload; typically "prod", "dev" or "test". These tags are then used to apply varying policies, backup retention, LAW,...
July 1, 2022 at 2:24 pm
Could also be picky and say that 52.6 rounds to 53 minutes, not 52 minutes (and still not taking into account the variance for leap years; I think it is...
February 15, 2022 at 4:33 pm
When I first saw the question, I would have put good money on a selection of SQL-based solutions!
I slapped this one together, but I'm sure there are better ways of...
February 14, 2022 at 3:19 pm
If a User has the EXECUTE permissions on a SP, they are automagically granted the rights to perform whatever the SP can do.
The User, when creating the SP, requires the...
January 17, 2022 at 5:24 pm
Can you describe where these connections are initated from?
What do you see when you run: select * from sys.dm_exec_connections
What protocols are enabled for the Instance? And how are they configured?
August 9, 2021 at 12:48 pm
The installation binaries are identical; the only difference (might be) the licence file embedded in the ISO image.
I think the licence file is: \x64\DefaultSetup.ini
Depending upon your Microsoft agreement, and whether...
July 12, 2021 at 4:10 pm
Not sure I understand the architecture here. You say your datasource is a DB in Azure; is that Azure SQL Database, MI or a VM running MSSQL?
Looking at the connection...
July 12, 2021 at 10:48 am
As a follow-up:
The "servername\instance" format relies on the Browser service; it will only work correctly if your local machine can reach the remote Browser service.
The SQL Server Browser service listens...
July 12, 2021 at 10:16 am
Where is the table being created? In the Subscriber database? Does the table also exist in the Publisher database? (and does it get replicated?).
Have you dug into what is happening...
June 11, 2021 at 11:32 am
Unfortunately, Replication is an unloved area of MSSQL. Microsoft hasn't made any changes for years. On the plus side, it still works and is reliable.
I don't quite understand your scenario,...
June 11, 2021 at 7:06 am
As Andreas said, the CU and GDR updates are different and cannot be mixed.
Previously, you could change between CU and GDR after installing a new SP; but with SPs now...
March 1, 2021 at 10:19 am
If I come across this license expiry in the future, and find a solution/workaround, I'll try to remember to post here.
January 13, 2021 at 6:56 am