x

sql server 2005 on window server 2003

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][1]

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?

[1]: http://aspspider.info/SannGhoniya/images/Network_Diagram.pdf
more ▼

asked May 15, 2012 at 07:29 AM in Default

sannghoniya gravatar image

sannghoniya
0 1 1 2

If you have set this up successfully before, why can't you set it up again?
May 15, 2012 at 08:26 AM WilliamD
Yeah, you lost me too. What's the problem?
May 15, 2012 at 09:55 AM Grant Fritchey ♦♦
actually this setup was done before 4 years by the other employee of our company and now they had left the company.........
May 15, 2012 at 10:45 AM sannghoniya

i agree with you WilliamD, There must be proper documenation for each and every installation but now i am helpless as i dont have anything as reference.

can we install/configure sql server 2005 for another window server exist in LAN?
May 15, 2012 at 11:09 AM sannghoniya
Yes. People install hundreds of SQL Server instances within a network. You just have to configure it to work within your network. Again, standard stuff defined by the user documentation that comes with SQL Server.
May 15, 2012 at 11:13 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.
more ▼

answered May 15, 2012 at 10:49 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered May 15, 2012 at 10:57 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
101k 19 21 74

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1948

asked: May 15, 2012 at 07:29 AM

Seen: 808 times

Last Updated: May 15, 2012 at 12:40 PM