Server IP: 192.168.6.188
Pb program client IP: 192.168.0.145

Tip "unable to connect: essentially is unavailable or does not exists; Access denied. "

And if it is connected to this paragraph 192.168.0.89 server, but can,
PING sense, TELNET and without question,
Younger brother beginners PB, please everybody to help solve,
The younger brother composition thanks!

CodePudding user response:

TELNET 192.168.6.188 1433 OK?

CodePudding user response:

OK?

CodePudding user response:

reference 1st floor response:

TELNET 192.168.6.188 1433 OK?

You can,

CodePudding user response:

It indicate that the network is no problem, don't have permission to connect.

CodePudding user response:

The

reference 4 floor response:

that indicate that the network is no problem, don't have permission to connect.

Sa users, the highest authority,

CodePudding user response:

You check SQL2008 security conditions. Sa light is not enough, even Windows permissions.

refer to fifth floor response:

reference 4 floor response:

It indicate that the network is no problem, don't have permission to connect.

Sa users, the highest authority,

CodePudding user response:

refer to 6th floor response:

you check SQL2008 security conditions. Sa is not enough light, even Windows permissions.

Refer to fifth floor response:
Refer to 4th floor response:

It indicate that the network is no problem, don't have permission to connect.

Sa users, the highest authority,

Don't know how to run it,,, please let us know,

CodePudding user response:

SQL Server 2008 remote connection is not allowed by default, the sa account is disabled by default, if you want to use locally SSMS to connect to a remote Server SQL Server 2008, you need to do the configuration of two parts:
1, SQL Server Management Studio Express (SSMS)
2, the SQL Server Configuration Manager/SQL Server Configuration Manager (SSCM)

There are two things to note:
1200 5 peripheral application configurator in 2008 changed the local
2, some of the Settings to take effect need to restart the SQL Server

Step 1: open the SSMS, connect to the database with Windows identity, and right after logging in, choose "properties"
Step 2: select "security" on the left, the right of the selected "SQL Server and Windows authentication mode" to enable the mixed mode login
Step 3: select the "connect", check the "allow remote connect to the server", then click "ok"
Step 4: a "security" - & gt;" Login name "- & gt;" Sa ", right click choose "properties"
Step 5: on the left side of the "regular" choice, select "SQL Server authentication" on the right side, and set the password
Step 6: select the "status", select "enable", click "ok"
Step 7: right-click on the database select "in"
Step 8: use "RemoteAccessEnabled" attribute set to "True", point "sure"
Step 9: thus SSMS has been set up, first, reoccupy sa login, success indicates that the sa account has enabled
Step 10: the following start configuring SSCM, selected on the left side of the "SQL Server services" to ensure that the right of the "SQL Server" and "SQL Server Browser is running"
Step 11: the following is the English version of the interface, as shown in figure: on the right side of the TCP/IP default is "Disabled", double-click to open the Settings panel to be changed to "Enabled"
Step 12: select the "IP Addersses" TAB, set the port "1433"
Step 13: as shown in figure will "Client separate Protocols" "TCP/IP" is changed to "Enabled"
Step 14: the configuration is complete, restart the SQL Server 2008,

Should be able to use the right now, but still need to confirm the firewall,
SQL Server Express 2005/2008 after installation, by default is to disable the remote connection, if you need to remote access, need to manually configure,

Open the firewall Settings, will SQLServr. Exe (C: \ Program Files \ Microsoft SQL Server \ MSSQL10 SQLEXPRESS \ MSSQL \ Binn \ SQLServr exe) add to the list of allowed,

CodePudding user response:

refer to the eighth floor response:

SQL Server 2008 remote connection is not allowed by default, the sa account is disabled by default, if you want to use locally SSMS to connect to a remote Server SQL Server 2008, needs to be done to the configuration of two parts:
1, SQL Server Management Studio Express (SSMS)
2, the SQL Server Configuration Manager/SQL Server Configuration Manager (SSCM)

.

All set, not careful not oh,

CodePudding user response:

The representation of SQL 2005 version of the above, the server is: the name of the machine/instance name

Try changing the sqlca server name

CodePudding user response:

references to the tenth floor response:

SQL 2005 version of the above, the representation of the server is: the name of the machine/instance name

Try changing the sqlca server name

Or I can't,,,

CodePudding user response:

To find the reason, I now also in the same situation with you,

CodePudding user response:

On a computer try to log on to the server, in running the program!

CodePudding user response:

With local SSMS, landing a across the net SQL try
This should be with pb it doesn't matter

CodePudding user response:

I also encountered such a problem, as if also not line, I encounter is that the problem, my server is to use the telecommunications network, public IP, for the client are also telecom can even, then the client for the mobile network, can't even on,

CodePudding user response:

Can I use the SQL is even out of, is to use PB not line,

CodePudding user response:

How do you use SQL even go out? Supposedly SQL server line, pb should also can

CodePudding user response:

Turn off the loaded database firewall that machine