Access AS from Excel 2007 from outside the domain

I am trying to access an AS DB from outside the domain. I'm using the https://.../msmdpump.dll to specify the server name. Is there a way to qualify the specific AS DB in the supplied server name? Excel allows for both Windows authentication as well as providing username and password, which seems to be a mistake - it appears it uses the same dialog box in creating a connection to AS and DB, so provides the ability to pass l/p. Can I provide a valid Domain login in these fields for connecting to AS? My machine is of course in a different domain then AS - is there a way to pass the remote domains credentials from this machine?

Thanks

If the laptop conaining Excel 2007 is not on the same domain as SSAS or the msmdpump.dll web server, then I would suggest one of two options:

1. Launch Excel with the runas command:

Code Block

C:\WINDOWS\system32\runas.exe /net /user:SSASDomain\username "C:\program files\Microsoft Office\Office12\EXCEL.EXE"

Then connect with "Use Windows Authentication" in Excel.

2. If that's not an acceptable solution, then enable basic security on the msmdpump virtual directory (which is still secure because you're using HTTPS) and connect using "Use the following User Name and Password" in Excel. Note that their password will be stored in the xlsx in clear text and on disk elsewhere on their computer. And if these users can publish to Excel Services, there will be a bunch of other complexities to worry about. (If Excel Services publishing is needed for these users, I would suggest you have them submit their xlsx files to internal IT who can remove the basic security and flip the connections over to Integrated Security before publishing to Excel Services.)

If msmdpump.dll is not on the same server as SSAS, you may have troubles getting #1 to work since Kerberos delegation across domains starting with a connection in Excel isn't possible that I know of. But #2 should work.

As for specifying the database, I believe that is configured on the next screen in the connection wizard in Excel 2007. If you meant "can msmdpump.dll point to several servers?" I think the answer is no. There's a msmdpump.ini which controls which SSAS server it connects to. But you can certainly deploy multiple msmdpump.dll virtual directories.

Keep us posted with your progress or with other lessons learned if you run into some gotchas. Hope the above helps.

Access 2003 and SQL Express

Is there a way to integrate Access 2003 as the Front End for SQL Express?

I tried, but I can't make a new Access project because I need to specify a login/pass and I have no idea what those are set to, or if I need to make an account somehow.

As you can see, I am totally new to SQL and any help would be appreciated.

Thank You,

James

The default login/password would probably be sa, with an empty password. That's generally what SQL Server uses before it's changed by the end user.

|||Create an ODBC connection using administrative tools, and then connect to it from ACCESS.|||Where can I find the appropraite adminstrative tools?|||

Run the following from DOS:

%SystemRoot%\system32\odbcad32.exe

This creates ODBC connections. Administrative tools gives you access features of the OS to meddle with, important if you are a programmer. I would suggest you get familiar with them, although I believe you need to be an administrator to access them. To add the shortcut to the Start Menu\All Programs menu

Right Click on taskbar\ start menu:

Properties>Start Menu Tab>Customize>Advanced Tab

Also, you have access to a full range of management utilites from mmc.exe. Run this, then add the appropriate snap ins.

Check out this link from MS:

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/app_misc_pr_load_snapin.mspx

HTH

|||

Thanks a lot for the help. Defintely helped out a lot!