Re: SQL 2005 Tools

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: Reaching Access 2003 datas via SQL Server 2005 64 bits
    ... even with the procedure to create the invoice number I still ... One client enters in the store and asks for a product. ... formats of Access database files known as MDB and ACCDB and/or Access JET. ... (I have no problem to reach Sql Server 2005 tables from Microsoft ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (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)
Loading