Questions tagged with RDS Custom for SQL Server
Content language: English
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
RDS Custom for SQL Server is a managed database service where the customer has full administrative access to the operating system and database configuration, including via RDP. New OS images are provided regularly with the latest patches. Assuming there are no critical patches to apply, about how much time would elapse between new versions?
asked 3 days ago
I've configured the Athena connection to a RDS SQL Server database using a JDBC driver. After choosing the Data Source the Database does not load and there is a "Network Failure" shown without any information. What might be the cause of such error or where I can find more information on how to solve such case?
We have made a new RDS Database and we have a public DNS record of it to connect. How can I find its private IP to connect from within the AWS network in same zone.
I'd like to use Maintenance Plans on RDS Custom for SQL Server.
asked 25 days ago
I have an RDS instance, with MS SQL Server database.
I need to grant permissions to a user in my application to execute some important procedures.
However, even connected to the RDS instance with the admin user, I cannot grant these permissions.
The query I need to run is the following:
```
USE [master]
GO
sp_configure 'Advanced Options', 1
GO
RECONFIGURE
GO
sp_configure 'Ole Automation Procedures', 1
GO
RECONFIGURE
GO
GRANT EXECUTE ON sys.sp_OACreate TO [usr_apis]
GRANT EXECUTE ON sys.sp_OADestroy TO [usr_apis]
GRANT EXECUTE ON sys.sp_OAGetErrorInfo TO [usr_apis]
GRANT EXECUTE ON sys.sp_OAGetProperty TO [usr_apis]
GRANT EXECUTE ON sys.sp_OAMethod TO [usr_apis]
GRANT EXECUTE ON sys.sp_OASetProperty TO [usr_apis]
GRANT EXECUTE ON sys.sp_OAStop TO [usr_apis]
```
and when running the query above, the following errors are returned:
```
Msg 15247, Level 16, State 1, Procedure sp_configure, Line 105 [Batch Start Line 2]
User does not have permission to perform this action.
Msg 5812, Level 14, State 1, Line 5
You do not have permission to run the RECONFIGURE statement.
Msg 15247, Level 16, State 1, Procedure sp_configure, Line 105 [Batch Start Line 6]
User does not have permission to perform this action.
Msg 5812, Level 14, State 1, Line 9
You do not have permission to run the RECONFIGURE statement.
Msg 15151, Level 16, State 1, Line 11
Cannot find the user 'usr_apis', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 12
Cannot find the user 'usr_apis', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 13
Cannot find the user 'usr_apis', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 14
Cannot find the user 'usr_apis', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 15
Cannot find the user 'usr_apis', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 16
Cannot find the user 'usr_apis', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 17
Cannot find the user 'usr_apis', because it does not exist or you do not have permission.
```
How can I grant the user of my application the necessary permissions to execute these procedures?
Thanks.
asked a month ago
I would like to reduce costs by allowing RDS Custom to use an existing trail rather than create a new one. Is this possible?
asked a month ago
Does RDS Custom for SQL Server support dedicated hosts?
asked a month ago
Today while trying to access my table through API, I accidentally ran the initialization function, which rewrote my data table with a blank one. We have not set up automatic backups nor taken a snapshot of the table as of yet. I found the event in the event stream, and I am wondering if there is any way that we can recover the data from the table. It happened 20 minutes ago, and we have been trying to figure out a way.