Question 'connection string' to SQL server in LAN network

[sudasam]

Hi Everyone,

I'm happy to register in this forum , here is my first question ..

I'm complete build my first program , but I wont to move the exe file to another computer linked with LAN network in case to create the database(SQL database) in the server.

how I can do this?

 

[pingman]

try one these:
SQL Server 2012 Connection String Samples - ConnectionStrings.com

 

[sudasam]

Thanks..

I tried connected via an IP address and was successful.. But this message was appeared
"can't connect to the user_name" ..
-I used the windows authentication in SQL server

any idea ..

 

[IanRyder]

Hi,

If you use SQL Server across a network and then use Windows Authentication to Login to that SQL server you then need to ensure that each user that will login to that server, and thus your database, is a recognised user of that database. Have a look here:-

How to: Create a SQL Server Login

Hope that helps.

Cheers,

Ian