Hi,

I just installed the IBuySpy Portal SDK, a few hours ago, and I am getting this error when I launch it: any comments are welcome!!


Server Error in '/IBuyPortal' 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:


Line 39: }
Line 40:
Line 41: Context.Items.Add("PortalSettings", new PortalSettings(tabIndex, tabId));
Line 42: }
Line 43:


My web.config file contains the following connection string settings:

<appSettings>
<add key="ConnectionString" value="server=(local)\\SERVER_NAME_HERE;Trusted_Connection=true;database=Portal;" />
</appSettings>


3. Install the Database in SQL server
Use the StoreDB.sql or PortalDB.sql script from the sample's installation directory to create the SQL database. You can create this database on the same server or a different server from ASP.NET using the Osql utility or Query Analyzer tool.

.... c:\ osql ... what is a sample syntax and why?


4. Edit the Connection String in Web.Config
Edit the ConnectionString value in the web.config file to add a valid connection string to your database server. The name of the IBuySpy Store database is "store"; the name of the IBuySpy Portal database is "portal".

For example:

<add key="ConnectionString" value="server=localhost;Trusted_Connection=true;database=Store" />


What is the basic connection string syntax for running with IIS & MSDE? Say the server was named ALAN.

I can't seem to get past this Server does not exist of access denied. I can see the database via SQL Server Enterprise Manager.


Another test site I am working with uses the following connection string syntax and this works.

myConnection = new SqlConnection("server=(local)\\ALAN;database=VENUEdb;Integrated Security=SSPI");


Thanks,
vanalan

---

VanAlan

vanalan04,

change this:

<add key="ConnectionString" value="server=(local)\\SERVER_NAME_HERE; Trusted_Connection=true; database=Portal;" />


to this:

<add key="ConnectionString" value="server=.\SERVER_NAME_HERE; Trusted_Connection=true; database=Portal;" />


this should work.

Regards,
vanalan04

---

VanAlan

I am getting the same error.

I have tried the above and numerous other combinations for the servername and still get the same error.

I have check the DB exists, all look to be fine but still get this error message.

Any help would be greatly appreciated.

Thanks!

Server Error in '/PortalVB' 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:


Line 37: End If
Line 38:
Line 39: Context.Items.Add("PortalSettings", New PortalSettings(tabIndex, tabId))
Line 40:
Line 41: End Sub


Source File: c:\PortalVB\PortalVB\global.asax Line: 39

Stack Trace:


[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASPNetPortal.PortalSettings..ctor(Int32 tabIndex, Int32 tabId) +1003
ASP.Global_asax.Application_BeginRequest(Object sender, EventArgs e) in c:\PortalVB\PortalVB\global.asax:39
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573