Hi,
   I have puchased the book,
Book Name : ASP.NET Website Programming (Problem - Design - Solution) by Marco Bellinaso and Kevin Hoffman

PROBLEM-
    I have downloaded the complete code for the "ThePhile" C# project as explained in the Book. I followed the instructions given in the readme file and FAQs to make the Code up and running. I had several Issues and i solved some of them and i am struck with one Issue. I have modified the Server Name in all the config files and set the SQL server authentication to SQL server and Windows.


ISSUE -

Page Error

--------------------------------------------------------------------------------
An unexpected error has occurred on this page. The system administrators have been notified. Please feel free to contact us with the information surrounding this error.
The error occurred in: http://localhost/ThePhile/Default.aspx
Error Message: SQL Server does not exist or access denied.
--------------------------------------------------------------------------------
Stack Trace:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at Wrox.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, Int32& rowsAffected) in C:\wrox\ThePhile\Modules\Core\DbObject.cs:line 104 at Wrox.WebModules.Polls.Data.Questions.GetCurrentID( ) in C:\wrox\ThePhile\Modules\Polls2\Polls.Data\Questio ns.cs:line 94 at Wrox.WebModules.Polls.Business.Question.GetCurrent ID() in C:\wrox\ThePhile\Modules\Polls2\Polls.Business\Que stion.cs:line 129 at Wrox.WebModules.Polls.Web.Controls.User.Poll.DataB ind() in C:\wrox\ThePhile\Modules\Polls2\Poll.ascx.cs:line 123 at Wrox.WebModules.Polls.Web.Controls.User.Poll.Page_ Load(Object sender, EventArgs e) in C:\wrox\ThePhile\Modules\Polls2\Poll.ascx.cs:line 114 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain()


Can someone help me out to solve this problem.

Thanks in advance,
arun

Hi there,

What version of SQL Server did you install? If you installed the MSDE, or installed a second instance of SQL Server, did you refer to server using ServerName\InstanceName? What's the name of the server?

Doe the account you use in your connection string exists and has access to the required database?

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: How High by Tricky (Track 6 from the album: Vulnerable)

Hi,
  Thanks a lot for the reply

    My server Name is GANESH
    How can i find my Instance Name? what is NetSDK?

This is the connection string i used

<ConnectionString>server=GANESH\NetSDK;database=Th ePhile;uid=sa;pwd=;
</ConnectionString>

Thanks in advance
arun

If you installed the MSDE as part of a NET SDK installation, it creates a ServerName\NetSDK instance by default.

Named instances is a new concept of SQL Server that allows multiple instances of SQL Server to coexist on the same physical machine.

Probably the easiest way to find out the instance name is to look here:

C:\Program Files\Microsoft SQL Server

You'll see a folder that starts with MSSQL$. What follows is the name of your MSDE instance.

If you don't see that folder, but have SQL Server installed anyway, try dropping the instance name from your connectionstring e.g.:

<ConnectionString>server=GANESH;database=ThePhile; uid=sa;pwd=;
</ConnectionString>

If you have the SQL Server Enterprise Manager installed, you can look at the Properties dialog for your server. The name, and if applicable the instance name, is displayed on the General tab.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Wait for God by Tricky (Track 10 from the album: Vulnerable)