Problem while connecting to a remote SQL Server through VS.NET1.1

Hi All..

I am having a problem while connecting to a remote sql server through VS.NET 1.1 , an asp.net application. It says :"SQL Server does not exist or access denied".

I have connected to the same server from my home using the same connection string through an asp.net 1.1 app.. So it cant b a prob with Server permissions. I can connect to the same server frm my office through asp.net2.0 app.. So its got nothing to do with office permissions.

I need this connection from my office from asp.net1.1 app 2 debug n find solution for a bug as im unable to simulate it here.

Will this be smth to do with .net installation, some security enabled in vs.net.. I have no idea.. Please help me at the earliest..

Thanks in advance..

aLLEN

Hi Allen,

First, please try to ping the server to see if you can connect to it. Then check if the SQL Server is the default instance. If not, you will need to add instance name after server name in your connection string.

You can try to use SQL Authentication to connect again. If that still doesn't work, please post your connection string here.