<<< Connection Problem with SQL Server + C#.Net on Local Area Network >>>

3 Apr 2006 7:16 PM

< g n d z k d r >

hi all,

i m new on Sql and i have a project related to C# and Sql.

i have to do a project which must work on LAN, and there must be only
one database file on main computer(Server Computer) and other
computers(client computers) must connect database on main computer.

i m preparing my project on my personal computer(it is called MYCOMP)
and doing connection with wizard. then it doesnt work on other
computers(works only my personal computer). when i done connection with
wizard .Net create a connection code like below....

// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=MYCOMP;packet
size=4096;integrated security=SSPI;data source=MYCOM" +
"P;persist security info=False;initial catalog=migros";

i think, because of taking my computer's name in connection string it
doesnt work on other computers...

what can i do for this problem :((((((((

please write me a solution as soon as possible...( i have only 15 days
to hand over and still couldnt start to write my codes, otherwise i
cant graduate....)

PLEASE HEEEEEEEEEEEEEEEELP !!!!!!!

thnks for now......

4 Apr 2006 9:01 PM

Keith Kratochvil

http://www.connectionstrings.com/

You are using integrated ("NT") authentication. In order for the other
workstations (network accounts / logins / users) to connect to your "server"
(MYCOMP) you must grant other network accounts access to the database on
your computer.

The other option is to use Standard Security and specify the SQL Server
login and pwd that every connection should use when they connect.

--
Keith Kratochvil

Show quote

"< g n d z k d r >" <gndz***@gmail.com> wrote in message
news:1144091800.885144.104800@j33g2000cwa.googlegroups.com...
> hi all,
>
> i m new on Sql and i have a project related to C# and Sql.
>
> i have to do a project which must work on LAN, and there must be only
> one database file on main computer(Server Computer) and other
> computers(client computers) must connect database on main computer.
>
> i m preparing my project on my personal computer(it is called MYCOMP)
> and doing connection with wizard. then it doesnt work on other
> computers(works only my personal computer). when i done connection with
> wizard .Net create a connection code like below....
>
> // sqlConnection1
> //
> this.sqlConnection1.ConnectionString = "workstation id=MYCOMP;packet
> size=4096;integrated security=SSPI;data source=MYCOM" +
> "P;persist security info=False;initial catalog=migros";
>
>
> i think, because of taking my computer's name in connection string it
> doesnt work on other computers...
>
> what can i do for this problem :((((((((
>
> please write me a solution as soon as possible...( i have only 15 days
> to hand over and still couldnt start to write my codes, otherwise i
> cant graduate....)
>
> PLEASE HEEEEEEEEEEEEEEEELP !!!!!!!
>
> thnks for now......
>