最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

SQL Server 2022 Error 233 , 0 after Oracle dblink provider - Stack Overflow

programmeradmin4浏览0评论

I'm getting this error:

Cannot connect to DATABASE

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Framework Microsoft SqlClient Data Provider)

Server Name: DATABASE
Error Number: 233
Severity: 20
State: 0

etc....

I installed the oracle 19c client to configure a dblink and then added the Oracle OLE DB provider for the dblink.

I tried to configure it, and trying to create one, SQL Server Management Studio crashed, I had to close it with task manager.

After that, trying to log in again, I received this error.

It seems there are active sessions, but it does not load the object tree on the left, there is the waiting wheel that spins.

I see multiple sessions of 'sa' (my administrator user) with high waits.

What could it be?

Thanks

发布评论

评论列表(0)

  1. 暂无评论