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
No comments:
Post a Comment