RE: MSDE AND SBS2003

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Todd (Todd_at_discussions.microsoft.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 06:07:01 -0700

Xavier,

I was able to get access by using the syntax servername\instancename. I had
to set it up in the SQL Server Client Network Utility first though.

When you installed MSDE, did you use the command-line switch
SECURITYMODE=SQL? That gives you an instance with a null sa password.

Help me if you would. I was able to install MSDE on my XP Workstation the
way I wanted it. However, I was not able to install it on my SBS2003 Server.
Did you have any problems installing to SBS2003? Did you use
INSTANCENAME=newinstance?

Hope I helped!

Todd

"Xavier" wrote:

> Hi all!
>
> I beg you to help me if you know the answer to the folling problem.
>
> I have an Access database that I need to upgrade using MSDE because it's
> getting too big and slow.
>
> I've already installed MSDE in my SBS2003 server. The first question is: Is
> it correct to install MSDE or SBS2003 comes with something already
> installed? I say that because before installing MSDE, I saw a couple of
> MSSQL$SBSxxxxxxx entries when issuing an "net use" command from the server.
>
> When I try to contact the server from a WinXP workstation, I never find the
> SQLServer. I always get the "server not exists or don't have permision"
> error (or something like that). Could it be because of the user privileges
> at the workstation? If so, how can I change the permissions so anyone at the
> office can login the server?
>
> I've tried to set up a ODBC connection to the server but I can't find it.
> I've tried to let Access (Access2002) do the work converting the database
> but it neither can't find the server.
> If I open an osql window from the server itself, then there's is no problem
> in querying the server or create a database.
>
> So I understand that the server is running properly.
>
> Could you please tell me anything I can do? I'm quite lost!!!
> I didn't install the SBS2003, so there're details about its installation I
> don't know, but I'll try to give you all the details you need.
>
> Thanks!
> Xavier
>
>
>
>

Relevant Pages

  • Re: MSDE / ODBC install problem...please help...
    ... >I have installed MSDE (and ODBC) at my client site on their 2003 server. ... > have attached my SQL database via Teratrax Database Manager to the MSDE ...
    (microsoft.public.sqlserver.msde)
  • Create Database in VS.Net IDE
    ... I have been working with VS.Net for a few years but I am new to MSDE and SQL ... I have installed MSDE on my desktop and I want to administer my database ... I am in the Server Explorer but I am having trouble creating a database. ...
    (microsoft.public.vsnet.general)
  • Re: MSDE Install fails. No service listed.
    ... "Gavin" ha scritto nel messaggio ... > I installed MSDE with the following command line: ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Installation OK, but cant connect
    ... little toolbar icon with a green arrow indicating that the ... understand that's unnecessary since I just installed MSDE ... (I'm not sure what connection string one should use. ... trusted SQL Server connection.". ...
    (microsoft.public.sqlserver.msde)
  • MSDE AND SBS2003
    ... I've already installed MSDE in my SBS2003 server. ... MSSQL$SBSxxxxxxx entries when issuing an "net use" command from the server. ... I've tried to let Access do the work converting the database ...
    (microsoft.public.sqlserver.msde)