Professional 2002 cant connect to SQL Server

[Fred]

Our new installation:
Windows 2000 Server
Project Server 2003
Sql Server 2000 strd

Hi all, i'm new to the forum, this place looks promising

I'm trying to publish project (Enterprise Global) in
server from Project Professional 2002. I get this error:

SQLState: 01000
SQL Server error: 53
SQLState: 08001
SQL Server error: 17
Server doesn't exist or access denied.

In PWA IE crashes or give jscript errors when opening
pages containin OWC's. We didn't have these problems in
our test environment were we used Project server 2002.

I succesfully have tried telnetting in port 1433, so
tcp/ip should be fine. On the other hand, server hasn't
been added in any DNS. Is it ok to use just IP for SQL
connectivity ?

any help?

thanks in advance

//Fred

 

[Nico Oosthuysen]

Hi Fred,
In my experience it really is much better to use DNS rather than a IP
address. I would suggest maybe putting a entry into your hosts file
pointing the IP to the name of the server, and seeing if that solves your
problems.

To put the entry into your hosts file, do the following:

Using the Search function in Windows, look for a file called "hosts"
Open this file in notepad.
At the end of the file, add entries like this:
10.10.11.1 dogmatix.traindomain.local
10.10.11.1 dogmatix

where "10.10.11.1" is the IP of your server, "dogmatix" is the name of your
server, and "traindomain.local" is the name of your DNS domain.

I hope this makes sense?

Nico Oosthuysen