SQL Server Problem.

[dolphinearth]

Hi. I hope someone smarter than me could help me with this strange
problem.

I created a system which needs to connect to a SQL database. Initially
the programs were designed in Visual Studios 2003 .Net, and the
database was SQL Server 2000. After a long wait, I finally got the go
ahead to install the software for the client, and I managed to get the
PDA software to connect with the database. But after a while, I
installed the SQL Server 2005 and the Management Studio for the Sql
Server. But this is now where my problem arises. I tried connecting to
the database again with the PDA, but it now says "Index 0: Server does
not exist or access denied" and I have checked the same settings with
the server application, but the application on the server logs into the
database. Even if I try removing everything, uninstalling the system,
wiping the database, and resetting the PDA, I still end up with that
problem.

This now occured after I installed SQL Server 2005, and I can't figure
out why this problen now surfaces, and even if I remove SQL Server
2005, it still says "Index 0: Server does not exist or access denied"
on the PDA.

Here is my connection string I pull out of a File I wrote:
mSession.CurrentConnection.ConnectionString = "Data Source=test;Initial
Catalog=DB;User Id=sa;Password=sa@123";

If I run this from my work computer, everything runs fine, but as soon
as I switch to the test computer, that error keeps on popping up. Any
way I can completely uninstall the WHOLE sql server from the test
computer? Every single file and folder? I already removed it by using
Control Panel Add Remove Programs, yet I still have this problem.

Does anyone have a solution without needing to reformat a server?

All and any help is greatly thankful.

 

[dolphinearth]

I assume you are still trying to connect to SQL2000 but you installed SQL2005
alongside it. You should check the SQLServer server network configuration as
SQL2005 may have changed its port number (although shouldnt have). Also check
the server settings to see whether it allowes mixed mode authentication and
whether it allows network connections.
If your still have problems, try and connect through a network pipe rather
than TCP. look up in the help how to set this up.
Plus, try the sqlserver newsgroup

HTH

Thank you, it seems the problem were port numbers.