Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cmwslw
Starting Member
3 Posts |
 Posted - 2009-03-20 : 21:02:43
|
| Hello everyone! This is my first post on SQL Team.Recently I have been working on a chart tracking system that utilizes MSSQL for a doctors' office. Now that I have finished it, I need a good way to deploy it across 50-100 computers in the office. The program will certainly need to be upgraded in the future, so changing the program should be an easy task to do. I tried changing the server field in the connect string to local, and was able to run the program on the server computer. When I tried to share the file and run it on another computer, the program failed to connect. Running one copy of the program from the network would be the best option, rather than using some sort of script to install the program on all the computers. If the only option is the latter, though, it would be fine. So what do you guys suggest that I do?Thanks in advance,Cory Walker |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-03-21 : 03:14:41
|
| What version / edition are you using of SQLServer? Is it 2005 - Express . If so , your problem may be you haven't got the communication protocols set properlyJack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
cmwslw
Starting Member
3 Posts |
Posted - 2009-03-21 : 11:23:58
|
| Well, I'm not at the office to check, but I'm pretty sure that it is even older than 2005. I've heard of using group policy to install software on multiple computers, but it seems fairly complicated. It would be nicer if I could just share one copy of the software, since it is only one .exe file. To share the program, would I need to change anything in the connection string to be able to connect? |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-03-21 : 12:53:43
|
| It would better if you application was designed as an n-tier application that people accessed through a web browser.Then you would only need to update it on the applcation server.CODO ERGO SUM |
|
|
|
cmwslw
Starting Member
3 Posts |
Posted - 2009-03-21 : 13:31:20
|
quote:
Originally posted by Michael Valentine Jones
It would better if you application was designed as an n-tier application that people accessed through a web browser.Then you would only need to update it on the applcation server.CODO ERGO SUM
That would have been a good idea, but I designed the program 2 years ago, and it has been in use since then. Two years ago, I manually installed the program on the 50-75 computers, but right now I would rather use an easier way of upgrading. This was my very first time making a program for large scale use, so I didn't really make the best choices. |
|
|
|
|
|
|
|
|
Best way to deploy MSSQL program?