Hi,

  if my post is not belong here, please point me the right place.

I using Vista Business , microsfot visual studio 2005 and ms sql server (developer edition).

I tryied to set up Role for my web site using ASP.net web site Administration Tool. But i have seen error and cant sort it out. 

I followed below step.

In visual studio 2006,

clicked Web site meu, ASP.NET configuration..

Clicked security.. , and then it said below line.

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. 

 And then i followed the step clicking choose Data Source Button.

It come up like this belwo

 Use this page to configure how Web site management data such as membership is stored. You can use a single provider for all the management data for your site or you can specify a different provider for each feature.

Your application is currently configured to use the provider: AspNetSqlProvider

Select a single provider for all site management data
Select a different provider for each feature (advanced)

 And then i clicked first line above which is a single provider for all site management data..

This page came up....below...

I clicked the above Test link and error came up below..

 Please help me to sort it out.

Thanks, 

Have you made sure the connection string for your database is correct in the web.config file?

I also think you have to run a utility or some scripts against your SQL Server database to create the required tables and objects for the AspNetSqlProvider. Have you done this?

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.

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

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

I used 

Window authentication for SQL server log in... 

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. 

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 

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

 <add .......

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

 <add .......

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

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?

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.

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)

 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 

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.