newbie connection problem

From: Ernesto (tsh_at_mathematicuslabs.com)
Date: 06/28/04


Date: Mon, 28 Jun 2004 11:48:55 -0400

I am just starting with MSDE switching from access2002.
The installation was done on a server pc with:
password="sa",
Authentication Mode = SQL, and
DisableNetworkProtocols=0

On the server, I can connect to it fine, both via my app and the configure
wiz'd in the SYSTEM-DSNs list (off of control panel-Admin tools).

But from another PC on a two computer network, I cannot connect to it.
The configure wiz;d gives a double error:
SQLstate 1000 connaction failed ANd
SQLState 8001 error 17: serber does not exist or connection denied.

Do I need to specify anything other than server's name as the server's ID,
e.g. the hard disk label or....?
Do I need to somehow tell the server to allow a conection from another
PC???? If yes, I can't find where that might be done?

I'd really appreciate ANY help on this frustrating problem.
Thanks in advance,



Relevant Pages

  • Re: SQL 2008 remote Management Studio connection
    ... can you recommend some good books for SQL 2008? ... Rick Byham, SQL Server Books Online ... is SQL Server and Windows Authentication mode ...
    (microsoft.public.sqlserver.connect)
  • Re: Not allowed to switch authentication modes
    ... It would not be enough to set a password to make the "sa" Login work. ... And to be able to connect using "sa" account you must change the authentication mode to Mixed Mode from Windows Authentication. ... > uninstall the entire sql server, ...
    (microsoft.public.sqlserver.security)
  • Cannot connect
    ... I have SQL 2000 installed on the server, and running VB6.0 program on the ... clients. ... SQLState: '08S01' ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL cannot connect to database for OnePoint/MOM/ForeFront all
    ... I restart SQL on the server, there are no errors referring to OnePoint in the log, about a minute later it starts doing this: ... [SQLSTATE 28000] ... The login failed. ...
    (microsoft.public.sqlserver.server)
  • Sql Mail Error c0000005 EXCEPTION_ACCESS_VIOLATION
    ... Server is terminating this process. ... [SQLSTATE HY000] ... From our Sql mail. ... running Windows 2000 Advanced Server and SQL Server 2000 ...
    (microsoft.public.sqlserver.tools)

Loading