|
|
 Posted 28/04/2005 10:16:35 |
|
|
Forum Newbie
Group: Customers
Last Login: 02/05/2005 11:41:55
Posts: 8,
Visits: 8
|
|
After installation , it occurs the following error even though I can log into my SQL Server by username sa and blank pass. Any one help me please !!
Server Error in '/instantforum34' Application.
--------------------------------------------------------------------------------
SQL Server does not exist or access denied.
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: SQL Server does not exist or access denied.
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.
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
InstantASP.InstantForum.Logic.AddMemberToActivityTable(Int32 intUserID)
InstantASP.InstantForum.Logic.GuestLogin()
InstantASP.InstantForum.WebSite.Global.Session_OnStart(Object Sender, EventArgs E)
System.Web.SessionState.SessionStateModule.CompleteAcquireState() +525
System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +698
System.Web.AsyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +66
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +173
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
|
|
|
|
 Posted 28/04/2005 10:30:28 |
|
|
Supreme Being
Group: Customers
Last Login: 22/09/2008 15:59:25
Posts: 693,
Visits: 2,418
|
|
| Hi GeorgeMike, How did you install the forum? Did the installation create its own database, or did you manually add the forum tables to an existing database? You should check your database connection string, within the web.config, to ensure the forum is trying to connect to the correct database. These are just stabs in the dark. We all could offer better assistance if you can give us a few more details about your installation. Thanks!!
..:: Bare ::..
http://www.livingformetal.com
|
|
|
|
| Posted 28/04/2005 14:15:16 |
|
|
Support Supremo
Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568,
Visits: 2,507
|
|
| Dear George, The trusted connection is the default type of connection in our applications if you would like to use the Trusted connection the HostName\IUSR_HostName and 'HostName\ASPNET' users need to be added to the SQL Server logins, and need to be given access to the InstantForum database. They will also need to be members of the dbo role in the InstantForum database. A database user should be added to the InstantForum database and you have to change the Value of the Key InstantForum_DSN in the web.config file as below: <add key="InstantForum_DSN" value="server=yourserver.com;uid=yourusername;pwd=yourpassword;database=InstantForum34;"/> GeorgeMike (4/28/2005)
After installation , it occurs the following error even though I can log into my SQL Server by username sa and blank pass. Any one help me please !!
Server Error in '/instantforum34' Application.
--------------------------------------------------------------------------------
SQL Server does not exist or access denied.
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: SQL Server does not exist or access denied.
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.
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
InstantASP.InstantForum.Logic.AddMemberToActivityTable(Int32 intUserID)
InstantASP.InstantForum.Logic.GuestLogin()
InstantASP.InstantForum.WebSite.Global.Session_OnStart(Object Sender, EventArgs E)
System.Web.SessionState.SessionStateModule.CompleteAcquireState() +525
System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +698
System.Web.AsyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +66
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +173
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
|
|
|
|
| Posted 28/04/2005 19:05:07 |
|
|
Forum Newbie
Group: Customers
Last Login: 02/05/2005 11:41:55
Posts: 8,
Visits: 8
|
|
I have chaged my connection string to this but doesn't work either
|
|
|
|
| Posted 28/04/2005 19:10:55 |
|
|
Forum Newbie
Group: Customers
Last Login: 02/05/2005 11:41:55
Posts: 8,
Visits: 8
|
|
| I installed the database manually , cos when using the installation of InstantForum it said that the SQL Server does not exist either and I can not use it automatically
|
|
|
|
| Posted 28/04/2005 20:37:46 |
|
|
IF.NET 4.2 Coming Soon
Group: Administrators
Last Login: Today @ 15:10:38
Posts: 1,957,
Visits: 3,021
|
|
| Hi George, Hope your well. If your running Windows 2000 or XP after installation on a local system you will should ensure the MACHINENAME/ASPNET account has db_owner privileges to your InstantForum database. If your running Windows Server 2003 you will need to ensure the MACHINENAME/NETWORKSERVICE account has db_owner privileges to your database. You mention you've change the connection string to use your SA account. I would not suggest using the SA account for 99.9% of applications. It's certainly a security risk. You should do as Carlos suggests and create a dedicated SQL account once in production and update the connection string to use that account. Is it possible to remotely connect to your installation to review your connection string and SQL server set-up? If so please create a ticket with your information or send me a private message with your details. I look forward to your response,
Kindest Regards,
Ryan Healey
Director / Developer
 Explore our products...
http://demos.instantasp.co.uk/
|
|
|
|