-
April 15th, 2011, 22:31
#1
Problems with Remote SQL Server
سلام
ببخشید لاتین مینویسم، وقت ندارم ترجمه کنم مسافرتم.
Hello,
I have some problems with sql server 2005 remote connection.
I was configured SQL Server 2005 to accept remote connections with this tutorial :
How to configure SQL Server 2005 to allow remote connections
all things done step by step.
Now I want to connect remotely via Sql Server Management studio Express
But this error returned:
- Server is windows 2003 server
- Firewall is turned off in server
- Panel is websitepanel
- mysql remote port is 1433 (Sql server configuration manager --> Protocols for sqlexpress --> Tcp IP Properties --> IP Address --> Port)
Can Anybody Help Me?
Thank you.
ویندوز و sql server هم ری استارت شدند!
---------- Post added at 10:31 PM ---------- Previous post was at 10:29 PM ----------
متن ارور :
TITLE: Connect to Server
------------------------------
Cannot connect to 184.154.xx.xxx
------------------------------
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) (Microsoft SQL Server, Error: 121)
For help, click:
Source: ID: ( ) - Events And Errors Message Center: Message Details
------------------------------
BUTTONS:
OK
------------------------------
-
-
April 15th, 2011 22:31
# ADS
-
April 15th, 2011, 22:59
#2
پاسخ : Problems with Remote SQL Server
معمولا وقتی از کلاینت به سرور کانکت می شوی یک اکسس باید به آن آی پی داده شود.
و البته چرا فایروال رو آف کردی
مطمئن شو که sql server پورت که گفتی رو گرفته
همکاران ویندوز فردا می پرسم کمکتون کنند
-
-
April 16th, 2011, 16:10
#3
پاسخ : Problems with Remote SQL Server
ویرایش توسط Talahost.Com : April 16th, 2011 در ساعت 18:53
-