ASP Connection String for Privileged Account

[sucaba.r]

I don't know if this is a unique problem, or I'm going about it the
wrong way. I currently connect to one of our SQL servers via a
priviliged account (by using RUNAS). Works with no problem. I now
need the ability to connect to the same SQL server using ASP. I have
the following connect string, but I'm not sure how to specify the
domain in the string, or is there some other way?

<%
Set demoConn = Server.CreateOb ject("ADODB.Con nection")
demoPath="DRIVE R={SQL Server};" & _
"SERVER=mysqlse rver;UID=myuser name;" & _
"PWD=mypassword #;DATABASE=qdb"
demoConn.open demoPath
%>

Thanks!

[Bob Barrows [MVP]]

su******@gmail. com wrote:

Aha! Now I can see the logon credentials. Per your suggestion, I
tried to write.response my connect string, but got the same error.
Here's what I tried:

response.write demopath

So what was the result?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[sucaba.r]

I'm not sure the response.write worked but here's the output:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

/test3.asp, line 6
Bob Barrows [MVP] wrote:

su******@gmail. com wrote:

Aha! Now I can see the logon credentials. Per your suggestion, I
tried to write.response my connect string, but got the same error.
Here's what I tried:

response.write demopath

So what was the result?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Bob Barrows [MVP]]

Assign the connection string to a variable and response.write the contents
of that variable:

dim constr
constr="provide r= ..."
response.write constr
response.end
dim cn
etc

su******@gmail. com wrote:

I'm not sure the response.write worked but here's the output:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

/test3.asp, line 6
Bob Barrows [MVP] wrote:

su******@gmail. com wrote:

Aha! Now I can see the logon credentials. Per your suggestion, I
tried to write.response my connect string, but got the same error.
Here's what I tried:

response.write demopath

So what was the result?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[sucaba.r]

Obviously I'm doing something wrong. Here's my code:

<%
dim demopath
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB;" & _
"Data Source=enpefrqd b01;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
response.write demopath
response.end
%>

BTW, thanks for all the help Bob.
Bob Barrows [MVP] wrote:

Assign the connection string to a variable and response.write the contents
of that variable:

dim constr
constr="provide r= ..."
response.write constr
response.end
dim cn
etc

su******@gmail. com wrote:

I'm not sure the response.write worked but here's the output:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

/test3.asp, line 6
Bob Barrows [MVP] wrote:

su******@gmail. com wrote:
Aha! Now I can see the logon credentials. Per your suggestion, I
tried to write.response my connect string, but got the same error.
Here's what I tried:

response.write demopath

So what was the result?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Bob Barrows [MVP]]

Move the Open statement to a line that follows the response.end statment
su******@gmail. com wrote:

Obviously I'm doing something wrong. Here's my code:

<%
dim demopath
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB;" & _
"Data Source=enpefrqd b01;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
response.write demopath
response.end
%>

BTW, thanks for all the help Bob.
Bob Barrows [MVP] wrote:

Assign the connection string to a variable and response.write the
contents of that variable:

dim constr
constr="provide r= ..."
response.write constr
response.end
dim cn
etc

su******@gmail. com wrote:

I'm not sure the response.write worked but here's the output:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

/test3.asp, line 6
Bob Barrows [MVP] wrote:
su******@gmail. com wrote:
> Aha! Now I can see the logon credentials. Per your suggestion, I
> tried to write.response my connect string, but got the same error.
> Here's what I tried:
>
> response.write demopath
>
So what was the result?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will
get
a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Bob Barrows [MVP]]

su******@gmail. com wrote:

Obviously I'm doing something wrong. Here's my code:

<%
dim demopath
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB;" & _
"Data Source=enpefrqd b01;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
response.write demopath
response.end
%>

BTW, thanks for all the help Bob.

Ask yourself:
Which line of code is raising the error?
Then
Which line of code do I want to prevent from being executed by using
response.end?

The solution should be obvious ... :-)
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[sucaba.r]

Doh! Sorry 'bout that. Here's the output:

Provider=SQLOLE DB;Data Source=xxxx01;I ntegrated Security=SSPI;I nitial
Catalog=qdb

Bob Barrows [MVP] wrote:

Move the Open statement to a line that follows the response.end statment
su******@gmail. com wrote:

Obviously I'm doing something wrong. Here's my code:

<%
dim demopath
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB;" & _
"Data Source=enpefrqd b01;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
response.write demopath
response.end
%>

BTW, thanks for all the help Bob.
Bob Barrows [MVP] wrote:

Assign the connection string to a variable and response.write the
contents of that variable:

dim constr
constr="provide r= ..."
response.write constr
response.end
dim cn
etc

su******@gmail. com wrote:
I'm not sure the response.write worked but here's the output:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

/test3.asp, line 6
Bob Barrows [MVP] wrote:
> su******@gmail. com wrote:
>> Aha! Now I can see the logon credentials. Per your suggestion, I
>> tried to write.response my connect string, but got the same error.
>> Here's what I tried:
>>
>> response.write demopath
>>
> So what was the result?
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will
> get
> a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Bob Barrows [MVP]]

Well, there's something wrong here. Your line of code is:

"Data Source=enpefrqd b01;Integrated Security=SSPI;" & _

But the result of Response.Write is:

Data Source=xxxx01;I ntegrated Security=SSPI
I doubt your server is really called "xxxx01" is it?

su******@gmail. com wrote:

Doh! Sorry 'bout that. Here's the output:

Provider=SQLOLE DB;Data Source=xxxx01;I ntegrated Security=SSPI;I nitial
Catalog=qdb

Bob Barrows [MVP] wrote:

Move the Open statement to a line that follows the response.end
statment su******@gmail. com wrote:

Obviously I'm doing something wrong. Here's my code:

<%
dim demopath
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB;" & _
"Data Source=enpefrqd b01;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
response.write demopath
response.end
%>

BTW, thanks for all the help Bob.
Bob Barrows [MVP] wrote:
Assign the connection string to a variable and response.write the
contents of that variable:

dim constr
constr="provide r= ..."
response.write constr
response.end
dim cn
etc

su******@gmail. com wrote:
> I'm not sure the response.write worked but here's the output:
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
>
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
> or access denied.
>
> /test3.asp, line 6
>
>
> Bob Barrows [MVP] wrote:
>> su******@gmail. com wrote:
>>> Aha! Now I can see the logon credentials. Per your
>>> suggestion, I tried to write.response my connect string, but
>>> got the same error. Here's what I tried:
>>>
>>> response.write demopath
>>>
>> So what was the result?
>> --
>> Microsoft MVP -- ASP/ASP.NET
>> Please reply to the newsgroup. The email account listed in my
>> From header is my spam trap, so I don't check it very often. You
>> will get
>> a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap
so I don't check it very often. If you must reply off-line, then
remove the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[sucaba.r]

No, I just x'd out the server name.

Bob Barrows [MVP] wrote:

Well, there's something wrong here. Your line of code is:

"Data Source=enpefrqd b01;Integrated Security=SSPI;" & _

But the result of Response.Write is:

Data Source=xxxx01;I ntegrated Security=SSPI
I doubt your server is really called "xxxx01" is it?

su******@gmail. com wrote:

Doh! Sorry 'bout that. Here's the output:

Provider=SQLOLE DB;Data Source=xxxx01;I ntegrated Security=SSPI;I nitial
Catalog=qdb

Bob Barrows [MVP] wrote:

Move the Open statement to a line that follows the response.end
statment su******@gmail. com wrote:
Obviously I'm doing something wrong. Here's my code:

<%
dim demopath
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB;" & _
"Data Source=enpefrqd b01;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
response.write demopath
response.end
%>

BTW, thanks for all the help Bob.
Bob Barrows [MVP] wrote:
> Assign the connection string to a variable and response.write the
> contents of that variable:
>
> dim constr
> constr="provide r= ..."
> response.write constr
> response.end
> dim cn
> etc
>
> su******@gmail. com wrote:
>> I'm not sure the response.write worked but here's the output:
>>
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>>
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
>> or access denied.
>>
>> /test3.asp, line 6
>>
>>
>> Bob Barrows [MVP] wrote:
>>> su******@gmail. com wrote:
>>>> Aha! Now I can see the logon credentials. Per your
>>>> suggestion, I tried to write.response my connect string, but
>>>> got the same error. Here's what I tried:
>>>>
>>>> response.write demopath
>>>>
>>> So what was the result?
>>> --
>>> Microsoft MVP -- ASP/ASP.NET
>>> Please reply to the newsgroup. The email account listed in my
>>> From header is my spam trap, so I don't check it very often. You
>>> will get
>>> a quicker response by posting to the newsgroup.
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap
> so I don't check it very often. If you must reply off-line, then
> remove the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Bob Barrows [MVP]]

In that case, the information in the aspfaq article I cited earlier is
relevant. Make sure to read the KB articles it links to.

Let us know how you make out.

su******@gmail. com wrote:

No, I just x'd out the server name.

Bob Barrows [MVP] wrote:

Well, there's something wrong here. Your line of code is:

"Data Source=enpefrqd b01;Integrated Security=SSPI;" & _

But the result of Response.Write is:

Data Source=xxxx01;I ntegrated Security=SSPI
I doubt your server is really called "xxxx01" is it?

su******@gmail. com wrote:

Doh! Sorry 'bout that. Here's the output:

Provider=SQLOLE DB;Data Source=xxxx01;I ntegrated
Security=SSPI;I nitial Catalog=qdb

Bob Barrows [MVP] wrote:
Move the Open statement to a line that follows the response.end
statment su******@gmail. com wrote:
> Obviously I'm doing something wrong. Here's my code:
>
> <%
> dim demopath
> Set demoConn = CreateObject("A DODB.Connection ")
> demoPath="Provi der=SQLOLEDB;" & _
> "Data Source=enpefrqd b01;Integrated Security=SSPI;" & _
> "Initial Catalog=qdb"
> demoConn.open demoPath
> response.write demopath
> response.end
> %>
>
> BTW, thanks for all the help Bob.
>
>
> Bob Barrows [MVP] wrote:
>> Assign the connection string to a variable and response.write the
>> contents of that variable:
>>
>> dim constr
>> constr="provide r= ..."
>> response.write constr
>> response.end
>> dim cn
>> etc
>>
>> su******@gmail. com wrote:
>>> I'm not sure the response.write worked but here's the output:
>>>
>>> Microsoft OLE DB Provider for SQL Server error '80004005'
>>>
>>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
>>> or access denied.
>>>
>>> /test3.asp, line 6
>>>
>>>
>>> Bob Barrows [MVP] wrote:
>>>> su******@gmail. com wrote:
>>>>> Aha! Now I can see the logon credentials. Per your
>>>>> suggestion, I tried to write.response my connect string, but
>>>>> got the same error. Here's what I tried:
>>>>>
>>>>> response.write demopath
>>>>>

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"