[SQL 2012] mysql connector ODBC 5.2 not showing on destination drop down |
| mysql connector ODBC 5.2 not showing on destination drop down Posted: 01 Jun 2013 08:38 PM PDT I tried to transfer data from ms sql server 2012 to mysql using sql server export, but could not find mysql connector ODBC 5.2 on the distination dropdown. I already have mysql connector ODBC 5.2. Any ideas on how to make it work?Thanks. |
| Posted: 01 Jun 2013 08:09 AM PDT (if this entry is not in the correct area - please move it - and sorry ... )-o-The DQS Installer log is below. I saw elsewhere to make sure that Named Pipes and TCP/IP were enabled. So I made sure of this (changed one or two settings) and restarted SQL Server 2012 (both the service and the application)Still Getting the same error though. I am experienced with SQL Server - but not overly so. I need to study DQS/MDS for the 70-463 Certification Test - and I would really like to get this properly installed on my home computer. The DQS/MDS files were installed initially (a few months back), but I never ran the DQS Installer till now.One note - I am trying to install this on my Personal Computer (plenty of power to run it ... ) - I do not think this is limited to a Windows Server, but I could be wrong.Also - I'm noting the failure to connect "Login failed for user 'FrogRoom-PC\Frog Room'". There is no User by that name - that is computer/sql server instance. So I am not sure why a user is not getting picked up here.Your help very much appreciate.Scott MacDonaldTucson, AZMicrosoft (R) DQS Installer Command Line ToolCopyright (c) 2012 Microsoft. All rights reserved.[5/31/2013 10:19:47 PM] DQS Installer started. Installation log will be written to c:\Program Files\Microsoft SQL Server\MSSQL11.FROGOFFICE\MSSQL\Log\DQS_install.log [5/31/2013 10:19:47 PM] Setting the collation to default value: SQL_Latin1_General_CP1_CI_AS[5/31/2013 10:19:47 PM] Failed to connect to local instance 'FROGROOM-PC\FROGOFFICE'.System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'FrogRoom-PC\Frog Room'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Ssdqs.DqsInstaller.Utilities.InstallerUtility.TestConnection(String instance, Exception& exception) |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment