Endpoints and authentication

I tried asking a similar question over at the asp.net, but I'm not getting any replies.

I created an endpoint in SS 2005 using DIGEST authentication, and I was successful in adding the web service to my project and getting results from a call to it.

However, the production environment does not exist in a domain environment, which eliminates even DIGEST (which requires a valid windows domain logon).

But, when I create the endpoint using BASIC authentication, I can no longer "find" the service. SS says the command(s) completed successfully after the Create Endpoint command. As a test, the documentation says that you can enter the http site into IE and the WSDL will display. And that works in digest mode. However, I've tried both:
http://<server>/path?WSDL and
https://<server>/path?WSDL
And neither returns the WSDL in IE (nor can it be added to my project as a web service).

I'm hoping someone has some ideas on how I can resolve this problem.

TIA,
DaveI suspect that my SSL problem has to do with how the server is setup. I just tried using DIGEST authentication with a LOGIN_TYPE=MIXED. This combination requires PORTS=SSL also.

I go the same messages when I tried to attach. Firefox reports the error as "The connection was interrupted" IE says "Internet Explorer cannot display the webpage"

Could someone give a few hints on what to check on my server?

TIA,
Dave

Encryption Not Supported Error

When running .Net apps against a local SQL Server (2000, SP3) I get the following error:
Connection failed:
ConnectionOpen (PreLoginHandshake())
Connection failed
Encryption not supported on SQL Server
Any help will be greatly appreciated.
Thanks
Hi,
Refer
INF: How SQL Server Uses a Certificate When the Force Protocol Encryption
Option is Set On
http://support.microsoft.com/default.aspx?id=318605
HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate Server
http://support.microsoft.com/?id=276553
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Footix" <anonymous@.discussions.microsoft.com> wrote in message
news:CAD808CD-CA74-4C15-B34C-88377C0D8200@.microsoft.com...
> When running .Net apps against a local SQL Server (2000, SP3) I get the
following error:
> Connection failed:
> ConnectionOpen (PreLoginHandshake())
> Connection failed
> Encryption not supported on SQL Server
> Any help will be greatly appreciated.
> Thanks
sql

Encryption Not Supported Error

When running .Net apps against a local SQL Server (2000, SP3) I get the foll
owing error:
Connection failed:
ConnectionOpen (PreLoginHandshake())
Connection failed
Encryption not supported on SQL Server
Any help will be greatly appreciated.
ThanksHi,
Refer
INF: How SQL Server Uses a Certificate When the Force Protocol Encryption
Option is Set On
http://support.microsoft.com/default.aspx?id=318605
HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate Server
http://support.microsoft.com/?id=276553
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Footix" <anonymous@.discussions.microsoft.com> wrote in message
news:CAD808CD-CA74-4C15-B34C-88377C0D8200@.microsoft.com...
> When running .Net apps against a local SQL Server (2000, SP3) I get the
following error:
> Connection failed:
> ConnectionOpen (PreLoginHandshake())
> Connection failed
> Encryption not supported on SQL Server
> Any help will be greatly appreciated.
> Thanks

Encryption for sql server

hey ppl..
i am creating a client that can access straight into the sql db using vb.net.
is there a way encrypt the data from the client and the sql server will decrypt the data and visa versa?Your best choice is to use some flavor of VPN to get your data to the server safely. A poor alternative (although pure MS-SQL) is to use Named Pipes, which can do feeble encryption at relatively low performance.

-PatP|||is there anyway to make a simple encryption? small enough so that it encrypts the data and it does not effect performance?|||See if this helps you:

http://www.developerfusion.com/show/4647/

You would basically be storing the data encrypted. The problem is when you go to search the data of course. If you need to encrypt all traffic, you can look at what Pat said. I would recommend against it. There are also several hardward level tools for this, but they are expensive.

encryption

I have a number of both classic asp and asp.net applications which are
writing data into a sql server 2000 database. I am am looking at a least
effort way of encrypting some of these details, I was thinking the best way
might be to create a trigger on the relevant database fields which encrypts
the information on insert. I am not sure what should go into the trigger to
do the encryption, any ideas?
There are a couple of issues to note
1. It would have to be a strong encryption algorithm like triple DES.
2. Data would from the database needs to be extracted into a vb.net
application which would need to be able to decrypt it, ideally with the
encryption functions built into .Net.
3. Encrypting the data in the asp/asp.net code before inserting is not
particularly practical due to the large number of separate applications.
ScottThere are 3rd party vendors that offer databse encryption, that SQL 2000
cannot natively provide.
Here's one of the vendors.
http://www.protegrity.com/
Some articles that may be of interest.
325757 INF: Using SQL Server 2000 with FIPS 140-1 Ciphers
http://support.microsoft.com/?id=325757
331367 PRB: Cannot Decrypt Data Using Data Encryption Standard (DES) Key
Across
http://support.microsoft.com/?id=331367
Building Secure ASP.NET Applications: Authentication, Authorization, and
Secure Communication
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/SecNetHT08.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hmmm .. Interesting. I am not a supporter of writing this in a trigger
personally. This will not be efficient and you will land up writing an
Extended stored procedures to do the encryption for you. In SQL Server 2005
this is out of the box feature to use and capitalize.
As a strategy I would always support things to be done in the middle tier
and then encrypting and decrypting them at that layer rather than sending it
to database and later trying to encrypt before inserting. Just my personal
views ...
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"scottrm" <scottrm@.newsgroup.nospam> wrote in message
news:3CE2425A-6063-48B3-A2DF-76C6F37AA06A@.microsoft.com...
> I have a number of both classic asp and asp.net applications which are
> writing data into a sql server 2000 database. I am am looking at a least
> effort way of encrypting some of these details, I was thinking the best
way
> might be to create a trigger on the relevant database fields which
encrypts
> the information on insert. I am not sure what should go into the trigger
to
> do the encryption, any ideas?
> There are a couple of issues to note
> 1. It would have to be a strong encryption algorithm like triple DES.
> 2. Data would from the database needs to be extracted into a vb.net
> application which would need to be able to decrypt it, ideally with the
> encryption functions built into .Net.
> 3. Encrypting the data in the asp/asp.net code before inserting is not
> particularly practical due to the large number of separate applications.
>
> --
> Scott

Encrypting Data

I have an application that has stores sensitive data in an SQL server and I am currently handling this through my ASP.NET application using the encryption classes in C#.

One of the things we would eventually like to be able to do is use other programs (like Microsoft Access) to run advanced Querys on the tables and retrive the data. With the encyption being done in C#/ASP all that would be returned would be the encrypted data.

I wondering if there is a way to build a layer to encrypt/decrypt data at the database level, my searches haven't yeiled to much info (As well as a trip to Borders) as I haven't seen any books that even touch on this.

I don't know a lot about SQL right now (Mainly only MySQL so Stored Procs and all that stuff are really new to me) so I don't know if I would go about it this way or not? (Using a stored procedure)

Can anyone reccommened where I should start to learn about accomplishing this? Books are usually the best help but I'll take any kind of information that can be thrown my way :-)

Thanks!ummm... what are you encrypting? and does it NEED to be encrypted up the wazoo?|||Yes, It needs to be encrypted. No matter what it is there should be a way to encrypt it correct?|||Sorry, To add to that what are my other options? I know there are user access controls (although never have worked with them) and that type of stuff but one thing that worried me would be using access control, right now as it is I can remote desktop to the SQL machine open enterprise manager and browse the tables. (No password needed) I'm all for doing it the correct way. But part of the thing to is even though I'm writing the program because it's encrypted I never have to see the data.

Encrypting a data

Hi,

I have creating a stored procedure in sql server 2005 to encrypt a parameter value that comes from an asp.net page. this value is of type varchar.

Now i have declared a paramater as varbinary to accept this value in the stored procedure. And encrypting it using symmetric key which is encrypted by certificate.

Now when i enter a value into the textbox in asp.net page. it shows

"implicit conversion from varchar to varbinary not possible" pls tell me what is the solution? do i have to convert the value in vb code while accessing the value of the textbox or do i have to convert the value while passing the value when call stored procedure.

pls tell me the solution so that i don't jave to change any coding in vb.

some solution in sql server itselt.

Thank you

Gaurav

If you're passing a varchar to the stored procedure, then rewrite the stored procedure to accept a varchar.

Thanks
Laurentiu

|||

But i have to encrypt that value - the value that is coming from a varchar parameter.

And encryption works on varbinary data type. so do i need to convert that parameter to varbinary in the stored procedure.

Infact i even tried that but it is showing the same result implicit conversion not allowed.

Pls give me a solution. where i could pass a varchar data type value to a stored procedure and encrypt it in the stored procdure.

Thanks

Gaurav

|||

You can encrypt varchar values; it is not true that encryption works only on varbinary data. See the BOL article for EncryptByKey:

http://msdn2.microsoft.com/en-us/library/ms174361(SQL.90).aspx

varchar is explicitly listed as an accepted type for the cleartext data, so you just need to rewrite your procedure to accept a varchar value. Converting the varchar data to varbinary in the procedure does not help, because the problem happens earlier when you pass the varchar value to the procedure that expects a varbinary. If you don't want to change the procedure code to expect a varchar, then you have to explicitly cast the varchar to varbinary before you pass it to the procedure.

For an example that encrypts varchar data, see http://blogs.msdn.com/lcris/archive/2005/12/16/504692.aspx. There are other examples on my blog that encrypt varchar data besides that one.

Thanks
Laurentiu

Encrypted Connection

Hi all,
If this is not the correct groups to post this, please redirect me.
I have a .NET application and SQL Server 2005 Express running on a Windows
Server 2003 Web Edition. Both connect to a remote SQL Server 2000 database
running on Windows 2000.
SQL Server Express 2005 has the 2000 server set up as a linked server.
What are my options for encrypting the connections to the SQL Server 2000?
For the .NET app, I assume that I can use multiprotocol. Correct? Other
suggestions?
What about the SQL Server 2005 linked server to 2000?
TIA
AG
Email: discuss at adhdata dot com
SQL Server supports SSL encryption for connections. See the following
articles:
http://support.microsoft.com/kb/276553
http://msdn2.microsoft.com/en-us/library/ms189067.aspx
http://msdn2.microsoft.com/en-us/library/ms191192.aspx
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23JeihNoKHHA.960@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> If this is not the correct groups to post this, please redirect me.
> I have a .NET application and SQL Server 2005 Express running on a Windows
> Server 2003 Web Edition. Both connect to a remote SQL Server 2000 database
> running on Windows 2000.
> SQL Server Express 2005 has the 2000 server set up as a linked server.
> What are my options for encrypting the connections to the SQL Server 2000?
> For the .NET app, I assume that I can use multiprotocol. Correct? Other
> suggestions?
> What about the SQL Server 2005 linked server to 2000?
> TIA
> --
> AG
> Email: discuss at adhdata dot com
>
>
|||Thanks for the quick response Plamen,
That all requires a SSL cert, which the 2000 server does not have.
Is there some way to use multiprotocol with the linked server?
The current setup is using a VPN, but we are moving to a new server and
there may be a problem setting up a VPN.
AG
Email: discuss at adhdata dot com
"Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
news:Oyn6mApKHHA.4992@.TK2MSFTNGP04.phx.gbl...
> SQL Server supports SSL encryption for connections. See the following
> articles:
> http://support.microsoft.com/kb/276553
> http://msdn2.microsoft.com/en-us/library/ms189067.aspx
> http://msdn2.microsoft.com/en-us/library/ms191192.aspx
> Regards,
> Plamen Ratchev
> http://www.SQLStudio.com
>
> "AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
> news:%23JeihNoKHHA.960@.TK2MSFTNGP04.phx.gbl...
>
|||The multiprotocol has been depreciated in SQL Server 2005. See this post for
details (look under the Changes section):
http://blogs.msdn.com/sql_protocols/archive/2005/09/22/473111.aspx
If you do not have a local Certificate Server you can always purchase a
third-party certificate.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23kAVctpKHHA.4384@.TK2MSFTNGP03.phx.gbl...
> Thanks for the quick response Plamen,
> That all requires a SSL cert, which the 2000 server does not have.
> Is there some way to use multiprotocol with the linked server?
> The current setup is using a VPN, but we are moving to a new server and
> there may be a problem setting up a VPN.
> --
> AG
> Email: discuss at adhdata dot com
>
> "Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
> news:Oyn6mApKHHA.4992@.TK2MSFTNGP04.phx.gbl...
>
|||Hello AG,
I agree with Plamen that you could use a third party certificate if
necessary.
Also, you may consider configure IPsec between the servers so that all IP
traffic is protected between them. Pleas esee the following articles for
more details:
TechNet Support WebCast: How to use IPSec to help secure network traffic
http://support.microsoft.com/default.aspx?kbid=888266
IPsec
http://www.microsoft.com/technet/network/ipsec/default.mspx
If you have further comments or feedback, please feel free to let's know.
Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thanks Peter,
Sorry, I did not get back to you sooner. I wanted to get the client's
networking person involved and that will happen today.
IPsec looks like it might do the job.
AG
Email: discuss at adhdata dot com
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:Jj1YdPvKHHA.2304@.TK2MSFTNGHUB02.phx.gbl...
> Hello AG,
> I agree with Plamen that you could use a third party certificate if
> necessary.
> Also, you may consider configure IPsec between the servers so that all IP
> traffic is protected between them. Pleas esee the following articles for
> more details:
> TechNet Support WebCast: How to use IPSec to help secure network traffic
> http://support.microsoft.com/default.aspx?kbid=888266
> IPsec
> http://www.microsoft.com/technet/network/ipsec/default.mspx
> If you have further comments or feedback, please feel free to let's know.
> Thank you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

Encrypted Connection

Hi all,
If this is not the correct groups to post this, please redirect me.
I have a .NET application and SQL Server 2005 Express running on a Windows
Server 2003 Web Edition. Both connect to a remote SQL Server 2000 database
running on Windows 2000.
SQL Server Express 2005 has the 2000 server set up as a linked server.
What are my options for encrypting the connections to the SQL Server 2000?
For the .NET app, I assume that I can use multiprotocol. Correct? Other
suggestions?
What about the SQL Server 2005 linked server to 2000?
TIA
AG
Email: discuss at adhdata dot comSQL Server supports SSL encryption for connections. See the following
articles:
http://support.microsoft.com/kb/276553
http://msdn2.microsoft.com/en-us/library/ms189067.aspx
http://msdn2.microsoft.com/en-us/library/ms191192.aspx
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23JeihNoKHHA.960@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> If this is not the correct groups to post this, please redirect me.
> I have a .NET application and SQL Server 2005 Express running on a Windows
> Server 2003 Web Edition. Both connect to a remote SQL Server 2000 database
> running on Windows 2000.
> SQL Server Express 2005 has the 2000 server set up as a linked server.
> What are my options for encrypting the connections to the SQL Server 2000?
> For the .NET app, I assume that I can use multiprotocol. Correct? Other
> suggestions?
> What about the SQL Server 2005 linked server to 2000?
> TIA
> --
> AG
> Email: discuss at adhdata dot com
>
>|||Thanks for the quick response Plamen,
That all requires a SSL cert, which the 2000 server does not have.
Is there some way to use multiprotocol with the linked server?
The current setup is using a VPN, but we are moving to a new server and
there may be a problem setting up a VPN.
AG
Email: discuss at adhdata dot com
"Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
news:Oyn6mApKHHA.4992@.TK2MSFTNGP04.phx.gbl...
> SQL Server supports SSL encryption for connections. See the following
> articles:
> http://support.microsoft.com/kb/276553
> http://msdn2.microsoft.com/en-us/library/ms189067.aspx
> http://msdn2.microsoft.com/en-us/library/ms191192.aspx
> Regards,
> Plamen Ratchev
> http://www.SQLStudio.com
>
> "AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
> news:%23JeihNoKHHA.960@.TK2MSFTNGP04.phx.gbl...
>|||The multiprotocol has been depreciated in SQL Server 2005. See this post for
details (look under the Changes section):
http://blogs.msdn.com/sql_protocols.../22/473111.aspx
If you do not have a local Certificate Server you can always purchase a
third-party certificate.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23kAVctpKHHA.4384@.TK2MSFTNGP03.phx.gbl...
> Thanks for the quick response Plamen,
> That all requires a SSL cert, which the 2000 server does not have.
> Is there some way to use multiprotocol with the linked server?
> The current setup is using a VPN, but we are moving to a new server and
> there may be a problem setting up a VPN.
> --
> AG
> Email: discuss at adhdata dot com
>
> "Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
> news:Oyn6mApKHHA.4992@.TK2MSFTNGP04.phx.gbl...
>|||Hello AG,
I agree with Plamen that you could use a third party certificate if
necessary.
Also, you may consider configure IPsec between the servers so that all IP
traffic is protected between them. Pleas esee the following articles for
more details:
TechNet Support WebCast: How to use IPSec to help secure network traffic
http://support.microsoft.com/default.aspx?kbid=888266
IPsec
http://www.microsoft.com/technet/ne...ec/default.mspx
If you have further comments or feedback, please feel free to let's know.
Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Peter,
Sorry, I did not get back to you sooner. I wanted to get the client's
networking person involved and that will happen today.
IPsec looks like it might do the job.
AG
Email: discuss at adhdata dot com
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:Jj1YdPvKHHA.2304@.TK2MSFTNGHUB02.phx.gbl...
> Hello AG,
> I agree with Plamen that you could use a third party certificate if
> necessary.
> Also, you may consider configure IPsec between the servers so that all IP
> traffic is protected between them. Pleas esee the following articles for
> more details:
> technet Support WebCast: How to use IPSec to help secure network traffic
> http://support.microsoft.com/default.aspx?kbid=888266
> IPsec
> http://www.microsoft.com/technet/ne...ec/default.mspx
> If you have further comments or feedback, please feel free to let's know.
> Thank you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

Encrypted Connection

Hi all,
If this is not the correct groups to post this, please redirect me.
I have a .NET application and SQL Server 2005 Express running on a Windows
Server 2003 Web Edition. Both connect to a remote SQL Server 2000 database
running on Windows 2000.
SQL Server Express 2005 has the 2000 server set up as a linked server.
What are my options for encrypting the connections to the SQL Server 2000?
For the .NET app, I assume that I can use multiprotocol. Correct? Other
suggestions?
What about the SQL Server 2005 linked server to 2000?
TIA
AG
Email: discuss at adhdata dot comSQL Server supports SSL encryption for connections. See the following
articles:
http://support.microsoft.com/kb/276553
http://msdn2.microsoft.com/en-us/library/ms189067.aspx
http://msdn2.microsoft.com/en-us/library/ms191192.aspx
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23JeihNoKHHA.960@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> If this is not the correct groups to post this, please redirect me.
> I have a .NET application and SQL Server 2005 Express running on a Windows
> Server 2003 Web Edition. Both connect to a remote SQL Server 2000 database
> running on Windows 2000.
> SQL Server Express 2005 has the 2000 server set up as a linked server.
> What are my options for encrypting the connections to the SQL Server 2000?
> For the .NET app, I assume that I can use multiprotocol. Correct? Other
> suggestions?
> What about the SQL Server 2005 linked server to 2000?
> TIA
> --
> AG
> Email: discuss at adhdata dot com
>
>|||Thanks for the quick response Plamen,
That all requires a SSL cert, which the 2000 server does not have.
Is there some way to use multiprotocol with the linked server?
The current setup is using a VPN, but we are moving to a new server and
there may be a problem setting up a VPN.
AG
Email: discuss at adhdata dot com
"Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
news:Oyn6mApKHHA.4992@.TK2MSFTNGP04.phx.gbl...
> SQL Server supports SSL encryption for connections. See the following
> articles:
> http://support.microsoft.com/kb/276553
> http://msdn2.microsoft.com/en-us/library/ms189067.aspx
> http://msdn2.microsoft.com/en-us/library/ms191192.aspx
> Regards,
> Plamen Ratchev
> http://www.SQLStudio.com
>
> "AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
> news:%23JeihNoKHHA.960@.TK2MSFTNGP04.phx.gbl...
>|||The multiprotocol has been depreciated in SQL Server 2005. See this post for
details (look under the Changes section):
http://blogs.msdn.com/sql_protocols.../22/473111.aspx
If you do not have a local Certificate Server you can always purchase a
third-party certificate.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23kAVctpKHHA.4384@.TK2MSFTNGP03.phx.gbl...
> Thanks for the quick response Plamen,
> That all requires a SSL cert, which the 2000 server does not have.
> Is there some way to use multiprotocol with the linked server?
> The current setup is using a VPN, but we are moving to a new server and
> there may be a problem setting up a VPN.
> --
> AG
> Email: discuss at adhdata dot com
>
> "Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
> news:Oyn6mApKHHA.4992@.TK2MSFTNGP04.phx.gbl...
>

encrypt data in database

Hi,

I have a .net application and i added a code that encrypts data saved in database. However, there is already data in the fields that was entered before this change.
I know need to check if the values in those fields are encrypted and if not i need to encrypt them.
How can I perform such a check and update the relevant data?
I use TrippleDES in .net to encrypt/decrypt the data.

Thanks

Have a look at this article:

http://aspnet.4guysfromrolla.com/articles/081705-1.aspx

Encrypt argument does not work in SqlConnection.ConnectionString?

Is "Encrypt" not support in Compact Framework 2.0 SqlConnection string?

Trying to connect to sql2005 db using SSL from WM5/.net 2.0 pda and am receiving the below error. I can connect fine w/o the "encrypt" argument and the same connection string with "encrypt" connects fine from XP workstation to sql db w/SSL.

"Unknown connection option in connection string: encrypt."

Connection String I used:

sqlConnection = newSqlConnection("Data Source=mysqlserver;Initial Catalog=sometable;UID=username;PWD=Password;Encrypt=true;");

Thanks,

Jim

Hello everybody

I have the same problem. I'm using mobile PC with WinCE 4.2 on board. And I need the connection to be encrypted. How can I make this? The CF1.0/2.0 doesn't allow this feature. :(

Also I can use the VPN connection. But my device doesn't have this function (the function is present in disable mode). May be there is another application that realize VPN for WinCE 4.2?

Thank you.

Best regards,

Sergey

|||

This works in my code. I'm showing you the function that calls GetConnectionString so you'll see where the string is being passed.

PublicSharedFunction GetConnection(ByVal strDatabaseName AsString) As SqlCeConnection

Dim cn As SqlCeConnection

cn = New SqlCeConnection(GetConnectionString(strDatabaseName))

Return cn

EndFunction

PublicSharedFunction GetConnectionString(ByVal strDatabaseName AsString) AsString

Return"Data Source=" & strDatabaseName & ";SSCE:Database Password=xxxxxxxx;SSCE:Encrypt Database=True"

EndFunction

|||

Why did you write the 'ssce' near connection string properties? Is it rule or something else?

Also, I need connect to the Sql Server on the host (not mobile sql server) and I use the SqlConnection class for it. Can I use such connection string? I didn't find the information in the msdn about its description.

Sorry, but I can't check your advise now and see the result, I'm away from my workstation. That is why I want to know more. And I'll check it latter.

|||

To Clearify - I'm trying to encrypt the sql connection to the host using, not to a local installation of SQL Mobile. I believe a couple of replies address encrypting data or the database of a local sql mobile db.

Jim

|||Sorry, I did not notice you were not using sqlce.|||This means that Encrypt is not supported in Compact Framework 2.0 SqlClient.SqlConnection|||

This code sample does not work on a WM 5 device with cf 2.0 but works ok if "Encrypt=true" is removed. Am I doing something wrong? Same code works fine on XP with .Net 2.0 when connecting to same ssl enabled sql server. How can I encrypt a sql connection from pda to sql server?

Thanks,

Jim

sqlConnection = new SqlConnection("Data Source=someSql2005Server;Initial Catalog=someSqlTable;"

+ "UID=myUsername;PWD=somePassword;Encrypt=true");

|||The compact framework is not the full .NET framework. Some features are disabled or just not implemented. If you get an error that the connection could not be established because of the encrypt feature not being available it's just not implemented!

Encrypt argument does not work in SqlConnection.ConnectionString?

Is "Encrypt" not support in Compact Framework 2.0 SqlConnection string?

Trying to connect to sql2005 db using SSL from WM5/.net 2.0 pda and am receiving the below error. I can connect fine w/o the "encrypt" argument and the same connection string with "encrypt" connects fine from XP workstation to sql db w/SSL.

"Unknown connection option in connection string: encrypt."

Connection String I used:

sqlConnection = new SqlConnection("Data Source=mysqlserver;Initial Catalog=sometable;UID=username;PWD=Password;Encrypt=true;");

Thanks,

Jim

Hello everybody

I have the same problem. I'm using mobile PC with WinCE 4.2 on board. And I need the connection to be encrypted. How can I make this? The CF1.0/2.0 doesn't allow this feature. :(

Also I can use the VPN connection. But my device doesn't have this function (the function is present in disable mode). May be there is another application that realize VPN for WinCE 4.2?

Thank you.

Best regards,

Sergey

|||

This works in my code. I'm showing you the function that calls GetConnectionString so you'll see where the string is being passed.

Public Shared Function GetConnection(ByVal strDatabaseName As String) As SqlCeConnection

Dim cn As SqlCeConnection

cn = New SqlCeConnection(GetConnectionString(strDatabaseName))

Return cn

End Function

Public Shared Function GetConnectionString(ByVal strDatabaseName As String) As String

Return "Data Source=" & strDatabaseName & ";SSCE:Database Password=xxxxxxxx;SSCE:Encrypt Database=True"

End Function

|||

Why did you write the 'ssce' near connection string properties? Is it rule or something else?

Also, I need connect to the Sql Server on the host (not mobile sql server) and I use the SqlConnection class for it. Can I use such connection string? I didn't find the information in the msdn about its description.

Sorry, but I can't check your advise now and see the result, I'm away from my workstation. That is why I want to know more. And I'll check it latter.

|||

To Clearify - I'm trying to encrypt the sql connection to the host using, not to a local installation of SQL Mobile. I believe a couple of replies address encrypting data or the database of a local sql mobile db.

Jim

|||Sorry, I did not notice you were not using sqlce.|||This means that Encrypt is not supported in Compact Framework 2.0 SqlClient.SqlConnection|||

This code sample does not work on a WM 5 device with cf 2.0 but works ok if "Encrypt=true" is removed. Am I doing something wrong? Same code works fine on XP with .Net 2.0 when connecting to same ssl enabled sql server. How can I encrypt a sql connection from pda to sql server?

Thanks,

Jim

sqlConnection = new SqlConnection("Data Source=someSql2005Server;Initial Catalog=someSqlTable;"

+ "UID=myUsername;PWD=somePassword;Encrypt=true");

|||The compact framework is not the full .NET framework. Some features are disabled or just not implemented. If you get an error that the connection could not be established because of the encrypt feature not being available it's just not implemented!

Empty reports

In my ASP.Net application, I need to give the user an error message when
a report is empty. Sometimes there is an exception that gets thrown and
sometimes there is not. How can I tell if the stream coming back from
RS contains an empty report?In most cases even if the report contains no data the stream isn´t empty
(PDF,ect). Did you try to get a stream back that based on the CSV format ?
It don´t now whether there will be a zero byte stream returned back by the
report server, but that should be the stream with the least overhead. If you
know how many bytes an empty report contains, you could also check the size
of the stream to evaluate the minimun for it and then throw an exception if
it is below o equeals that minimun level.
(If you got your own Data service provider, but I think that isn´t in your
case you could check for the rows in the tabes of the dataset you are
apssing to the report)
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"No One" <aintnoway@.blahblahblah.com> schrieb im Newsbeitrag
news:hlmnl2-ii3.ln1@.gandalf.grey-net.com...
> In my ASP.Net application, I need to give the user an error message when a
> report is empty. Sometimes there is an exception that gets thrown and
> sometimes there is not. How can I tell if the stream coming back from RS
> contains an empty report?|||There is a "No Rows" property on the table which allows the developer to
specify a string to display if no rows of data are available.
"No One" <aintnoway@.blahblahblah.com> wrote in message
news:hlmnl2-ii3.ln1@.gandalf.grey-net.com...
> In my ASP.Net application, I need to give the user an error message when
> a report is empty. Sometimes there is an exception that gets thrown and
> sometimes there is not. How can I tell if the stream coming back from
> RS contains an empty report?|||I don't want to return a "No Rows" file. I want to display that on the
browser without trying to send the user a file at all.
Jason wrote:
> There is a "No Rows" property on the table which allows the developer to
> specify a string to display if no rows of data are available.
> "No One" <aintnoway@.blahblahblah.com> wrote in message
> news:hlmnl2-ii3.ln1@.gandalf.grey-net.com...
>>In my ASP.Net application, I need to give the user an error message when
>>a report is empty. Sometimes there is an exception that gets thrown and
>>sometimes there is not. How can I tell if the stream coming back from
>>RS contains an empty report?
>
>

Emps working Hrs. <CrossTab> ..

hello all

i'm really confused .. i use VS 2005, VB.NET, Crystal Reports and SQL Server Studio Managment as my DB..

My problem is i dont know where do i have to implement this report i want to produce .. its working hours for all employees showing by month ...

ex:

Jan-07 Feb-07 March-07 ......HrsSUM

joe 54 50 88 sum(hrs)

Sam 20 20 50 sum(hrs)

note : it doesnt always starts at jan-07 ... we have a "cut off date" which is the calculations start date till the end of the project (2010)

so its a crosstab query ... should i do that using crystal report , writing a function there to generate the months and create a crosstable ?(no idea how to do that).... or writing a VB code and pass it to the report ?

or just create a stored procedure in the DB to do that ?

i think the last one is wt should do it ... but i still dont know how

any help plz ,,,,,,,,

I would create a query to sum all the hours for each employee by month.

Then use crystal reports to generate the crosstab report and summation.