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

On the IIS server.
But see my previous reply.

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

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.

--
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 back...Now I'm getting the access denied error again:

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

Stupid question 2: Where/how are login credentials being taken care of?

[Bob Barrows [MVP]]

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

I'm back...Now I'm getting the access denied error again:

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

http://www.aspfaq.com/show.asp?id=2009 (scroll down almost halfway)
Stupid question 2: Where/how are login credentials being taken care
of?

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

Stupid question...I know. How/where are login info specified?

Bob Barrows [MVP] wrote:

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

I'm back...Now I'm getting the access denied error again:

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

http://www.aspfaq.com/show.asp?id=2009 (scroll down almost halfway)

Stupid question 2: Where/how are login credentials being taken care
of?

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

Repeating the question does not clear up the confusion. What are you
talking about? Windows security? SQL Server security?

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

Stupid question...I know. How/where are login info specified?

Bob Barrows [MVP] wrote:

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

I'm back...Now I'm getting the access denied error again:

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

http://www.aspfaq.com/show.asp?id=2009 (scroll down almost halfway)

Stupid question 2: Where/how are login credentials being taken care
of?

Huh?
--
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. 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]

Authentication is set to Windows and SQL Server. Note that when I
connect to Query Analyzer, I connect using RUNAS then specify domain
and username.
Bob Barrows [MVP] wrote:

Repeating the question does not clear up the confusion. What are you
talking about? Windows security? SQL Server security?

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

Stupid question...I know. How/where are login info specified?

Bob Barrows [MVP] wrote:

su******@gmail. com wrote:
I'm back...Now I'm getting the access denied error again:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
http://www.aspfaq.com/show.asp?id=2009 (scroll down almost halfway)

Stupid question 2: Where/how are login credentials being taken care
of?
Huh?
--
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. 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]]

Y-e-e-e-s.
I'm sorry, but that does not make your question any clearer to me. What
"login info" are you asking about. SQL logins? Are you asking how to set
up your users in SQL Server? If so, this is more of a SQL Server
question than an ASP general question (there are newsgroupse devoted to
SQL Server questions: they have "sqlserver" in their names). The answer
depends on if you have Enterprise Manager. Do you have SQL Books Online?
if so, look up Security.

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

Authentication is set to Windows and SQL Server. Note that when I
connect to Query Analyzer, I connect using RUNAS then specify domain
and username.
Bob Barrows [MVP] wrote:

Repeating the question does not clear up the confusion. What are you
talking about? Windows security? SQL Server security?

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

Stupid question...I know. How/where are login info specified?

Bob Barrows [MVP] wrote:
su******@gmail. com wrote:
> I'm back...Now I'm getting the access denied error again:
>
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
> or access denied.
>

http://www.aspfaq.com/show.asp?id=2009 (scroll down almost halfway)

> Stupid question 2: Where/how are login credentials being taken
> care of?
Huh?
--
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. 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. 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]

Sorry Bob. All I'm trying to do is create a connect string with ASP to
log into the same SQL database I use with Query Analyzer and Enterprise
Manager. My confusion is that the connect string from above doesn't
have username/password in the string and I was wondering why not? Are
they implied? Should I be using a different connect string? Sorry for
the confusion.
Bob Barrows [MVP] wrote:

Y-e-e-e-s.
I'm sorry, but that does not make your question any clearer to me. What
"login info" are you asking about. SQL logins? Are you asking how to set
up your users in SQL Server? If so, this is more of a SQL Server
question than an ASP general question (there are newsgroupse devoted to
SQL Server questions: they have "sqlserver" in their names). The answer
depends on if you have Enterprise Manager. Do you have SQL Books Online?
if so, look up Security.

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

Authentication is set to Windows and SQL Server. Note that when I
connect to Query Analyzer, I connect using RUNAS then specify domain
and username.
Bob Barrows [MVP] wrote:

Repeating the question does not clear up the confusion. What are you
talking about? Windows security? SQL Server security?

su******@gmail. com wrote:
Stupid question...I know. How/where are login info specified?

Bob Barrows [MVP] wrote:
> su******@gmail. com wrote:
>> I'm back...Now I'm getting the access denied error again:
>>
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
>> or access denied.
>>
>
> http://www.aspfaq.com/show.asp?id=2009 (scroll down almost halfway)
>
>> Stupid question 2: Where/how are login credentials being taken
>> care of?
> Huh?
> --
> 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. 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. 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]]

Ahhh! Now the question is clear!
The line "Integrated Security=SSPI" causes the windows credentials of
the current user to be used to log into the server.
In an ASP application, as long as Anonymous access is disabled, the
current user will be the user whose name appears in the "LOGON_USER "
servervariable. Use this to verify that the user's credentials are being
seen:

Response.Write Request.ServerV ariables("LOGON _USER")

But that should have nothing to do with your problem. The "server does
not exist..." error you are seeing is happening even before the login
is attempted. You should Response.Write your connection string and make
sure you have no typos.

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

Sorry Bob. All I'm trying to do is create a connect string with ASP
to log into the same SQL database I use with Query Analyzer and
Enterprise Manager. My confusion is that the connect string from
above doesn't have username/password in the string and I was
wondering why not? Are they implied? Should I be using a different
connect string? Sorry for the confusion.
Bob Barrows [MVP] wrote:

Y-e-e-e-s.
I'm sorry, but that does not make your question any clearer to me.
What "login info" are you asking about. SQL logins? Are you asking
how to set up your users in SQL Server? If so, this is more of a SQL
Server question than an ASP general question (there are newsgroupse
devoted to SQL Server questions: they have "sqlserver" in their
names). The answer depends on if you have Enterprise Manager. Do you
have SQL Books Online? if so, look up Security.

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

Authentication is set to Windows and SQL Server. Note that when I
connect to Query Analyzer, I connect using RUNAS then specify domain
and username.
Bob Barrows [MVP] wrote:
Repeating the question does not clear up the confusion. What are
you talking about? Windows security? SQL Server security?

su******@gmail. com wrote:
> Stupid question...I know. How/where are login info specified?
>
> Bob Barrows [MVP] wrote:
>> su******@gmail. com wrote:
>>> I'm back...Now I'm getting the access denied error again:
>>>
>>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
>>> or access denied.
>>>
>>
>> http://www.aspfaq.com/show.asp?id=2009 (scroll down almost
>> halfway)
>>
>>> Stupid question 2: Where/how are login credentials being taken
>>> care of?
>> Huh?

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

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
Bob Barrows [MVP] wrote:

Ahhh! Now the question is clear!
The line "Integrated Security=SSPI" causes the windows credentials of
the current user to be used to log into the server.
In an ASP application, as long as Anonymous access is disabled, the
current user will be the user whose name appears in the "LOGON_USER "
servervariable. Use this to verify that the user's credentials are being
seen:

Response.Write Request.ServerV ariables("LOGON _USER")

But that should have nothing to do with your problem. The "server does
not exist..." error you are seeing is happening even before the login
is attempted. You should Response.Write your connection string and make
sure you have no typos.

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

Sorry Bob. All I'm trying to do is create a connect string with ASP
to log into the same SQL database I use with Query Analyzer and
Enterprise Manager. My confusion is that the connect string from
above doesn't have username/password in the string and I was
wondering why not? Are they implied? Should I be using a different
connect string? Sorry for the confusion.
Bob Barrows [MVP] wrote:

Y-e-e-e-s.
I'm sorry, but that does not make your question any clearer to me.
What "login info" are you asking about. SQL logins? Are you asking
how to set up your users in SQL Server? If so, this is more of a SQL
Server question than an ASP general question (there are newsgroupse
devoted to SQL Server questions: they have "sqlserver" in their
names). The answer depends on if you have Enterprise Manager. Do you
have SQL Books Online? if so, look up Security.

su******@gmail. com wrote:
Authentication is set to Windows and SQL Server. Note that when I
connect to Query Analyzer, I connect using RUNAS then specify domain
and username.
Bob Barrows [MVP] wrote:
> Repeating the question does not clear up the confusion. What are
> you talking about? Windows security? SQL Server security?
>
> su******@gmail. com wrote:
>> Stupid question...I know. How/where are login info specified?
>>
>> Bob Barrows [MVP] wrote:
>>> su******@gmail. com wrote:
>>>> I'm back...Now I'm getting the access denied error again:
>>>>
>>>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
>>>> or access denied.
>>>>
>>>
>>> http://www.aspfaq.com/show.asp?id=2009 (scroll down almost
>>> halfway)
>>>
>>>> Stupid question 2: Where/how are login credentials being taken
>>>> care of?
>>> Huh?

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