Oracle GoldenGate for SQL Server connection ODBC failed processing method

Source: Internet
Author: User
Tags dsn microsoft sql server odbc odbc connection management studio microsoft sql server management studio sql server management sql server management studio



Oracle GoldenGate for SQL Server is still relatively easy to connect to the Oracle database, as long as the command line is:



ggsci> dblogin Useridalias [alias name]
Or
ggsci> dblogin userid [user name] password [password]



Just fine.



If you are under MS SQL Server, you can also connect via ODBC using the following command:



ggsci> dblgoin sourcedb [DSN]



Here SQL Server and Oracle are different, SQL Server uses the DSN name, and can be connected as well.



But when it comes to extract and replicat, you get the following error:


ERROR OGG-00551 Database operation Failed:couldn ' t connect to DSN001. ODBC error:sqlstate 37000 Native Database error 4060. [Microsoft] [SQL Server Native Client 11.0] [SQL Server] could not open the database requested by login "Baseapp". Logon failure:

 


The following may be an error in the English system:


ERROR OGG-00551 Database Operation Failed:couldn ' t connect to [dsn001]. ODBC error:sqlstate 37000 Native Database error 4060. [Microsoft] [SQL Server Native Client 11.0] [SQL Server] Cannot open database "db_name" requested by the login. The login failed.

 


This kind of error hint is very pit, cannot solve this problem by literal meaning, whether modify ODBC inside DSN's login or SQL Server authorization is useless, but actually in Ggsci inside the same operation is no problem.



The way to solve this problem is simple:



Open Microsoft SQL Server Management Studio, under Security, login name, select NT Authority\system->, right-click Properties, Server Role Just tick the sysadmin.



This problem arises because the Goldengate Manager (MGR) service runs as a service, runs under Windows as a system account, and the system account may not have access to the SQL Server database



The other is that we generally install the mixed mode of SQL Server is selected, so the establishment of ODBC connection is the use of integrated account login;






Oracle GoldenGate for SQL Server connection ODBC failed processing method


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.