Accessing MSDE from a different domain

[splaisance]

Hi,

I am new to MSDE and am having some difficulty setting up an application for testing purposes. I have installed MSDE on a server on 'DomainA'. I added a database and have an application retrieving data from the database. I set up a profile in the data engine and made sure it had access to the database and relevant tables. The problem is when I log on at 'DomainB', the application can not retrieve the data. The computer on 'DomainB' can see the server where MSDE is setup but errors on connecting to the data engine.

What am i missing????


Thanks!

Shannon

 

[neecie]

Check the service account under the properties for the server your database is on. It must have a domain account to enable communication across a network.

Look for 'domain user account' in the SQL Books On Line