Hi!
Can You tell me how can i fix this error:
Cannot open database "DiaulusSimple" requested by the login. The login failed.
Login failed for user 'DIAULUS\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 database "DiaulusSimple" requested by the login. The login failed.
Login failed for user 'DIAULUS\ASPNET'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
I am using ASP.NET, SQLServer2005, Visual Studio 2005
I imagine you are using integrated security - that is, you are not passing in a SQL Server username and password (you need to show us your connection string). Presuming that is the case, you need to add the Windows ASPNET user as a user in SQL Server.|||This is my connection string:
Data Source=diaulus;Initial Catalog=DiaulusSimple;Integrated Security=True
If I use SQL Server Authentication I get this error:
Login faild for user "<user name>". The user is not associated with a trusted SQL connection.
MSDN Library for Visual Studio 2005 has some text about this, but it's about SQL Server 2000, and some Enterprise Menager, that I don't have
|||For the login failure of SQL Authentication, make sure the SQL Server is configured to use mixed authentication mode (both Windows and SQL Authentication), and you have the SQL account in SQL logins. You can check the Authentication Mode in Enterprise Manager->right click the SQL instance->choose Properties->switch to Security tab.|||How can I startENTERPRISE MANAGER?
I don't have it any where
|||In SQL Server 2005, it is SQL Server Management Studio.
No comments:
Post a Comment