Connection error from Project2002 to SQL-server - wrong server-name

[Kasper]

Hi
I also posted this at microsoft.public.sqlserver but thought that some of
you might know the answer...:

When connection from MS Project 2002 using the Enterprise options, I'm
confronted with a dialogue-box saying:

Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Micosoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Micosoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not excist or
access denied.


I know that the problem is a wrong servername, because when i click OK to
this info, another dialoguebox shows up, and i can now write the correct
servername.

The server-name that the connection uses by default it the LOCAL servername,
but i'm located outside the domain, so I have to type in the external
IP-number - and do this every time i have to connect to the Db!


Is there any way i can make this connection use the IP-number instead of the
local server-name (so i wont have to do this retyping every time) by
default?


Thanks in advance!

Kasper

 

[John Rutledge]

I had the same problem doing this over the internet. I got around it by
adding a client-side alias for the SQL Server. This works fine, but means
that every machine that is going to access the SQL Server will have to do
this same procedure.

On the client machine that will be connecting to SQL Server:
- Start->Run->cliconfg
- Select the Alias Tab
- Click Add
- Type in the local name that is being used in the top field, then the fully
qualified name in the Server Name field. Be sure to select the correct
protocol (TCP/IP if you're doing this over the internet)
- Click Ok, then Ok again

That should fix the problem.

Let me know if you another/better solution.

-- jr