*** Have you ever seen such a problem? ***

落叶瓢花

The system is ok, because it is normal on other computers
ODBC is automatically set, but I cannot connect to SQL Server after installing the system
odbc is also set manually, but it still cannot be connected, and odbc is set correctly

The error prompt is:
Run-time error '-2147467259 (80004005)':
[Micrsoft] [ODBC SQL Server Driver] [TCP / IP Sockets] Specified SQL server not found.

I don't know which noble person can help this person?

prajna

Either the server address is incorrect? Are you even connected to a remote server?

cv4bf5d65fd

You use the ip address to connect! Change to the appropriate database server name

我是杀人狂

odbc connection problem ~

prajna

Send the connection string to see

落叶瓢花

It is a remote server, the server address is correct, because it is normal to use on many other computers, and the ODBC configuration method is the same;
The IP address is better than the database server name, but I also tried to use the server name, and I still ca n’t connect
Odbc connection should be no problem, I have reinstalled ODBC, if there is a problem with odbc, other computers will not run.

So I don't think it's a system or odbc problem, is there any problem with the settings on the installed computer?

Attached connection string:
Public Const DB_DSN = "SQL10"
Public Const DB_SERVER = "EDPSQL10"
Public Const DB_NAME = "MPEPWI"
Public Const DB_UID = "APPS_MPEPWI"
Public Const DB_UIDPWD = "0408191047"
Public Const DB_BAKPWD = "mpepwiback"
...
Set g_objDBService = New UD_Utility.DBService
    With g_objDBService
        .DSN = DB_DSN
        .Server = DB_SERVER
        .LoginID = DB_UID
        .Password = DB_UIDPWD
        .Database = DB_NAME
        .Connect Driver_SQLServer
    End With
...

fanfan1980

sqlserver server-> Start menu-> SQLserver-> Server network utility-> Enable WinSock proxy-> Proxy address: (sqlserver server IP)-> Proxy port-> 1433-> OK now
 
Connect with IP

wgfxman

Has the SQL Agent been opened?
SQL Agent

落叶瓢花

Because it comes from the client, there is no server installed, so there is no port setting.

dream88

Server connection settings
sqlserver server-> Start menu-> SQLserver-> Server network utility-> Enable WinSock proxy-> Proxy address: (sqlserver server IP)-> Proxy port-> 1433