how to use sql server database from server system to client

Question

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

leathu raj · Answer

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;

leathu raj · Answer

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;

Nitesh Luharuka · Answer

Use connection string as - public static string str =  Data Source = WIN-6A67QTTNU6J\SQLEXPRESS;Database = Sample;User id=user1;Password=pwd;

Saineshwar Bageri · Answer

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 /

leathu raj · Answer

thankz for your reply i can't understand fully Please explain briefly with example connection string thankz in advance

Nitesh Luharuka · Answer

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.

leathu raj · Answer

no sir this does not work.... whether i want to install sql in my client system

Saineshwar Bageri · Answer

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.