I have several SQL 2005 servers all in domain environment most using sql and
windows authentication. I also have a couple of SQL and Analysis servers
outside the domain (in DMZ) that I want to connect to via management studio
and reporting services running on machines inside the domain. I can connect
to the database engine no problem with an SQL account but AS doesn't allow
me to choose other that Windows Authentication. Is there something I'm doing
wrong here?



--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

On Feb 7, 7:00*pm, "Dave Patrick" <DSPatr... (AT) nospam (DOT) gmail.com> wrote:
Dave -

Check this out:
http://technet.microsoft.com/en-us/l.../cc304417.aspx

You are not doing anything wrong. SSAS supports windows authentication
only. There are workarounds through linked servers/web services to get
to the data but they are not the default connection option and
certainly not to administer the instance/cubes/etc.

HTH
Mike Walsh
www.straightpathsql.com/blog

Thanks Mike, I'll take a look at this. This may be a problem and or a show
stopper for me. I wonder why on earth they would have done this?



--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


"Mike" wrote:
Dave -

Check this out:
http://technet.microsoft.com/en-us/l.../cc304417.aspx

You are not doing anything wrong. SSAS supports windows authentication
only. There are workarounds through linked servers/web services to get
to the data but they are not the default connection option and
certainly not to administer the instance/cubes/etc.

HTH
Mike Walsh
www.straightpathsql.com/blog

Under some conditions, it might be possible to connect to the DMZ with
Windows Authentication by using the Named Pipes protocol but this method is
prone to error and I don't know if this will work for you but if you want to
tak a look at it, see:

http://sqljunkies.com/WebLog/roman/a...1/28/5296.aspx

http://www.jasonfollas.com/wiki/(X(1...ookieSupport=1

Also, the usual recommended method to administer a machine inside a DMZ is
to use Remoting.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain aei ca (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)


"Dave Patrick" <DSPatrick (AT) nospam (DOT) gmail.com> wrote