Burke
Active Member
My configuration. E1 8.9 with Tools 8.97.26 | Oracle 10g | Citrix.
We have some data that we need to access on a SQL server. I created the Database Data Source for the SQL server and created a corresponding system DSN. Every time I try to create an OCM or access the table via UTB it prompts me for the user ID and password. The SQL server is setup with SQL authentication. I have created a SQL server connection in E1 in the distant past but it was NT authenticated.
The SQL server is managed by someone outside our company and therefore have limited access to it.
Any suggestions?
We have some data that we need to access on a SQL server. I created the Database Data Source for the SQL server and created a corresponding system DSN. Every time I try to create an OCM or access the table via UTB it prompts me for the user ID and password. The SQL server is setup with SQL authentication. I have created a SQL server connection in E1 in the distant past but it was NT authenticated.
The SQL server is managed by someone outside our company and therefore have limited access to it.
Any suggestions?