Re: SQL 2005 Tools

I have warned the manager again via email of the risk of doing this and he
responded that he understands the risk but will go ahead with it. So I can
say I am immune from any consequences with email evidence in black and white.

Can you please point me to tools I can recommend to the manager to connect
to a specific database in the default instance over the internet as well as
connection strings used for specific tools.

Thanx.



"William Vaughn (MVP)" wrote:

It's a catch-22 sort of deal. In order to grant access to additional (specific) Windows domain accounts or to specific SQL Server login IDs you need to have System Administrator (SA) access to the database. Using these credentials you can use SSMS to connect to the server (instance) and make changes to the security settings including the logins. Notice that I have added specific domain users to the list of acceptable Logins. Each of these has properties that grant/deny access to specific system and user databases. Ah, setting up login authentication is not something to be taken lightly. Once you grant anyone (even your manager) rights to the database they can potentially wreck it, expose it to the outside world or just make it a living nightmare to keep stable... just don't tell me that I didn't warn you.




"MF" <MF@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9CA61292-C2FE-449A-961E-A1C38CFE60CE@xxxxxxxxxxxxxxxx
I am a consultant for the company and this just does not make sense. Not only
does he want the developer to work on the server, he himself is demanding
access to SQL management tools to access it too. He knows nothing about such
things yet he requested the password from me to access the server and poke
around the database and doing all sorts. I observed that his username has now
been added to system databases and he created a new database as well. The
server has remained pristine until he requested the password recently and
went into it the server.

Anyway, what string do I use to allow connections to a specific database in
the default instance and where do I put the string in what tool?

Thanx.



"William Vaughn (MVP)" wrote:

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)
____________________________________________________________________________________________




--
__________________________________________________________________________
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: 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: WSS install locked into MSDE DB - Can not install for SQL Serv
    ... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How to Replicate an SQL Server 2000 Database
    ... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: sqlservr.exe taking 90% of memory
    ... On the defrag issue I would stop all non-essential services but specifically ... It might be worth asking this on an sql server specific ... It would be interesting to have SQL Server Manager running and ... the database server every 30 minutes, which if you are having a slowdown ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... I have had quite a number of clients that used a SAN for a database server and suffered significant performance problems because their underlying SAN infrastructure was a huge stripe across many drives. ... By application files I mean the binn folder which contains the sql server executable among other things. ...
    (microsoft.public.sqlserver.setup)