Access 2003 / SQL Server 2005 linking.

I have an Access 2003 database that I have split, then upsized to SQL Server
2005. The database works find on the machine that has the SQL Server 2005,
but when I try to run the program from another machine on the network, I get
the following error:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
Now I have done everything suggested by Microsoft's documentation
(http://support.microsoft.com/default.aspx/kb/914277), including setting the
SQL Server Surface Area Configuration tool and modifying the firewall
settings.
Does anyone have any other suggestions I can try?
(I think the problem may be in my dsn file, but I am not sure.)
--
Larry J. West, MCSD, MOUS, FLMI, ACSSame error I was getting.
My problem was caused by an alias set up in client network utility to the
server.
I just deleted the alias and then Access connected fine.
Gary
"LarryWestMCSD" wrote:

> I have an Access 2003 database that I have split, then upsized to SQL Serv
er
> 2005. The database works find on the machine that has the SQL Server 2005
,
> but when I try to run the program from another machine on the network, I g
et
> the following error:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> Now I have done everything suggested by Microsoft's documentation
> (http://support.microsoft.com/default.aspx/kb/914277), including setting t
he
> SQL Server Surface Area Configuration tool and modifying the firewall
> settings.
> Does anyone have any other suggestions I can try?
> (I think the problem may be in my dsn file, but I am not sure.)
> --
> Larry J. West, MCSD, MOUS, FLMI, ACS