Hello!

You can change the authentication to "SQL Server and Windows" by 
changing this registry setting:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer=09

LoginMode =3D 1	Then MSDE uses "Windows Only"
LoginMode =3D 2	Then MSDE uses "SQL Server and Windows"

Regards
Martin

-----Ursprungligt meddelande-----
Fr=E5n: Eric [mailto:eric@d...]
Skickat: den 20 april 2002 06:24
Till: ASP Database Setup
=C4mne: [asp_database_setup] MSDE Assistance: Login failed for user 
'sa'. Reason: Not associated with a trusted SQL Server connection.


Good evening,

I am attempting to Upsize an Access DB to MSDE in preparation for the
eventual migration to SQL Server.

In attempting to access the DB via ASP I am receiving the following 
error:

Microsoft OLE DB Provider for SQL Server error '80004005'

Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.

/7275957373/db/datastore.asp, line 37

My connection object is the following:

objConn.Open 	"Provider=3DSQLOLEDB;Persist Security Info=3DFalse;" & _
		"User ID=3Dsa;Initial Catalog=3Dsubrep;" & _
		"Initial File Name =3D C:\Program Files\Microsoft SQL
Server\MSSQL\Data\subrepSQL.mdf"


Can someone please tell me how I would go about resolving this problem?

I am running on a WinXP machine and the DB is located on a W2K Server
running IIS across a Local Network.

Thanks much for any and all assistance.

Regards,
Eric
martin.axelsson@k... 
%%email.unsub%%