I want to make a simple application which its databse is on another PC in my LAN,What do I need to do to make such connection?
I can make connections on the local PC.What do need to do to make a remote one?
I want the exact syntax of the connection string(and what its different parts are):
This is the connection string on the local computer:
Data Source=SETMC252TAHA\SQLEXPRESS;Initial Catalog=MYD;Integrated Security=True
How should I change it?
Does it need a usrname and password?if yes how can I make them in SQLSERVER.
Do I need to change some settings in SQLSEREVR?(cause I used several syntaxes in C# but none of them worked.)
(Another questions Shouldn`t an application with this
CODE]Data Source=SETMC252TAHA\SQLEXPRESS;Initial Catalog=MYD;Integrated Security=True
connection string easily work on other PCs on my LAN?)
Cause it has the server name.