how to use sql server database from server system to client

leathu raj

Hi,

Please Help me..... In my c# project i want to use one database from server computer and want to run my application on all other client PC connected to this network to use the same database. I installed sql server 2012 in my sever computer and change the TCP/IP property enable.Now i try to use my database from another PC but i faced the error "a network related or instance specific error occurred sql server 2012. The Server was not found or not accessible. Verify the instance name and configure to allow remote connection."My connection string was

public static string str = " Data Source = WIN-6A67QTTNU6J\\SQLEXPRESS;Database = Sample;Integrated Security = True";

I refer all related link and do the steps but still no solutions...Please help... Last 10 days i am searching this i am new in c#..

It is possible or not... Or I want to install sql server in my client machine to configure it. Plese answer me in detail....

Waiting eagerly for answer

Thanks for everyone in advance

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

leathu raj12y ago
thanks i got solution for this.i changed my connection string as public static string str = " Data Source = WIN-6A67QTTNU6J\\SQLEXPRESS;Database = Sample;User id=user1;Password=pwd";Application Name =Sample;
0
leathu raj12y ago
thanks i got solution for this.i changed my connection string as public static string str = " Data Source = WIN-6A67QTTNU6J\\SQLEXPRESS;Database = Sample;User id=user1;Password=pwd";Application Name =Sample;
0
Nitesh Kejriwal12y ago
Use connection string as -
public static string str = " Data Source = WIN-6A67QTTNU6J\\SQLEXPRESS;Database = Sample;User id=user1;Password=pwd";
0
Saineshwar Bageri12y ago
Enter your Server Instance Name of sql server while install which you have given.

if installed on Windows Authentication mode.
if installed on Mixed Authentication mode.
name="ST" connectionString="Data Source=192.0.0.1\SQLEXPRESS;Initial Catalog=ST; User Id=myUsername;Password=myPassword;" providerName="System.Data.SqlClient"/
0
leathu raj12y ago
thankz for your reply i can't understand fully Please explain briefly with example connection string, thankz in advance
0
Nitesh Kejriwal12y ago
You are using Integrated Security=True. This means that everytime you're connecting to, you are connecting with the user of client machine. have you ensured that all client machine users are allowed to access SQL Server? A better solution is to use a specific username/password to connect to server.
0
leathu raj12y ago
no sir this does not work.... whether i want to install sql in my client system
0
Saineshwar Bageri12y ago
Close Windows Firewall on Client and server and check.

From server you will need IP Address and use that IP Address as Server name in Client PC and same Login and Password of Server.

0