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:

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?
First, you need to turn off Anonymous access in your website's Directory
Security settings using IIS Manager.

<%
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!

http://www.aspfaq.com/show.asp?id=2126

--
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"

[Egbert Nierop \(MVP for IIS\)]

<su******@gmail .com> wrote in message
news:11******** **************@ c74g2000cwc.goo glegroups.com.. .

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
%>

This might work perfect. Including the tip Bob gave.

<%
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB" & _
"Data Source=mysqlser ver;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
%>
--
compatible web farm Session replacement for Asp and Asp.Net
http://www.nieropwebconsult.nl/asp_session_manager.htm

[Bob Barrows [MVP]]

Hopefully one of these search results will help:
http://groups.google.com/groups?as_q...=2006&safe=off

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

I tried your suggestion but got the following error:

Provider cannot be found. It may not be properly installed.

This might work perfect. Including the tip Bob gave.

<%
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB" & _
"Data Source=mysqlser ver;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
%>

--
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]]

More to the point:
http://support.microsoft.com/kb/q278604/
su******@gmail. com wrote:

I tried your suggestion but got the following error:

Provider cannot be found. It may not be properly installed.

This might work perfect. Including the tip Bob gave.

<%
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB" & _
"Data Source=mysqlser ver;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
%>

--
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 tried your suggestion but got the following error:

Provider cannot be found. It may not be properly installed.

This might work perfect. Including the tip Bob gave.

<%
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB" & _
"Data Source=mysqlser ver;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
%>

[sucaba.r]

Thanks Bob. I thought I had a syntax problem instead of a provider
problem.

Bob Barrows [MVP] wrote:

More to the point:
http://support.microsoft.com/kb/q278604/
su******@gmail. com wrote:

I tried your suggestion but got the following error:

Provider cannot be found. It may not be properly installed.

This might work perfect. Including the tip Bob gave.

<%
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB" & _
"Data Source=mysqlser ver;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
%>

--
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]

Okay, I registered the dll, but still getting the same error.

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

Thanks Bob. I thought I had a syntax problem instead of a provider
problem.

Bob Barrows [MVP] wrote:

More to the point:
http://support.microsoft.com/kb/q278604/
su******@gmail. com wrote:

I tried your suggestion but got the following error:

Provider cannot be found. It may not be properly installed.

> This might work perfect. Including the tip Bob gave.
>
> <%
> Set demoConn = CreateObject("A DODB.Connection ")
> demoPath="Provi der=SQLOLEDB" & _
> "Data Source=mysqlser ver;Integrated Security=SSPI;" & _
> "Initial Catalog=qdb"
> demoConn.open demoPath
> %>

--
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]

Okay, stupid question, but I just realized that I'm not sure I
registered the dll on the right machine. Do I register on the SQL
server or the IIs server that has the ASP scripts?

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

Okay, I registered the dll, but still getting the same error.

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

Thanks Bob. I thought I had a syntax problem instead of a provider
problem.

Bob Barrows [MVP] wrote:

More to the point:
http://support.microsoft.com/kb/q278604/
su******@gmail. com wrote:
> I tried your suggestion but got the following error:
>
> Provider cannot be found. It may not be properly installed.
>
>> This might work perfect. Including the tip Bob gave.
>>
>> <%
>> Set demoConn = CreateObject("A DODB.Connection ")
>> demoPath="Provi der=SQLOLEDB" & _
>> "Data Source=mysqlser ver;Integrated Security=SSPI;" & _
>> "Initial Catalog=qdb"
>> demoConn.open demoPath
>> %>

--
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]]

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

I tried your suggestion but got the following error:

Provider cannot be found. It may not be properly installed.

This might work perfect. Including the tip Bob gave.

<%
Set demoConn = CreateObject("A DODB.Connection ")
demoPath="Provi der=SQLOLEDB" & _
"Data Source=mysqlser ver;Integrated Security=SSPI;" & _
"Initial Catalog=qdb"
demoConn.open demoPath
%>

Actually, if you used this code verbatim, there is a syntax error: it's
missing a semicolon after the word "SQLOLEDB"

demoPath="Provi der=SQLOLEDB;" & _
--
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.