Mssql Remote Database?

[iGuest 3]

I want to use 4 laptop using 1 mssql server(master) as a client.
Master mssql ip is : 198.162.000.1
laptop1 ip is 198.162.000.2 (trying as 198.162.000.1\databaseame)
laptop2 ip is 198.162.000.3 (trying as 198.162.000.1\databasename)
laptop3 ip is 198.162.000.4 (trying as 198.162.000.1\databasename)
laptop4 ip is 198.162.000.5 (trying as 198.162.000.1\databasename)

But it didnot connect please help me i am new in this mssql thanks.

[iGuest 3]

Well i tryed with the port and also shutdown the firewall but its also no use.I admit that i am a new user and need to be learn , but i need this urgent.please let me know.

[wutske 0]

MySQL is configured to not allow any remote connections, this is for security reasons (because the webserver and database server are often on the same machine).

You'll have to change your MySQL configuration to allow remote connections and also grant your user remote access to your tables.

 

This should get you going: https://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

[iGuest 3]

Well its mssql(Microsoft sql server ) and you provided the MySQL treatment.Well please let me know how do i use my mssql database?

[wutske 0]

Well its mssql(Microsoft sql server ) and you provided the MySQL treatment.Well please let me know how do i use my mssql database?

joink, read your post too fast

Anyway, issue is similar in MsSQL server. Just google something like "MS SQL server remote connection"

[OpaQue 15]

2 things to ensure to connect to Mssql Remote Database.

1. Ensure Firewall is not blocking incoming connections to the port used by MSSQL.
2. MSSQL database / user should whitelist the IP of the client. Allow connection other than localhost.

[iGuest 3]

This issue still a problem.No issue found.please share how to for this topic.

[FirefoxRocks 0]

This issue still a problem.No issue found.
please share how to for this topic.

First of all, the values you provided for IP addresses are private IP addresses. That means your 4 laptops must be on the same private network as the MS SQL server, or else you need to configure your router to do port forwarding to the MS SQL database server.

Are you able to see the server within your workgroup? I'm assuming all of the computers are running Windows as you are using MS SQL. If not, there may be a network setting configured incorrectly.

Have you configured SQL Server to allow remote connections? https://support.microsoft.com/en-us/kb/914277 The support article is for SQL Server 2005, but you may be able to find a similar option for SQL Server 2008 or other versions.

[iGuest 3]

Well i temm my software devoloer to use a webbased system where i can use the mysqlserver. uing router and with a simple laptop (as server) i can use the software with 10 machine.And the devolopment is under way. thsis mssql cost me 1 month delay.It is so frestrating here.and finally i moved mssql to mysql.its a grate relief.