Re: SQL Connection help needed

This means you can't run the stored procedure if you connect using
integrated and running as yourself.

You need to either:
1) run as this other user, meaning their NT login, so windows auth works
2) Have your DB Admin give your NT login access to the stored procedure
3) Not use windows auth, but use a SQL login, that does have access to the
stored procedure

Since, I doubt #1 is an option here, it's really up to your DB admin to do
some work and give you access in some way to the stored procedure.

"Backwards" <Andrew@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1145437775.650278.321540@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm using visual studio 2005 and SQL 2000, trying to connect to a sql
database as a differnent user.

Here is my current connection string that is using my own NT login:

Dim message As String = "Data Source=" +
Me.ComboBox1.Text.ToString() + ";Initial Catalog=Store;Integrated
Security=SSPI"
Dim sql As New SqlClient.SqlConnection(message)

sql.Open()

I have access to this database and the connection establishes fine.
However i dont have access to certain Stored Procedure's on this
database and these run through a differnt NT user.

I dont have access to a SQL user name and password so i cant hardcode
the "sa" login instead.

Does anyone know if i can change my connection string above to use
another windows/NT login?

Awaiting reply,
Andy



.

Relevant Pages