SQL remote connection problem

[Jack_Sparrow]

C# program ekak network thru access karaddi SQL remote connection weda neha

meka tamai conn string

connectionString="Data Source=server\SQLEXPRESS;Initial Catalog=Time_Sheet_DB;Integrated Security=True;

eka server machine eke run karaddi hodata connect wenawa, network wena machin ekakin meka use karala connect weddi error 26 enawa

• server eke fire wall disable karala tiyenne...
• user logins windows authentication tiyenne...
• sql config wala remote connections enable and TCP/IP protocol enable karala tiyenne

 

[Anushka123]

terminal server use karanawada?

matat oya aula awa.et windows 7 walata ne.tcp\i netuwa name pipe eken connect karapan

 

[Jack_Sparrow]

terminal server use karanawada?

matat oya aula awa.et windows 7 walata ne.tcp\i netuwa name pipe eken connect karapan

neha ban terminal server ekak neha
server eka duwanne server 2008 R2
client nam XP
uba hitanne eeekada awula kiyala

 

[Jack_Sparrow]

bump

thanks machan

 

[Anushka123]

ow ban 2008 Active Directory eken xp hariyata connect wenne.. connect wela disconnect wenawada?? netanam connect wenne nedda???

 

[Jack_Sparrow]

ow ban 2008 Active Directory eken xp hariyata connect wenne.. connect wela disconnect wenawada?? netanam connect wenne nedda???

AD eka connect wenawa, i mean domain eke client machines okkom XP and ewa domain eke users la hodata awulak netuwa log wenawa...

 

[cmsgun]

uba windows authentication da use karala thiyenne
SQL server authentication use kerala balapan wadi hari yai mama hithanne

 

[Jack_Sparrow]

uba windows authentication da use karala thiyenne
SQL server authentication use kerala balapan wadi hari yai mama hithanne

mama machan ehemat try kala, SQL user kenek hadala, e user name and pass string ekata dala.
eket local server eka ethule connect wenawa
thru network connect wenne neha

 

[Anushka123]

ow machan domain users hodata weda karai.et tcp/ip port eka xp client log wenakota wahanawa.mata meka une server eka update kalata passe.hodama wede windows 7 pc ekakata dala balapan

 

[cmsgun]

mama machan ehemat try kala, SQL user kenek hadala, e user name and pass string ekata dala.
eket local server eka ethule connect wenawa
thru network connect wenne neha

balapan port number hari?

 

[kosandpol]

1. does the SQL Server have TCP/IP enabled on fixed port ?
2. is that fixed port open on the server firewall ?
3. is the server netbios/dns name resolvable on the network ?

change the connection string's Data Source parameter accordingly.

 

[Jack_Sparrow]

balapan port number hari?

firewall eke port ekakut open kala... anyway firewall eka off karala tiyenne

 

[shan4djfun]

oka hadane tikak porak gawata yane wenawa. SQL Express natuwa server install kerela google parak danne microsoft eken deela tiyenawa system eka. hama machine kekema wada kerane naa specially laptops

 

[Jack_Sparrow]

1. does the SQL Server have TCP/IP enabled on fixed port ?
2. is that fixed port open on the server firewall ?
3. is the server netbios/dns name resolvable on the network ?

change the connection string's Data Source parameter accordingly.

1. YES
2. YES
3. mokadda e netbios scen eka :S how to check dat??

 

[Jack_Sparrow]

oka hadane tikak porak gawata yane wenawa. SQL Express natuwa server install kerela google parak danne microsoft eken deela tiyenawa system eka. hama machine kekema wada kerane naa specially laptops

SQL full itin crack ewane hoyaganna wenne, ekane awula
nettam eeekak daganna wei

 

[Jack_Sparrow]

bump

 

[kosandpol]

1. YES
2. YES
3. mokadda e netbios scen eka :S how to check dat??

from the client PC, open a command terminal and run

ping <server_name>

replace <server_name> with actual name of server.
If it resolves the name and show the ip address properly, change your connection string's data source name to :

Data Source=<server_name>,<fixed_port_number>

if the ip address is not being resolved, then change the data source to :

Data Source=<ip_address_of_server>,<fixed_port_number>

replace <server_name> with the actual server name, <fixed_port_number> with the actual port for the SQL service and <ip_address_server> with the actual ip address of the server..

 

[DjSpK]

mysql navicat kiyala soft ekak thiyenava .. issella eka install karala remote server ekata connect venna puluwanda kiyala balanna ..

 

[eskavin]

Uba Win authentication enable karalada thiyenne? ehema naththan 'sa' walin log weyan .Integrated Security=True; ain karapan ethakota

 

[sami_kalpika]

If you still have the problem give me a team viewer session to have a look.

Jst PM