在国大使用过 sql server 2000 的大侠请进了, 求助!不知各位大侠有没有试过从国大连接到远程的 sql server 服务器上过?
我不知道国大是不是封了一些端口,总之我的网站 www.sgpromotion.com 我无法从国大通过远程服务器连接,这样的话,常规的数据库备份都做不了了,添加个域都要等那个管理员有空(一下就耽误了很久)
我每次连接远程服务器,一开始说 timeout, 后来我把timeout设高了,又告诉我说找不到地址.
我用的是默认端口 1433
有那位大侠知道为什么或者知道如何解救,在下感激不尽!!!!!!!!
since the attack of the "slammer"
computer centre had blocked port 1433 and 1434. if you wanna connect, do the following:
1.Start menu -> SQL Server -> Client Network Utilities
2.Tab Alias -> Add
3.Server Alias: anyname you like, say serversql
Network Libraries: TCP/IP
Server Name: (specify you sql server name here)
Uncheck "Dynamically determine port", and specify the port (use a very large number say 66666, u hv also to configure the server side 66666)
4. Click OK
Next Go to SQL Enterprise Manager, Register for a new server
Server: serversql (the alias name you have choosen)
UserID: xxxxx
Password: ******
done.
1.Start menu -> SQL Server -> Client Network Utilities
2.Tab Alias -> Add
3.Server Alias: anyname you like, say serversql
Network Libraries: TCP/IP
Server Name: (specify you sql server name here)
Uncheck "Dynamically determine port", and specify the port (use a very large number say 66666, u hv also to configure the server side 66666)
4. Click OK
Next Go to SQL Enterprise Manager, Register for a new server
Server: serversql (the alias name you have choosen)
UserID: xxxxx
Password: ******
done.
Huasing Association 1999 - 2013