Are there any special tricks if you're trying to link a SQL2000 server into a SQL2005 server? I feel like I've tried every possible combination without success. :crazy:

I'm using this...

I guess I'll have to talk to the DB2 DBA. I've tried just about every combination possible from the data that I have. I also checked that MS article and...

OK, I assigned roles to my cube and now everyone is happy. At first I gave everyone the lowest security, Read, and they could see the cube, then they could...

They already had read permissions on the database. I used my credentials on their machine when connecting, and that did the trick. However, I sure don't like doing that. Is...

OK, had the users install the msxml6 file and the ASOLEDB9 file. They get the option to choose the OLAP 9.0 in the drop down now, however, they cannot see...

I, personally, have ExcelXP, but I've got the SQL2005 client tools loaded. I assume that's why I can see the data in Excel. How about Excel2003, will that work? Or...

Wow, the first one I tried today actually worked. It was:

http://servername/Reports$minstancename/Pages/Folder.aspx.

I don't think I tried the /Reports$myinstancename syntax. I also went into IIS Manager and selected...

I tried that, http://ABC/$XYZ where

ABC = my server name and

XYZ = my instance name

still no luck. I also made sure that active content was enabled in...

That did it. At least when I'm working on the server itself. How about when I try and hit it from the browser on my pc? I think I've tried...

Don't feel stupid. Those shouldn't even show up if the user is just a Browser. Microsoft should've seen to this. Now the user is going to be curious about what...

Logically you shouldn't be using that field for anything but a surrogate key. But yes, you can get the current maximum from that field by using:

SELECT MAX(YourIdentityField) + 1 FROM...

Is it possible that when the former DBA left, his account was disabled, and the VB app is using a connection with his credentials? I've experienced that before when someone...

I come from a shop that used Access for their production apps. I tasked myself with the job of converting as much data/queries/reports to SQL Server. I converted all queries...

Great!! I'll try it and let you know my progress.

Those links are awesome. I use the experiment method where I try everything under the sun and finally give up, then ask someone else. Thanks guys.