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!

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

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!

Great. Have fun with the BugBase.

Cheers,

Imar