Solved

DB connection help

Posted on 2008-10-27
13
208 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
kill process lock Sql server 9 63
How to Create Separate Guest WiFi VLAN on Netgear R8000 19 83
google exe file 5 58
Loops and updating in SQL Query 9 52
If your business is like most, chances are you still need to maintain a fax infrastructure for your staff. It’s hard to believe that a communication technology that was thriving in the mid-80s could still be an essential part of your team’s modern I…
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 …
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…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

792 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