Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
This is the forum to discuss the Wrox book ASP.NET 2.0 Instant Results by Imar Spaanjaars, Paul Wilton, Shawn Livermore; ISBN: 9780471749516
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 12th, 2006, 10:55 PM
Registered User
 
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default BugBase - SQL 2005 Server setup

Okay, I have tried to walk my way through what changes might be needed. Granted I am trying to set this up without walking through all the previous chapters.

However, I have successfully attached the BugBase with my Sql Server 2005 and can connect with Sql Server Management Studio and see data.

Below is the connection string:

  <connectionStrings>
    <add name="BugBase" connectionString="Data Source=BSTARW2K3E\BugBase;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
  </connectionStrings>

But when I attempt to log on, I get the following error:

Server Error in '/BugBase' Application.
--------------------------------------------------------------------------------

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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.


I am sure I am missing something simple, but could use some help getting over this problem.


Just an old geek!
 
Old November 13th, 2006, 06:54 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

Your connectionstring doesn't look right. Do you have a SQL Server instance called BugBase? I think your database is called BugBase instead.

Take a look here: www.connectionstrings.com and here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395 for more info.

Cheers,

Imar
 
Old November 13th, 2006, 07:40 AM
Registered User
 
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks. You were correct. I had already started playing with the setup as I had found your examples earlier.

However, your sample at your site used the notation: .\SQL2005 as the Data Source, which I had taken as a reference needed to get the running instance of SQL Server. However, got it to work with just using the instance name. I guess I should have read more of your explanation on the page before I jumped in.

Thanks for the guidance. I am now playing with BugBase.


Just an old geek!
 
Old November 13th, 2006, 07:47 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Great. Have fun with the BugBase.

Cheers,

Imar





Similar Threads
Thread Thread Starter Forum Replies Last Post
reg conn to sql server 2005 from vb.net 2005.. veda SQL Server 2005 2 July 1st, 2008 12:16 AM
Conflict in SQL Server 2000 and SQL Server 2005 ayan.mukherjee SQL Language 0 June 30th, 2008 03:34 AM
Install Bugbase on a web SQL SERVER 2005 giametta BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 4 August 14th, 2007 05:10 PM
Bugbase SQL 2005 remote connection error dtcalif BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 January 12th, 2007 06:46 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.