Hi when restart my computer, does sql server 2005 default back to service instead of remote connections,

after I change to remote connections and restarted my computer it defaults back to initial state, will my porject still be allowed to run remotely on another machine?

Hi when restart my computer, does sql server 2005 default by to service instead of remote connections,

after I change to remote connections and restarted my computer it defaults by to initial state, will my porject still be allowed to run remotely on another machine?

right now I have the appconfig as

 
   
      connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\z1083774\Desktop\Data
     
      \Database.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True"
     
      providerName="System.Data.SqlClient" />

I know I can put it in the root directory c:\  ,but i know there is another way to do it.

Thanks ,I new to sql so i though you do it visual studio c#  ide or something, but now it make sense, but i configure it to local and remote connections.I just have to let the customer test it out again again within a hour or so.

I have a appconfig that i use , is there anyway to set up the path to where the exe will automatic detect the database im talking to or allowing the customer to talk to the mdf. So that way they wont have to keep opening up the appconfig and changing the path.

hi friend,
go to your sqlserver surface area configuration from
start->program->Microsoft SqlServer2005->Configuration tools->Sqlserver surface area configuration
you will see window like this:

after clicking on it you will see the window below. click on remote connection and set he properties like below:



And you are done.
Hope it helps. Please don't forget to mark as answer.