Connect to external DataBase Via SQLExpress?

Hi again... I guess this is yet another newbie question (Sorry if its been asked before!)

If I have an IP address for an external SQL DB with valid User & Pass... Can I connect to it using SQLExpress on my machine?

If so can anyone point me towards how to do it, or run through it below (In easy steps as I'm dumb )

Hi,

Yes, In the Server Name write your IP Address and Select Authenticaion Mode as SQL , supply your given credential and thats it!!! Once it let you in , right click on that IP Address in left corner and right click on it and select Register to Register the server.

Hemantgiri S. Goswami

|||

You can use Sql Server Management Studio (SSMS) to connect to other servers also. In Object Explorer window of SSMS, you have a Connect Combo in Top Left corner of Object Explorer window.

Steps are as follows

(a) Press on Connect

(b) Select Database Engine - You will get a "Connect To Server " window

(c) In this window Give IP Address in Server Name Text Box

(d) giver login name and passoward

(e) Press Connect Button

Madhu

|||Hi ... Many thanks for taking the time to reply, but I am getting this error message? Do I have to change any other settings?

TITLE: Connect to Server

Cannot connect to XX.XX.XX.XX

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476|||

Can you get the DBA to run SQL Server Surfice Area Configuration tool to chech that Name Pipes is allowed.

Also, one thing worth check, have you confirmed the port on the IP address.
Finally please remember to check the firewall settings on the server as this could also be causing you problems.

hth

Barry Andrew

|||Thank you very much! All sorted and connected :o)... Thankssqlsql

Configuring a domain & SQL SERVER 2005 to work.

Attempting to link Access 2003 to SQL 2005, there is something keeping from doing so.

1 I setup the instance as sqlexpress.

2 I have a database shell there also.

3 It connects when I start the instance service.

4 My remote connections are configured to handle TCP/IP & Named Pipes.

Not in this order, but you get the idea. Now that I have these in place, I went first to the Access 2003 database to link the tables to this. When I came accross trouble in the form of need for a DSN to the domain for the things I created above.

In attempting to create one that looked functional, I came back to the same step. But, unsuccessful to link the tables again because browsing to that domain does not even show that particular file. This is the problem.

I do believe that once I am able to select a DSN, I will have a "healthy baby connection". I will then be the proud father of my first Server-side database setup!!!! But I am trying to get over these labor pains.

If you can′t use Windows authentication you will probably have to use SQL Server authentication. In addition you could try to set the network credentials of the user (Under the User account settings) to the domain which you want to connect to.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Configuring a domain & SQL SERVER 2005 to connection to another pc on another domain.

Attempting to link Access 2003 to SQL 2005, there is something keeping from doing so.

1 I setup the instance as sqlexpress.

2 I have a database shell there also.

3 It connects when I start the instance service.

4 My remote connections are configured to handle TCP/IP & Named Pipes.

Not in this order, but you get the idea. Now that I have these in place, I went first to the Access 2003 database to link the tables to this. When I came accross trouble in the form of need for a DSN to the domain for the things I created above.

In attempting to create one that looked functional, I came back to the same step. But, unsuccessful to link the tables again because browsing to that domain does not even show that particular file. This is the problem.

I do believe that once I am able to select a DSN, I will have a "healthy baby connection". I will then be the proud father of my first Server-side database setup!!!! But I am trying to get over these labor pains.

If you can′t use Windows authentication you will probably have to use SQL Server authentication. In addition you could try to set the network credentials of the user (Under the User account settings) to the domain which you want to connect to.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de