blindrookie
asked on
ASPNET login failure in Visual Studio / MDSE environment
Based on my searches, this problem happens a lot. I am a rookie and have attempted these solution and have gotten nowhere.
I am working (just starting) in a Visual Studio .NET environment using VB. Trying to get the ASP.NET Web App. Walkthrough to work. I can see that I am able to access the “pubs” database through via the via the VS/VB wizards. But at run time it doesn’t work.
Here’s part of the text of the message:
...
Login failed for user 'CSCHERL-D4500\ASPNET'.
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.SqlE
...
Here is what I have tried with no change in the message.
1. Using the WIN XP Control panel I created a ASPNET admin user account with no password. I didn’t think that it would work as I was not setting this user up in the SQL Server.
2. I found what I thought was the solution here:
https://www.experts-exchange.com/questions/20728747/Login-failed-LAPTOP-ASPNET.html?query=Login+failed+for+user+ASPNET+&searchType=all
I tried building the .bat file and making the appropriate substitution to add the user to the MSDE SQL Server. Here’s what I tried
…
cd "C:\Program Files\Microsoft SQL Server\80\Tools\Binn"
osql -E -S CSCHERL-D4500\MSSQLServer r -Q "sp_grantlogin 'CSCHERL-D4500\ASPNET'"
osql -E -S CSCHERL-D4500\MSSQLServer -d pubs-Q "sp_grantdbaccess 'CSCHERL-D4500\ASPNET'"
osql -E -S CSCHERL-D4500\MSSQLServer -d pubs -Q "sp_addrolemember 'db_owner', 'CSCHERL-D4500\ASPNET'
pause
…
Here’s what I get:
...
C:\Program Files\Microsoft SQL Server\80\Tools\Binn>osql -E -S CSCHERL-D4500\MSSQLServer -Q "sp_grantlogin 'CSCHERL-D4500\ASPNET'"
[DBMSLPCN]Invalid connection.
[DBMSLPCN]ConnectionOpen (ParseConnectParams()).
...
It seems pretty clear that I have a bad connection. I suspect that my “instance” of the SQLServer is improperly specified. The SQL Service Manager running in the task tray says the following:
Server:CSCHERL-D4500
Services:SQL Server
At the bottom of the box [Running - \\CSCHERL-D4500 – MSSQLServer]
Am I even close to solving this problem???
Is there a possible problem in the “Component Designer generated code”???
What do I need to do and how (very clearly for this dummy) do I do it?
Help!!!!
ChuckS
I am working (just starting) in a Visual Studio .NET environment using VB. Trying to get the ASP.NET Web App. Walkthrough to work. I can see that I am able to access the “pubs” database through via the via the VS/VB wizards. But at run time it doesn’t work.
Here’s part of the text of the message:
...
Login failed for user 'CSCHERL-D4500\ASPNET'.
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.SqlE
...
Here is what I have tried with no change in the message.
1. Using the WIN XP Control panel I created a ASPNET admin user account with no password. I didn’t think that it would work as I was not setting this user up in the SQL Server.
2. I found what I thought was the solution here:
https://www.experts-exchange.com/questions/20728747/Login-failed-LAPTOP-ASPNET.html?query=Login+failed+for+user+ASPNET+&searchType=all
I tried building the .bat file and making the appropriate substitution to add the user to the MSDE SQL Server. Here’s what I tried
…
cd "C:\Program Files\Microsoft SQL Server\80\Tools\Binn"
osql -E -S CSCHERL-D4500\MSSQLServer r -Q "sp_grantlogin 'CSCHERL-D4500\ASPNET'"
osql -E -S CSCHERL-D4500\MSSQLServer -d pubs-Q "sp_grantdbaccess 'CSCHERL-D4500\ASPNET'"
osql -E -S CSCHERL-D4500\MSSQLServer -d pubs -Q "sp_addrolemember 'db_owner', 'CSCHERL-D4500\ASPNET'
pause
…
Here’s what I get:
...
C:\Program Files\Microsoft SQL Server\80\Tools\Binn>osql -E -S CSCHERL-D4500\MSSQLServer -Q "sp_grantlogin 'CSCHERL-D4500\ASPNET'"
[DBMSLPCN]Invalid connection.
[DBMSLPCN]ConnectionOpen (ParseConnectParams()).
...
It seems pretty clear that I have a bad connection. I suspect that my “instance” of the SQLServer is improperly specified. The SQL Service Manager running in the task tray says the following:
Server:CSCHERL-D4500
Services:SQL Server
At the bottom of the box [Running - \\CSCHERL-D4500 – MSSQLServer]
Am I even close to solving this problem???
Is there a possible problem in the “Component Designer generated code”???
What do I need to do and how (very clearly for this dummy) do I do it?
Help!!!!
ChuckS
ASKER
I certainly do appreciate the references .... however I can find nothing that tells me how to:
1. create userids for virtual servers such as IIS & SQL
2. assign permissions etc.
3. exactly where in the web.config files things need to be placed
As I mentioned before, I am not certain that I ma on the right track.
1. create userids for virtual servers such as IIS & SQL
2. assign permissions etc.
3. exactly where in the web.config files things need to be placed
As I mentioned before, I am not certain that I ma on the right track.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
After posting my comments, I found modifaction to the connection string on MS Knowledge Base which was referenced by one of your articles.
I changed this code which was generated by VS:
...
Me.SqlConnection1.Connecti
"rce=""cscherl-d4500"";per
...
to this:
...
'Me.SqlConnection1.Connect
'"rce=""cscherl-d4500"";pe
...
This worked and I was able to see the database display.
When I got your <identity impersonate>, I backed out the above change to see if it would also work prior to implementing your fix. The now works with the old code!!!!!!!
...
I then installed your fix and the application still works.
The problem is solved and now I can't and I am not certain why.
I am not going to worry about it now .... but if you have any comments I would appreciate it.
Thanks for the help
I changed this code which was generated by VS:
...
Me.SqlConnection1.Connecti
"rce=""cscherl-d4500"";per
...
to this:
...
'Me.SqlConnection1.Connect
'"rce=""cscherl-d4500"";pe
...
This worked and I was able to see the database display.
When I got your <identity impersonate>, I backed out the above change to see if it would also work prior to implementing your fix. The now works with the old code!!!!!!!
...
I then installed your fix and the application still works.
The problem is solved and now I can't and I am not certain why.
I am not going to worry about it now .... but if you have any comments I would appreciate it.
Thanks for the help
:) happy it works!
-Joe
-Joe
http://weblogs.asp.net/coltk/archive/2003/07/10/9920.aspx
http://www.dotnetforums.net/showthread.php?p=410867#post410867
http://www.dotnet247.com/247reference/msgs/16/83222.aspx
-Joe