Not associated with a trusted SQL server connection

• Lai John Zhen

  SSC Enthusiast

  Points: 123

  More actions

  October 20, 2005 at 6:27 pm

  #363982

   

   Why I had create a new database user, and assign a login name and password to the new user.But when I run the project the error still come out.

   

      <add key="ConnectionStringNECnet" value="server=Mypesrvnet02;database=NECNetGateway;uid=zhen;pwd=123456;" /> 

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  October 20, 2005 at 8:06 pm

  #599003

  The SQL Server could be configured to only allow Window Accounts to connect and not allow SQL Server accounts.

  Are you using the MSDE edition ? If so, integrated security is the default.

  To set up Mixed Mode security using Enterprise Manager:

  Right-click a server, and then click Properties.

  Click the Security tab.

  Under Authentication, click SQL Server and Windows.

  SQL = Scarcely Qualifies as a Language

• Lai John Zhen

  SSC Enthusiast

  Points: 123

  More actions

  October 20, 2005 at 8:49 pm

  #599004

  I am using developer edition for MS SQL server.Did the way I create a new database user wrong or mistake.I create a new user on that database then I check the Windows Authentication , and Security access (I check the Grant access)