connection problem

Hi.
I have installed Microsoft SQL Server Desktop on Windows XP Pro. I can
connect to database from remote machines with Windows 98Se, but i can't
connect from machines with Windows XP.
ChrisI think that it is a problem with not having the 'correct' client network
utilities installed.
On the Start menu, select [All Programs], [Microsoft SQL Server], th
en
[Client Network Utility].
In the [Enabled Protocols] window, you should have both TCP/IP and Named
Pipes.
If one is missing, select the missing protocol from the list on the left
side, and click the [Enable] button.
Hopefully, if my memory is correct, that will take care of the problem.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Krzysztof" <colinkj@.poczta.onet.pl> wrote in message
news:eb0a61$jov$1@.nemesis.news.tpi.pl...
> Hi.
> I have installed Microsoft SQL Server Desktop on Windows XP Pro. I can
> connect to database from remote machines with Windows 98Se, but i can't
> connect from machines with Windows XP.
> Chris
>
>|||Have you tried temporarily disabling the firewall on the XP machines?
John Opincar
john.opincar@.sundesksoftware.com
"Krzysztof" <colinkj@.poczta.onet.pl> wrote in message
news:eb0a61$jov$1@.nemesis.news.tpi.pl...
> Hi.
> I have installed Microsoft SQL Server Desktop on Windows XP Pro. I can
> connect to database from remote machines with Windows 98Se, but i can't
> connect from machines with Windows XP.
> Chris
>
>

connecting to web database from desktop application.

I am thinking of using my web database as the database to use for my program, though not sure how feasible due to connection speeds and having to transfer that info.

what I am using as the connection string is

con.ConnectionString = "Data Source=databse ipadress inserted here; Initial Catalog=databasename here;Integrated Security=True"; with real data obviously inserted into the ip and tables, but when i try and send values there it just hangs and then crashes. I am thinking its not finding the database. Is there something else im to do?

I am using the exact same code as when i use my own machine as the server, and it works great that way, only thing different is the trying to send to the web server.

Verify with your host IF the SQL Server is available outside the firewall -my guess is NOT.

You probably would need to also add the IP port: "Data Source=nnn.nnn.nnn.nnn:1433;..."

Security would be different since I doubt that you are in the same domain -therefore "...;Intetrated Security=True" probably isn't true. You would most likely need a SQL Server login (User/Password).

But first, check with the host to see if it is even worth any more time.

|||

I contacted them and it seems like it should be np. They told me where I need to add in the white space the ipaddress its coming from and did all that.

From looking at another site I got a little code from there, but still is wrong. is this any closer?

con.ConnectionString = "Data Source=69.89.20.44:3306; user=buenavi1_test&password=testing; Initial Catalog=buenavi1_Lottery";

This was simply a test table set up and a test user and password and im sending the data from a program i have used before to this database and not the other database I used, so I know the data is good.

Just always times out on the connection string.

|||

Rick,

First, a reminder to be cautious when posting security information. You should immediately change your username and password -many hackers will be hitting the connection you posted.

I see this error: "user=buenavi1_test&password=testing" should be "user=buenavi1_test;password=testing" (Semi-colon instead of amperstand.)

But more importantly, since you aren't getting any error messages, I suspect that you may not be making a connection.

Have you verified that your firewall is open and allowing outbound traffic?

|||

Thanks for the help, I will review this agin later. Still not going through so I will check firewalls.

Im not needing this as an option was just investigating the feasibility more or less of using it like that.

As far as security, in this point I wasn't too concerned as that database, table, user name and password were all created for no other reason then to test this, they aren't used elsewhere for anything, but I have now deleted all.

Again thanks for the help.