Can't access from internet ?

Moreno,
Reporting Services will work overt the web. Here's what I have done to
enable this to work: -
1. Installed Reporting Services on a Server inside the DMZ.
2. Set up a rule on the external DMZ firewall (ISA Server) to pass
through all requests for www.mydomain.com to the server with Reporting
Services installed on it (making sure that it's also passing through
all HTTP Headers).
3. Mapped the Site on the Reporting Services server to listen to
www.mydomain.com requests.
I then set up Forms Authentication using this sample: -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
Does this help?
Thanks,
Phil Winstanley
Microsoft ASP.NET MVP
http://www.myservicescentral.comThank you for your response, Phil.
Points 1 and 2 are OK.
I don't know exactly how to modify configuration files to make Report Server
listen to new URL requests.
( I've tried a lot of combinations without success )
I've also configured Reporting services to work with SSL. May this causes
some additional problems ?
"Phil Winstanley [Microsoft MVP ASP.NET]" <phil@.winstanley.name> ha scritto
nel messaggio news:cbmejv$4mt@.odak26.prod.google.com...
> Moreno,
> Reporting Services will work overt the web. Here's what I have done to
> enable this to work: -
> 1. Installed Reporting Services on a Server inside the DMZ.
> 2. Set up a rule on the external DMZ firewall (ISA Server) to pass
> through all requests for www.mydomain.com to the server with Reporting
> Services installed on it (making sure that it's also passing through
> all HTTP Headers).
> 3. Mapped the Site on the Reporting Services server to listen to
> www.mydomain.com requests.
> I then set up Forms Authentication using this sample: -
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
> Does this help?
> Thanks,
> Phil Winstanley
> Microsoft ASP.NET MVP
> http://www.myservicescentral.com
>

Cannot use the special principal 'sa'

Hello,

I am starting to use SQL Server 2005. I am having trouble connecting remotely. I tried to enable the 'sa' user and got this error:

Cannot use the special principal 'sa'

Is the 'sa' user no longer valid for remote connections?

Thank you

Did you enable "Mixed Mode" authentication? If you use Windows authentication, sa is disabled by default.

Sung

|||

How did you try to "enable" sa? What statement did you execute to get that error?

Thanks
Laurentiu

|||

Thank you for your reply.

Yes, I did enable Windows authentication, but when I could not connect remotely I decided to to try and connect using SQL authentication. Can I change the authentication mode?

Thank you

|||

Yes, you can change the authentication mode: go to Management Studio and open Object Explorer. Connect to your server and right-click on the server name, then select Properties. Go to Security tab and under Server Authentication select SQL Server and Windows Authentication Mode.

Thanks
Laurentiu

|||

Also, after you follow the directions above, you will also need to explicitly enable the sa account as well. In the same place as before, go to Security->Logins. Right-click on the "sa" account, select "Properties". In the list on the left, select "Status" and under "Login" on the right, make sure "Enable" is selected.

[edit] - nevermind, looks like you got it working :)

Sung

|||

I found the steps to change the authentication.

Now I can login remotely.

Thank you