System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

  • Thread starter Thread starter dinesh
  • Start date Start date
D

dinesh

I'm trying to run the ibuyspy ecommerce example (www.ibuyspy.com)
using MSDE as a database. I get the following error:

System.Data.SqlClient.SqlException: SQL Server does not exist or
access denied.

and occurs when the application tries to load the product listing:

Line 63:
Line 64: ' Execute the command
Line 65: myConnection.Open()
Line 66: Dim result As SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 67:

Source File: C:\StoreVBVS\StoreVBVS\Components\ProductsDB.vb Line:
65


I've tried specifying a username and password in the connection
string, both with the trusted connection string and without--to no
avail.

my web.config is:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<!-- application specific settings -->
<appSettings>
<add key="ConnectionString"
value="server=localhost;Trusted_Connection=true;database=store" />

</appSettings>
<!-- forms based authentication -->
<system.web>
<!-- enable Forms authentication -->
<authentication mode="Forms">


<forms name="IBuySpyStoreAuth" loginUrl="login.aspx"
protection="All" path="/" />
</authentication>
<!-- enable custom errors for the application -->
<customErrors mode="RemoteOnly"
defaultRedirect="ErrorPage.aspx" />
<!-- disable session state for application -->
<sessionState mode="Off" />
</system.web>
<!-- set secure paths -->
<location path="Checkout.aspx">
<system.web>
<authorization>
<deny users="?" />
</authorization>
</system.web>
</location>
<location path="OrderList.aspx">
<system.web>
<authorization>
<deny users="?" />
</authorization>
</system.web>
</location>
<location path="OrderDetails.aspx">
<system.web>
<authorization>
<deny users="?" />
</authorization>
</system.web>
</location>
</configuration>

------------------------------------

any ideas??




dinesh
 
Back
Top