0

.i'm dave and i'm working with some receiving and m0nitoring system like.,i develop a system but it is a individual machine or a stand alone system,which means it w0rks only on a single pc,.my problem is i want to convert it to be a client server system which i can access the database from other pc?some f0rums says that i need to use SSMS,but don't know to use it?can anyone help me and lead me to a tut0rial?
.h0ping 4 ur suggestion .thanks.
.by the way.sorry for my bad english,hope you understand my problem :)

2
Contributors
5
Replies
16
Views
3 Years
Discussion Span
Last Post by deyb.dizon
0

If all you want to do is access a database on another computer then you don't need client/server software. In the connection string put in the IP address of the computer that hosts the database. "Data Source=xxx.xxx.xxx" replacing the xs with the actual ip address. Here is a link for more info.

You might have to make sure the port on the computer hosting the database is not blocked by it's firewall.

0

thanks,its helps me a l0t.
.my second question is.i'm ung SSMSE.but i didn't know how to configure it?

0

I've already done all the suggested solution.

-went to sql configuration and changed the port
-disabled the firewall of eset
-changed the permission of sql management studio

after doing all those, yet it does not work.

i'm using windows 7 ultimate and eset 7

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.