SQL Connection help needed
- From: "Backwards" <Andrew@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: 19 Apr 2006 02:09:35 -0700
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
.
- Follow-Ups:
- Re: SQL Connection help needed
- From: Marina Levit [MVP]
- Re: SQL Connection help needed
- Prev by Date: Re: Emailing with default client
- Next by Date: Crystal Reports not in VB .NET 2003 Standard
- Previous by thread: button with drop down
- Next by thread: Re: SQL Connection help needed
- Index(es):