Solved

DB connection help

Posted on 2008-10-27
13
207 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
I had an issue with InstallShield not being able to use Computer Browser service on Windows Server 2012. Here is the solution I found.
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…

930 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