using Integrated Security SSPI with User ID
- From: kenglish_hi@xxxxxxxxx
- Date: 9 May 2005 18:25:36 -0700
Aloha,
I'm writing a desktop/Windows application using VB.net (MSDE 2003).
I'm trying to use integrated security with a User Id and password to
connect to a SQL Server. The SQL Server administrators insist that I
use intergrated security rather than create an account within the SQL
Server. They've made one windows account and they want my application
to log into the SQL server using that windows account. However, when I
use the intergrated security option in the connection string, the
application fails to connect. The error generated makes it clear that
the application is trying to connect as the Windows user that is using
the application and NOT the user that I have specified in the connect
string.
This is my current connect string:
Integrated Security=SSPI;Persist Security Info=False;Data
Source=MY_SQLSERVER_NAME;Initial Catalog=MY_DB_NAME;User
ID=MY_DB_USER_ID;Password=MY_DB_PASSWORD
First of all, is it possible to specify a User ID and Password when
using "Integrated Security"? If not, does anyone have a way to
accomodate the scenario I describe?
Kevin English
Honolulu, HI
.
- Follow-Ups:
- Re: using Integrated Security SSPI with User ID
- From: Pablo Castro [MS]
- Re: using Integrated Security SSPI with User ID
- From: Sahil Malik [MVP]
- Re: using Integrated Security SSPI with User ID
- Prev by Date: Re: Insert copy auto_increment to another column
- Next by Date: Re: using Integrated Security SSPI with User ID
- Previous by thread: Adding columns in a dataset
- Next by thread: Re: using Integrated Security SSPI with User ID
- Index(es):
Relevant Pages
|
