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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Nov 7, 2007
Hi,
I am looking for TSQL book for Administration
Could anybody help ASAP.
Frozen
View 3 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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