Re: SQL7 standalone

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 09:38:29 +0100

Can you connect with Query Analyzer using a SQL login (SQL authentication)? 

-- 
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"giovanni" <anonymous@discussions.microsoft.com> wrote in message
news:FE2D762F-C255-4D90-BFAB-4327035E43D5@microsoft.com...
> Hi Dejan, I checked my local install: mixed authentication is enabled but
still when notebook is connected to a network all works fine, but when is
disconnected service can started but Enterprise manager can't let me browse
anything of my databases. Do You have another idea?
> TIA giovanni
>
>      ----- Dejan Sarka wrote: -----
>
>      I thought you mean SQL Server installed on the ME. It has to be
Personal or
>      MSDE edition, I guess. Still you need SQL authentication, because
MEdoes not
>      have local Win users. Check if your local ME installation (which
version is
>      it?) has mixed authentication mode enabled.
>
>      -- 
>      Dejan Sarka, SQL Server MVP
>      Associate Mentor
>      Solid Quality Learning
>      More than just Training
>      www.SolidQualityLearning.com
>
>      "giovanni" <anonymous@discussions.microsoft.com> wrote in message
>      news:F39AC964-3D32-48AB-8C6A-30A787194A1B@microsoft.com...
>      >>      Dejan, I already use SQL server Authentication, maybe there
was a
>      misunderstanding: server side is installed onto ME notebook too. I
tried to
>      create a new server registration as LOCAL but I recieve always a
mesage of
>      connection failure.
>      >>      ----- Dejan Sarka wrote: -----
>      >>> Hi Dejan, one more problem: notebook has WindowsME as OS.
>      >>      Then your only choice is to use a SQL Server login.
>      >>      -- 
>      >      Dejan Sarka, SQL Server MVP
>      >      Associate Mentor
>      >      Solid Quality Learning
>      >      More than just Training
>      >      www.SolidQualityLearning.com
>      >>>

Relevant Pages

  • Re: Multiple Quesions and some feedback on Modelling
    ... need to add ENV is sql server 2005 enterprise edition. ... Have a model structure that entails three mining models including tree. ... >> was they are trained already for sql management studio because otherwise ... > Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.datamining)
  • Re: Multi Dimensional Cases in Time Series
    ... This message does not imply endorsement from Solid Quality Learning, ... >> - in SQL Server, create a linked server to the Analysis Services ... >> Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.datamining)
  • Log of Logins/Logouts
    ... Subject: Re: Log of Logins/Logouts ... Dejan Sarka, SQL Server MVP ... > for me because the applications I'm looking for all use ...
    (microsoft.public.sqlserver.security)
  • Re: SQL7 standalone
    ... I thought you mean SQL Server installed on the ME. ... Still you need SQL authentication, ... Check if your local ME installation (which version is ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Shrinking or reseting log file
    ... Dejan Sarka, SQL Server MVP ... > It seems that two databases are using the same log file ... >> Dejan Sarka, SQL Server MVP ... >> Solid Quality Learning ...
    (microsoft.public.sqlserver.programming)