Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [protocol]

13 questions
7
votes
2 answers

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 that are not conflict serializable but are…
Vimal Patel
  • 173
  • 3
2
votes
1 answer

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 when I noticed that the SQL named instance port…
Dominique Boucher
  • 3,287
  • 11
  • 27
2
votes
2 answers

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 releases of the PostgreSQL documentation However, I…
Eyal leshem
  • 145
  • 5
1
vote
0 answers

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 ManagedComputer and ServerInstance parameters, the script…
Nizami Khalilbayli
  • 131
  • 2
  • 16
1
vote
1 answer

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. I found this article that says NetBIOS should be…
DrewCranmer
  • 75
  • 1
  • 2
  • 7
1
vote
2 answers

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/IP protocol) intercontinental (from China to…
T. Andreea
  • 13
  • 1
  • 3
1
vote
1 answer

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.com/watch?v=4lvkbwsspZc Hope someone can point me…
Just a learner
  • 2,082
  • 7
  • 36
  • 57
0
votes
0 answers

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 in the Transactions schema to tables in the…
Jim
  • 123
  • 5
0
votes
1 answer

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 databases hosted on this server. Does SSMS reveal the…
BaltoStar
  • 99
  • 4
0
votes
0 answers

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 PostgreSQL DBMS - I presume that I would be required…
ultimate cause
  • 101
  • 1
0
votes
2 answers

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.
Fariman Kashani
  • 139
  • 1
  • 10
0
votes
0 answers

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 sysdba or with username and password , it always…
Aegon
  • 1
  • 2
  • 4
0
votes
1 answer

Cannot connect to SQL server through SSMS from other machine after IP change

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 1433 and all the network protocols are open named…
SQL_NoExpert
  • 1,107
  • 1
  • 21
  • 37