Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

remoted linked server problem

Status
Not open for further replies.
supernova122

supernova122

MIS
Jun 9, 1999
45
HK
I am running SQL 2005 trigger and update the table in remote linked server. This is working perfectly when the firewall is off. However when I turn on the firewall, it won’t run any more. I need the firewall on for the security issue. How can I run this trigger with firewall on? Thanks.
 
Sort by date Sort by votes
you change your firewall settings for this.

i guess you had better apporach firewall forums...

Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
429
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
782
Volvere
V
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
1K
gmmastros
gmmastros
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
273
pjw001
pjw001
EM1107
  • Locked
  • Question
Copy folder and content using SQL Server TSQL.
Replies
6
Views
561
RobertPhillips
RobertPhillips

Part and Inventory Search

Sponsor

Back
Top