Installation and Setup

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

kyle@live-it.com — Thu, 06 Nov 2008 11:10:39 GMT

Please paste web.config code

is your membership provider setup ?

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

innocent_Developer — Wed, 08 Oct 2008 19:40:07 GMT

Hi,

I have already done db_owner permission over the database , I hope.

I can configure using aSP.NET sQL Server setup Wizard...

In ASP.NET SQL Server Setup Wizard,

The database has been created or modified.

You should now configure the provider for membership,profiles, role, personalization and sQL Web event provider to reflect

the changes you made in this wizard. If you have removed application services information from the database, be sure to

change the provide to reference a different data store.

To close this wizard, click Finish..

I can see above line in ASP.NET SQL Server setup wizard...

but

In asp.net configuration, I am still seeing below errors.

---------------

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Unable to connect to SQL Server database.

-----------------

Please Advice me...

In my Web.config file, this is a connection string for my database

KIndly Help Me Please....

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

murtaza_t — Fri, 26 Sep 2008 22:13:33 GMT

1. Make sure that the user kyaw has db_owner permissions over the database you are tryging to connect.

2. Try resetting the password of the user from compmgmt.msc >> Local Users and groups >> Users.

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

innocent_Developer — Fri, 26 Sep 2008 20:52:56 GMT

That is a good questing for me. When i tried,

In the server text box : cute_Developer and

Database : <Default>

I tried to choose my database... but message box came up. it said

Connect failed

Failed to query a list of database names from the sql server. Login failed for user 'Cute_Developer\kyaw'

What should i do? any advice.. Please

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

gavinharriss — Thu, 25 Sep 2008 23:19:10 GMT

In that case...

When you ran aspnet_regsql.exe it asked for which database to be run against and which account to use to connect to that database I guess?

Did you select the database you use for your application?

Did the account you supply credentials for been granted db_owner permissions on that database in SQL Server? (having db_owner permission on the database allows the tables, stored procedures and views to be created using the account)

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

innocent_Developer — Thu, 25 Sep 2008 20:53:03 GMT

Hi,

I'm saying I have created tables and stored procedures in SQL and have given owner permission for tables. But i havenet create aspnet_USers and aspnet_tables,

i tried .. aspnet_regsql.exe and u can see errors massage which i have posted already above.

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

gavinharriss — Wed, 24 Sep 2008 21:04:29 GMT

innocent_Developer:
I already created table and stored procedure in my database(cute_Developer\kyaw). And I can upload data on my web site from database. The problem is
when i create role manager using ASP.net web site tool, error came up like I said on my 1st post.

So you're saying you have already got all the aspnet_Users, and other aspnet_* tables, views and stored procedures present in your database that aspnet_regsql.exe would have created for you?

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

Mar7in — Wed, 24 Sep 2008 03:40:21 GMT

<roleManager ......>
<providers>
<clear/>

<add .......

<membership ......>
<providers>
<clear/>

<add .......

Be sure to "clear" first ... there are default settings in machine.config level...

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

innocent_Developer — Tue, 23 Sep 2008 22:00:11 GMT

I already created table and stored procedure in my database(cute_Developer\kyaw). And I can upload data on my web site from database. The problem is

when i create role manager using ASP.net web site tool, error came up like I said on my 1st post.

Thank for your email, Please Help me out.

Other wise i have to uninstall SQL developer edition and reinstall Express Edition.

Thanks

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

gavinharriss — Tue, 23 Sep 2008 20:51:43 GMT

Have you given user cute_Developer\kyaw db_owner permissions on the database so the account can be used to create the required tables, views and stored procedures?

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

innocent_Developer — Tue, 23 Sep 2008 19:36:42 GMT

I used SQL server Express Before. ASP.NET web site admin tool was working probably with SQL Express.

Now I using SQL Developer Version. Please tell me is there anything different between these sql version. is it happen because of SQL Developer Edition??

Pleease help me out.

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

innocent_Developer — Tue, 23 Sep 2008 11:52:27 GMT

I used

Window authentication for SQL server log in...

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

innocent_Developer — Tue, 23 Sep 2008 11:47:25 GMT

HI,

I have configured connection string for my data base in the web.config file. It worked probably. I can upload data on my web page.

I do not know wat kind of script to run a utility to create the required tables and objects for the AspNetSqlProvider.

I followed below to run a script tha will register aspnet db with my database.

C:/Windows>Microsoft.NET\FrameWrok\v2.0.50727> aspnet_regsql.exe

configuration wizard came up and asked me and followed the step which the wizad has provided.
I chose Configuration sQLServer for application services
next
Chose SQL Server authentication, Database Default
next
and next

Error

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: Login failed for user 'cute_Developer\kyaw'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   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

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

mydreams — Tue, 23 Sep 2008 09:11:39 GMT

You may have not connected database successfully. Sometime the problem is caused by the configuration of the database.

Re: Error!! ==Unable to connect to sQL Server database using ASP.net Web site Admin Tool

chenthil_it — Tue, 23 Sep 2008 05:50:52 GMT

Before try using the administration tool you need to run an script that will register aspnet db with your database.

aspnet_regsql.exe -E -S localhost -A mr

http://msdn.microsoft.com/en-us/library/ms229862.aspx

Check the following link for more information.