Solved

DB connection help

Posted on 2008-10-27
13
206 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
  • 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
 

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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Let’s list some of the technologies that enable smooth teleworking. 
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now