Additionally use Surface Area Configuration tool, that comes with sql server, to allow remote connections to server.
Thanks TFR. On Tue, Feb 24, 2009 at 3:47 PM, Kassa <[email protected]> wrote: > > if you are working in a network.Check these things first. > > is client computer can communicate with server ? try ping command. > is server allowing remote connection ..most in cases need to check > port is opened or not (default port 1433) > you are in a intranet ..then check dns settings in tcp/ip properties > or use IP address to replace the computer name. > > more information can be after posting error message. > > kassa > www.elinklanka.com > > On Feb 24, 8:00 am, MikaylaLouise <[email protected]> wrote: >> Hello, >> >> Can anyone assist me on my problem, I'm really having a hard time >> trying to figure out how to modify my program. I have build a >> winforms application connecting to an sql server database (from >> another computer) using remote connection. I have installed it on my >> machine and it works fine. But when I try to install it on another >> machine, the connection doesn't seem to work at all. I think this has >> to do something with the logins in the SQL Server because my computer >> name is included in it. How do I configure my program to allow >> anonymous connections, or at least eliminate the computer name so that >> I can access my database on the program from anywhere in the network? >> Is this possible? >> >> I guess also that this has to do with my connection string, but how >> can I configure it? I have created my installer using the click once >> method. I'm not familiar with the other methods. >> >> Please help! >> >> MikaylaLouise >
