SQL error when importin enterprise project

L

lovets

hi,
i installed MS Porject Server 2003 on my server and connectod via my MS
Project Pro. But when i tried to import my project i got the SQL error;

Connection Failed;
SQLState: '01000'
SQL Server Error: 52
[Microsoft][ODBS SQL Server Driver][DBNETLIB]ConnnectionOen (Connect())
Connection failedÄ°
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBS SQL Server Driver][DBNETLID]SQL Server does not exist or
access denied.

at the next step it give me a login screen
where
Server = localhost
i chnage it to my project server
Server = project_srv

when i tried to connect with this Server = project_srv option i got the
following error

[Microsoft][ODBS SQL Server Driver][SQL Server]Cannot insert duplicate key
row in object 'MSP_PROJECT' with unique index 'I_PROJ_NAME'.

and i can not import my project what could be a problem.
 
G

Gary L. Chefetz [MVP]

Lovets:

Does your server name really contain an underscore? You do realize that
underscores are not legal in http URLs? If you answer yes, if I were you,
I'd start over again with a clean install.
 
L

lovets

No, my server name is not really project_srv i just write to show that i
changed to project_srv.
my project srv name is "project"

Gary L. Chefetz said:
Lovets:

Does your server name really contain an underscore? You do realize that
underscores are not legal in http URLs? If you answer yes, if I were you,
I'd start over again with a clean install.




lovets said:
hi,
i installed MS Porject Server 2003 on my server and connectod via my MS
Project Pro. But when i tried to import my project i got the SQL error;

Connection Failed;
SQLState: '01000'
SQL Server Error: 52
[Microsoft][ODBS SQL Server Driver][DBNETLIB]ConnnectionOen (Connect())
Connection failedI
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBS SQL Server Driver][DBNETLID]SQL Server does not exist or
access denied.

at the next step it give me a login screen
where
Server = localhost
i chnage it to my project server
Server = project_srv

when i tried to connect with this Server = project_srv option i got the
following error

[Microsoft][ODBS SQL Server Driver][SQL Server]Cannot insert duplicate key
row in object 'MSP_PROJECT' with unique index 'I_PROJ_NAME'.

and i can not import my project what could be a problem.
 
G

Gary L. Chefetz [MVP]

Lovets:

Try to be careful what you write. We can only take this stuff literally.
What order did you install? WSS first or second? What else can you share
about how you setup your system? Changing names to protect the innocent is
fine, as long as you do so without adding confusion to your questions.




lovets said:
No, my server name is not really project_srv i just write to show that i
changed to project_srv.
my project srv name is "project"

Gary L. Chefetz said:
Lovets:

Does your server name really contain an underscore? You do realize that
underscores are not legal in http URLs? If you answer yes, if I were you,
I'd start over again with a clean install.




lovets said:
hi,
i installed MS Porject Server 2003 on my server and connectod via my MS
Project Pro. But when i tried to import my project i got the SQL error;

Connection Failed;
SQLState: '01000'
SQL Server Error: 52
[Microsoft][ODBS SQL Server Driver][DBNETLIB]ConnnectionOen (Connect())
Connection failedI
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBS SQL Server Driver][DBNETLID]SQL Server does not exist
or
access denied.

at the next step it give me a login screen
where
Server = localhost
i chnage it to my project server
Server = project_srv

when i tried to connect with this Server = project_srv option i got the
following error

[Microsoft][ODBS SQL Server Driver][SQL Server]Cannot insert duplicate
key
row in object 'MSP_PROJECT' with unique index 'I_PROJ_NAME'.

and i can not import my project what could be a problem.
 
G

Gary L. Chefetz [MVP]

Lovets:

Try to be careful what you write. We can only take this stuff literally.
What order did you install? WSS first or second? What else can you share
about how you setup your system? Changing names to protect the innocent is
fine, as long as you do so without adding confusion to your questions.




lovets said:
No, my server name is not really project_srv i just write to show that i
changed to project_srv.
my project srv name is "project"

Gary L. Chefetz said:
Lovets:

Does your server name really contain an underscore? You do realize that
underscores are not legal in http URLs? If you answer yes, if I were you,
I'd start over again with a clean install.




lovets said:
hi,
i installed MS Porject Server 2003 on my server and connectod via my MS
Project Pro. But when i tried to import my project i got the SQL error;

Connection Failed;
SQLState: '01000'
SQL Server Error: 52
[Microsoft][ODBS SQL Server Driver][DBNETLIB]ConnnectionOen (Connect())
Connection failedI
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBS SQL Server Driver][DBNETLID]SQL Server does not exist
or
access denied.

at the next step it give me a login screen
where
Server = localhost
i chnage it to my project server
Server = project_srv

when i tried to connect with this Server = project_srv option i got the
following error

[Microsoft][ODBS SQL Server Driver][SQL Server]Cannot insert duplicate
key
row in object 'MSP_PROJECT' with unique index 'I_PROJ_NAME'.

and i can not import my project what could be a problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top