Troubleshooting SQL Server
1 Introduction
This document covers various errors you might encounter when using SQL Server, and offers suggestions on how to resolve them.
2 Issues
2.1 Read Committed Snapshot
|
|
In order to set Read Committed Snapshot or to create an assembly, the user will need to have the db_ddladmin
role. For each new Mendix database, the Read Committed Snapshot configuration must be enabled. The assembly query is only executed once per database server instance, and is used by all Mendix applications.
2.2 Create Function
|
|
This permission is granted implicitly to the db_ddladmin
and db_owner
fixed database roles. In SQL Server 2005 or higher, the user will still need ALTER SCHEMA
rights to create the function in a particular schema.
In general if the user has the db_owner
role for the database they will have sufficient privileges to executing this query.
2.3 JDBC Connections
2.3.1 Time Out
|
|
If the server address and instance name are correct, then validate if the service “SQL Server Browser” is running. When this process is not running start the service. If you don’t want to use “SQL Server Browser” you need to include the port of the database instance in your URL as well.
2.3.2 Login Failed
|
|
Validate the ‘Status’ of the User. One of the login properties of the user is probably configured to be Deny or Disabled. Both permissions should be configured as Grant/Enabled.
3 Read More
- Setting Up the Database User
- Restoring a SQL Server Database
- Mendix SQL Maintenance Plans
- Setting Up a New SQL Server Database
- Setting Up a SQL Server User
Feedback
Was this page helpful?
Glad to hear it! Thank you for your response.
Sorry to hear that. Please tell us how we can improve.