IP address using connection string error

Question

2.18/5 (5 votes)

See more:

i want to connect sql server in client system but..

i have an error like

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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

web.config

C#

<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <!--<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\demo.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>-->
      <add name="ConnectionString" connectionString="Data Source=192.168.0.82,1433;Network Library=DBMSSOCN;Initial Catalog=NewsAdvt;User ID=sa;Password=sql;" providerName="System.Data.SqlClient"/>
    </connectionStrings>
<startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup></configuration>

Form Code

C#

db = DatabaseFactory.CreateDatabase("Connectionstring");
           dbCommand = db.GetSqlStringCommand("select max(GroupCode) from AccountGroup");
           DataSet ds = db.ExecuteDataSet(dbCommand);

error line is DataSet ds = db.ExecuteDataSet(dbCommand);

I can't find the error, what can i do ?

Regards
AR

Posted 19-Dec-13 20:48pm

An@nd Rajan10

Updated 20-Dec-13 0:28am

v8

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Maciej Los · Accepted Answer · 2013-12-19T21:05:00

Solution 1

When you install MS SQL Server on local machine, its instance (by default) is visible on local computer only. If you want to use MS SQL Server in LAN, you need to enable TCP/IP connections.
Please, read this: Enabling Network Access to SQL Server Express[^]

If it won't help, please try to connect to MS SQL Server via instance:

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;

instead of IP address.
http://www.connectionstrings.com/sql-server/[^]

Posted 19-Dec-13 21:05pm

Maciej Los

Updated 19-Dec-13 21:23pm

v2

Comments

An@nd Rajan10 20-Dec-13 3:11am

it is more confusing...

Maciej Los 20-Dec-13 3:18am

Answer has been updated!

An@nd Rajan10 20-Dec-13 4:37am

thank you
what is mean by myInstanceName ?

Maciej Los 20-Dec-13 6:32am

Have a look at example ;)

An@nd Rajan10 20-Dec-13 6:35am

Yes,that why i ask you !

Maciej Los 20-Dec-13 6:48am

OK, i understand now... ;)
Open MS SQL Server Management Studio. The first window which you'll see is a "Connect to Server" dialog. Have a look at "Server name". There you'll find MyServerName\MyInstancename ;)

An@nd Rajan10 · Accepted Answer · 2013-12-23T23:54:00

my mistake is the manual problem in server computer and client computer that is may be the configuration manger -> tcp\ip set as enable and protocol as enable...

C#

<connectionstrings>
   <add name="ConnectionString" connectionstring="Data Source=192.168.0.82,1433;Network Library=DBMSSOCN;Initial Catalog=NewsAdvt;User ID=sa;Password=sql;" providername="System.Data.SqlClient" />
 </connectionstrings>
 <startup uselegacyv2runtimeactivationpolicy="true">
   <supportedruntime version="v4.0" sku=".NETFramework,Version=v4.0" />
 </startup>