We have sql server 2005 workgroup edition(say it "Dserver1") installed on window server 2003(say it WServer1).
This window server is connected with another linux based server(say it LServer1). LServer is connected with 30 XP based client machines. plz find network diagram for above setup from here : link text
These XP based clients sends SQL commands to Wserver1 via LServer1 and they are executed in WServer1.
We have 1 running system with above setup and its running very well.Now we are planning to setup one extra system with same setup environment.
But we can't do the same.Can any body help in how to configure widow server & sql server 2005 for above setup?
So, no documentation, no idea how the system was setup?
At present, and without any other information, there is no way that we can help you.
If the systems are standard installs, then start off with that and go from there. This time, make sure to document what you have done.
answered May 15, 2012 at 10:49 AM
Nothing sounds like you're doing anything completely unheard of. Follow the documentation for setting up each of the servers and then connect them together. When in doubt look at, but don't change, the original setup.
answered May 15, 2012 at 10:57 AM
Grant Fritchey ♦♦