Check that your MSDE is accepting "Mixed Authentication" (SQL Server and
Windows) instead of Windows authentication (You need SQL Enterprise Manager
for that).I have got that same error with SQL Server when trying to use db
with "sa" user and SQL accepted only Windows users.

And BTW, with IP-based DB it's not a good idea to use file names in
connection string.
Change it to something like:"Provider=SQLOLEDB;Persist Security Info=False;"
& _
		"User ID=sa;Initial Catalog=subrep;" & _
		"Data Source=ip_to_your_db_or_machinename_if_on_lan"

I have noticed that if you use file names in connection string with SQL
Server, you are able to use the db only with "sa" user. If you later change
the user to something else (which is appropriate), you have problems.

Teemu Keiski


-----Alkuperäinen viesti-----
Lähettäjä: Eric [mailto:eric@d...]
Lähetetty: 20. huhtikuuta 2002 4:24
Vastaanottaja: ASP Database Setup
Aihe: [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=SQLOLEDB;Persist Security Info=False;" & _
		"User ID=sa;Initial Catalog=subrep;" & _
		"Initial File Name = 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
%%email.unsub%%