Comments (2)
SQL Browser service should help you connect to the right instance even if non-default port is used.
SQLDiag.exe cannot read a connection string of the type "tcp:123.234.56.78,1455" and thus you cannot specify this as machine name in PSSDIAG. You would get an error similar to the following indicating that the machine is not local but somewhere "on the network" but is invalid:
2022/04/20 16:50:57.68 SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
2022/04/20 16:50:57.68 SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
2022/04/20 16:50:57.69 SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
2022/04/20 16:50:57.69 SQLDIAG There are no instances of version 15 on this computer
2022/04/20 16:50:57.69 SQLDIAG . Function result: 87. Message: The parameter is incorrect.
However, SQLDiag.exe does accept a separate parameter /T where you can specify /T tcp,port . Therefore as a workaround you can invoke SQLDiag.exe yourself using this switch and the rest of the switches.
from diagmanager.
We can consider adding the /T switch to pssdiag.ps1 PowerShell file to accommodate this ask
from diagmanager.
Related Issues (20)
- PSSDIAG custom service with /A is not unregistering successfully when using pssdiag.ps1 -A "app" -U.
- Cannot start a custom-named pssdiag service using the /A parameter
- Revise and clean-up SQLBaseUtil.ps1 and all SQLBase custom diagnostics HOT 1
- Add Filtered Drivers Collection to the Diag Manager
- Ensure PSSDIAG collects a cluster log (test if there and if not enable)
- Modify MultiCopy.cmd into a Powershell file
- If you check an individual task/item in a CustomDiagnostics group the file is not copied into .zip folder
- Collect the cluster setting with respect to AlwaysOn
- Minor fix - Add application name or hostname in connection string in PlanGeneratingNeverEndingQuery.ps1 to identify the connections
- Provide an Informational Dialog to alert users about using the modern toolset in SQL LogScout
- Enhancement to perfstats snapshot script for db scoped configuration is_default_value column
- WaitForExe.cmd placed in quarantine HOT 7
- Clean up or remove some unused .BAT or .CMD files in the Diagmanager project
- Ensure that the memory grant diagnostic queries do not use query execution memory themselves or will they get stuck waiting for grants HOT 1
- Remove SQL processor utilization query against sys.dm_os_ring_buffers
- Refactor: Switch serialization classes for optimization and security in ObjectCopier.Clone<T>()
- Prefix the output folder name with the name of the tool gathering the output
- Re-write PowerPlan.vbs and rtrim.vbs into PowerShell scripts
- Refactor: Update some XML related API calls based to newer and safer methods HOT 1
- SQLDIAG Error opening HKLM key . Function result: 5. Message: Access is denied.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from diagmanager.