Re: securing connection between web site and SQL server
- From: "Mike C#" <xyz@xxxxxxx>
- Date: Thu, 15 Feb 2007 16:01:26 -0500
Hi rb
"rb0404" <rb0404@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7F5CD444-BF9F-4FE5-9743-8626CF6DB2C1@xxxxxxxxxxxxxxxx
I am having a complete nightmare of a time trying to setup an SSL
certificate
to secure the connection between a web site (hosted externally) and a
machine
within the network in our office with the SQL server database. I am using
a
connection string like the following:
"DRIVER={SQL
Server};Network=DBMSSOCN;SERVER=<domain_name>,1433;DATABASE=<database_name>;UID=<user_name>;PWD=<password>;Encrypt=Yes"
Our router fowards traffic on port 1433 to port 1433 and the ip address of
the database machine.
Now I can make an unencrypted connection between the two without any
problems.
I've tried generating certificates from the database machine with no
success
through IIS and selecting properties on the default website node. I have
tried using our external domain name as the fully qualified domain name
and
the fully qualified domain name of the machine with SQL server database
and
neither method seems to work.
Has anyone got any experience with such a setup and can you point me at
step-by-step instructions on setting up a certificate that work?
cheers
Check out this link: http://msdn2.microsoft.com/en-us/library/ms189067.aspx
.
- Prev by Date: Re: Granting Access to Modify jobs
- Next by Date: Re: sys.database_role_members - how can I make the output useful ?
- Previous by thread: Re: Granting Access to Modify jobs
- Next by thread: Re: securing connection between web site and SQL server
- Index(es):
Relevant Pages
|
|
