Not associated with a trusted Sql Server connection?

[wangdong]

VB.NET 2003
MSDE

I am using the following code as the sql server connection string.

 strconn = "Data Source=" & "erp" & _
           ";User ID=" & "erpsa" & _
           ";Password=" & "erpsa" & _
           ";Persist Security Info=True" & _
           ";Catalog=" & "erpdata" & ";"

But, it always pops up a error message says "Login failed for user "sa". Not associated with a trusted Sql Server connection.

Anyone knows the problem?

Thank you.


Chinese Java Faq Forum

http://www.4ugo.com/bbs/index.asp

 

[chrissie1]

how is MSDE setup? if it is on only windows authentication you will have to set it to windows authentication and sql server authentication.

Did you add that user to the database and gave it permissions?

Christiaan Baes
Belgium

"My new site" - Me

 

[wangdong]

Here is the script that I run to install MSDE.

setup /settings "setup.ini" SAPWD="aaaa" /L*v C:/MSDELog.log

Anything wrong with that?

How do I know if sa has already exist in the system? I think the sa is a default user account for login on to the sql server, likes oracle has a scott as a default account.

Chinese Java Faq Forum

http://www.4ugo.com/bbs/index.asp