You may want to look around for the Double Hop issue. Once the SPNs were set up correctly, I didn't have any issues passing through authentication.

http://jesseorosz.spaces.live.com/Blog/cns!E322FD91218E57CF!329.entry

Thanks for your response Brian.

For SQLSentry, we are using the Virtual SQL Name for SQL Server Cluster instance. However, there lies the problem. The Virtual SQL Name is...

I believe the root problem was a combination of how Microsoft Dynamics AX was calling the object. Also, there is a trace flag 7646; DBCC TRACEON(7646, -1) that can...

Thanks. I will have our network guy verify the ports are open. If I add Anonymous Users to the cube, they have access. I would imagine, that...

Sorry, I hit reply to quickly, if you read my first thread, it may make more sense.

There are no errors on the Oracle side. The SQL being sent to Oracle completes successfully. Each time, the OLEDB will error as mentioned, but on the Oracle...

I would be willing to look at SQLClue & SQLRunbook. Not sure what they do, but we do have Oracle and MySQL along with SQL Server.

Everyone has...

I am looking for something that completely documents database and operating system. Profiler and Perfmon provide activity, but I am looking for a periodic run to keep server/database documentation...

Wow, this has been a good discussion to read. Of course, it took me a while to get through all of the posts. It must be that I...

I am also interested in Transaction Replication from Oracle to SQL Server 2005. Can someone offer any links, documents, information regarding Replication with these database servers?

Thanks

Greg

I sent a private message, asking for contact information. Our "Var" is in the process of upgrading from 3.3 to 4.2 DAX. I would like to have an...

Yes, it is Navision. Same product. I don't have a whole lot of information as I am new to this particular ERP solution. However, I am trying...

Thanks for your reply Steve. I always enjoy reading your responses. As for the post, I do think I am going to be on guard with Dynamics AX...

For those of you that are still working with SQL Server 2000, I think you are missing the SYNONYM. I have used SYNONYMs a little, and have found them...

Thanks everyone for the responses.  I do like the idea of LINQ being able to work with data easily.  My concern is data access to the database.  I have seen...