469,623 Members | 874 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Connect SQLserver through LAN

Hi,

I m developing a window application using C# . NET and sqlserver 2005.
Curently i locate my database in same folder with my application .exe folder.

so my connection string looks like that :

"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|MYDATABASE.mdf;Integrated Security=True;User Instance=True"

Now, i have a new PC. I need to put the database into that pc and that pc will act as server.
I need to connect the database through LAN.

So, what i need to do while installing or setup the new PC (sqlserver2005)?

how i connect the database through LAN? how the connection string should look like?
I m newbie to sqlserver2005. Hope u guys can help.

Thanks in advance.
Aug 6 '08 #1
3 1542
r035198x
13,262 8TB
The connection strings to use can be found here
Aug 6 '08 #2
hmm...i not really sure which one i should use.
what need to be set in server side?
Aug 6 '08 #3
r035198x
13,262 8TB
hmm...i not really sure which one i should use.
what need to be set in server side?
You can use the configuration manager to enable network access.
Aug 6 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Neff | last post: by
3 posts views Thread by =?Utf-8?B?ZGF2aWQ=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.