please let me know whether there is a facility in SQL SERVER EXPRESS 2008 to logout idling users automatically.My problem here is that due to limited no of license other needy users can not log in to the system
View Complete Post
We have an application that we ship and include a version of sql express on the CD. In the old days we used to ship MSDE and this worked fine with mult-users; we have since shipped 2005 & 2008 express editions and have had no issues. BUT
I have read somewhere ( though can't find the article again ) that something changed in 2008 R2 Express with regards to using it in a multi-user environment and I remember that the article suggested that "buying" the workgroup edition might be the way forward,
if you want to use it in a multi-user system. Obviously this has drastic impact, in that we can not give away free editions of Workgroup !!
I have searched high and low on the Microsoft sites to find any information that might lead us to believe that R2 Express is not designed for multi-user systems, but can not find anything saying this; so just wanted to know if anyone knows of such information
or why people may believe R2 Express is not suitable ?
I have been looking everywhere online regarding this, but have not found a clear answer.
I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.
I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.
I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.
Did I set the server up wrong? or do I have to do something within ASP.Net to create this user and then give it rights?
I've posted my problem in a few other categories. Sorry for that. I didn't see the security category until now.
I'm trying to use ASP.NET's built-in role/user management for a couple ASP.NET MVC 2 sites. I'm using the MVCMusicStore as my guide. I click on the Configuration Tool as the tutorial suggests, which launches the site administration page. Unfortunately when I click on the security tab, I get an error that it cannot connect to the data store. Attempting to test the AspNetSqlProvider gives me a similar error.
I've run the aspnet_regsql program as the error message suggested, and I have a role/user management database ready to go on the server. The proper tables are constructed, and all that. The configuration tool still doesn't see the data store.
As a test, I ran the MVCMusicStore demo in the debugger. Its role/user management functionality worked. I was able to add myself as a customer, and add/remove items from my cart with no errors or exceptions. However, when I attempted to access its security tab in the configuration tool, I received the same error as I get for my own project. How is it possible that role/user management works, but the configuration tool cannot change its settings?
Any suggestions on how I can get the configuration t
I just installed SQL Server 2008 Management studio Express on my Vista machine. i tried connecting to local machine using :.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpressnothing is working, getting this error:-----------------------------Cannot
connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating