How to connect as guest?
From: Tumurbaatar S. (nospam_tumur_at_magicnet.mn)
Date: 11/22/04
- Next message: maryam rezvani: "Re: SP **"
- Previous message: Eniko Tegen: "Re: dynamically create a column"
- Next in thread: Tibor Karaszi: "Re: How to connect as guest?"
- Reply: Tibor Karaszi: "Re: How to connect as guest?"
- Reply: Rand Boyd [MSFT]: "RE: How to connect as guest?"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: maryam rezvani: "Re: SP **"
- Previous message: Eniko Tegen: "Re: dynamically create a column"
- Next in thread: Tibor Karaszi: "Re: How to connect as guest?"
- Reply: Tibor Karaszi: "Re: How to connect as guest?"
- Reply: Rand Boyd [MSFT]: "RE: How to connect as guest?"
- Messages sorted by: [ date ] [ thread ]