October 31, 2011 at 2:38 am
Hi ,please i need help if you can,i like connecting to database exist in PC in network has ip adress Private and i work with port 1433 but it's not working when i connect from client PC ,if you have idea or document thank you nice day
October 31, 2011 at 3:15 am
Take a look at http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx. If you don't find anything about the failed login in SQL Server's error log, then check if the server is configured to log failed login. If it is configured and you still don't find any error in the log, then maybe the problem is a network problem (for example the IT blocked the access from the P.C with the firewall).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 31, 2011 at 3:28 am
Thank you the configuration network is good , and my connection string like that :
"Data Source=xxxx.xxx.xxxx.xxxx,1433;Network Library=DBMSSOCN;Initial Catalog=Elite;User Id=sa;Password=pass;"
this is my private IP adress : xxxx.xxx.xxxx.xxxx;
this connection string maybe failed ?? help me pleaze and thanks so match:)
November 1, 2011 at 2:03 am
I’m not a developer and not an export in connection string, but I think that you also need to add the driver that should be used (have to admit that I might be wrong here).
In any case you can try something else. Do a right click on your desktop and then select from the menu the option new. From the second menu select the option “text document”. You’ll get an empty file that is called “New Text document.txt”. Rename it to “a.udl”. After you rename it, double click it. You’ll get the connection string’s wizard. Use it to create the connection string. After you finish, you can rename the file again and give it the txt extension. Then you can open it and you’ll have to connection string written. You will have to add the user and password because this part will not be saved.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 1, 2011 at 2:14 am
Thank you so match ,I found the solution ,the problem is network configuration ,but now my problem is the application is heavy because the distance is great,but I will work with technology wcf and use the wcf service, and will be the server that processes and sends data to the client, if you can give me your idea and thank you, good day
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply