Re: Error Message When Connecting to SQl Server Data

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 12:16:36 +0100

hi Gerald
"Gerald G" <GeraldG@discussions.microsoft.com> ha scritto nel messaggio
news:7CD6EC0F-53A4-4252-9228-A40089BE66FF@microsoft.com
> Hi Andrea - thanks for answering
> I think you are right about it being a standard security problem.
> How do I telnet on port 1433, and How do I grant login to my MSDE
> instance?
>

in order to grant your 'OFFICEPC\xxxx' users, you have to add them to the
SQL Server Windows logins...
please have a look at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003#8 for
further info about granting login to Windows logins/groups 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.9.1  -  DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Relevant Pages

  • Re: Securing Connection string
    ... How do I assign rights to the SQL Server ... instance my app will be using and how to I assign the rights to my database ... recommended to avoid the users from having to login again and again (once on ... Andrea Montanari ...
    (microsoft.public.sqlserver.msde)
  • Re: Install MSDE w/ MSDE Depl.Toolkit. What permissions when using Win Auth?
    ... "Andrew Gaskell" ha scritto nel messaggio ... login member of that group will be granted SQL Server login privilege, ... not your clients that should be member of other groups... ... Andrea Montanari ...
    (microsoft.public.sqlserver.msde)
  • Re: 5 User License
    ... Thanks for clearing up my doubt ... if you choose MSDE, ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: is it worth creating multiple indexes?
    ... (customer code, invoice, product code, ... This technique worked well in DBF so I'll try it in SQL. ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: Yukon tools?
    ... In addition to Andrea usual great response, :-), there will be a GUI ... management tool shipped with SQL Server 2005 Express, ... >> were named either with Yukon or 2005 so im posting it here. ... >> Manager, Query Analyzer or anything. ...
    (microsoft.public.sqlserver.tools)