473,388 Members | 1,492 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

Authentication problem continued

SAL
Hello,
I'm still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204

and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />

Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"

I pass in my user name and password as:

User Id=me;Password=mypassword

When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI

I get logged in, but only on my developement machine and not another box.

When the user name and password is passed in the connection string I get the
login failed for User Id=me

I'm the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other than
my development box also.

Can anyone help me with this? Thanks

S
Dec 14 '06 #1
10 1457
Going by your input there could be 2 problems that I can think off

1) SQL Server is configured for Windows Authentication only and not mixed
authentication

2) The account used to set the security context for the application pool of
your web site has no access to the other box' SQL Server

Gabriel Lozano-Morán
http://www.pointerx.net

"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl...
Hello,
I'm still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204

and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />

Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"

I pass in my user name and password as:

User Id=me;Password=mypassword

When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI

I get logged in, but only on my developement machine and not another box.

When the user name and password is passed in the connection string I get
the login failed for User Id=me

I'm the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.

Can anyone help me with this? Thanks

S

Dec 14 '06 #2
SAL
Gabriel,
thank you for your reply.

I have a SQL Server login established now and I can log in on my development
machine but I'm getting the Anonymous login failure on my test box.

my machinename\ASPNET is a user of the database and is a user for the
server, it looks like to me.
What other account might be being used to set the security context for the
application pool? I'm not sure about this part.

S

"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl...
Going by your input there could be 2 problems that I can think off

1) SQL Server is configured for Windows Authentication only and not mixed
authentication

2) The account used to set the security context for the application pool
of your web site has no access to the other box' SQL Server

Gabriel Lozano-Morán
http://www.pointerx.net

"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl...
>Hello,
I'm still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204

and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />

Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"

I pass in my user name and password as:

User Id=me;Password=mypassword

When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI

I get logged in, but only on my developement machine and not another box.

When the user name and password is passed in the connection string I get
the login failed for User Id=me

I'm the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.

Can anyone help me with this? Thanks

S


Dec 14 '06 #3
SAL
Another piece of information here is that if I run the app on my development
box, then go to my test box and access the web page as:
my machinename/ClarkCategory/Startfrm1.aspx it will open up and work
correctly. However, once a certain amount of time has expired, the login
will fail on my test box again.

S
"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl...
Going by your input there could be 2 problems that I can think off

1) SQL Server is configured for Windows Authentication only and not mixed
authentication

2) The account used to set the security context for the application pool
of your web site has no access to the other box' SQL Server

Gabriel Lozano-Morán
http://www.pointerx.net

"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl...
>Hello,
I'm still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204

and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />

Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"

I pass in my user name and password as:

User Id=me;Password=mypassword

When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI

I get logged in, but only on my developement machine and not another box.

When the user name and password is passed in the connection string I get
the login failed for User Id=me

I'm the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.

Can anyone help me with this? Thanks

S


Dec 14 '06 #4
If your dev and test sandbox running Windows Server 2003?

Gabriel

"SAL" <SA**@NoNo.comwrote in message
news:uM**************@TK2MSFTNGP06.phx.gbl...
Gabriel,
thank you for your reply.

I have a SQL Server login established now and I can log in on my
development machine but I'm getting the Anonymous login failure on my test
box.

my machinename\ASPNET is a user of the database and is a user for the
server, it looks like to me.
What other account might be being used to set the security context for the
application pool? I'm not sure about this part.

S

"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl...
>Going by your input there could be 2 problems that I can think off

1) SQL Server is configured for Windows Authentication only and not mixed
authentication

2) The account used to set the security context for the application pool
of your web site has no access to the other box' SQL Server

Gabriel Lozano-Morán
http://www.pointerx.net

"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl...
>>Hello,
I'm still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204

and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />

Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"

I pass in my user name and password as:

User Id=me;Password=mypassword

When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI

I get logged in, but only on my developement machine and not another
box.

When the user name and password is passed in the connection string I get
the login failed for User Id=me

I'm the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.

Can anyone help me with this? Thanks

S



Dec 14 '06 #5
What other account might be being used to set the security context for the
application pool? I'm not sure about this part.
Login failures are logged to the Application event log therefore try to
reconnect and then look at the event log for "login failed" messages.

Gabriel Lozano-Morán
http://www.pointerx.net
"SAL" <SA**@NoNo.comwrote in message
news:uM**************@TK2MSFTNGP06.phx.gbl...
Gabriel,
thank you for your reply.

I have a SQL Server login established now and I can log in on my
development machine but I'm getting the Anonymous login failure on my test
box.

my machinename\ASPNET is a user of the database and is a user for the
server, it looks like to me.
What other account might be being used to set the security context for the
application pool? I'm not sure about this part.

S

"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl...
>Going by your input there could be 2 problems that I can think off

1) SQL Server is configured for Windows Authentication only and not mixed
authentication

2) The account used to set the security context for the application pool
of your web site has no access to the other box' SQL Server

Gabriel Lozano-Morán
http://www.pointerx.net

"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl...
>>Hello,
I'm still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204

and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />

Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"

I pass in my user name and password as:

User Id=me;Password=mypassword

When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI

I get logged in, but only on my developement machine and not another
box.

When the user name and password is passed in the connection string I get
the login failed for User Id=me

I'm the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.

Can anyone help me with this? Thanks

S



Dec 14 '06 #6
SAL
both are running XP sp2.

S
"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:es**************@TK2MSFTNGP03.phx.gbl...
If your dev and test sandbox running Windows Server 2003?

Gabriel

"SAL" <SA**@NoNo.comwrote in message
news:uM**************@TK2MSFTNGP06.phx.gbl...
>Gabriel,
thank you for your reply.

I have a SQL Server login established now and I can log in on my
development machine but I'm getting the Anonymous login failure on my
test box.

my machinename\ASPNET is a user of the database and is a user for the
server, it looks like to me.
What other account might be being used to set the security context for
the application pool? I'm not sure about this part.

S

"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl...
>>Going by your input there could be 2 problems that I can think off

1) SQL Server is configured for Windows Authentication only and not
mixed authentication

2) The account used to set the security context for the application pool
of your web site has no access to the other box' SQL Server

Gabriel Lozano-Morán
http://www.pointerx.net

"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl.. .
Hello,
I'm still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204

and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />

Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"

I pass in my user name and password as:

User Id=me;Password=mypassword

When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI

I get logged in, but only on my developement machine and not another
box.

When the user name and password is passed in the connection string I
get the login failed for User Id=me

I'm the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.

Can anyone help me with this? Thanks

S



Dec 14 '06 #7
SAL
Yeah, I'm not seeing any logs that seem helpful in the event viewer.
However, the line that causes the login failure is where I try to open the
connection to SQL Server.
If I take the impersonate="true"
line out of the web.config file, I can no longer log in on my development
box either.

S
"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:Oh**************@TK2MSFTNGP03.phx.gbl...
>What other account might be being used to set the security context for
the application pool? I'm not sure about this part.

Login failures are logged to the Application event log therefore try to
reconnect and then look at the event log for "login failed" messages.

Gabriel Lozano-Morán
http://www.pointerx.net
"SAL" <SA**@NoNo.comwrote in message
news:uM**************@TK2MSFTNGP06.phx.gbl...
>Gabriel,
thank you for your reply.

I have a SQL Server login established now and I can log in on my
development machine but I'm getting the Anonymous login failure on my
test box.

my machinename\ASPNET is a user of the database and is a user for the
server, it looks like to me.
What other account might be being used to set the security context for
the application pool? I'm not sure about this part.

S

"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl...
>>Going by your input there could be 2 problems that I can think off

1) SQL Server is configured for Windows Authentication only and not
mixed authentication

2) The account used to set the security context for the application pool
of your web site has no access to the other box' SQL Server

Gabriel Lozano-Morán
http://www.pointerx.net

"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl.. .
Hello,
I'm still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204

and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />

Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"

I pass in my user name and password as:

User Id=me;Password=mypassword

When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI

I get logged in, but only on my developement machine and not another
box.

When the user name and password is passed in the connection string I
get the login failed for User Id=me

I'm the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.

Can anyone help me with this? Thanks

S



Dec 14 '06 #8
Can you post the exact exception message please?

Gabriel

"SAL" <SA**@NoNo.comwrote in message
news:u2**************@TK2MSFTNGP03.phx.gbl...
Yeah, I'm not seeing any logs that seem helpful in the event viewer.
However, the line that causes the login failure is where I try to open the
connection to SQL Server.
If I take the impersonate="true"
line out of the web.config file, I can no longer log in on my development
box either.

S
"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:Oh**************@TK2MSFTNGP03.phx.gbl...
>>What other account might be being used to set the security context for
the application pool? I'm not sure about this part.

Login failures are logged to the Application event log therefore try to
reconnect and then look at the event log for "login failed" messages.

Gabriel Lozano-Morán
http://www.pointerx.net
"SAL" <SA**@NoNo.comwrote in message
news:uM**************@TK2MSFTNGP06.phx.gbl...
>>Gabriel,
thank you for your reply.

I have a SQL Server login established now and I can log in on my
development machine but I'm getting the Anonymous login failure on my
test box.

my machinename\ASPNET is a user of the database and is a user for the
server, it looks like to me.
What other account might be being used to set the security context for
the application pool? I'm not sure about this part.

S

"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl...
Going by your input there could be 2 problems that I can think off

1) SQL Server is configured for Windows Authentication only and not
mixed authentication

2) The account used to set the security context for the application
pool of your web site has no access to the other box' SQL Server

Gabriel Lozano-Morán
http://www.pointerx.net

"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl. ..
Hello,
I'm still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204
>
and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />
>
Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"
>
I pass in my user name and password as:
>
User Id=me;Password=mypassword
>
When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI
>
I get logged in, but only on my developement machine and not another
box.
>
When the user name and password is passed in the connection string I
get the login failed for User Id=me
>
I'm the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.
>
Can anyone help me with this? Thanks
>
S
>




Dec 14 '06 #9
SAL
Sure Gabriel. This is the exception I get if on my test box if I haven't run
the app on my development box very recently:

Exception Text:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'NT AUTHORITY\ANONYMOUS LOGON'.

Source Error:
Line 209: If SqlConnection2.State <ConnectionState.Open Then
Line 210: SqlConnection2.ConnectionString = scon
Line 211: SqlConnection2.Open()
Line 212: End If
Line 213: com.Connection = SqlConnection2

Source File: c:\inetpub\wwwroot\ClarkCategory\StartFrm1.aspx.vb Line: 211

Does this have anything to do with the double hop problem?

S

"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:uY*************@TK2MSFTNGP03.phx.gbl...
Can you post the exact exception message please?

Gabriel

"SAL" <SA**@NoNo.comwrote in message
news:u2**************@TK2MSFTNGP03.phx.gbl...
>Yeah, I'm not seeing any logs that seem helpful in the event viewer.
However, the line that causes the login failure is where I try to open
the connection to SQL Server.
If I take the impersonate="true"
line out of the web.config file, I can no longer log in on my development
box either.

S
"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:Oh**************@TK2MSFTNGP03.phx.gbl...
>>>What other account might be being used to set the security context for
the application pool? I'm not sure about this part.

Login failures are logged to the Application event log therefore try to
reconnect and then look at the event log for "login failed" messages.

Gabriel Lozano-Morán
http://www.pointerx.net
"SAL" <SA**@NoNo.comwrote in message
news:uM**************@TK2MSFTNGP06.phx.gbl...
Gabriel,
thank you for your reply.

I have a SQL Server login established now and I can log in on my
development machine but I'm getting the Anonymous login failure on my
test box.

my machinename\ASPNET is a user of the database and is a user for the
server, it looks like to me.
What other account might be being used to set the security context for
the application pool? I'm not sure about this part.

S

"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl...
Going by your input there could be 2 problems that I can think off
>
1) SQL Server is configured for Windows Authentication only and not
mixed authentication
>
2) The account used to set the security context for the application
pool of your web site has no access to the other box' SQL Server
>
Gabriel Lozano-Morán
http://www.pointerx.net
>
"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl.. .
>Hello,
>I'm still having trouble getting my app to authenticate correctly.
>I have read the tips at:
>http://www.devhood.com/messages/mess...hread_id=72204
>>
>and am still having trouble making this happen correctly. Here are my
>settings.
>SQL Server 2005 db access is required
>Web page
>Anonymous access is turned off in IIS.
><identity impersonate="true" />
><impersonate="true" />
>>
>Connection string is:
>packet size=4096;Trusted_Connection=True;data source=NTserver;persist
>security info=False;initial catalog=MyTest"
>>
>I pass in my user name and password as:
>>
>User Id=me;Password=mypassword
>>
>When I take out the User Id and Password stuff and put in:
>Integrated Security=SSPI
>>
>I get logged in, but only on my developement machine and not another
>box.
>>
>When the user name and password is passed in the connection string I
>get the login failed for User Id=me
>>
>I'm the dbo of this sql server database so I should be able to log
>in. However, I need to be able to access this web page from machines
>other than my development box also.
>>
>Can anyone help me with this? Thanks
>>
>S
>>
>
>




Dec 14 '06 #10
SAL
Okay, well at the risk of sounding the all clear too soon, it appears what
has been happening here is that when you hit SQL Server, you actually have
to log into the machine that is hosting SQL Server to be able to reach it.
Because I was disallowing Anonymous Logins via Directory Security a user,
whoever, on my test box was not able to reach the machine and therefore
couldn't reach SQL Server. When I changed Directory Security to allow
Anonymous Access and entering in my user name and password, I could then
reach the server and the, temporarily hard coded, SQL Server user name and
password I was sending in the connection string worked to allow access via
that user.

If that's not clear as mud, let me know and I'll try to clearify more.
Thanks for your help on the Gabriel
S
"SAL" <SA**@NoNo.comwrote in message
news:eF**************@TK2MSFTNGP03.phx.gbl...
Sure Gabriel. This is the exception I get if on my test box if I haven't
run the app on my development box very recently:

Exception Text:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for
user 'NT AUTHORITY\ANONYMOUS LOGON'.

Source Error:
Line 209: If SqlConnection2.State <ConnectionState.Open Then
Line 210: SqlConnection2.ConnectionString = scon
Line 211: SqlConnection2.Open()
Line 212: End If
Line 213: com.Connection = SqlConnection2

Source File: c:\inetpub\wwwroot\ClarkCategory\StartFrm1.aspx.vb Line:
211

Does this have anything to do with the double hop problem?

S

"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:uY*************@TK2MSFTNGP03.phx.gbl...
>Can you post the exact exception message please?

Gabriel

"SAL" <SA**@NoNo.comwrote in message
news:u2**************@TK2MSFTNGP03.phx.gbl...
>>Yeah, I'm not seeing any logs that seem helpful in the event viewer.
However, the line that causes the login failure is where I try to open
the connection to SQL Server.
If I take the impersonate="true"
line out of the web.config file, I can no longer log in on my
development box either.

S
"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:Oh**************@TK2MSFTNGP03.phx.gbl...
What other account might be being used to set the security context for
the application pool? I'm not sure about this part.

Login failures are logged to the Application event log therefore try to
reconnect and then look at the event log for "login failed" messages.

Gabriel Lozano-Morán
http://www.pointerx.net
"SAL" <SA**@NoNo.comwrote in message
news:uM**************@TK2MSFTNGP06.phx.gbl...
Gabriel,
thank you for your reply.
>
I have a SQL Server login established now and I can log in on my
development machine but I'm getting the Anonymous login failure on my
test box.
>
my machinename\ASPNET is a user of the database and is a user for the
server, it looks like to me.
What other account might be being used to set the security context for
the application pool? I'm not sure about this part.
>
S
>
"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl.. .
>Going by your input there could be 2 problems that I can think off
>>
>1) SQL Server is configured for Windows Authentication only and not
>mixed authentication
>>
>2) The account used to set the security context for the application
>pool of your web site has no access to the other box' SQL Server
>>
>Gabriel Lozano-Morán
>http://www.pointerx.net
>>
>"SAL" <SA**@NoNo.comwrote in message
>news:ur****************@TK2MSFTNGP04.phx.gbl. ..
>>Hello,
>>I'm still having trouble getting my app to authenticate correctly.
>>I have read the tips at:
>>http://www.devhood.com/messages/mess...hread_id=72204
>>>
>>and am still having trouble making this happen correctly. Here are
>>my settings.
>>SQL Server 2005 db access is required
>>Web page
>>Anonymous access is turned off in IIS.
>><identity impersonate="true" />
>><impersonate="true" />
>>>
>>Connection string is:
>>packet size=4096;Trusted_Connection=True;data
>>source=NTserver;persist security info=False;initial catalog=MyTest"
>>>
>>I pass in my user name and password as:
>>>
>>User Id=me;Password=mypassword
>>>
>>When I take out the User Id and Password stuff and put in:
>>Integrated Security=SSPI
>>>
>>I get logged in, but only on my developement machine and not another
>>box.
>>>
>>When the user name and password is passed in the connection string I
>>get the login failed for User Id=me
>>>
>>I'm the dbo of this sql server database so I should be able to log
>>in. However, I need to be able to access this web page from machines
>>other than my development box also.
>>>
>>Can anyone help me with this? Thanks
>>>
>>S
>>>
>>
>>
>
>




Dec 14 '06 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Michael Foord | last post by:
#!/usr/bin/python -u # 15-09-04 # v1.0.0 # auth_example.py # A simple script manually demonstrating basic authentication. # Copyright Michael Foord # Free to use, modify and relicense. #...
6
by: Pete Mahoney | last post by:
I am trying to 'POST' values from a form in a ASP file that has anonymous access permissions. I can retrieve the form values when I redirect to this page from another page which has also has...
8
by: Bob Everland | last post by:
I have an application that is ISAPI and the only way to secure it is through NT permissions. I need to have a way to login to windows authentication so that when I get to the ISAPI application no...
6
by: Billy Jacobs | last post by:
I have a website which has both secure and non-secure pages. I want to uses forms authentication. How do I accomplish this? Originally I had my web.config file in the root with Forms...
0
by: Nunya Biznas | last post by:
I have a two column report that needs to have the word "continued" appear at the top of the 2nd column if the detail records are part of the group from the previous column. I have tried using a...
9
by: Tom B | last post by:
In my web.config file I've specified Windows for the authentication, in IIS I've set it to Integrated Authentication. But my SQL connection is still showing Anonymous. Is there somewhere else I...
0
by: Anonieko Ramos | last post by:
ASP.NET Forms Authentication Best Practices Dr. Dobb's Journal February 2004 Protecting user information is critical By Douglas Reilly Douglas is the author of Designing Microsoft ASP.NET...
4
by: andreas.w.h.k. :-\) | last post by:
How do I change the address location in the wsdl <wsdl:port name="SearchSoap12" binding="tns:SearchSoap12"> <soap12:address location="http://searchservices/engine/search.asmx" /> </wsdl:port> ...
2
by: Frank Swarbrick | last post by:
I am trying to understand "client authentication" works. My environment is DB2/UDB LUW 8.2 on zSeries SLES9 as the database server and DB2 for VSE 7.4 as the client. We currently have DB2/LUW set...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.