473,396 Members | 1,834 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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 1697
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

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

Similar topics

1
by: Akif | last post by:
Hi. I'm a SQL Server novice, so apologies if any of this sounds simple. I am running Windows XP SP2, and have just installed SQLServer 2000. I need another application to connect to SQLServer,...
1
by: mdurliSPAMFILTER | last post by:
Hello, I developed a win32 .exe CGI that connects to a clustered SQLServer to report some data. The software is written with Borland C++Builder. This is the oledb string:...
2
by: Reza | last post by:
Hello I am trying to resolve this for a week and pretty much tried everything, Windows authenticatio, Forms authentication, none of .net, but still get a message of. Login failed for user,...
1
by: jhcorey | last post by:
We recently had to repair our SQLServer and a new C drive was put in and SQLServer 2000 sp3 re-installed. The data files were on another drive and I attached them. Now I can do everything...
0
by: man910 | last post by:
hi i configured my win2003 server to a remote access dial up server i want connect to sqlserver and get & Insert data from/into database on server from remote computer plz help me
3
by: emadattalla1983 | last post by:
Hi I need to know exactly and in details, how can I connect to SQL server 2005 from NetBeans5.5 using sqljdbc_01 package. thanks in advance
0
by: Neff | last post by:
I have a clustered installation of SQL Server 2005 with SSIS installed on the cluster. I'm running SQL Server Management Server on one of the cluster nodes and trying to connect to the...
1
by: anupsonawane | last post by:
hi friends i want to connect sqlserver & vc++ 2005 windows application plz send me any useful inf. or code
3
by: =?Utf-8?B?ZGF2aWQ=?= | last post by:
Last week I asked a question about connection to database from client machine (developer machine). I have changed the database security setup for "SQL Server and Windows" under (local)Windows NT...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.