MS 2008 c# SQL remote server

Question

How to configure SQL Server 2008 to allow network connections

im getting this error when someone else runs my exe on there computer, on my computer its working find.

A network related or instance specific error occurred, while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that
SQL server is configured to allow remote connections.(provider: SQL Network Inrerfaces, error:26 -
Error Locating Server/Insatance Specified)(Microsoft SQL Server)

David Smith · Answer

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?

David Smith · Answer

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?

David Smith · Answer

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.

David Smith · Answer

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.

Amit Choudhary · Answer

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.

MS 2008 c# SQL remote server

Answers (5)