Hi Everybody,
While connecting the MSSQL 2000 server to EP 7.0 SP10, the connection is failed. I have added the sqljdbc.jar file through the Visual Administrator through the given procedure. And after that i have created a system com.sap.portal.systems.bi -> SAP_BI_JDBC. I have created the connector eith name MSSQL_JDBC in the Visual Administrator. With the same name i have edited the information in the Show All tab. After that i have added the connection properties with URL : jdbc:sap:sqlserver:// : ;database=
and driver name is com.microsoft.sqlserver.jdbc.SQLServerDriver.
After that i have given the user permissions. Next i have created the system alias and given User mapping for system access.
I have followed everything as per the document available for the connection. But the connection test is failing. One differnece i have observed is, i am not getting the value of Delta Link Tracer value -1 in the show all tab. Does it really make any problem for this.
Please help me to solve this. Any kind of help is appreciated.
Thanks,
Rajesh