Questions tagged with Microsoft SQL Server
Content language: English
Sort by most recent
Hi,
May I please know if I deploy a SQL Server Enterprise Edition on my AWS Account, how may licenses will I need?
***Is the number of license required same as vCPUs of the EC2 instance?***
For eg. If I install SQL Server on a 16 vCPU instance, then will I need 16 SQL Server licenses?
I currently have Enterprise edition SQL Server with Software Assurance installed on my local machine (out side AWS). It has 10 physical cores and 20 logical cores. I'm paying for 10 core license.
***So does that means I can use those 10 licenses for 10 vCPUs?***
I have gone through multiple documentations, so please don't point to any document. Would appreciate if I can get answer in yes or now for above two questions.
Please help. Thank you
I am trying to migrate data from an on prem SQL Server DB to Postgres Aurora using AWS DMS. The data migrates just fine, but for tables that have a boolean column in the primary key, during validation it fails with the following error:
```
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.
```
Upon checking the logs on the Postgres side, I find this:
`ERROR: invalid input syntax for type boolean: "" at character <number>`
`STATEMENT: SELECT cast ("pcode" as varchar(6)) , "other_columns" , "boolean_column" FROM "db"."table" WHERE ((("boolean_column" = ' ' AND "pcode" > 'L7L3V9') AND ("boolean_column" = ' ' AND "pcode" <= 'L8L4E8'))) ORDER BY "boolean_column" ASC , "pcode" ASC
`
During validation, it's fetching the records from the postgres in batches, and for each batch it uses the wrong value for the "bolean_column" (comparing to '' - blank string). I am not sure why it's doing this, or how to influence this behaviour so that the validations will be performed successfully.
The boolean column is a:
- bit field on the SQL Server side
- on postgres side, have tried converting to (both with same validation error as above):
- numeric with precision 1
- boolean
I am running a large pandas merge join operation on a `jupyter` notebook running on `SageMaker` notebook instance `ml.t3.large` i.e `8 gb` of memory.
```
import pandas as pd
df1 = pd.DataFrame({
'ID': [1, 2, 3],
'Name': ['A','B','C'],
....
})
df1.shape
(3000000, 10)
df2 = pd.DataFrame({
'ID': [],
'Name': [],
....
)}
df2.shape
(50000, 12)
# Join data
df_merge = pd.merge(
df1,
df2,
left_on = ['ID','Name'],
right_on = ['ID','Name'],
how = 'left'
)
```
When I run this operation, the kernel dies within a minute or so. How can I optimize this operation for memory efficiency?
We are using SQL Server RDS and looking to implement full-text search. We need to search on a variety of file types but mainly on pdf. My understanding for pdf there is an Adobe iFilter plugin that will allow this. I have accomplished this on-premise before but not RDS. Would I install Adobe iFilter plugin on RDS?
Is it even possible to install this pdf iFilter plugin on RDS?
We are using windows server. On that windows server we have SQL server installed. We are planning to upgrade that to SQL 2022. Now I want to know the feasibility to move databases to S3 bucket. Is it feasible to have mdf and ldf files of the SQL databases on S3 bucket directly and SQL server installed on windows server which is hosted on AWS.
Hi,
I have an old SQL Server Web Edition (14.00.3381.3.v1) in storage-full state. What would be the best way to resolve this situation?
I have tried to follow e.g. guides:
* [How do I resolve problems that occur when Amazon RDS DB instances run out of storage?](https://aws.amazon.com/premiumsupport/knowledge-center/rds-out-of-storage/)
* [How can I troubleshoot storage consumption in my RDS for SQL Server DB instance?](https://aws.amazon.com/premiumsupport/knowledge-center/rds-sql-server-storage-optimization/)
* And a dozen other guides.
I tried to add more storage but it stays in this state
```
"PendingModifiedValues": {
"AllocatedStorage": 200
},
```
I also tried to enable Storage autoscaling many days ago but it hasn't helped either.
From RDS events we can see the following:
```
Storage for tempdb log files is almost full. Shrink the tempdb files, or reboot the DB instance to reset the file size.
The free storage capacity for DB Instance: <name> is low at 0% of the provisioned storage [Provisioned Storage: 39.87 GB, Free Storage: 0 B]. You may want to increase the provisioned storage to address this issue.
```
But the suggested reboot is not an option as it's not allowed when db is in the storage-full state.
Connection to Database works and I have tried to understand and fix the issue, but unfortunately failed. Some information is below:
```
"2023-01-10 00:50:55.420" "spid53" "The transaction log for database 'msdb' is full due to 'LOG_BACKUP'."
"2023-01-10 00:51:01.290" "Backup" "Error: 18210, Severity: 16, State: 1."
"2023-01-10 00:51:01.290" "Backup" "BackupIoRequest::ReportIoError: write failure on backup device 'D:\rdsdbdata\BACKUP\mas***.database_backup'. Operating system error 112(There is not enough space on the disk.)."
"2023-01-10 00:51:01.290" "Backup" "Error: 3041, Severity: 16, State: 1."
"2023-01-10 00:51:01.290" "Backup" "BACKUP failed to complete the command BACKUP DATABASE mas***. Check the backup application log for detailed messages."
"2023-01-10 00:51:55.030" "spid54" "Error: 9002, Severity: 17, State: 2."
```
`DBCC SQLPERF(LOGSPACE);` Returns
|Database Name|Log Size (MB)|Log Space Used (%)|Status|
|---|---|---|---|
|mas***| 0,9921875| 57,0374| 0|
|tempdb| 1,875| 52,57813| 0|
|msdb| 0,9921875| 100| 0|
|rdsadmin| 81,99219| 100,0048| 0|
|users| 4,367188| 16,13372| 0|
Shrinking the files hasn't been working for me with the command `DBCC SHRINKFILE`
Pretty much all the commands against `msdb` and `rdsadmin` databases have failed because of insufficient rights.
Even deleting the database (from the AWS console) fails with a message saying "We're sorry, your request to delete DB instance <name> has failed".
I'm not specialized MSSQL/RDS so any pointers on how to proceed would be highly appreciated!
Thanks!
A customer has a RDS database and Windows Forms client application. He want to create a new client app. What is the best solution?
Client->REST API Lambda ->(Cognito)->RDS
or may be
Client->REST API NET Core service ->(Cognito)->RDS
Is it possible to publish the NET Core web service to AWS or it is better to use Lambda?
I have a Flask Application running locally and there is using `pymysql` to query a `MySQL` DB hosted on AWS RDS. After the application has been idle for a few minutes (>5), I get an error: ` Lost connection to MySQL server during query ([Errno 54] Connection reset by peer)') `
```
File "/Applications/Anaconda/anaconda3/lib/python3.9/site-packages/pymysql/connections.py", line 738, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 54] Connection reset by peer)')
[SQL: SELECT users.id AS users_id, users.fullname AS users_fullname, users.email AS users_email, users.password AS users_password, users.name AS users_name, users.jobtitle AS users_jobtitle, users.country AS users_country, users.emailverified AS users_emailverified, users.created_at AS users_created_at
FROM users
WHERE users.id = %(pk_1)s]
[parameters: {'pk_1': 1}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
```
I tried updating the parameters on AWS RDS - specifically, the `timeout` params, but it didn't work. What else can I try? Is this an issue with the Application code (mysql queries) or with the DB configuration in AWS RDS?
Hi,
We are evaluating to migrate our dot net framework based application using the SQL server as data base to AWS cloud.We are evaluation the RDS for SQL server as possible option for database , however the current application has a of dependency on custom build stored procedure ( keeping a lot of business logic) . Can we use RDS option for SQL server has option to use custom stored procedures and function . Also is there option to migrate the data as well as SP and function to RDS for SQL server.
Unfortunately , I do not have much exp with SQL server and Window based application , hence i am bit clueless .
Any help would be appreciated
I have VPC-1 and VPC-2 in different AWS accounts. Both VPC's have private and public subnets.
VPC-1 has IIS and SQL servers running on the same EC2 Win Server in private subnet. I set up Endpoint Service associated with a Network Load Balancer targeting this EC2 instance.
In VPC-2, I set up Interface Endpoint in public subnet and requested connection acceptance from VPC-1. After request was accepted in VPC-1 Endpoint Service, both endpoints have Available status. However, when I try connecting to SQL Server in SSMS running in VPC-2 public subnet, the connection is timed out.
What I have tried is as follows.
Tested SSMS SQL connection from VPC-1 public subnet using Load Balancer's DNS and it worked fine.
Tried to use both VPC-2 regional and zonal endpoints' DNS in SSMS but to no avail.
Checked out VPC-2 ACL's, they all allow all inbound and outbound traffic.
Checked out VPC-2 public EC2 Win Server security group. It has permitted inbound TCP traffic for Interface Endpoint's IPv4 address in ports 80 and 58090 Please note, the VPC-1 SQL Server is set up on port 58090.
Tested PrivateLink with port 80. In my test, I set up PrivateLink between VPC-1 and VPC-2 through TCP port 80 and added another target to the same VPC-1 Load Balancer for port 80. Then, I RDP'd to EC2 running in VPC-2 public subnet, and opened web page from VPC-1 private subnet's IIS. PrivateLink through port 80 worked fine between VPC-1 and 2.
SQL Server Log Auth failure message:
> 12/20/2022 19:35:27,Logon,Unknown,Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only.
Which does not shore up with the setting of the instance - Mixed Mode is On:
Allow Remote Connections:
I am attempting to authenticate using sql credentials pulled from secretsmanger. The endpoint has the key and secret pointer and all policies check pout. The scenario is:
DMS Endpoint --> Replication Instance(Secrest Manager) --> RDS Sql Server Instance
When I test the connection from the DMS Endpoint above, I get the following message:
> Test Endpoint failed: Application-Status: 1020912, Application-Message: Cannot connect to SQL Server Authentication failed, Application-Detailed-Message: RetCode: SQL_ERROR SqlState: 28000 NativeError: 18456 Message: [unixODBC][Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user ''.
However, I can use the same sql login from my laptop via ZScaler and log into the rds instance.
I am sure everything is connected, and I rebooted that RDS instance and double-checked settings. There is a Postgres RDS instance with the exact same configuration and the connection test from the DMS Endpoint returns success.
It is just odd that SQL Server is logging that "integrated security only" is enabled and failing logins, but the configuring is showing mixed mode. Has anyone seen anything of the sort?
NOTE: It is behaving like a double-hop issue, however, that should not occur with SQL Authentication and generally on Windows you get the ANONYOMOUS_USER as the username.
UPDATE : I noticed there is a rdsadmin user with a disabled status,
asked 3 months ago
I'd like to provide mirroring or redundancy across AZs with RDS Custom for SQL Server. How can this be done and is it possible?
asked 3 months ago