Method for overcoming SQL SERVER user isolation in cluster environment

An isolated and user-friendly technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve problems such as inability to log in, achieve good use value, and ensure continuity.

Inactive Publication Date: 2014-09-17
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

That is to say, the account only has a user nam

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for overcoming SQL SERVER user isolation in cluster environment

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0014] Implementation

[0015] The present invention will be described in detail below with reference to the accompanying drawings.

[0016] A method for solving the isolation of SQL SERVER users in a cluster environment of the present invention, the principle in the structure is described as follows:

[0017] (1) Get the current orphaned user sp_change_users_login 'report', use the database command, and modify its status to normal;

[0018] (2) In the Windows environment, write an executable script, write the script authorize.sql, the function is to modify the status of the isolated user, in the Windows command line (CMD), osql executes the authorize.sql script;

[0019] (3) During resource migration, execute the osql command:

[0020] Write a batch file script_osql.bat and call the authorize.sql script:

[0021] According to the configuration requirements of the cluster, add script_osql.bat to the cluster to realize the management of scripts by the cluster:

[0022] Set ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a method for overcoming SQL SERVER user isolation in a cluster environment. The method comprises the steps: first, obtaining a current isolated user sp_change_users_login'report', and correcting the state of the isolated user to be normal by using database commands; then writing an executable script in the windows environment, writing the script authorize.sql which has the function of correcting the state of the isolated user, in the Window command line (CMD), executing the authorize.sql script by osql; lastly, during resource migration, executing an osql command, and setting a script_osql.bat resource dependence relation, namely, executing the script after a database is started. The method provided by the invention can automatically eliminate the 'isolated' user, and change the state of the user to be normal, the continuity of the database and user business is ensured, and the method has good using value.

Description

technical field [0001] The invention relates to a method for solving the isolation of SQL SERVER users in a cluster environment. Background technique [0002] For the Microsoft SQL Server application in the cluster, when using a custom user (non-sa), the user is in an "orphaned" state after resource migration (failover), so the client cannot connect to the database, and the high availability function of the cluster is lost. [0003] The so-called isolated account means that it exists in the sysusers system table of the user database, but there is no corresponding record in the syslogins of the master database. That is to say, the account only has a user name but no login name, so it cannot be logged in. Contents of the invention [0004] The purpose of the present invention is to provide a method for solving the isolation of SQL SERVER users in a cluster environment. This method can automatically eliminate "isolated" users and turn them into normal states to ensure the co...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F9/44G06F17/30
Inventor 赵芳斌张洪宾任华进陈彬
Owner LANGCHAO ELECTRONIC INFORMATION IND CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap