Login failed for user 'sa'
Posted on 2004-09-26
I am following a example in a book. It is dealing with ASP, which covers this area well, but gives very little explanatin on installing sql 2000
I am using msde version, and installed it, it did not ask for a user, and so I am using the default - where do I go to check the user
with the asp snippet as such:
objConn.Open "Provider=SQLOLEDB;Persist Security Info=False;" & _
"User ID=sa;Initial Catalog=Movie;" & _
"Initial File Name=C:\MSSQL7\Database\Movie2000.mdf"
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
i really do not know where to go to fix this