Re: SQL 2005 Tools

Ah, as I see it, your manager is begging for a disaster. Consider that SQL Server is initially configured to prevent access from the web or even the network. You'll need to enable the ports and protocols using the SQL Server Surface Area configuration tool. SSMS can't be "configured"--all you get to provide is a connect string to point to the server instance and pass the credentials (and little else). Configuration is all done on each server instance.

I rarely (okay, never) recommend exposing a SQL Server on the WWW to be accessed by an IP address.
I never recommend doing development on a production server. I know by experience that it's VERY simple to delete or mangle the database with no hope of recovery.
I suggest building a system that has a copy of the production database for your manager to play with. Once the application is working, then you can try to access the production DB.

If I was working for you as a consultant and came across a manager with this attitude, I would leave. I would not want my name associated with a highway bridge as the manager started pulling out bolts.

"MF" <MF@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:46CF31BF-B1A1-4F70-B46A-AF14804F25AA@xxxxxxxxxxxxxxxx
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)
____________________________________________________________________________________________




--
__________________________________________________________________________
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: 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)
  • 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.server)
  • 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)