?
Solved

how to connect to a remote SQL server on a different ip....from my local system....both are on same network

Posted on 2005-04-28
12
Medium Priority
?
171 Views
Last Modified: 2010-03-19
Hi

I am trying to connect to SQL server at a different location through vb code.....my local system n the server are on a same network....

Pls suggest me how to do that...what should be the connection string
0
Comment
Question by:dvsameerkumar
  • 6
  • 4
10 Comments
 
LVL 13

Expert Comment

by:ispaleny
ID: 13887288
Dim con As New ADODB.Connection
con.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=PutDatabaseHere;Data Source=PutServerHere"
 
0
 
LVL 1

Author Comment

by:dvsameerkumar
ID: 13888011
I have tried this...its still not retrieving the data....

But surprisingly, when I have tried this code to get connected to a sql on a different ip, its getting connected...

Do we need to do any settings on the server end for this....
0
 
LVL 13

Expert Comment

by:ispaleny
ID: 13892766
Check
1. Client firewall
2. Server firewall
3. Network firewall
4. Server network settings
5. SQL Server network settings
6. Client SQL connector settings
7. SQL Server logon security settings
8. SQL Server security settings

You can start with commands
ping PutServerHere
(result OK:responding;result KO:it detects UDP connection blocked-not critical for MSSQL, but can identify network connection problems)
telnet PutServerHere 1433
(result OK:blank window;result KO:MSSQL is not listenning on a default port)
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
LVL 1

Author Comment

by:dvsameerkumar
ID: 13892964

hey when i typed  telnet PutServerHere 1433,

i got the following error....

Connecting To 10.190.88.13...Could not open a connection to host on port 1433 : Connect failed

What do i do now...

Please help
0
 
LVL 13

Expert Comment

by:ispaleny
ID: 13893282
Is the SQL Server started?
Are you able to log on server console/TS ?
0
 
LVL 1

Author Comment

by:dvsameerkumar
ID: 13893569
yes on the server
0
 
LVL 13

Expert Comment

by:ispaleny
ID: 13893609
And are you able to connect to the SQL Server locally?
0
 
LVL 1

Author Comment

by:dvsameerkumar
ID: 13894349
yes
0
 
LVL 13

Accepted Solution

by:
ispaleny earned 250 total points
ID: 13894618
Run svrnetcn.exe to see enabled protocols on server.
And cliconfg.exe to see enabled protocols on client.
0
 
LVL 13

Expert Comment

by:ispaleny
ID: 14056290
dvsameerkumar stoped responding...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question