I am reading the "Beginning ASP 3.0" and I am in chapter 12, page 475. In Try It Out there is a SQL SERVER connection string that is not working. I take an error page when I am trying to run the page. The error "Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."

The connection String:

"Provider=SQLOLEDB;Persist Security Info=False;" &_
"UID=sa;Initial Catalog=Movie;" &_
"Initial File Name=C:\Program Files\Microsoft SQL Server\MSSQL\Data\Movie2000.mdf"

What is wrong? It is very annoying when I follow the instructions as somebody tells me and then it is not working.
I have winxp SP2 with IIS 5.1 and an MSDE 2000 that I have installed it from MS OFFICE XP CD

I think you missed out the pwd word in the syntex
Try this

Provider=SQLOLEDB;Persist Security Info=False;" &_
"UID=sa;pwd=;Initial Catalog=Movie;" &_
"Initial File Name=C:\Program Files\Microsoft SQL Server\MSSQL\Data\Movie2000.mdf"

But if have passord for sa then type it against pwd

How do you find the User ID and Password? I have the same issue. Only have MSDE installed

It all depends on how you installed the SQL Server. To make it simple to connect from the IIS on the local PC, my SQL Server is a 'local' with Windows authentiation. Then I created a DSN for SQL Server database (see PP. 488 to 492). Finally, code objConn.Open "DSN=SQLdsnName" , instead of a strConnect/DataStore.asp SSI connection.

It worked well for me on Movie2000 SQL Server database, which I imported from the Access Movie2000.

C. Jeffrey Wang