Click here to Skip to main content
15,881,882 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi everybody,

I first build a software and creates a database on my local host using EMS 2008 and every thing worked fine. Then I wanted to create the same database on the server on our LAN. I used EMS and created a database on the server. I configured SQL Server 2005 to accept connections via TCP/IP and name pipes. SQL Server Browser service is running and I think all configuration on server is fine.

When I use my EMS 2008 on my local host and try to connect to the server it doesn't work.

I am a user on the same domain name as the server on the LAN.
I try to register a new host, so I add the host name :
QN-SRV01.Qatarnavigator.com\ACRONIS
and I also tried : QN-SRV01\ACRONIS
and also tried that : QN-SRV01
They're all not working , where QN-SRV0 is the server name
and Qatarnavigator.com is the domain name
and ACRONIS is the Sql database engine...
and it is using windows authentication...

Kindly help me solve this issue.


Best Regards!
Posted
Updated 25-Nov-10 4:17am
v3
Comments
Manfred Rudolf Bihy 25-Nov-10 10:15am    
Some spelling and grammar changes.
Manfred Rudolf Bihy 30-Nov-10 3:56am    
@Tamer: Any news? Did you resolve your issues?

On your local machine open up a command prompt and try the following:

nslookup QN-SRV01.Qatarnavigator.com

This is just to verify that the host can be resolved.

telnet QN-SRV01.Qatarnavigator.com 1433

This will test if you can connect to the SQL Server.
This only works if your SQL Server is listening on port 1433,
which is the default port of every installation.

Can you try these checks and come back with your results?

Cheers

Manfred
 
Share this answer
 
Comments
Tamer Hatoum 26-Nov-10 16:41pm    
thank you for the reply , but it is giving connecting failed, but if I ping to the server IP it is pinging, any suggestion?
Manfred Rudolf Bihy 29-Nov-10 3:30am    
If your telnet to server on port 1433 gives you "connection failed" that can mean three things:
1. SQL Server is not using the default port 1433.
2. SQL Server is not configured to server remote requests
3. Port 1433 is blocked by a firewall or some such.
All points may apply eventhough I assume SQL Server is using the standard port if you haven't conigured explicitely to something else and you already said that you can access the DB from the server itsself so
please check that SQL Server allows remote connections. Use this MSDN KB article http://support.microsoft.com/kb/914277/en-us
Tamer Hatoum 29-Nov-10 4:22am    
Thanks so much , BUt I already Applied all of these steps, But what if I am using a workgroup not the domain name, I am using SQL authentication and workgroup is any thing will chang???
Manfred Rudolf Bihy 29-Nov-10 4:36am    
If you're using SQL server authentication it doesn't matter.
Questions:After configuring SQL server for remote access did you remember to restart the service?
Is the windows firewall enabled on your server?

I'm also curios about the .com domain. Is your server in an intranet, is it in a DMZ and exposed to the
internet. If your server is in a DMZ, your issues are most likely caused by the firewalls protecting the
DMZ.
Tamer Hatoum 29-Nov-10 5:28am    
the firewall is turned off, our server domain is not on intranet, and I do all the configurations in the right way, and I am testing it from my cleint side PC using EMS 2008, and also trying to connect the Software by changing the connection string but it is not connected, but if I try the software from the server directly it is connecting to the database...
I am tired since one week and trying ...
note : I have configured before a server outside the country remotly and connected to the sql and working very fine.. but I donot know why I am not able for that now :(...
regards...
After Long struggle with my server, I have found the following Issues :

That If I am on workgroup I have to use SQL Authentication. Then what I have done :
Remove the SQL server 2005 and delete all the engines before, then Install it again with enabling the Mixed authentication and defining a sa user and password.
then creating my database
configuration for remote connections , and enabling the sql browser.
then On the the TCP/Ip service double click and assgin the port , after that I found some errors in my LAN Configuration which the internet sharing is enabled, So I disable the internet sharing from the lan properties.
then I write the connection string LIke : 192.168.1.8,1433\SQLEXPRESS
then it works perfectly..
then on my software I try first to use this connection string :
string myconn = "Data Source=192.168.1.8,1433\\SQLENGINE;Initial Catalog=qn_archive;Integrated Security=True;User ID=sa;Password=password";
but it gives user is not trusted , so I remove the Integrated security fromt the string and it works fine....

Finally It works .. I appretiate your help man thanks a lot...
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900