Problem With open program in another PC

Question

1.00/5 (1 vote)

See more:

Hi i made program with c# and sql express and i want to open my program in another PC and i installed sql express in my user PC but when i want to open the program it give me an error what should i do to open it in another PC?
this is my sql connection

C#

SqlConnection sql = new SqlConnection(@"server=.\SQLEXPRESS;database=student;integrated security=true;");

and this is the problem
http://upload7.ir/imgs/2014-10/34014132393299938740.jpg[^]
With Respect "Spaceman"

Posted 13-Oct-14 23:12pm

Avenger1

Add a Solution

4 solutions

Add a Solution

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

Mehdi Gholam · Answer 1 · 2014-10-13T23:23:00

Solution 1

When using integrated security on SQL server your user account from the machine you are connecting with must have permission to access that SQL server.

http://stackoverflow.com/questions/3998634/sql-server-2008-how-do-i-grant-privileges-to-a-username[^]

Posted 13-Oct-14 23:23pm

Mehdi Gholam

Garth J Lancaster · Answer 2 · 2014-10-13T23:26:00

Well, it says 'Cannot Open Database "Student"' (more or less)

So, did you copy/import your database from your dev pc to this 'user pc' ? (not sure of the exact way to move or copy a database, but there are docs around on how to deploy it)

- or, re-init the Student database from scratch on the 'user' pc

'g'

Mathew Soji · Answer 3 · 2014-10-13T23:27:00

Solution 3

Hi,

As per the error messages , seems like it related to permission .You need to grant the necessary permissions to
student database for the mentioned user.

Thanks

Posted 13-Oct-14 23:27pm

Mathew Soji

Comments

Avenger1 15-Oct-14 6:51am

how can i do it for my User in my PC?
With Respect "Spaceman"

Mathew Soji · Answer 4 · 2014-10-15T02:02:00

Solution 4

Hi,

Please refer the below link.

http://stackoverflow.com/questions/3998634/sql-server-2008-how-do-i-grant-privileges-to-a-username[^]

If this link is not helping ,please Google on this .I am sure you will get the required information.

Thanks

Posted 15-Oct-14 2:02am

Mathew Soji

Problem With open program in another PC

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Problem With open program in another PC

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us