"dolphinea***@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.
>
>

> 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
>
>
> "dolphinea***@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.
> >
> >