ASP .NET Web Site Administration Tool Problem

Sep 13, 2007

Hi,
I have a problem when I use ASP .NET Web Application Administration tool. When I click the Security tab, I receive following message
"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."
In the same page, there is a button to go to Provider section. I clicked it, and I went to the Provider page. There, there were two links, which were: "Select a single
provider for all site management data" and
"Select a different provider for each feature
(advanced)". I clicked the earlier, and I was redirected to a page to select provider. There, there was a link, I clicked it and I receive following message:
"
Provider
Management

Could
not establish a connection to the database.
If you have not yet created the
SQL Server database, exit the Web Site Administration tool, use the
aspnet_regsql command-line utility to create and configure the database, and
then return to this tool to set the provider.
"
After reading this message, I opened Command Prompt and went to C:WINDOWSMicrosoft.NETFrameworkv2.0.50727. There, I ran the aspnet_regsql command, and then ASP .NET SQL Server Setup Wizard was displayed. In the first page of this wizard I chose "Configure SQL Server for application services" and then I clicked "Next" button. In the second page I left all fields as they were and then I clicke"Next". In the third page I only clicked "Next" and then some process ran. Finally, in the last page I received following message:
"
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()
"
What should I do? I tried to use this administration tool on computer in my house and everything was just fine. Why do I have this problem in my office? 

View 6 Replies


ADVERTISEMENT

Error Using Web Site Administration Tool

Mar 7, 2007

I am getting the following error using the Web Site Administration
Tool.  I have created the database I want to use.  Please
help.Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to
create and configure the database, and then return to this tool to set
the provider.

The utility either is not working or I do not know how to use it.

I have SQL 2005 Express and SQL 2000.  SQL 2000 is working
properly, not sure about SQL 2005.  I have been told to use SQL
2000 because that is what our server is using.  I am developing on
my server and when application works will port to our server.

Dee 

View 24 Replies View Related

Provider In Web Site Administration Tool

Jul 17, 2007

Hello,I'm trying to create new users and roles using the Web Site Administration Tool, tab Provider, but I get the following error message: Could not establish a connection to the database.If you have not yet created the SQL Server database, exit the Web SiteAdministration tool, use the aspnet_regsql command-line utility to create andconfigure the database, and then return to this tool to set the provider.Then I ran aspnet_regsql utility using default values in every screen, but I got the following error message: 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) ...How can I solve this? Thanks 

View 5 Replies View Related

SQL Server 2005 Express And ASP.NET Web Site Administration Tool Problem.

Mar 31, 2006

I installed SQL Server 2005 Express Edition, I can login to it just fine using SQL Server Management Studio Express.  I ran the aspnet_regsql and it created the aspnetdb database.  But when I try to test the AspNetMembershipProvider or go to the Security tab in the ASP.NET Web Site Administration Tool it does not work.  I have tried messing with the connectionString of the LocalSqlServer in the machine.config, but to no avail.  My SQL Server is installed on the Default Instance.  Can someone help me get ASP.NET Web Site Administrator to work with my SQL Server 2005 Express Edition?

View 1 Replies View Related

Duplicate Data Entry When Using The ASP.NET Web Site Administration Tool For Logins

Nov 5, 2007

Hello All,

I am using the Web Site Administration Tool with the ASP.NET login controls to create/manage user logins & roles for my site.

I have exported the ASPNETDB.MDF into my SQL Database ready to use with my app. The problem that I'm having is that whenever I add a user, using either the Web Site Administration Tool or the Classes available in the code-behind. The entry is doubled up in the database.

This is not a problem when logging on....however, when it comes to deleting a user it will only take one of the entries out and leave the duplicate in there. So if the administrator has deleted a user from the app and then tried to create another one with the same UserName (Which whomever is well within his/her rights to be able to do), they cannot because the entry which has "stay behind" in the database conflicts with the entry.

Any help on this matter would be greatly apprieciated. If any more info on this matter is required please ask (It was quite hard to try and explain this :-)

View 1 Replies View Related

How Do I Tranfer A Previous Table And Its Data To The ASPNETDB.MDF In The Web Site Administration Tool.

Dec 29, 2006

How do I tranfer a previous table and its data to the ASPNETDB.MDF in the Web Site Administration tool. I've tried right, but I can't locate the database in the SQL server on my server. help please.

View 1 Replies View Related

SQL Database Administration Tool

Jun 26, 2005

Hi...
Does anybody know of an open source script I can download that will enable me to manage an SQL database? I basically need to access and modify the database from any machine that may not have SQL Enterprise Manager Installed. I was thinking of writing my own script to do this but I assumed that there is probably already one out there.

View 6 Replies View Related

Free Administration Tool For SQL SERVER 6.5

Mar 30, 2004

Hello,

I need an Administration tool for SQL SERVER 6.5 compatible with WINDOWS 2000.

When I try to search one with GOOGLE, I find none ...

If anyone can provide me with any solution, he (or she) will make me the most happy of the DBAs today ...

Thanks in advance

Al'

View 1 Replies View Related

MSDE 2000 Administration Tool

Jul 20, 2005

Hi all,I have installed MSDE on my computer but it's missing, as all you alreadyknow, a serious (well, osql IS TOO serious but not very newbie friendly)admin tool.I have downloaded http://www.asql.biz/DbaMgr.shtm and i'm quite happy withit but was wondering if there's something better or that may complete whatDbaMgr2k is missing... and preferably is as free as DbaMgr2k.Thank You,Lorenzo

View 2 Replies View Related

Auth Problem To SQL In Web Administration Tool

Apr 30, 2008

I am trying to set up the web administration for a website that uses login controls. I have set up the ASPNETDB database using the regular aspnet_regsql command on my SQLEXPRESS.




To set up the web admin tool, I created a vdir to point to %WINDIR%Microsoft.NETFrameworkv2.0.50727ASP.NETWebAdminFiles. This works absolutely fine. I also changed the configuration of this website to use the ASPNETDB on my SQLEXPRESS.

<add name="LocalSqlServer" connectionString="data source=.SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=aspnetdb"
providerName="System.Data.SqlClient" />




This website also has impersonation enabled

<identity impersonate = "true" />




The administration website works fine till I click on the security tab, and I get the following error:

Cannot open database "aspnetdb" requested by the login. The login failed. Login failed for user 'HOMEASPNET'

What I don't understand is why the application is using the ASPNET account to connect to the database when impersonation is enabled. Isn't it supposed to use the credentials of the windows user? I read a couple of posts on MSDN which advise to explicitly create a login for the ASPNET user in the ASPNETDB database (which will definitely work) but somehow it seems counter-intuitive to me. Any advise anyone?

View 8 Replies View Related

SQL Server Express &&amp; Web Administration Tool

Nov 28, 2007

I am new to VWD, and web development. I installed VWD and SQL Server Express local.

I'm learning how to use the VWD with some of the walkthrough samples. It was going great until I got to the walkthrough where it show "how to use configure user and role with Web Site Admin Tool". I followed the walkthrough steps by step. I clicked the Security Tab and I got the following error:

"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. "

I read some article. According to the articles, SQL Server Express will automatically create the asp database for the first time. but my SSE did not create the database.

What did you do wrong? Please help. Thank you

TCF

View 1 Replies View Related

Can Not Access Security Page On Web Administration Tool

Dec 1, 2006

I get the following error message when i click the Security tab on my websites' Administration tool. All the other tabs are working properly.
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: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 1802 and the SqlException message is: CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file 'C:SAFETYDATABASEAPP_DATAASPNETDB_TMP.MDF' because it already exists. Change the file path or the file name, and retry the operation. Creating the ASPNETDB_652db56c1d7d4c9f94da67107d9c917a database...
Any help is appreciated.

View 1 Replies View Related

Web Site Admin Tool

Aug 24, 2006

Hi!
My problem is...i gut this errormessage in Web Site Administration Tool:
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: The database filename can not contain the following 3 characters: [ (open square brace), ] (close square brace) and ' (single quote)
 
I recieved it after i try'ed to change the default Providers and use another DB then default. Now i want to go back to how it was from start, if i create a user and role - i want VS 2005 to create a SQL Express DB for me. Can anyone help me? I have even tryed to reinstalled VS 2005 but it didn't help.
/Bamsen

View 1 Replies View Related

Site Actitivy Tool

Oct 21, 2007

All,

What kind of tools do you use to monitor the site(SOC/NOC) activities?

What is your experience on the tools? Which one would you recommend?

View 3 Replies View Related

Asp.net Confgiguration Tool. Tool Keeps Timing Out

Mar 2, 2006

is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible??

View 1 Replies View Related

Administration

Nov 7, 2007

Hi,

I am looking for TSQL book for Administration
Could anybody help ASAP.

Frozen

View 3 Replies View Related

DBA Administration Db

Mar 13, 2007

HI, I would like to set up a dba admin database on each of the instances that I have. Is there any recommended standard format for this database?



Thanks

View 1 Replies View Related

Can You Do SQL Server Administration From An ASP.NET App?

Jun 11, 2007

Is it possible to write an ASP.NET app that can do certain SQL Server 2000 administration tasks, specifically add sql server users, and change sql server user passwords?  Would it just be a matter of running the appropriate system stored procedures (sp_password, etc.), or does .NET provide any hooks into SQL Server for something like this?  Thanks!

View 5 Replies View Related

MSSQL Administration

Feb 17, 2008

The job failed.  The Job was invoked by User SERVER110Administrator.  The last step to run was step 1 (Subplan_1).
anyone know what this error means?

View 1 Replies View Related

Database Administration

Oct 5, 2001

To All SQL Guru's

I have this simple problem. How can I make SQL Enterprise Manager list only one database that is accessible by client who registered the SQL Server on his / her Enterprise Manager. The user has been granted access to only one database. But every time I register the server in the client's SQL Server Enterpise Manager it lists all database and user database with it.

I just want it to show only one or two or as how many database that login has granted access to and eliminate the database from the SQL Server Enterprise Manager's database list.

Please Help

Thanks

View 3 Replies View Related

Remote Administration

Apr 13, 2000

Hi!
I need to connect to a database located in another city and administer it from my place.Can any one suggest the basic hardware and sql server(std/enterprice edition?).Shall it be on NT work station or server?Any limitations in administering this way due to some reason we can't move it entirely here.Please advice.
Thanks.

View 2 Replies View Related

Remote Administration

Nov 28, 2000

Hi all,
We are about to have 'colocated servers' for our web pages, mail and on line catalogues. The NT administrator is going to use 'pcAnywhere' to administer the servers. I prefer to register the SQL server in Enterprise Manager,using the IP address.

Are there any known advantages between pcAnywhere against using enterprise manager, particularly any security issues?

Many thanks in advance
Keith

View 1 Replies View Related

Administration Of SQL 7 Over The Internet

Jan 21, 2000

Hi
Could someone help me out with administration of SQL Server over the internet.
What do I need to change on my SQL Server and what will I need to configure on my clients using SQL analyzer connecting over the internet

Vijay

View 1 Replies View Related

MSX Multiserver Administration

Feb 18, 2002

I have configured a master server to do multiserver administration and configured my production server as a client. My problem is that when I try to create a multi system maintenance plan it says that I get a security error and it won't create the plan. I have local admin rights to both systems. Do I need domain admin rights?

View 2 Replies View Related

SQL 2000 Administration

Oct 11, 2006

Can anyone help me how to monitor the growth of transaction log of our SQL Server?... How will I maintain it?..

View 4 Replies View Related

User Administration ...

Mar 15, 2007

Hi pals,

I want to create a user in sql server 2000 and i need to give only
INSERT,UPDATE,DELETE,SELECT,CREATE VIEW,CREATE PROCEDURE,ALTER PROCEDURE,DEBUG PROCEDURE,EXECUTE PROCEDURE permissions. i dont want give Administrative priviliges. He should not be able to alter table structures/drop tables.

In SQL server 2005 ihave the concept of DDL triggers so that i can track and restrict whatever suspcious activities (dropping columns,changing datatypes) being done by the database users.

But in SQl Server 2000, what i can do i want restrict the users. to

I need this.can any one me help me out.

Regards,
franky

View 2 Replies View Related

Multiserver Administration

Oct 29, 2005

I want to set up Multiserver Administration.The problem I encounter is a firewall between the master server and sometarget servers.What ports need to be set open to make this possible ?

View 1 Replies View Related

SSAS05 Cube Administration?

Jul 25, 2006

Hi all!

We would like to create an Intranet based cube administration tool.
Power users should be able to process cubes and dimensions. This works
and all the cubes, dimensions and even databases from the SSAS can be
displayed in the web! ASP.NET@C# combined with
Microsoft.AnalysisServices offer a lot of very good possibilities!

But we still have a problem:
How ist it possible to show some kind of progress bar (maybe in a self refreshing iframe or a new window??)??
When a cube/dimension is processed the user does not get ANY feedback
(of course the webserver waits to finish the process() method.
I tried to start a different thread an this even works!
I want to show our powerusers at least some kind of progress (%, events, what ever).

can someone help?? we are totally lost with that topic!

I already had a look at the example from:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=75148&SiteID=1
But it did not lead me to a propper solution :)

TIA and regards

JohnnyR

View 1 Replies View Related

SQL Server Administration And Config

Mar 2, 2004

I'm new in the DBA position recently aquired, and I'm having a few issues with MSSQL configuration and administration.

1. I have created a two maintenance plans, one for system databases and another one for user databases, this plans include things such as, Integrity Checks, Optimizations and DB Backups, however the Integrity Checks fail with the error that the DB's must be in single user mode, how can I go about to make this and what are the implications of doing so?

2. There's been a few reports of MSSQL server compromises through UDP port 1433, so I closed it at firewall level, only TCP 1433 is going through, do I really need UDP 1433?

Thank you very much.

View 1 Replies View Related

User Administration Tools

Nov 6, 2001

Does anyone have a user administration tool that they like? It seems that there are two common operations that have to be performed:

1. Create a new login for a user, and grant all of the database access rights and role memberships already assigned to another user. In other words, "Make User B just like User A." This same operation has to be performed for multiple servers.

2. Copy a login to a different server. This is usually done to add someone to a test environment. The database names and role names are the same, but the server is different.

In our environment, adding a new employee involves going to three different servers, finding a "model" login, and adding the database access rights for three or four databases, with three or four role memberships in each database. Some databases have thirty or more roles defined, so it's easy to miss a checkmark when scrolling through a list of that size.

I have tinkered with some scripts to do this, but they usually fail because things like sp_addrolemember only work in the current database. I am about to start writing something in VB to do this, but I don't want to reinvent the wheel if someone has already done something similar.

View 1 Replies View Related

SQL7 & SQL2000 Administration

Dec 1, 2000

Is it possible to administer both SQL7 & SQL2000 databases from the same console ?? It's fine administering SQL 6.5 & SQL7, as 6.5 had no MMC, but it seems that SQL7 & SQL2000 have the same MMC.

Thanks,
Jazz.

View 1 Replies View Related

SQL Server 7 Remote Administration II

Oct 30, 1999

Sorry for starting a new thread on this subject but my situation is a bit different.

I want to connect to a remote SQL-server in a DIFFERENT domain, using Enterprise Manager. Whatever I try, I allways get an "SQLserver not found"-error.

The ASP's on the server that make use of the SQL server are functioning without any problems, so I guess the SQL-server itself is OK.

I tried:
servername = URL remote server
setting up a linked server
setting up a remote server

I'm a webdesigner and a newbe to SQLserver7. Please keep in mind I could be overseeing something that very obvious for you.

So what could be the problem. Any tips? Thanks!

View 2 Replies View Related

Remote Administration Of SQL Server 7.0

Jan 26, 2000

Is there a way to remotely control SQL server 7.0 from NT workstation
and win98?

Thanks
williams

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved