PC Review


Reply
Thread Tools Rate Thread

connection error, user data wrong

 
 
Patrick
Guest
Posts: n/a
 
      13th Feb 2005
I installed the Community Starter kit earlier today and fooled around with
it. And I also reinstalled the dot net framework sdk. I already had MSDE
installed as w2000\netsdk, but have it disabled, set for manual startup. I
have sql server 2000 installed as default (local) and always on.

Now I am trying to get an aspx page to check website login and/or
registration info through SQL2k stored proceedures, and get a failed login
for "user w2000\netsdk", but my login is supposed to be integrated security,
user = "". This is a little confusing, I am not having problems with the
asp.net login page, just the connection to SQL server to CHECK the saved
user names/passwords in database "trythis."

I've never seen this problem before. I uninstalled Community Starter and
deleted the w200\netsdk login on sql server, but it still tries to use it.
Here is my login string:

connData = New SqlConnection("workstation id=W2000;packet
size=4096;integrated security=SSPI;data source=W2000;" & _
"persist security info=False;initial catalog=trythis")

TIA
Patrick

psully at eatel dot net




 
Reply With Quote
 
 
 
 
Keenan Newton
Guest
Posts: n/a
 
      13th Feb 2005
You should have a element called identity in your web.config file for
you web application. If not add it. This element should have a
atribute called impersonate which is set to true. If not add the
element . If attributes called userName and Password exist then the
web application will impersonate that specified account. Essentially
what you are doingt here is your telling ASP.Net to impersonate the
idnetity running thwe application by default that identity is the
client making the request or if you specify a username and password it
will use those credientials.

 
Reply With Quote
 
Patrick
Guest
Posts: n/a
 
      13th Feb 2005
Thanks, Keenan, I'll look into that. Sounds like it might be smarter or
easier, just to rename the variables. I was wondering if that could be a
problem, but it seems ridiculous.
Patrick

"Keenan Newton" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You should have a element called identity in your web.config file for
> you web application. If not add it. This element should have a
> atribute called impersonate which is set to true. If not add the
> element . If attributes called userName and Password exist then the
> web application will impersonate that specified account. Essentially
> what you are doingt here is your telling ASP.Net to impersonate the
> idnetity running thwe application by default that identity is the
> client making the request or if you specify a username and password it
> will use those credientials.
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrong data type returned from user-defined function hooroy63 Microsoft Excel Programming 9 13th Jan 2009 11:15 AM
VB.NET application cliick-once deployment via internet - Error - Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. Peri Microsoft Dot NET 2 29th Feb 2008 08:46 AM
Error:Login failed for user ''. The user is not associated with a trusted SQL Server connection. CFTK Microsoft ASP .NET 5 9th Jan 2007 10:51 AM
when I use webpart, I got sql connection error, what is wrong? tony dong Microsoft Dot NET 0 15th Dec 2005 07:13 AM
Front Page: error"425 can't build data connection:connection time. =?Utf-8?B?SGVhcnRBY3Jlcw==?= Microsoft Frontpage 0 29th Sep 2004 03:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:13 PM.