I can't use the aspnet_regsql tool

I tried using my user account that works on my local host on the production server but it will not log me in to allow me view the admin-role contents of my page.

I have changed my connection string in all of my web forms to:ConnectionString='<%$ ConnectionStrings:LocalSqlServer %>' and the connection string of my web.config file to: <remove name='LocalSqlServer'/>
<add name='LocalSqlServer' connectionString='Data Source=tcp:sql2k506.discountasp.net;Initial Catalog=SQL2005_489160_romiwa;User ID=SQL2005_489160_romiwa_user;Password=*******;' providerName='System.Data.SqlClient' />
</connectionStrings>

but still I cannot log in, please reply promptly and let me know if u need any information, thank you.

 

Can you list the steps you've taken already?
For example, you did add a SQL Server to your account...
And maybe you've followed some tutorials from ASP.NET on how to create logins.
Or possibly you're using a Starter Kit.

As you can see just a bit more info is needed to help you.
Salute,
Mark

 

Gooday, Is there any need for me to install IIS? (I don't have it installed because I am using visual studio which has it's own IIS). tried using aspnet_regsql.exe tool to setup the server and I got the error message below......


Setup failed.

Exception:
Unable to connect to SQL Server database.

----------------------------------------
Details of failure
----------------------------------------

System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)
--- End of inner exception stack trace ---
at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)
at System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install)
at System.Web.Management.SqlServices.Install(String database, SqlFeatures features, String connectionString)
at System.Web.Management.ConfirmPanel.Execute().


Please help me and let me know if you need any information from me. This is my school project and need to have it running as soon as possible, thank you very much and God Bless as you help me.

 

Hi,
You posted more than enough information but...
You are going to need someone to look at your SQL DB and the related code.
If you want me to take a look e-mail your Control Panel username and PW to me at [email protected]

This is something I do for a lot of the accounts here.

Ifyou choose todo this, once I get the login info I'll then be able to get the information I need.
The first thing I'll do is connect with my local SQL Server and make sure your DB is ready for service.
If that looks fine I'll then load your site in VS2008 and take a look at the code.
All the best,
Mark
http://blogcastrepository.com/blogs/wisemx/

 

Hi,
No you don't have to install IIS, this only requires the .NET framework 2.0, or later.
Please see if this helps:
http://iis7testcom.web701.discountasp.net/membershipprovider/
God's blessings,
Mark

 

UPDATE:
I've got your site open in VS2008 Pro.
Already verified your SQL Server data, all was good there.

Your site code however is anything but good.
I'm simply being honest, do not want to imply any harm.

Your root web.config is not valid.
How did you create this? Visual Studio Express?
If so, didn't you see all the errors?

A few other notes...

1. Why do you have Front Page extensions installed?
   If you don't need them, and it looks to me you don't...Please uninstall them in your Control Panel.
2. Why do you have a mirror of the entire site in a folder named "Romiwa" ?
3. Do you want everyone coming to the site to login via their browser before they log into the site?
   You are doing that now with the Users in your Control Panel.

As is your site needs a redesign to function.
I'm still willing to help you but simply cannot invest that much time into another project right now.


Please look at the DASP Knowledge Base articles that are linked to each section of the Control Panel.
For example, User and Permissions.
http://kb.discountasp.net/article.aspx?id=10357

For the code, please review these videos:
http://www.asp.net/learn/videos/


Everything you need is displayed there.

And to create a valid web.config, please make sure you are using the latest VS product.
The new Express VS tools are available for free and they can create the web.config for you.
http://www.microsoft.com/express/vwd/

Just backup theweb.config you have now, remove it from the root of your local site, then press F5.
When VS asks if you want a new web.config answer Yes then use that one to add your changes.

I'm sorry that I don't have time to do all this for you but in all honesty I'm swamped.
Salute,
Mark

 

I'll do my best to help you.

Yes the e-mail address I gave you is secure, directly from a DASP server to me.

By the way, my oldest son is named Samuel.
* My children are Samuel, Gabriela and Lucas.
http://blogcastrepository.com/photos/marks_shots/default.aspx

 

Thanks a million but do not think it is a good idea to send my control panel details across to you but I have got no choice because if I do not get this site working before tuesday next week, then I am going to carry-over this project for another eight months which is 2 semesters and will have to pay a carry-over fee of $200 dollars which I can not afford at the moment.

I will email my control panel login credentials to you and I want to plead with you to just help me out as soon as you can, Almighty God will reward you enormously as you show true kindness to me and others in my situation.

Thank you loads.

Samuel ([email protected]).

 

Thank you, I used visual studio 2005 (professional edition) for developing my application.

The folder (Romiwa) is not meant to be in the application and it would not delete from my root site, each time I tried to delete it from my root site, I get the error - cannot remove file. Please how do I go about this? or can you delete it from your side? Would really appreciate while I keep trying to delete it from my side.

I have uninstalled the frontpage extensions.

I tried deleting the web.config file and ran the site on my local host, I was prompted to create a new web.config file and when I did, I saw this error .....>


Unable to attach to application 'WebDev.WebServer.EXE' (PID: 4000) using 'SAMUEL'. A debugger dll, msdbg2.dll, is
not correctly installed. Please repair your Visual Studio installation via 'Add or Remove Programs' in control panel.

If the problem persists, you can manually register msdbg2.dll from the command prompt with 'regsvr32
'%CommonProgramFiles%\Microsoft Shared\VS7Debug\msdbg.dll'.

Please how do I get to correct this problem too.

I know you don't really have time but please I'm novice and your experience will help me a lot and at the same time help others in future through this experience. Thank you very much, God Bless you.

 

Hi,
I'm not sure about this but my guess is that your copy of VS2005 is in need of repair.
To be honest you will do better using the free version of VWD 2008 rather than VS2005.
The only reason to stay with VS2005 now would be for legacy code or components.
I don't think you need those features, so if you aren't going to upgrade at least install VWD2008, for free.
Salute,
Mark