MSDE Installation

[mmatsumura]

Hello,

I have been having a problem and am hoping that someone provides me the resolution.

My goal is to deploy MSDE to employees that do not have it. I've been following the instruction as either on-line provided help sites, WebCast movies and books, but haven't been able to get things to work. The language I have trying to been using is VB.Net which is very, very new for me. In an article I've read from Microsoft titled "Embedding MSDE 2000 Setup into the Setup of Custom Applications" had a FAQ section which happens mention exactly my problem. Below I will show you what is written:

*****
Q: My application is unable to connect to MSDE 2000. I receive an error message that says that the connection attempted is not a trusted connection. How can I fix that?

A: This occurs because MSDE 2000 uses Windows authentication by default. Windows authentication is more secure than SQL Server authentication. You must alter code within your custom application to use the secure login to overcome this error rather than using SQL Server authentication.
*****

So, this is where I am having an understanding problem. What code would I need to alter and how??? I really hope that someone would send me a plain-text answer rather that links to Web pages.


Thank You!

 

[jalbao]

Hi mmatsumura,

Were you able to solve this problem?

If so, please post your solution - I am dealing with the same issue.

 

[chiph]

You would change the connect string your application uses to connect to the database to include INTEGRATED SECURITY=SSPI; and not pass in a UID and/or PWD values (those are for the old SQLServer style authentication).

The format of the connection string changed in ADO.NET. You can read more in your helpfile at:
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/cpref/html/frlrfSystemDataSqlClientSqlConnectionClassConnectionStringTopic.htm

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first