We are trying to connect our adapter to a SQL Server table, and for the first time we are using a domain account rather than a SQL user account (I guess a better way to say this is that SQL is using a domain account as a user account). SQL Server is denying access to this account. Question: is WebFOCUS set up to send a domain account to SQL?

Thanks for your replies!

This message has been edited. Last edited by: Kerry,

Doesn't that user have to be defined in the MS SQL Server DB? How did you set up the WF connection to the database - explicit, pass-through, trusted?

Thanks for the reply, Francis. Yes,this domain account is defined in the database as a SQL user, and we are attempting to set up this connection using "explicit."

Can you connect to SSMS using that account and access that table that way? If you can't do that, then it would appear the issue is on the SQL Server side and not on the WebFOCUS side.

Hi Jessica,

Yes we can log in using that account and can open any table in the database. My question, based on the replies I have received, is that WebFOCUS should be able to use this domain SQL user account just like any other SQL account, right?

One other thing, we define the user in the connection page as domain\username...is this syntax correct?

All the ID's we use to connect are set up as SQL Server log in ID's. I checked the doc just now and it doesn't say one way or the other if a domain name can be specified, so I'm not sure if the syntax you are using is correct or not. From your last post, I see you tried with the backward slash. Have you tried the forward slash (domain/userid)? Other than that, I'm afraid you're going to have to ask IBI.... unless someone else out there has done this.