Client not work

[turillo]

hi guys

I have a problem to run a client

I installed sql express and it works fine locally.

the server is windows 7 pro.
The client is windows xp home

I tried to install sql express with user id and password,  not work.

sql browser is running!

on the client I used this string: data source = Turillo-pc\tre; user id = sa, password = 1234  (not work)

I tried with the settings defoult, does not work.
on the client I used this string: data source = Turillo-pc \ tre  (not work)

on the local server settings, data connections string, use this string data source = localhost \ three, and it works

I disabled the firewall on both PCs, but it does not work

I do not know what the problem depends

Can you help me please?

I'm sorry for my english

thanks

[emre]

1. data source will be [SERVER NAME]\[SQL INSTANCE NAME]. If your server setting is data source= localhost\three your client setting will be [SERVER NAME]\three. So if the server name is Turillo-pc you'll use Turillo-pc\three

2. there should be ; instead of , between user id and password. user id will be sa and the password will be what you entered while running sql express setup.

[turillo]

Hi emre

I set everything exactly as you said, but it does not work!
I can not understand why?

I am going crazy

thanks for your answer

[emre]

Please check If tcp-ip connection is enabled.
This topic might help
http://forum2.sambapos.org/index.php/topic,74.msg575.html#msg575

[willaycoo]

I think I had the exact same problem as you. I also had to follow the TCP/IP suggestion, and it worked! Take my suggestions with a grain of salt though, because I'm very very new to all this.

So for me, this meant...

Go into SQL server configuration manager.

On the left side navigation window, click on "SQL server network configuration" and click underneath on "Protocols for SQLEXPRESS (or w/e your instance is named)"

On the right, you'll see TCP/IP. Right click into “Properties." Click on the second tab that says "IP Addresses." Scroll to the very bottom and make sure that "TCP Dynamic Ports" under "IPAll" has the port number you're using. Click ok.

Make sure TCP/IP is enabled. And make sure you restart "SQL Server," which can be done by right clicking it. This is located under "SQL Server Services."



That did it for me! I should note that I've found when using XP and win 7, sometimes the computers stop networking suddenly for no reason...but my XP is old as shit. So I always check to see if the two are truly networked when I start samba.

Good luck.

[turillo]

HI willaycoo

you have been very kind

many thanks

but I lost hope, I did everything you tell me, and more,more,more, not work .

The great thing is, mysql server, work.... and I communicate with the client.

I'll jump off a bridge...

ciao

[emre]

Can you check sa user? It might be disabled.
Don't you see any error message or something similar that may give some more info about the problem? For example can you paste the connection string?

[turillo]

Hi emre

I solved using windows xp as a server.
I can not understand why windows 7 professional is not working......What could it be?

many thanks

[Stelzi79]

Did you set a firewall rule for Windows 7? If you havn't disabled the Firewall or added rules to let the services through the SQL-Server and the MessagingServer arn't available. Windows XP hasn't a proper firewall so it let them through. Thats because it works for Windows XP as the server.

[Isaac]

Turillo, To get a client to work there are several things to do, I am running Windows 7 as my server so it should work no problem.

can you copy and paste your datasource string, so we can see if you missed anything obvious?

Open up SQL Configuration Manager, click on SQL Server Services and check if SQL Server Browser is running? If not set this to Automatic in the Properties and Start the Service.

Also make sure you have enabled Shared Memory, Named Pipes, TCP/IP and VIA under Protocols for SQLEXPRESS.

[JohnS]

Guys, this thread is 12months old.

[Isaac]

Lol, good point John.