connect to AS via management studio

8 Feb 2009 12:00 AM

Dave Patrick

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

8 Feb 2009 1:32 AM

Mike

Show quote Hide quote

On Feb 7, 7:00 pm, "Dave Patrick" <DSPatr...@nospam.gmail.com> wrote:
> 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

Dave -

Check this out:
http://technet.microsoft.com/en-us/library/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

8 Feb 2009 3:35 PM

Dave Patrick

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/library/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

8 Feb 2009 9:05 PM

Sylvain Lafontaine

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/archive/2004/11/28/5296.aspx

http://www.jasonfollas.com/wiki/(X(1)S(a3b5czblmu0uhm45xce4wmbk))/Default.aspx?Page=SQL%20Management%20Studio%20on%20Vista&AspxAutoDetectCookieSupport=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)

Show quoteHide quote

"Dave Patrick" <DSPatrick@nospam.gmail.com> wrote in message
news:6B851A32-AFA2-4884-B2C0-0363BDD93CD7@microsoft.com...
> 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/library/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