Sue_H

Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 4,477 total)

RE: Report Builder connection issue

It could just be the URL you are referencing for the Report Server. Try using:
http://<servername>/reportserver
You need to point to the report server, not...

July 27, 2017 at 9:23 am

#1953055
RE: SQL Server Agent Jobs Statistics

francesco.mantovani - Wednesday, July 26, 2017 5:47 PM
Yes, you were right, I was in a Master but then run the same...

July 26, 2017 at 6:01 pm

#1952937
RE: SQL Server Agent Jobs Statistics

francesco.mantovani - Wednesday, July 26, 2017 4:43 PM
The script is not working on SSMS 2016
It looks like you are...

July 26, 2017 at 5:40 pm

#1952933
RE: Download ssdt in English if your machine isn't

Arthur Kirchner - Tuesday, July 25, 2017 11:53 AM
Dear all,
That is an annoying problem I have with ssdt and (just today) ssms....

July 26, 2017 at 5:06 pm

#1952929
RE: "Network-related or Instance specific error" when connecting through SSMS

newdba2017 - Wednesday, July 26, 2017 2:55 PM
I know it has something to do with firewall because I just disabled the firewall...

July 26, 2017 at 3:10 pm

#1952919
RE: "Network-related or Instance specific error" when connecting through SSMS

bmg002 - Wednesday, July 26, 2017 3:02 PM
OH, my bad. But, yay, progress!
SQL browser service (I believe) uses port 1434. Do you...

July 26, 2017 at 3:06 pm

#1952918
RE: "Network-related or Instance specific error" when connecting through SSMS

bmg002 - Wednesday, July 26, 2017 2:42 PM
Since you can connect when you specify the port, I am thinking this isn't a...

July 26, 2017 at 3:02 pm

#1952915
RE: "Network-related or Instance specific error" when connecting through SSMS

I would use PortQry. If you don't have it, it's just a free download from Microsoft that you can use from your PC to scan what ports...

July 26, 2017 at 2:19 pm

#1952908
RE: Linked Server error: OLE DB provider "SQLNCLI10" for linked server "wellcom_linked_server" returned message "The transaction manager has disabled its support for remote/network transactions.

With it being sporadic, you would think it's not a DTC configuration error as that would normally cause consistent failures.
Did you check to see if the...

July 26, 2017 at 2:01 pm

#1952906
RE: "Network-related or Instance specific error" when connecting through SSMS

You probably need to recheck the ports as Perry mentioned. I don't use Windows firewall but I don't think that would open up the port for the...

July 26, 2017 at 1:45 pm

#1952900
RE: Replication : can we list out transactions group by articles?

muth_51 - Wednesday, July 26, 2017 11:17 AM
We are having issues with replication latency in our environment. I figured out it's from...

July 26, 2017 at 1:30 pm

#1952896
RE: restore point

Point in time is similar but not the same as you are doing a series of restores. What you do depends on why you were using guaranteed...

July 26, 2017 at 11:32 am

#1952862
RE: "Network-related or Instance specific error" when connecting through SSMS

Is the browser service is running on the Server?
Sue

July 26, 2017 at 10:24 am

#1952840
RE: List of all dtsx files used in [Integration Services Catalog] - I need help with the SELECT statement

mw112009 - Wednesday, July 26, 2017 7:12 AM
Which powershell should I pick, I picked #1 and tried to...

July 26, 2017 at 7:26 am

#1952762
RE: restore point

Perry Whittle - Wednesday, July 26, 2017 6:25 AM
sounds equivalent to backup marks, read more on them at this link

July 26, 2017 at 7:17 am

#1952756

Viewing 15 posts - 3,286 through 3,300 (of 4,477 total)