Re: SQL 2005 Tools

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.


.

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: SQL 2005 Tools
    ... I have tried my best to warn the manager who authorized this sort of work. ... 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 ... a clumsy or inept developer (or ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL 2005 Tools
    ... Ah, I would install the Client tools from SQL Server Express 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. ... a clumsy or inept developer (or manager) can wreck the entire database in a heartbeat--with any client tool. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Developer Remote Access
    ... The developer doesn't have to have access to SQL Server at all in order to develop the application. ... He can develop locally at their location and when they are ready to deploy they create the database part of the system at your location. ... You just created a> Login ...
    (microsoft.public.windows.server.sbs)
  • SQL Auditing with Single-Sign On Web App? Possible? Best Practices?
    ... for generating an audit trail of ALL user activity within a database that is ... Experience-wise, I am not a web developer, I am a ... and I have decent Transact-SQL and SQL Server experience. ... "apply" the code to any database I specify. ...
    (microsoft.public.sqlserver)
Loading