Hi,
I am using GP10 with SQL server 2005.
Since i am new to econnect i am trying out some sample integration to get an hold on it. I tried out an sample integration with Vendor master creation, but i am stuck up with a porblem . The XML file was created (under bin>>debug folder) which looks fine. But the problem is with the connection string were the eConnect_EntryPoint throws a exception "Integrated security is required".
catch (Exception exc)
{
//string strmessge = "";
//strmessge = exc.Message;
Console.WriteLine(exc.ToString());
}
Integrated Security is required.Please ensure that the ConnectionString input parameter is valid.
Examples:SQLCLIENT Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TWO;Data Source=MySQLServerName
Examples:SQLOLEDB Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TWO;Data Source=MySQLServerName
But my connection string contain Integrated security = SSPI. I cant figure out whats the exact problem is about, this happens with both my SQL instance. My SQL server instances are AFG5850 and AFG5850\V2 (AFG5850 is my local system name)
string sqlconnec = @"Data Source=AFG5850;Initial Catalog=TWO;integrated security = SSPI;persist security info=False;packet size = 4096";
// Instance2
//string sqlconnec = @"Data Source=AFG5850\V2;Initial Catalog=TWO;integrated security = SSPI;persist security info=False;packet size = 4096";
en.eConnect_EntryPoint(sqlconnec, EnumTypes.ConnectionStringType.SqlClient, svendmstr, EnumTypes.SchemaValidationType.None, "");
I have included the following namespaces
using System.Collections.Generic;
using System.Text;
using System.Xml;
using System.IO;
using System.Data.SqlClient;
using System.Globalization;
using System.Xml.Serialization;
using System.EnterpriseServices;
using Microsoft.Dynamics.GP.eConnect;
using Microsoft.Dynamics.GP.eConnect.MiscRoutines;
using Microsoft.Dynamics.GP.eConnect.Serialization;
I have tried some security settings which i found in the forum under component service. I have also created my window login account in GP and provided access to DYNAMICS and company db with DYNGRP role.
Can any one guide me in solving it.
Thanks!