Questions tagged [protocol]
The protocol tag has no summary.
13 questions
0 votes
0 answers
61 views
Does MySQL perform 2PC automatically for internal (mysql only) transactions?
If I have done functional partitioning in my database and have for example a database Transactions and a database Products and these are different database servers and there are references from tables ...
- 123
0 votes
1 answer
246 views
Connection string for a successful SSMS connection
In SSMS v19 I can successfully connect/login to a SQL server that is listening on the default port 1433 Server : server.env.domain.com,1433 Authentication : SQL Auth And I can query any of the ...
- 99
0 votes
0 answers
129 views
Converting Wire Protocol from Oracle to Postgres and Vice-Versa
Naive Question Assume we have an Application which was originally written for ORACLE as DBMS. If I want write an intermediary layer that gives this application independence to be able to work with ...
- 101
2 votes
1 answer
1k views
Connecting to a remote SQL named instance with named pipe
I found out that when I connect to a remote SQL named instance (ServerA\instanceA) from SSMS installed on ServerB, it does connect without error, but it uses the Named Pipe protocol. I found that out ...
- 3,287
1 vote
0 answers
548 views
Enable Shared Memory Protocol (SQL Server PowerShell)
I`m trying to modify and use powershell script from learn.microsoft.com in order to enable SQL Shared Memory protocol on a remote server. But my issue is instead of connecting to provided ...
1 vote
1 answer
2k views
Does SQL Server require NetBIOS for Named Pipes?
I'm not all that familiar with networking or protocols and couldn't find a similar question here or elsewhere. One of my security people is asking whether SQL Server requires NetBIOS for Named Pipes. ...
- 75
0 votes
2 answers
115 views
MySQL Transport Protocol Used
How can I find out which Transport Protocol MySQL is using? I know how I can change it but I don't know how to show the current one.
- 139
2 votes
2 answers
136 views
Where is the documentation for version 1.0 of PostgreSQL wire protocol
The current documentation refers only to version 3 of the wire protocol. However, there is the following note in the documentation: For descriptions of the earlier protocol versions, see previous ...
- 145
0 votes
0 answers
980 views
ORA-12560: TNS:protocol adapter error in Windows 10
Listener and service are up and running. In SQL Plus, if I connect with no login, and execute 'conn sys/pwd@host:port/sid as sysdba', connection is established successfully. But if I connect / as ...
- 1
7 votes
2 answers
587 views
Does timestamp protocol following thomas's write rule allow non-view-serializable schedules in some cases?
I have come across the following line in a text book (Database System Concepts Textbook by Avi Silberschatz, Henry F. Korth, and S. Sudarshan $6e$) page no. 686: Thomas’ write rule allows schedules ...
- 173
0 votes
1 answer
3k views
Cannot connect to SQL server through SSMS from other machine after IP change [closed]
There was an ip change on the sql server and after that I cannot connect from other machines ssms but can connect locally . The firewall is disabled on the server and moreover its listening on port ...
- 1,117
1 vote
2 answers
3k views
Is there any SQL Database that will use UDP replication?
I have to find a database that will ensure the UDP replication intercontinental. Do you know if there is any SQL database that will support UDP replication? If not, can I use MySQL replication (TCP/...
- 13
1 vote
1 answer
3k views
Why can I use named pipes to connect to SQL Server even if it's been disabled?
Why can I still use named pipes to connect to SQL Server even if it's been disabled? I'm on SQL Server 2016 doing the testing. I have recorded my operation in this youtube video: https://www.youtube....
- 2,126