Installing Multiple Instances of ASP.NET Application Services on ONE SQL Server Database

Hi,

I am trying to install multiple application services on 1 sql server database. Is this possible? I do not know how to install anything but the default application services settings for the membership, roles, etc.

Please help if you can.

Thanks,

Ezeibe

Seems not possilble in 1 databases, but should be able in different databases on 1 SQL instance. Just use aspnet_regsql.exe to create schema for membership in serveral database, and then connect to 1 database respectively in your applications.

Installing Microsoft SQL server management studio express broke my asp.net databases

Morning,

I installed the managerment stuid on my machine and now none of my database connections seem to work any more. I keep getting the attached error. Before I installed the studio the system worked fine, I could connect to the database and everything was fine. Does the studio change any permission stuff? I cannot seem to get it to work again at all now, I added in aspnet as a login inside the studio and it still won't let me connect to the database. I cannot find *any* logs anywhere that might be helpful in what it is doing or see any way to debug the connection to find out what the problem is. When I look at the permissions inside of the studio it shows me that the connections should all be fine.

I checked and remote and local connections are setup, although it is only doing local connections anyway since this is a asp.net web server page.

Any idea what the problem is here? This is very frustrating and annoying :( Since I didn't change anything and now nothing I will do gets it to work. I even tried to uninstall the management tool and it still doesn't work.

Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFY\ASPNET'.

Description: An

unhandled exception occurred during the execution of the current web

request. Please review the stack trace for more information about the

error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFY\ASPNET'.

I have posted a solution (that works for me) here.

And there are other solutions in that older post.

|||Simply set the user dafault database for the user to a database which is existing and accessible to him, either with the procedure sp_defaultdb or via the management Studio.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||It was working just fine till I installed the management studio though. What could that possibly be doing to muck with the permissions?

I checked and the user has the default database as master and it definately has access to it. None of the other solutions on this page worked either.

I am really really really unimpressed with this current situation, it is a terrible user experience.|||Make also sure that the database mentioned in the connection string (depending on your provider you are using, for .NET it should be "Initial Catalog" is existing and accessible to the user. if you didn′t configure the user extensivly just drop anbd recreate him. i don′t know which administrative tasks you did prior to this problem, but this should "reset" the settings. make also sure that the user is not in a group which has access denied in the database you are redirecting to. These right will be inherited to the user as restrictive right will always overwrite granted rights.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Installing ASP.NET

I have looked all over microsofts website
to install a Virtual Web Server under Windows XP
It appears that it is installed under IIS. I can not
use ASP.NET in Visual Studio .Net to access it and
test programs. 9WinXP Pro)
What am I doing wrong '?You will probably get an answer if you post this in the .net programming
groups
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DW" <don@.performancefiberglass.com> wrote in message
news:01d701c4939a$3e7777c0$a401280a@.phx.gbl...
> I have looked all over microsofts website
> to install a Virtual Web Server under Windows XP
> It appears that it is installed under IIS. I can not
> use ASP.NET in Visual Studio .Net to access it and
> test programs. 9WinXP Pro)
> What am I doing wrong '?sql

Installing ASP.NET

I have looked all over microsofts website
to install a Virtual Web Server under Windows XP
It appears that it is installed under IIS. I can not
use ASP.NET in Visual Studio .Net to access it and
test programs. 9WinXP Pro)
What am I doing wrong ??
You will probably get an answer if you post this in the .net programming
groups
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DW" <don@.performancefiberglass.com> wrote in message
news:01d701c4939a$3e7777c0$a401280a@.phx.gbl...
> I have looked all over microsofts website
> to install a Virtual Web Server under Windows XP
> It appears that it is installed under IIS. I can not
> use ASP.NET in Visual Studio .Net to access it and
> test programs. 9WinXP Pro)
> What am I doing wrong ??

Installation Problems with Win2K3

I am unable to install Reporting Services on our new Windows 2003
Server.
I have tried several times.
I have given ASPNET administration privileges.
I have tried the install via remote desktop and VNC.
I have tried various systems and local accounts all of which work on
other servers.
After the install I get a warning: Setup could not initialize error,
which said to
manually initialize
When I navigate to
http://localhost/Reports/Pages/Folder.aspx
or http://localhost/Reportserver
I get this error:
An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help The system cannot find
the file specified.
I get this warning from the Application Event Log
Event Id: 5603
A provider, ReportingServicesWMI, has been registered in the WMI
namespace, root\Microsoft\SqlServer\ReportingServices\v8, but did not
specify the HostingModel property. This provider will be run using the
LocalSystem account. This account is privileged and the provider may
cause a security violation if it does not correctly impersonate user
requests. Ensure that provider has been reviewed for security behavior
and update the HostingModel property of the provider registration to an
account with the least privileges possible for the required
functionality.
For more information, see Help and Support Center at
Please HelpFixed
It was related to security.
I edited the machine.config file
Updated username under "processmodel" to system. It was originally
machine. I am not sure if this step was necessary.
I also updated the security of the application pool
Go to IIS, Application Pools, DefaultAppPool, Properties, Identity Tab,
Select Predefined = Network Service.
I also updated the windows services to use NT Authority\NetworkService.
I restarted IIS. Then I ran the rsconfig.exe tool because I changed
the account of the windows services.
I also ran the rsactivate with the -r switch.
Everything works now; hope this post helps if someone else has a
similar problem.
daveg.01@.gmail.com wrote:
> I am unable to install Reporting Services on our new Windows 2003
> Server.
> I have tried several times.
> I have given ASPNET administration privileges.
> I have tried the install via remote desktop and VNC.
> I have tried various systems and local accounts all of which work on
> other servers.
> After the install I get a warning: Setup could not initialize error,
> which said to
> manually initialize
> When I navigate to
> http://localhost/Reports/Pages/Folder.aspx
> or http://localhost/Reportserver
>
> I get this error:
> An internal error occurred on the report server. See the error log for
> more details. (rsInternalError) Get Online Help The system cannot find
> the file specified.
>
> I get this warning from the Application Event Log
> Event Id: 5603
> A provider, ReportingServicesWMI, has been registered in the WMI
> namespace, root\Microsoft\SqlServer\ReportingServices\v8, but did not
> specify the HostingModel property. This provider will be run using the
> LocalSystem account. This account is privileged and the provider may
> cause a security violation if it does not correctly impersonate user
> requests. Ensure that provider has been reviewed for security behavior
> and update the HostingModel property of the provider registration to an
> account with the least privileges possible for the required
> functionality.
> For more information, see Help and Support Center at
>
> Please Help