Excellent. Thank you so much Sue for great support. Very much appreciated.

Thanks

Malik Adeel Imtiaz

Hi Sue,

I can see the UTF patch in SP 2 in below link.

https://support.microsoft.com/en-us/help/3171021

But have unable to find UTF patch in SP 3 in below link.

https://support.microsoft.com/en-us/help/4022619/sql-server-2014-service-pack-3-release-information

Regards,

Malik...

Dear Sue,

Thank you so much for your reply.

Please see that we have changed our code, the issue is now we need UTF-8 encoding which is available in SP3 please see...

Dear Sue,

Can you please explain in little bit more detail.

Thanks

Malik Adeel Imtiaz

Can someone please help.

Thanks

Adeel Imtiaz

Dear Gurus,

The problem has been resolved after installing {msoledbsql_18.2.2.0_x64.msi}

and update string with below Provider.

Provider=SQLNCLI11; Server=myServerName\theInstanceName;Database=myDataBase;

Trusted_Connection=yes;

to:

Provider=MSOLEDBSQL; Server=myServerName\theInstanceName; Database=myDataBase;

Trusted_Connection=yes;

Reference: https://blogs.msdn.microsoft.com/sqlreleaseservices/released-microsoft-ole-db-driver-for-sql-server/

Now i am facing ANOTHER error.

Message:

Executed as user: NT Service\SQLSERVERAGENT. Error Code: 0 ...

Thanks for your reply.

Please confirm.

During MS SQL 2014 installation, i observed MS SQL 2012 Native Client also get installed with SQL 2014.

Its version is 11.4.7462.6

I have upgraded its version to...

Its Microsoft Windows 2012 R2 EE. So how can i know which SQL Driver i am using is there any steps to identify. ?

Thanks
Malik Adeel Imtiaz

I have observed one thing.

When i create ODBC connection from below steps 

It gives me below error.

But when i connect with below steps it successfully connects.

Dear All,

Problem has been resolved. by uninstalling MS14-049 (KB2918614) from my machine and then install the SP4 again.

Special Thanks to Vitor Montavao (http://www.experts-exchange.com/members/VMontalvao.html)

Regards

Adeel Imtiaz

Dear All,

I have installed successfully SP4 on SQL 2005 but on new machine which was not on DOMAIN.

I make old (machine which was giving error) machine on workgroup and after...

Dear Sir,

thank you so much.

Can you please confirm me that how can i do this.

As an simple cluster we use two nodes

Node 1 : windows 2008 R2 + SQL Cluster...

Thank you for your reply.

Please see screen short.

Thanks

Malik Adeel Imtiaz

Dear Guru,

can i please share further clarification about it. i can do it or not.

<<can i build a two node sql cluster with Shared storage(SAN) with AlwaysOn>>

OR

I have...