How to connect as guest?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tumurbaatar S. (nospam_tumur_at_magicnet.mn)
Date: 11/22/04


Date: Mon, 22 Nov 2004 15:14:48 +0800

I tried 2 variants of ADO connection string, but connection fails:
1. Provider=sqloledb; Network Library=DBMSSOCN; Initial Catalog=Services;
User ID=guest; Data Source=127.0.0.1,1433;
2. Provider=sqloledb; Network Library=DBMSSOCN; Initial Catalog=Services;
Data Source=127.0.0.1,1433;

The Services db has guest account created as "EXEC sp_grantdbaccess guest",
but the guest does not have any permissions.

P.S. I use guest account only to access the db, but just after my
app switches to application role.