Questions tagged [protocol]
The protocol tag has no usage guidance.
11
questions
7
votes
2
answers
473
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
2
votes
2
answers
108
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
1
vote
1
answer
781
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,118
1
vote
1
answer
1k
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
1
vote
1
answer
2k
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,682
1
vote
0
answers
344
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
2
answers
2k
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
0
votes
2
answers
93
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
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,049
0
votes
0
answers
77
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
0
votes
0
answers
886
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 ...
- 11