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.

Re: SQL Server Problem. by dolphinearth

dolphinearth
Tue Jan 09 03:47:07 CST 2007


Ciaran O''''Donnell wrote:
> 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
>
>
> --
> Ciaran O'Donnell
> http://wannabedeveloper.spaces.live.com
>
>
> "dolphinearth@gmail.com" wrote:
>
> > 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.
> >
> >


Thank you, it seems the problem were port numbers.