Will restarting IIS kick remote users out of database?

EM 271 Reputation points
2023-03-09T21:15:35.4233333+00:00

My question may be too vague. I'm not real sure how to ask it and I'm not a dba or web person.

We have a number of users around the USA who access our SQL Server database. They do not use a web site for this access.

I'm trying to open up a web site that was accessible a few months ago but does not appear to be any longer. The message "Your connection is not private" displays. The programmer who developed the site said that either IIS needs to be restarted or the SSL certificate has expired. The SSL certificate doesn't expire until 2024.

If IIS is restarted, will that kick out any users that are currently using the database? Is there an implied internet connection between us and our users?

Thanks for your help and advice.

Windows development | Internet Information Services
{count} votes

Accepted answer
  1. TP 125.8K Reputation points Volunteer Moderator
    2023-03-09T21:31:07.4233333+00:00

    Hi,

    If you are only restarting IIS and not SQL Server, then this should not impact users that are connected directly to SQL Server since they are not accessing via a web application. Are SQL Server and IIS on the same server? If yes, you are not planning on restarting entire server, just IIS, correct?

    In regards to your certificate issue, before doing anything I recommend you open IIS Manager and check the binding to make sure that the correct certificate is bound. It is entirely possible that you just need to correct 443 binding and your web site will work fine.

    If the above was helpful please click Accept Answer.

    Thanks.

    -TP

    2 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.