Re: SQL 2005 Tools

I have tried my best to warn the manager who authorized this sort of work. I
made the implications clear to him and advised him to have the developer do
any development on their server and port over for deployment when done. He
said NO, that he prefers developing directly on the server that currently
runs the company's business. At least I have this in black and white on my
email so it won;t be an issue of blaming me for anything.

Anyway, I downloaded and installed the SSMSE
(http://www.microsoft.com/downloads/details.aspx?FamilyID=6053c6f8-82c8-479c-b25b-9aca13141c9e&displaylang=en)
and I need to know how to use this thing to connect to the database remotely.
I have already forwarded TCP port 1433 and UDP port 1434 to the SQL server
and I am able to telnet to port 1433 successfully.

How do I configure SSMSE to connect to the database in a re mote office via
TCP/IP?

Thanx.


"William Vaughn (MVP)" wrote:

Ah, I would install the Client tools from SQL Server Express (Advanced
Services Edition) to get to the server, but I'm not sure this is such a good
idea unless you don't really care about data security or integrity. The fact
that they want to create an Access application against the DBMS is troubling
as well. If it's not properly implemented, a clumsy or inept developer (or
manager) can wreck the entire database in a heartbeat--with any client tool.

Drop me a line if you want to talk this over in more detail. I would also
suggest picking up a copy of my book. It's targeted at companies like yours.

"MF" <MF@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:864C2757-E417-4B11-BAE3-51B98E73C75E@xxxxxxxxxxxxxxxx
In addition, the developer needs to develop a database with Office Access
for
the company I believe. I have not been able to speak with her yet, but I
was
told this by the manager.

"MF" wrote:

Thanx for your response. Yes, SSMS is included in SQL 2005 on SBS. How do
I
load SSMS (and what other tools) on client machines to connect to a
specific
database created on the default instance?

Thanx.


"Andrew J. Kelly" wrote:

Connecting to the database can be done via ODBC, OLEDB etc. from just
about
any client interface. The question is what does this developer need to
do?
The tool of choice to manage a SQL2005 database, write TSQL etc. is the
SQL
Server Management Studio (SSMS). You are telneting to the server that
the
database instance is hosted on, not the database instance itself. I
don't
know what comes with SBS but I have to assume SSMS is included and if
the
client tools were loaded you can find it in the SQL Server folder in
the
start menu. You can load the client tools (SSMS & others) on other
machines
as well in order to connect to SQL Server.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"MF" <MF@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51C67DBC-FFEE-46C9-ABAB-CAD1F2DB6CCF@xxxxxxxxxxxxxxxx
Hello All,

I am not conversant with SQL but I need to know what tools or apps
can be
used to connect to SQL Server 2005 on SBS 2003 Premium or what
methods
there
are for connecting to it. Basically, my manager (who knows nothing
about
databases) demands that he needs to connect to the database being
made
available to a developer). The database has been created and I am
able to
successfully telnet to it remotely. How can I have the manager
connect to
it?
And what else do I need to do to let the developer connect and do
development
work on it?

Thanx.



--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________



.

Relevant Pages

  • Re: Access to Visual Basic Conversion???
    ... As the number of records in this database has grown, ... mentioned that I should start looking at converting the ... >On a typical developer team, ... >to sql server). ...
    (microsoft.public.access.formscoding)
  • Re: Senior Developer looking for your asst in employmt issue (not job seeking!)
    ... manager hat, you must manage expectations. ... Wish I could see the actual database to answer your ... > I am dealing with a tough employment issue in which a supervisor - who is ... > I've been working professionally as a developer since 1993. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Senior Developer looking for your asst in employmt issue (not job seeking!)
    ... manager hat, you must manage expectations. ... Wish I could see the actual database to answer your ... > I am dealing with a tough employment issue in which a supervisor - who is ... > I've been working professionally as a developer since 1993. ...
    (microsoft.public.vb.database)
  • Re: Senior Developer looking for your asst in employmt issue (not job seeking!)
    ... manager hat, you must manage expectations. ... Wish I could see the actual database to answer your ... > I am dealing with a tough employment issue in which a supervisor - who is ... > I've been working professionally as a developer since 1993. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: How do I approach this?
    ... a s/w developer or any other developer. ... > If I was your manager you would have a very hard time convincing me this ... >> comment' that it could really do to be something like an sql database. ... >> be better on the corporate sql server and this seemed appropriate. ...
    (microsoft.public.vstudio.development)