English Boards > Support

Client not work

(1/3) > >>

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 :-X

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.

Navigation

[0] Message Index

[#] Next page