Error Script Connection SQL SERVER 2005

Question

I have a problem connecting to SQL Server Express 2005 from Visual Studio 2008.

This is the connection string...

Public connect As New SqlConnection( _
    "Data Source=MERSI_IT_04\SQLEXPRESS;Initial Catalog=MERSIFAM;
    Integrated Security=True")

When running locally the connection completes successfully, however when the client running the script there is a connection error.

How can I fix this?

Client running connection were - in their environment? Also, is this an ASP.NET, WinForm or other application? And finally seeing actual error message would help too. As well as line of code that causes it — Comfortably Numb
– Comfortably Numb, Commented Oct 1, 2013 at 2:12

Ardalan Shahgholi · Accepted Answer · 2013-10-01 04:49:33Z

1

You most create one connection with UserName and Password.

And set SQL Server authentication on mix mode.

or you can use Windows authentication if you use Active Directory and all client are part of domain .

For create a Connection String in mix mode use this

Server=myServerAddress;Database=myDataBase;User Id=myUsername;
Password=myPassword;

answered Oct 1, 2013 at 4:49

Ardalan Shahgholi

12.7k25 gold badges116 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1