Connecting to Dara Analysis as a different user

[szymen]

Hi,

Is it possible to connect to Data Analysis view NOT as a Windows Domain User?
I see that such a thing is possible in MS Excel 2007 in: Data->From Other
Sources-> From SQL Server, where you can choose "Use the following user Name
and Password". It would be very helpful option when user isn't currently in
the domain and wants to show some reports about his projects.

Regards,
szymon

 

[Stephen Sanderlin [MVP]]

Please see http://technet.microsoft.com/en-us/library/dd180745.aspx.
Although this article discusses SQL 2005 on Windows 2003, a blog post
that discusses SQL 2008 and Windows 2008 is available at:
http://bloggingabout.net/blogs/mgla...ervices-on-microsoft-windows-server-2008.aspx.

--
Stephen Sanderlin, Project MVP
VP of Technology
msProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com