How to enable SSL for HTTP endpoint?

Hi,

I'd like to know how can I setup the SSL so I can secure my HTTP Endpoint.

I saw in the documentation that some settings such as SSL_PORT and PORTS should be set to SSL port number and SSL but I did not find out anywhere where they explain how to enable SSL.

Do we enable SSL the same way we enable it or SQL Server 2005 or does that have to be done through the MMC - Certificates.

I don't have any IIS server running on this server, so I was wondering if IIS is a requirement to generate and import the certificate.

I appreciate your help and comments.

Bruce.

Bruce,

You can use the same SSL certificate as IIS if you like. Once the SSL certificate is setup for the IPAddressort combination, all you need is to configure the ENDPOINT to support SSL.

For additional information on how to configure a SSL certificate for use by the ENDPOINT, please refer to the "Configuring Certificate for Use by SSL" topic in Books Online (http://msdn2.microsoft.com/en-us/library/ms186362.aspx)

Jimmy

|||

Thanks Jimmy,

It's now working. I thought that was much more complicated than that to enable SSL on the HTTP endpoint.

Thx.

Bruce

How to enable SSL for HTTP endpoint?

Hi,

I'd like to know how can I setup the SSL so I can secure my HTTP Endpoint.

I saw in the documentation that some settings such as SSL_PORT and PORTS should be set to SSL port number and SSL but I did not find out anywhere where they explain how to enable SSL.

Do we enable SSL the same way we enable it or SQL Server 2005 or does that have to be done through the MMC - Certificates.

I don't have any IIS server running on this server, so I was wondering if IIS is a requirement to generate and import the certificate.

I appreciate your help and comments.

Bruce.

Bruce,

You can use the same SSL certificate as IIS if you like. Once the SSL certificate is setup for the IPAddressort combination, all you need is to configure the ENDPOINT to support SSL.

For additional information on how to configure a SSL certificate for use by the ENDPOINT, please refer to the "Configuring Certificate for Use by SSL" topic in Books Online (http://msdn2.microsoft.com/en-us/library/ms186362.aspx)

Jimmy

|||

Thanks Jimmy,

It's now working. I thought that was much more complicated than that to enable SSL on the HTTP endpoint.

Thx.

Bruce

How to eliminate login screen when i try to access report via URL

I am trying to access a report via url

http://69.23.3.112/reportserver?/rptProject/rptStatus&eStatus=All&eUser=2

it always asks for username and password.

All my users login to my project which is asp.net 1.1(vs2003) based project, now from inside the project, if they try to access any report from (which is on framework 2.0), they have to go through a autentication screen which is related to sql server reporting services.

can you please help, how to override this login screen.

Thank you very much for the information.

If It is for login to the datasource then you ned to pass datasource credentials. (reportviewer.setdatasourcecredentials())And if it ask you to login to the report server than you need to set the report server to allow access of the report to your website.

and if you want you can set report server credentials.. and give that credentials access to the reports using report manager.

|||

Hi, Thanks.

I gave permissions to report manager folder for aspnet and also iusr_machine name both.

and also checked anonymous login for reports virtual directory under intepub.

still i get the login screen if somone trying to access reports via reporting services reports folder.

i am calling the reports via url from vs 2003 , and my reports are on vs 2005.

And microsoft did'nt release no report viewer with framework 1.1., that is causing the problem.

please help guys.,

Thank you all.

|||

I can give you one option.

You can crete one project with a page (may be 1 default.aspx) containing report viewer and if you want parameter promp controls of your own.

And redirect your users from original website to new website when ever they select menuitem( or whatever you have used) for report.

Now for login screen.

I need to know where it pop us..

when anyone trying to go to report folder or when any one trying to run report.

If it is asking when anyone trying to go to report folder.. I thing you need to pass login for the user in URL( Not sure how)

If it is asking when they run report just do one thing. go to each report.. than properties than datasource and save credentials for datasource.

How to eliminate login screen when i try to access report via URL

I am trying to access a report via url

http://69.23.3.112/reportserver?/rptProject/rptStatus&eStatus=All&eUser=2

it always asks for username and password.

All my users login to my project which is asp.net 1.1(vs2003) based project, now from inside the project, if they try to access any report from (which is on framework 2.0), they have to go through a autentication screen which is related to sql server reporting services.

can you please help, how to override this login screen.

Thank you very much for the information.

If It is for login to the datasource then you ned to pass datasource credentials. (reportviewer.setdatasourcecredentials())And if it ask you to login to the report server than you need to set the report server to allow access of the report to your website.

and if you want you can set report server credentials.. and give that credentials access to the reports using report manager.

|||

Hi, Thanks.

I gave permissions to report manager folder for aspnet and also iusr_machine name both.

and also checked anonymous login for reports virtual directory under intepub.

still i get the login screen if somone trying to access reports via reporting services reports folder.

i am calling the reports via url from vs 2003 , and my reports are on vs 2005.

And microsoft did'nt release no report viewer with framework 1.1., that is causing the problem.

please help guys.,

Thank you all.

|||

I can give you one option.

You can crete one project with a page (may be 1 default.aspx) containing report viewer and if you want parameter promp controls of your own.

And redirect your users from original website to new website when ever they select menuitem( or whatever you have used) for report.

Now for login screen.

I need to know where it pop us..

when anyone trying to go to report folder or when any one trying to run report.

If it is asking when anyone trying to go to report folder.. I thing you need to pass login for the user in URL( Not sure how)

If it is asking when they run report just do one thing. go to each report.. than properties than datasource and save credentials for datasource.

sql

How to download the english version of SQL Sever Express?

Hello,

when i try to download SQL Server Express from

http://msdn.microsoft.com/vstudio/express/sql/download/

i only get the german version. But i want to download the original english version. Because i like more to work with the english terms than the translated german ones.

Regards,

Markus

Visit this page, select English then click Change, scroll-down to the Files in This Download then click the third download-button.
Hope this helps you.
|||

Thank you. I want to download the SQL Server 2005 Express Edition with Advanced Services SP1.

Like on this page:

http://msdn.microsoft.com/vstudio/express/sql/download/

But in English, not in German. I'ts not helpful for me to work with an german version and read the english documentation.

The subset of english microsoft uses is so good and understandable that in my opinion german versions of development tools are obsolete. When all use the english version, all use the same terms.

Markus

|||Okay, take a look at this page...|||

For those of you wondering, the MSDN download page is language sensitive and automatically downloads the language version of Express based on your Browser settings, assuming we release a version in that language. For cases where you want a language other than the one your Browser is set to, you can get those languages directly from the Microsoft Download Center as described above.

I will be updating the MSDN download page in the near future to contain this information so that you will be able to get to the correct download center page for alternate language downloads directly from MSDN.

Regards,

Mike Wachal
SQL Express team

Mark the best posts as Answers!

|||

Thank you, Moayad for the link to the original version!

Mike wrote:
> I will be updating the MSDN download page in the near future to
> contain this information so that you will be able to get to the
> correct download center page for alternate language downloads
> directly from MSDN.

thank you very much!