473,320 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

sql server connection string to connect through domain name(internet)

Hi all,
I have tried to connect my sql server 2005 using a domain name. i have bought a domain name and a dns client. this is my connection string
Expand|Select|Wrap|Line Numbers
  1. { SqlConnection sqlconn = 
  2.  new SqlConnection("user id=user1;" + "password=pass2;"
  3.   + "server=www.mysite.info\\ServerInstance;" 
  4. + "trusted_Connection=false;" + "network 
  5. library=DBMSSOCN;" + "Integrated security=false;" 
  6. + "initial catalog=Mydatabase;" +"connection timeout=5
  7. ;"); }
I have added sql browser & sql server in fire wall, and also enabled tcp port 1433 and udp port 1434. the above connection string works perfect when i run it in the server machine, buy when i try to run it on other machines i am getting an error that server is not available or cannot find the specified server..
I desperately need to access my database through an url. ie., through internet..
Help me if you can.. I will loose my job if i fails to do this.. so please anybody help me..
Sep 20 '12 #1
6 3342
ariful alam
185 100+
is your accessing program and the database server in one PC or database server in one PC and accessing program in another PC?
Sep 20 '12 #2
accessing program is in another PC,ie.,through internet from any where. My SQL server is running in my laptop. my program cannot locate my sqlserver. I tried this, http://www.it-sideways.com/2008/02/c...rver-2005.html, but no use. I dont know where i went wrong..
Sep 21 '12 #3
ariful alam
185 100+
Do your laptop has a unique ip which we have to buy from the ip authority? if not then your pc has an ip address that is reserved ip address which we use in our internal network. so, that may be not work.

if your SQL server is hosted in any web server that may be accessed by your program from any computer from anywhere in the world.
Sep 21 '12 #4
I dont have a unique IP, But I have bought a domain name and also i have dynamic dns client to update my public ip.
I can host my website pages through apache, I want to know how to host my sql server?
Sep 22 '12 #5
ariful alam
185 100+
Are you using your public ip on your laptop or in any isp's hosting server?
Sep 22 '12 #6
yes. I am using public IP in my laptop only.
Sep 22 '12 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: fruddy | last post by:
Hi everybody, I currently have my SQL Server connection string in an Application variable in the global.asa. Could that be a security risk? I have heard that with Cold Fusion, when there is a...
5
by: Fred Zuckerman | last post by:
Hello All, After reading in this group about the preference for connecting to a SQL Server using a connection string instead of a DSN file, I have done just that. BUT, I cannot update my data....
2
by: D. Shane Fowlkes | last post by:
Upon reading through my ASP.NET book, I've learned how to place the connection string in both locations in my application. Just due to habit, I naturally want to place my SQL Server connection...
8
by: KJ | last post by:
This is kind of confusing. I'm trying to create a connection string to connect to a database on another server supposely in the network. Now if I set the Data Source = dbservername on my local...
3
by: paulo | last post by:
Hello, I'm developing a web services apllication using SQL Server in mixed mode. I'm also using WSE 3.0. For each user in the application there's a corresponding user on the database. The...
4
by: Tim Sapp | last post by:
Folks, I am working on a .Net web site that connects to SQL Server 2000 on another box. The DBA has given me a Domain user account with rights to the database and table. I have confirmed with...
2
by: SAL | last post by:
Hello, I am working with Framework 1.1 and Microsoft Enterprise Library 2005. I've used the Enterprise Library Configuration utility to create my app.config & dataConfiguration.config files. ...
4
by: eruth | last post by:
There are loads of post on this, but nothing that seems to cover my exact problem ;) I have an ASP.Net 1.1 web application running on my local machine. I want to connect to an SQL 2005 server...
3
by: venkatanarasimhaa | last post by:
Hi, I am developing one application in VB as front end and SQL Server as backend. When I am trying to connect to SQL server, If I have Local Admin rights to my system then it is working fine...
2
by: Man T | last post by:
I just wonder what is/are your practices to build the SQL Server connection string? Use object to build the connection string from config file or somewhere?
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.