can't connect to sql server using ip number

31 Mar 2006 2:06 AM

AC

My code:
Dim IP As String
IP = "192.168.0.169"
SqlConnection1.ConnectionString = "workstation id=xxxxx;integrated
security=SSPI;Data Source=" & IP & ";persist security info=False;initial
catalog=adp1SQL"

The error occurs when I use the IP address instead "mshome". when
IP="MSHOME" the code runs smoothly.
while in the development stage, this project is only instaled in the PC
where MSDE 2000 is installed. Could this be the problem?

31 Mar 2006 7:45 AM

Cor Ligthert [MVP]

AC,

Can you try it with an as short as possible connection String.
Server=192.168.0.169;DataBase=;Integrated Security=SSPI

I hope this helps,

Cor

Show quote

> Dim IP As String
> IP = "192.168.0.169"
> SqlConnection1.ConnectionString = "Data Source = 192.168.0.169;
> integrated
> security=SSPI;"
>
> The error occurs when I use the IP address instead "mshome". when
> IP="MSHOME" the code runs smoothly.
> while in the development stage, this project is only instaled in the PC
> where MSDE 2000 is installed. Could this be the problem?
>

31 Mar 2006 8:05 AM

AC

sorry, didn't work.
but the exact same thing happened.
when server=Mshome, everything works.
when server=IP number, doesn't work.

AC

Show quote

"Cor Ligthert [MVP]" wrote:

> AC,
>
> Can you try it with an as short as possible connection String.
> Server=192.168.0.169;DataBase=;Integrated Security=SSPI
>
> I hope this helps,
>
> Cor
>

31 Mar 2006 8:24 AM

AC

ok. I've tried to perfom this connection using a diferent sql server in a
different PC.
and it worked using both ways. (IP number and name)
This tells me that the problem is not on my vb code but in my server
configuration.
any help in how to configure my server to work correctly?

AC

Show quote

"Cor Ligthert [MVP]" wrote:

> AC,
>
> Can you try it with an as short as possible connection String.
> Server=192.168.0.169;DataBase=;Integrated Security=SSPI
>
> I hope this helps,
>
> Cor
>
>
>
> > Dim IP As String
> > IP = "192.168.0.169"
> > SqlConnection1.ConnectionString = "Data Source = 192.168.0.169;
> > integrated
> > security=SSPI;"
> >
> > The error occurs when I use the IP address instead "mshome". when
> > IP="MSHOME" the code runs smoothly.
> > while in the development stage, this project is only instaled in the PC
> > where MSDE 2000 is installed. Could this be the problem?
> >
>
>
>

31 Mar 2006 2:08 PM

Ron Allen

AC,
Use the Server Network Utility and make sure that TCP/IP is in the list
of active protocols. For new installations this is normally off by default
nowdays to prevent security holes.

Ron Allen
Show quote

"AC" <A*@discussions.microsoft.com> wrote in message
news:1CF512D0-97F5-4010-BE91-33E191AD0AEA@microsoft.com...
> ok. I've tried to perfom this connection using a diferent sql server in a
> different PC.
> and it worked using both ways. (IP number and name)
> This tells me that the problem is not on my vb code but in my server
> configuration.
> any help in how to configure my server to work correctly?
>
> AC
>
> "Cor Ligthert [MVP]" wrote:
>
>> AC,
>>
>> Can you try it with an as short as possible connection String.
>> Server=192.168.0.169;DataBase=;Integrated Security=SSPI
>>
>> I hope this helps,
>>
>> Cor
-----------snip------------