I am using SQL Server 2000. My database server was running in the named instance as SQL2K. My Server name is Pradeep. I gives the connection string as foolowing:-
Server : Pradeep
Database : DemoDB
Password : demo@123
Login : Demo
Schema : dbo
Port : 1433
AdditionalParams : instance=SQL2K
The above syntax is correct or not. My job was threwing the following error.
Exception in component tMSSqlOutput_1
java.sql.SQLException: Server Pradeep has no instance named SQL2K.
Thanks & Regards,