> 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?

"Erland Sommarskog" <sommar@algonet.se> wrote in message
news:Xns93C4E2B0246E6Yazorman@127.0.0.1...
> Kasper (ovi@kabelnettet.dk) writes:
> > 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?
>
> This sounds more like question for an MS Project forum. I cannot
> answer how you can change the server name in MS Project.
>
> However, you may want to check out the Client Network Utility in the
> SQL Server program group. Here you can add an alias which you can map
> to an IP address.