Click here to Skip to main content
12,948,130 members (89,914 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
hi
i use this code for connect to the SQL Server in my domain network


<add name="Database">
connectionString="server=192.168.0.13,1433;Network Library=DBMSSOCN;Initial Catalog=RayanehSanatPB;User ID=sa;Password=123456;"
providerName="System.Data.SqlClient" />


i have one sql server 2008 and my database are here
i want to all client use this sal database
but the application just running in the local machine that running SQl server
i cant conet to the sql server from another pc in my LAN
please help me
Posted 23-Dec-12 10:06am

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

- Check if tcp/ip is enabled for the server instance
- Check firewall
- Use a network tool (like Network Monitor) to catch the connection failure on tcp or ip level
- This connection string is useful in special cases[^], you should use the general connection string syntax[^]
(PS: never use SA to connect an application to the server! You are in a domain and you can add even AD groups as users to SQL server, thus use trusted connection. )
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,344
CHill60 3,275
Maciej Los 2,703
Jochen Arndt 1,935
ppolymorphe 1,795


Advertise | Privacy | Mobile
Web02 | 2.8.170524.1 | Last Updated 23 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100