Questions tagged with Microsoft SQL Server
Content language: English
Sort by most recent
We have SSIS running in a RDS instances.
One of the DB Connection Manger in the SSIS workflow is to an Actian PSQL database.
For the connection manager to work we need the PSQL-AdoNetDataProvider4.3 to be installed on the RDS server.
https://esd.actian.com/product/Zen_PSQL/SDKs/ADO.NET/ADO.NET
Is this supported? If so how can i accomplish it?
Good day, I have an EC2 instance that was launched using Ubuntu 20 with SQL Server Standard. It was supposed to be launched as Ubuntu 20 WITHOUT SQL. We reached out to AWS support and resolved this by uninstalling the SQL Server software and created a snapshot, which we used to launch an instance without the license attached to it. Now, we have launched another instance from a new snapshot from the new instance and the new instance comes up with the SQL Server Standard license and we have been billed for this license. Please help!
we tried using the SSMS console to add linked servers but the admin user does not have Sys admin access to add linked servers. so we tried using the sp_addlinkedserver from this article:
https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/
https://aws.amazon.com/premiumsupport/knowledge-center/rds-sql-server-create-linked-server/
but have still been unsuccessful. our linked servers are ODBCs and can connect in localhost easily
Please help
I have used the Glue Job editor to create a simple job that has a SQL Server DB as a source, does a filter by a column (SQL Query) and outputs it into an S3 bucket so I can use Athena to query. It works perfectly.
Now I wanted the same job to do the same with a number of other tables, so I edited the code just duplicating the block that starts at the "job = Job(glueContext)" line but no matter how I do it, the two tables are created and loaded weirdly, e.g. there should be 3 records on one and 2 on the other, they both end up with like 20 records each, with blank values for most of the rows.
What am I doing wrong? How else can I achieve this purpose? I thought of having crawlers for getting the schema and adding it into the data catalog first, but I create one simple crawler and it just spins and spins and fails with "Internal Service Exception". Not sure how else I can achieve this. Thanks for any insights.
In the Support Docs i see that "Import Column and Export Column transformations and the Script component on the Data Flow Task aren't supported."
Also can see a list of the Control Flow tasks tasks that are supported.
But wasn't clear about the "Web Service Task".
Does the RDS integration with SSIS support it?
Hi Friends,
I'm considering moving from RDS SQL Server databases DB.m4 to DB.m5, but I do not have a clear idea of what to expect when I push the button.
Could you please advise me on what to expect If I remain in DB.m4 machines?
What am I missing?
Thank you,
Best Regards,
I am using aws sagemaker notebook instance to run jupyter notebook. I have a` MS SQL Server DB 2019` db that I am trying to connect to from the notebook. Notebook instance is running on Amazon Linux 2, Jupyter Lab 1 platform.
import pandas as pd
import numpy as np
from datetime import datetime
import json
import os
# sql database
import pyodbc
connection = pyodbc.connect(
'Driver={SQL Server};'
'Server=sname;'
'Database=dbname;'
'Trusted_Connection=True;'
)
cursor = connection.cursor()
I get an error, likely because the driver is not installed on the instance.
Error Traceback (most recent call last)
/tmp/ipykernel_20407/3026941781.py in <cell line: 12>()
10 # sql database
11 import pyodbc
---> 12 connection = pyodbc.connect(
13 'Driver={SQL Server};'
14 'Server=sname;'
Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found (0) (SQLDriverConnect)")
how do I install the driver on sagemaker instance and resolve this issue?
Hello, I have some 2008 and 2012 MS SQL Servers running on windows server in my on-premises. I want to migrate those to AWS. Looking for suggestions on what's the right migration path.
1. Should I first make an in-place upgrade of those SQL servers on-premise, then move to RDS?
2. Should I migrate those as-is using back and restore to EC2, then use AWS SSM playbook to upgrade to 2019?
3. Is there an option using AWS DMS or backup and restore to directly upgrade to 2019 on RDS?
I'm ok to move those servers to either license included EC2 or to RDS with MS SQL.
Thank you.
Hi All,
We are planning to create RDS custom database, we have one question regarding RDS custom Public and Private access.
Question:- can we switch/Change RDS Custom database Public and Private access types after creating RDS custom database.
e.g:- RDS custom Database we have created as Public and after few days if we need it as private then how to achieve this.
Currently unable to find that option in RDS custom console modify.
We have our Sites built on Lucee & hosted on EC2 with database on SQL using AWS RDS in Africa(Cape Town) Region. A replica of them are hosted in Europe(Ireland) Region. The sites in Africa region have really become slow but sites in Europe are working fine. We tried copying the sites from Africa to Europe & they work fine when moved to Europe, but our clients have specific rules on the servers that they need to be in Africa.
We are unable to resolve the issue & AWS support is just trying stick a support plan to us for which the price is again outrageous.
Can you guys please help, we have already evaluated the burst credits, memory utilisation, cpu utilisation, IOPS, Storage & almost all support articles out there regarding the same topic. Please help.
My snapshot restore is hung and not progressing.
asked 5 months ago
I would like to launch an EC2 instance (t3a.medium) on Windows Operating System with SQL Server Web. However, the options available were only with SQL Server Standard and Enterprise Edition. I have searched the marketplace but the packages available there does not come with t3a.medium. How can I solve this?