janice

I have used various connection strings to connect to sql server db.
Recently, management decided we should be using ssp1 security method.
Here is the entire syntax:
emailDB.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=sumpta;Data Source=mystarts"

I have the database security mode set as "mixed mode" which is sql server and windows.
On the startup service account, I selected System Account.
Then I created a user account that authentics through windows domain user account.
So far, I have had no luck connecting to sql server database.
I keep getting this error:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'PUBLIC-404GV86P\IUSR_mystarts'.

What do I need to do to use this connection method?
Thanks in advance

DrMike

The error messgae sounds likt the username/password are incorrect, the code looks fine