How to get my database from another computer

Question

I have set my database so that From another computer user can get my database remotely (setting firewall, port...).

However I do not know how user get my database, what they should do.

Would you tell me how users can use my database remotely?

My purpose:

I have pdf form which is connected to the SQL server 2008 through ODBC(working fine). I wish users can use pdf form which will be connected with my database through ODBC. What should I do?

In addition my server name: ABC-PC\SQLEXPRESS

Answer 1

If you have already added Firewall exceptions for the port used by SQL Server and used this port to connect to SQL Server it should work.

What Authentication are you using for giving users access to the database. Can you post the connection String used for above setup.

Are you getting any login failures inside SQL ErrorLog.

Are you getting any errors when you use remotely via network. Can you post the errors encountered?

---

Vamshi SQL DBA(MCITP) My Blogs: http://sqlserver-dba.co.uk http://sql-developers.co.uk/

Answer 2

I am using windows authentic. I have not set up log in password in my computer. Just connect with windows authentic.

I was trying from  another computer with windows authentic and ABC-PC\SQLEXPRESS which is used as server name in my computer.

I was getting error.

Answer 3

There are many things involved here...

1. check if the SQL is configured for remote connections on instance level properties.

2. check if your Browser service is up and running and added as exception in firewall as UDP.

3.disable the firewall for small duration if possible and check if its caused by Firewall.

4.Check SQL Server Error logs to see any login failures.

5. Try to Build a ODBC connection from other server.

Hope this helps....

---

Vamshi SQL DBA(MCITP) My Blogs: http://sqlserver-dba.co.uk http://sql-developers.co.uk/

Answer 4

greenInd,

There was a similar issue following is the link having steps that you can use to move forward.

http://social.msdn.microsoft.com/Forums/en/sqltools/thread/0596c5c5-9652-4483-8f01-cd071ffdad25

Hope that helps.

Answer 5

Thanks for your kind help.

1. check if the SQL is configured for remote connections on instance level properties.

>>>

would  you tell how I can check?

Answer 6

Can you please try below article

http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

To check instance level properties, you can either use SSMS Client tool->Connect to instance->Right Click on instancename->connections

From Query Window

USE master;
GO
EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;
EXEC sp_configure;

check the remote access inside the results which should be 1.

Hope this helps...

---

Vamshi SQL DBA(MCITP) My Blogs: http://sqlserver-dba.co.uk http://sql-developers.co.uk/

Answer 7

Many thanks.

I tried from query. It is OK. I think I am creating problem in server name. Server name is instance name?

I connect with DREAM_PEAK-PC\SQLEXPRESS (SUCCESFULLY CONNECTED)

What will be server name, When user want to get my database from another computer? User's computer needs to be set -up (firwall, port)?

Answer 8

Yes, server name would be the same. However, can you check whether port 1433 (SQL Server default) is open between your server and client PCs?

To verify the port number on which your SQL Server is listening to - check SQL Server Configuration Manager.

Cheers,

{P}

---

Microsoft Techie

Answer 9

Hi,

All say ok. but same problem remains.

I was trying over internet. Is it wrong for me?Need any specific setting?

Do I have to connect LAN?

Answer 10

I was trying over internet. Is it wrong for me?Need any specific setting?

In that case, it's problematic to use Windows authentication since the client and SQL Server are in different domains. 

Is the SQL Server PC on a typical home network connected to the internet via a router/firewall?  If so, you'll need to determine the public IP address of the router and forward the needed port traffic to the SQL Server PC using the router management utility.  The client will need to specify the public IP address since it's unlikely you have a FQDN (yourpc.example.com) for the SQL Server PC.  You will find it easier to specify the public IP address and port number in the connection string to avoid the need to use the SQL Browser service. 

An example SQL Server Native Client ODBC connection string to connect to IP xxx.xxx.xxx.xxx on port 12345 using SQL authentication:

Driver={SQL Server Native Client 11.0};Address=tcp:xxx.xxx.xxx.xxx,12345;Database=MyDatabase;UID=SqlLogin;PWD=SqlLoginPassword

---

Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

Answer 11

Hi,

All say ok. but same problem remains.

I was trying over internet. Is it wrong for me?Need any specific setting?

Do I have to connect LAN?

Has the error changed? What is the error that you are getting now?

Answer 12

Would you tell me how I can this IP?