| Groups | Blog | Home |
sql server new users : How to remotely adminster Sql Server
Hi,
We've just set up Sql Server 2000 on Win2003 server. My office machine is currently running Win2000. It's been years since I played with Sql Server and I don't remember the drill for setting up remote administration. I.e. I'm in my office and the machine is in the server room. I need to connect to the thing to do the standard DBA things like set up databases, tables, constraints, stored procs, etc. I;ve searched thru the docs for things like Remote Administration but didn't come up with anything that looked helpful. I'm sure Microsoft has invented it's own unintuiative lingo for remote adminstration ... all I need is a pointer to where to start in the documentation. I suspect it has something to do with connecting my workstation's MMC with the remote Sql Server. Thanks in advance. Barry in Oregon
Hi BBFrost,
In your case all you need is to register your SQL server with Enterprise manager, if you already tried this and cannot find server, reason is probably the firewall which is by default on WIN2003 so you have to allow traffic on TCP port 1433. Regards, Daniel [quoted text, click to view] "BBFrost" <barry.b.frost@remove_this.wrd.state.or.us> wrote in message news:uug9y$45EHA.2572@tk2msftngp13.phx.gbl... > Hi, > > We've just set up Sql Server 2000 on Win2003 server. My office machine is > currently running Win2000. > > It's been years since I played with Sql Server and I don't remember the > drill for setting up remote administration. I.e. I'm in my office and the > machine is in the server room. I need to connect to the thing to do the > standard DBA things like set up databases, tables, constraints, stored > procs, etc. > > I;ve searched thru the docs for things like Remote Administration but didn't > come up with anything that looked helpful. I'm sure Microsoft has invented > it's own unintuiative lingo for remote adminstration ... all I need is a > pointer to where to start in the documentation. > > I suspect it has something to do with connecting my workstation's MMC with > the remote Sql Server. > > Thanks in advance. > > Barry > in Oregon > >
Daniel,
Many thanks. Enterprise Manager ... that's the lingo I was looking for ! :) Best wishes and happy computing! Barry in Oregon [quoted text, click to view] "Daniel Joskovski" <omnis@NOSPAMunetREMOVECAPS.com.mk> wrote in message news:#zvxsX75EHA.992@TK2MSFTNGP12.phx.gbl... > Hi BBFrost, > In your case all you need is to register your SQL server with Enterprise > manager, if you already tried this and cannot find server, reason is > probably the firewall which is by default on WIN2003 so you have to allow > traffic on TCP port 1433. > > Regards, > Daniel > > "BBFrost" <barry.b.frost@remove_this.wrd.state.or.us> wrote in message > news:uug9y$45EHA.2572@tk2msftngp13.phx.gbl... > > Hi, > > > > We've just set up Sql Server 2000 on Win2003 server. My office machine > is > > currently running Win2000. > > > > It's been years since I played with Sql Server and I don't remember the > > drill for setting up remote administration. I.e. I'm in my office and the > > machine is in the server room. I need to connect to the thing to do the > > standard DBA things like set up databases, tables, constraints, stored > > procs, etc. > > > > I;ve searched thru the docs for things like Remote Administration but > didn't > > come up with anything that looked helpful. I'm sure Microsoft has invented > > it's own unintuiative lingo for remote adminstration ... all I need is a > > pointer to where to start in the documentation. > > > > I suspect it has something to do with connecting my workstation's MMC with > > the remote Sql Server. > > > > Thanks in advance. > > > > Barry > > in Oregon > > > > > >
JD,
Excellent! Many thanks. These are the 'leads' that I was looking for. Best wishes & Happy computing! Barry in Oregon [quoted text, click to view] "JD" <joeydba@yahoo.com> wrote in message news:41c98bbb$1@news.qgraph.com... > BBFrost, > If you haven't done so yet, you'll need to install the SQL Server Client > tools on your office machine. These are on the same CD as SQL, just choose > the option for Client tools. Then as, Daniel said in his post, you can use > Enterprise Manager to administer the SQL server instance. > > HTH > > > "BBFrost" <barry.b.frost@remove_this.wrd.state.or.us> wrote in message > news:uug9y$45EHA.2572@tk2msftngp13.phx.gbl... > > Hi, > > > > We've just set up Sql Server 2000 on Win2003 server. My office machine > is > > currently running Win2000. > > > > It's been years since I played with Sql Server and I don't remember the > > drill for setting up remote administration. I.e. I'm in my office and the > > machine is in the server room. I need to connect to the thing to do the > > standard DBA things like set up databases, tables, constraints, stored > > procs, etc. > > > > I;ve searched thru the docs for things like Remote Administration but > didn't > > come up with anything that looked helpful. I'm sure Microsoft has invented > > it's own unintuiative lingo for remote adminstration ... all I need is a > > pointer to where to start in the documentation. > > > > I suspect it has something to do with connecting my workstation's MMC with > > the remote Sql Server. > > > > Thanks in advance. > > > > Barry > > in Oregon > > > > > >
BBFrost,
If you haven't done so yet, you'll need to install the SQL Server Client tools on your office machine. These are on the same CD as SQL, just choose the option for Client tools. Then as, Daniel said in his post, you can use Enterprise Manager to administer the SQL server instance. HTH [quoted text, click to view] "BBFrost" <barry.b.frost@remove_this.wrd.state.or.us> wrote in message news:uug9y$45EHA.2572@tk2msftngp13.phx.gbl... > Hi, > > We've just set up Sql Server 2000 on Win2003 server. My office machine is > currently running Win2000. > > It's been years since I played with Sql Server and I don't remember the > drill for setting up remote administration. I.e. I'm in my office and the > machine is in the server room. I need to connect to the thing to do the > standard DBA things like set up databases, tables, constraints, stored > procs, etc. > > I;ve searched thru the docs for things like Remote Administration but didn't > come up with anything that looked helpful. I'm sure Microsoft has invented > it's own unintuiative lingo for remote adminstration ... all I need is a > pointer to where to start in the documentation. > > I suspect it has something to do with connecting my workstation's MMC with > the remote Sql Server. > > Thanks in advance. > > Barry > in Oregon > >
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |