Re: SQL7 standalone

From: giovanni (anonymous_at_discussions.microsoft.com)
Date: 03/10/04


Date: Wed, 10 Mar 2004 10:16:08 -0800


  No, it answers: "unable to connect to server "\\NOTEBOOK"
Server: Msg 17, Level16, State 1
...server does not exists or access refused (this maybe not the same 'cos I translated from Italian version)
     ----- Dejan Sarka wrote: -----
     
     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: Save as in SQL Server(Backup - Restore)
    ... "Dan Guzman" wrote in message ... > SQL Server MVP ... I take it you already know about the RESTORE command ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: SP accessing other db
    ... regarding the cross-database chaining server option. ... Now the database name is hard-coded. ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Type of Cluster?
    ... MVP - Windows Server - Clustering ... >> cluster, granted not as fast as a SAN, but cheaper:) ... >>>well within the capabilities of SQL Server. ... >>> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: active active: can somebody help with design?
    ... SQL Server MVP ... You can't have a default instance in virtual server 1 and another default ... You don't install the instances on particular nodes per se. ...
    (microsoft.public.sqlserver.clustering)
  • Re: What those data files use for?
    ... Columnist, SQL Server Professional ... Now I need move all the system databases to SAN drive, ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)