René's URL Explorer Experiment


Title: Intermittent or no connection established to SQL Server · Issue #11804 · PowerShell/PowerShell · GitHub

Open Graph Title: Intermittent or no connection established to SQL Server · Issue #11804 · PowerShell/PowerShell

X Title: Intermittent or no connection established to SQL Server · Issue #11804 · PowerShell/PowerShell

Description: #Steps to reproduce Create a connection to a SQL Server and run a command from the SQLserver module $connectionString = "Server=,14481;database=hoclusters;Integrated Security=True;Persist Security Info=True;User ID=$user;Pass...

Open Graph Description: #Steps to reproduce Create a connection to a SQL Server and run a command from the SQLserver module $connectionString = "Server=,14481;database=hoclusters;Integrated Security=True;Persi...

X Description: #Steps to reproduce Create a connection to a SQL Server and run a command from the SQLserver module $connectionString = "Server=<servername>,14481;database=hoclusters;Integrated Security...

Opengraph URL: https://github.com/PowerShell/PowerShell/issues/11804

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Intermittent or no connection established to SQL Server","articleBody":"#Steps to reproduce\r\n\r\n```powershell 7 \r\nCreate a connection to a SQL Server and run a command from the SQLserver module\r\n$connectionString = \"Server=\u003cservername>,14481;database=hoclusters;Integrated Security=True;Persist Security Info=True;User ID=$user;Password=$pwd\"\r\n$sqlConnection = New-Object System.Data.SqlClient.SqlConnection $connectionString\r\n$SqlCmd = New-Object System.Data.SqlClient.SqlCommand\r\n$SqlCmd.Connection = $SqlConnection\r\n$SqlCmd.CommandTimeout = 0\r\n\r\ninvoke-sqlcmd -serverinstance '\u003cservername>,14481' -database 'master' -query \"select @@servername\" -QueryTimeout 60\r\n\r\n\r\n```\r\n\r\n# Expected behavior\r\n\r\n```\r\ninvoke-sqlcmd command to return server name after successful connection\r\n\r\n```\r\n\r\n# Actual behavior\r\n\r\n```\r\nA connection is established but the pre-login handshake times out\r\n```\r\n\r\n# Environment data\r\n\r\n\u003c!-- Name                           Value\r\n----                           -----\r\nPSVersion                      7.0.0-rc.2\r\nPSEdition                      Core\r\nGitCommitId                    7.0.0-rc.2\r\nOS                             Microsoft Windows 10.0.17763\r\nPlatform                       Win32NT\r\nPSCompatibleVersions           {1.0, 2.0, 3.0, 4.0…}\r\nPSRemotingProtocolVersion      2.3\r\nSerializationVersion           1.1.0.1\r\nWSManStackVersion              3.0\r\n\r\n PS /> $PSVersionTable\r\n\r\nName                           Value\r\n----                           -----\r\nPSVersion                      7.0.0-rc.2\r\nPSEdition                      Core\r\nGitCommitId                    7.0.0-rc.2\r\nOS                             Linux 3.10.0-1062.9.1.el7.x86_64 #1 SMP Fri Dec 6 15:49:49 UTC 2019\r\nPlatform                       Unix\r\nPSCompatibleVersions           {1.0, 2.0, 3.0, 4.0…}\r\nPSRemotingProtocolVersion      2.3\r\nSerializationVersion           1.1.0.1\r\nWSManStackVersion              3.0-->\r\n\r\n```\r\nException             : \r\n    Type           : Microsoft.SqlServer.Management.Common.ConnectionFailureException\r\n    TargetSite     : \r\n        Name          : Connect\r\n        DeclaringType : Microsoft.SqlServer.Management.Common.ConnectionManager\r\n        MemberType    : Method\r\n        Module        : Microsoft.SqlServer.ConnectionInfo.dll\r\n    StackTrace     : \r\n   at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()\r\n   at Microsoft.SqlServer.Management.PowerShell.SmoCmdlet.ConnectToServer(String instance, PSCredential cred, Nullable`1 timeout)\r\n   at Microsoft.SqlServer.Management.PowerShell.SmoContextSensitiveTargetedWithServerInstanceCmdlet`1.ResolveTargets()+MoveNext()\r\n    Message        : Failed to connect to server \u003cservername>,14481.\r\n    InnerException : \r\n        Type               : System.Data.SqlClient.SqlException\r\n        Errors             : \r\n            Source  : Core .Net SqlClient Data Provider\r\n            Number  : 258\r\n            Class   : 20\r\n            Server  : \u003cservername>,14481\r\n            Message : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error:\r\n0 - The wait operation timed out.)\r\n        ClientConnectionId : d95f684b-ab07-4bb7-9f0f-cfa4c9517b1e\r\n        Class              : 20\r\n        Number             : 258\r\n        Server             : \u003cservername>,14481\r\n        Source             : Core .Net SqlClient Data Provider\r\n        ErrorCode          : -2146232060\r\n        TargetSite         : Void .ctor(System.Data.ProviderBase.DbConnectionPoolIdentity, System.Data.SqlClient.SqlConnectionString, System.Data.SqlClient.SqlCredential,\r\nSystem.Object, System.String, System.Security.SecureString, Boolean, System.Data.SqlClient.SqlConnectionString, System.Data.SqlClient.SessionData, Boolean, System.String)\r\n        StackTrace         : \r\n   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object\r\nproviderInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData\r\nreconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)\r\n   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool\r\npool, DbConnection owningConnection, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options,\r\nDbConnectionPoolKey poolKey, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean\r\nonlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions,\r\nDbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions,\r\nDbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1\r\nretry, DbConnectionOptions userOptions)\r\n   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry,\r\nDbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect()\r\n   at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()\r\n        Message            : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider,\r\nerror: 0 - The wait operation timed out.)\r\n        Data               : System.Collections.ListDictionaryInternal\r\n        InnerException     : \r\n            Type            : System.ComponentModel.Win32Exception\r\n            NativeErrorCode : 258\r\n            ErrorCode       : -2147467259\r\n            Message         : The wait operation timed out.\r\n            HResult         : -2147467259\r\n        HResult            : -2146232060\r\n    Source         : Microsoft.SqlServer.ConnectionInfo\r\n    HResult        : -2146233087\r\nTargetObject          : \u003cservername>,14481\r\nCategoryInfo          : ObjectNotFound: (\u003cservername>,14481:String) [Read-SqlTableData], ConnectionFailureException\r\nFullyQualifiedErrorId : ConnectionToServerFailed,Microsoft.SqlServer.Management.PowerShell.ReadSqlTableData\r\nInvocationInfo        : \r\n    MyCommand        : Read-SqlTableData\r\n    ScriptLineNumber : 1\r\n    OffsetInLine     : 1\r\n    HistoryId        : 11\r\n    Line             : Read-SqlTableData -ServerInstance '\u003cservername>,14481' -DatabaseName ho_cpu_wait -SchemaName \"dbo\" -TableName \"table1\"\r\n    PositionMessage  : At line:1 char:1\r\n                       + Read-SqlTableData -ServerInstance '\u003cservername>. …\r\n                       + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\n    InvocationName   : Read-SqlTableData\r\n    CommandOrigin    : Internal\r\nScriptStackTrace      : at \u003cScriptBlock>, \u003cNo file>: line 1\r\nPipelineIterationInfo : \r\n\r\n```\r\n","author":{"url":"https://github.com/Spectre-007","@type":"Person","name":"Spectre-007"},"datePublished":"2020-02-07T14:02:15Z","url":"https://github.com/PowerShell/PowerShell/issues/11804"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:6389b43d-8e07-9d7a-0fee-65f7eda89253
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-id8DD2:15BFB5:D622D:122BF1:6AFD4B49
html-safe-nonced43630dba780f6e8ce4a6e3167ebe82e9590f1d8a5115a933ae8f5e3568c0116
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4REQyOjE1QkZCNTpENjIyRDoxMjJCRjE6NkFGRDRCNDkiLCJ2aXNpdG9yX2lkIjoiNTE0MTU1NjgyMjcyNDY2MDA0MiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac02939a8ef5475a3764b9010017a8ed07b3e70b1706741474f5ea58048a0a86b4
hovercard-subject-tagissue:561655280
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/PowerShell/PowerShell/11804/issue_layout
twitter:imagehttps://opengraph.githubassets.com/f385f36a7e28ccf0a89c4aa3b70b638db04a801bf38bae7fae9e9e48a6e8b418/PowerShell/PowerShell/issues/11804
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/f385f36a7e28ccf0a89c4aa3b70b638db04a801bf38bae7fae9e9e48a6e8b418/PowerShell/PowerShell/issues/11804
og:image:alt#Steps to reproduce Create a connection to a SQL Server and run a command from the SQLserver module $connectionString = "Server=,14481;database=hoclusters;Integrated Security=True;Persi...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameSpectre-007
hostnamegithub.com
expected-hostnamegithub.com
None66653c2e55a6fff2930be1bdf07ee4f8aa137e3956d056c822563be6f878755e
turbo-cache-controlno-preview
go-importgithub.com/PowerShell/PowerShell git https://github.com/PowerShell/PowerShell.git
octolytics-dimension-user_id11524380
octolytics-dimension-user_loginPowerShell
octolytics-dimension-repository_id49609581
octolytics-dimension-repository_nwoPowerShell/PowerShell
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id49609581
octolytics-dimension-repository_network_root_nwoPowerShell/PowerShell
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releaseb6f01f7cb9f35f8c09949773241a3d49dd04b340
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/PowerShell/PowerShell/issues/11804#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FPowerShell%2FPowerShell%2Fissues%2F11804
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FPowerShell%2FPowerShell%2Fissues%2F11804
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=PowerShell%2FPowerShell
Reloadhttps://github.com/PowerShell/PowerShell/issues/11804
Reloadhttps://github.com/PowerShell/PowerShell/issues/11804
Reloadhttps://github.com/PowerShell/PowerShell/issues/11804
PowerShellhttps://github.com/PowerShell
PowerShellhttps://github.com/PowerShell/PowerShell
Codehttps://github.com/PowerShell/PowerShell
Issues1.3k (1.3k)https://github.com/PowerShell/PowerShell/issues
Pull requests365 (365)https://github.com/PowerShell/PowerShell/pulls
Discussionshttps://github.com/PowerShell/PowerShell/discussions
Actionshttps://github.com/PowerShell/PowerShell/actions
Projectshttps://github.com/PowerShell/PowerShell/projects
Security and quality3 (3)https://github.com/PowerShell/PowerShell/security
Insightshttps://github.com/PowerShell/PowerShell/insights
https://github.com/PowerShell/PowerShell
New issuehttps://github.com/login?return_to=https://github.com/PowerShell/PowerShell/issues/11804
New issuehttps://github.com/login?return_to=https://github.com/PowerShell/PowerShell/issues/11804
Intermittent or no connection established to SQL Serverhttps://github.com/PowerShell/PowerShell/issues/11804#top
Issue-Questionideally support can be provided via other mechanisms, but sometimes folks do open an issue to get ahttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Issue-Question%22
Resolution-AnsweredThe question is answered.https://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-Answered%22
https://github.com/Spectre-007
Spectre-007https://github.com/Spectre-007
on Feb 7, 2020https://github.com/PowerShell/PowerShell/issues/11804#issue-561655280
Spectre-007https://github.com/Spectre-007
Issue-Questionideally support can be provided via other mechanisms, but sometimes folks do open an issue to get ahttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Issue-Question%22
on Feb 7, 2020https://github.com/PowerShell/PowerShell/issues/11804#event-3017749806
https://github.com/Spectre-007
Spectre-007https://github.com/Spectre-007
on Feb 17, 2020https://github.com/PowerShell/PowerShell/issues/11804#issuecomment-587092551
https://github.com/mklement0
Michael Klement (mklement0)https://github.com/mklement0
on Feb 18, 2020https://github.com/PowerShell/PowerShell/issues/11804#issuecomment-587263124
https://github.com/PowerShell/PowerShell/blob/master/.github/SUPPORT.mdhttps://github.com/PowerShell/PowerShell/blob/master/.github/SUPPORT.md
has been pointed out beforehttps://github.com/PowerShell/PowerShell/pull/11153#issuecomment-557585631
Steve Lee (@SteveL-MSFT)https://github.com/SteveL-MSFT
existing issueshttps://github.com/PowerShell/PowerShell/issues
latest released or preview versionhttps://github.com/PowerShell/PowerShell/releases
create a new bug-report issuehttps://github.com/PowerShell/PowerShell/issues/new?assignees=&labels=Issue-Question&template=Bug_Report.md
Slackhttps://join.slack.com/t/powershell/shared_invite/enQtMzA3MDcxNTM5MTkxLTBmMWIyNzhkYzVjNGRiOTgxZmFlN2E0ZmVmOWU5NDczNTY2NDFhZjFlZTM1MTZiMWIzZDcwMGYzNjQ3YTRkNWM
Discordhttps://discordapp.com/invite/AtzXnJM
StackOverflow.comhttps://stackoverflow.com/questions/tagged/powershell
PowerShell.org Forumhttps://powershell.org/forums/
official support lifecycle and policyhttps://docs.microsoft.com/en-us/powershell/scripting/powershell-support-lifecycle
https://repository-images.githubusercontent.com/49609581/96590180-07d7-11ea-89b1-2f719dc4bb9c
https://camo.githubusercontent.com/367743aeb3919fb6453d8d3b9052f46876bfbe1f90944156efcb74377ed6a6f8/68747470733a2f2f6769746875622e6769746875626173736574732e636f6d2f66617669636f6e2e69636f
PowerShell/PowerShellhttps://github.com/PowerShell/PowerShell
Ilya (iSazonov)https://github.com/iSazonov
Resolution-AnsweredThe question is answered.https://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-Answered%22
on May 8, 2020https://github.com/PowerShell/PowerShell/issues/11804#event-3316335412
completedhttps://github.com/PowerShell/PowerShell/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on May 9, 2020https://github.com/PowerShell/PowerShell/issues/11804#event-3319322259
Sign up for freehttps://github.com/signup?return_to=https://github.com/PowerShell/PowerShell/issues/11804
Sign in to commenthttps://github.com/login?return_to=https://github.com/PowerShell/PowerShell/issues/11804
Issue-Questionideally support can be provided via other mechanisms, but sometimes folks do open an issue to get ahttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Issue-Question%22
Resolution-AnsweredThe question is answered.https://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-Answered%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.