verified that we cannot connect to the edw server over VPN. Tried troubleshooting for a while then headed in
30m drive etc
Sent reply to Merle saying we are unable to connect via VPN to EDW and asked for the instance's port number. He replied with 1433 which is the single instance port and not logical
worked on learning more SSIS
attended Unahandled brainstorming meeting.
resumed SSIS
Mic asked me if I'd tried 1433 and I'd not. Tried from LAN and failed. Replied to Merle that it didn't work. Realized that with Merle had left so I tried port scanning and using sqlcmd. Showed me that port is 3600 and verified on LAN that it's correct. Disconnected and went to Centura's free WiFi and connected over VPN. Worked.
did a little more SSIS learning while walking Mic through setting up the alias and connecting. For some bizarre reason, his computer cannot use the server name. Had to use hard IP addr
1830 heading home
net 9
No comments:
Post a Comment