Its actually a data analysis software called jump. They embed the sql query in the program and it uses dsn to make the connection to sql server. If I...

Our sys admin created user service accounts for each user.

So you mean I should be able to use File dsn instead of system dsn? I think File dsn is...

I can make a windows authentication connection from a workstation in a different domain to sql server in different domain using the following command.

RunAs /user: sqldomain\user /netonly "%systemRoot% system32/odbccad32.exe"

When...

Both the systems cannot be in the same domain. One is production network.

Our system admin is so adament about this windows authentication and according to him there should be...

No. I couldn't make publisher as distributor. But I fixed my issue. It was all login issue.

I was giving distributor as trusted connection. But it wasn't a trusted connection....

Above error is fixed now. But log reader is failing again after some time. This step did not generate any output . When I right click and start agent it...

Yes I added distributor_agent on both servers and gave sysadmin role.

I deleted all replications and started again from the beginning .. Now I am gettinf a new error, Snapshot...

Hi

Please help me to solve my issue.. I am having the same problem.. When I set up the replication it was working fine. After 10 or 15...

No one has answer for this?

Thanks. It works just fine..

Server1 (2005 Express is a temparory storage. So I can clean the table after I push the data to 2000.

I thought If I can connect to 2000 using T-SQL commands...

Are you trying to connect to sql server2005 Express?

what is the linked server name you are using?

I can see all the files under the shared directory.

Yes I tried with //AMPCS04/VI/SamInfo.mdb

VI is the share name .

Then it is givving me the same error. It is already opened exclusively by another user.

or you need permeission...