Re: No Security

From: Kent Tegels <ktegels@xxxxxxxxxxx>
Date: Wed, 8 Mar 2006 23:59:22 +0000 (UTC)

Hello John,

Ok...I've consulted with my co-workers and we seem to be at a loss.
How would I go about avoiding the "move to server" and registering the
remote instances in SSMS? What is SSMS?

SQL Server Management Studio, you know, that program you admin SQL Server with... :) [you are using something other than SQL 2005 Expression edition, right?]

You should be able to connect to any instance, even on the remote machines, so long as they have the proper network ports open and do whats needed on them.

Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

.

References:
- Re: No Security
  - From: John Reynolds

Prev by Date: Database security design with ASP.net and form-based authentication
Next by Date: Re: Database security design with ASP.net and form-based authentication
Previous by thread: Re: No Security
Next by thread: how to transfer logins between 2k5 instances
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Agent Job
... You want to add the job through stored procedure calls or using the GUI (SQL Server Management Studio, ... If you want to use SSMS, just use the Agent Node, Jobs, add a job, add a job step, make it CmdExec type and type the path and name of your exe file. ...
(microsoft.public.sqlserver.programming)
Missing SSMS
... These are the instructions to get into SSMS ... "To open SQL Server Management Studio ... On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio." ...
(microsoft.public.sqlserver.setup)
Re: Why I cant change collation w/ Query Analyzer, but can do that w/
... When making table changes you can generate a script in EM and SSMS ... SQL Server Management Studio, and what is in Mgmt Studio is very ...
(microsoft.public.sqlserver.tools)
Re: SQL Express MDF file moved from 1 computer to another - auth f
... I try to attach the database which is located in MyDocuments\Visual ... Microsoft SQL Server Management Studio ... now it tells me that authentication has failed for my windows ...
(microsoft.public.sqlserver.connect)
Re: SQL Express MDF file moved from 1 computer to another - auth f
... I try to attach the database which is located in MyDocuments\Visual ... Microsoft SQL Server Management Studio ... now it tells me that authentication has failed for my windows ...
(microsoft.public.sqlserver.connect)