- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
I've tried this so far. Added port TCP 1433 to the security group in addition to 1434 UDP, and the TCP port associated with my server. When I try to connect via SQL Server Management Studio I get these error messages.
Specified cast is not valid:
(Microsoft.SqlServer.ConnectionInfo)
Reached out to the babelfish-preview email address and got a response back.
Had to connect via first creating a new query window in SSMS and then changing/starting the connection. Also had to specify the database name in the connection information. In the actual query, I had to include my tablename in quotes because I think SSMS was converting it to lowercase and my table name contained an uppercase letter.
Also works with sql-cmd. Which is fine since it replaced osql forever ago. Just had to supply -d parameter with database.
Edited by: codingjoe-hig on Jun 15, 2021 11:26 AM
This applies to the Preview version. Babelfish 1.2.0 or above supports SSMS login out of the box. Simply connect with your user, password and server address. You will need to ensure that you open ports for SQL (1433) and, assuming you are using PostgreSQL, the default PostgreSQL port as well in your security groups.
Which port should I be using?
Babelfish creates an additional port for the TDS protocol, by default, 1433. You can simultaneously connect via the PostgreSQL port (default 5432) with pgAdmin. (You can browse your data live from both ports, using different SQL clients for TDS and PostgreSQL.)
How do I connect using Babelfish?
The easiest way to get started is to use SSMS, which is free to download. When making your Aurora cluster, double check that you select PostgreSQL 13.6 or higher (which includes Babelfish 1.2.0+). Older versions of Babelfish have very limited SSMS support, which require workarounds.
Babelfish is continually improving SSMS support, so choose the latest version of PostgreSQL, which will have the most up-to-date support.
Babelfish documentation can be found here.
Relevanter Inhalt
AWS OFFICIALAktualisiert vor einem Jahr- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor 10 Monaten
You should ideally upgrade to Babelfish 2.1+ (simply deploy Aurora 14.3 or higher) which improves SSMS support. However, if you're on an old version, you need to hit cancel on the default SSMS login and then connect using the "New Query" button (ie, the Query Editor). Blog with screenshots: https://aws.amazon.com/blogs/database/get-started-with-babelfish-for-aurora-postgresql/