Solved

DB connection help

Posted on 2008-10-27
13
209 Views
Last Modified: 2013-12-25
hello there,

i have bought a domain with db option.but my hosting company did not give any details of how to setup and test the db.when i asked them they gave me this reply which is still  not very clear.
As per the issue, we would like to update you that the database is connecting using our test database. We request you to login in query analyzer and access the database and cross check the data base details from net4.in panel. Data base IP address: 202.71.129.164 - this is for shared and for dedicated the IP address is - 202 .71.130.7.
Can you'll please help me,appreciate your help.
0
Comment
Question by:zolf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22819286
refer this link .. i am sure it would resolve your problem

http://www.connectionstrings.com/
0
 

Author Comment

by:zolf
ID: 22819291

what tool do i use to test.i mean how do i connect to their db.
0
 
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22819326
you might have sql server right and that database is also sql server ..

open your sql server management studio ..

under server name put this : 202.71.129.164

select sql server auth
under login put your username and under password give you password now click connect ... it will connect  to your database ...

URL which i provided is used to connect database through code .. but for you above explanation is usefull..
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:zolf
ID: 22819386

i tried doing what you mentioned.but i get this error Login failed for user 'aj'. (.Net SqlClient Data Provider)
1.JPG
0
 

Author Comment

by:zolf
ID: 22819393
i tried the other IP address and i got this error

Cannot connect to 202 .71.130.7.

===================================

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) (.Net SqlClient Data Provider)
0
 

Author Comment

by:zolf
ID: 22819400
this is my package.so the first IP is the correct.becasue the second ip is for dedicated which is not what i have.
Package: Shared Hosting Windows 50MB Space
0
 
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22820205
Are you sure that aj is correct username ... I guess better if you log this issue to your isp ...

Also i tried to ping both IP but i got requested time out .. i guess both ip are not proper ... please login to your ISP control panel , i guess they will provide you some kind of control panel.. from there connect to this db .. you will get all the details ...
0
 

Author Comment

by:zolf
ID: 22820262

i dont know.they asked me for username and i assigned aj
i dont know that ip was provided to me by their dumb support dept.
in the control panel i dont have any features where i can test the db. i can only see my username and password details.
can you suggest any reliable and efficient web hosting company.appreciate your help
0
 
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22820341
NET4IN is also good one but there customer support is horrible ...  do one thing login to net4in control panel

now go to my service tab .. now click hosting ... now you will be in manage hosting page ... please lookinto manage datanbase .... and try to connect ...

or better create ticket for same ...

Please check http://www.znetindia.com/  .. as per my experience they are good and their customer support are excellent
0
 

Author Comment

by:zolf
ID: 22820403
>>now go to my service tab .. now click hosting ... now you will be in manage hosting page ... please >>lookinto manage datanbase .... and try to connect ...
when i do that i get a message see the shot.
i think something is wrong
1.JPG
2.JPG
0
 
LVL 16

Accepted Solution

by:
Gyanendra Singh earned 500 total points
ID: 22820455
hmm in you manage DB please fill all the details .. also provide some strong username .. atleast 4 to 5 chart long and click continue ...

this will give you all the details ... and that try to connect with your server ... but these settings will take some time ... so you need to wait for sometime ...

As per me it would be better if you log a request ...
0
 

Author Comment

by:zolf
ID: 22820479

thanks very much for your help.
0
 
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22820521
your welcome ... in future of you problem .. let me know
0

Featured Post

Industry Leaders: 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

Suggested Solutions

Title # Comments Views Activity
Cisco 4400 will not take SFP module ? SFP 10 GB module 1 49
CentOS 7 wireless 2 34
pfsense upgrade from 2.2.6 to 2.3.3 28 27
DFS replication issue 7 23
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

733 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