The following is a sample of the correct connection string: Provider=MSDASQL Persist Security Info=True User ID=sa Extended Properties="DSN=MSSQL 2012 UID=sa APP=Microsoft Office 2013 WSID=GENLI-T430 DATABASE=test Pwd=**********" Initial Catalog=test Password=********** This issue occurs because the Extended Properties information is not contained in the ODBC connection string. The following is a sample of the connection string that you created: Provider=MSDASQL.1 Persist Security Info=True User ID=sa Initial Catalog=test DSN=MSSQL 2012 Password=********** Reason: ERROR Login failed for user ''.ĮRROR Invalid connection string attributeĮRROR Login failed for user ''. However, when you click Next, you receive the following error message: Failed to connect to the server. You create the connection string by using the Table Import Wizard. SymptomsĪssume that you try to connect to a database by using Microsoft OLE DB Provider for ODBC Drivers in the PowerPivot for Microsoft Excel 2010 or PowerPivot for Microsoft Excel 2013 add-in. For more information about this change, read this blog post. Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |