Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aaydee_15
Starting Member
2 Posts |
 Posted - 2014-01-25 : 10:57:16
|
| Hi All,I am new to sql programming and on 1st day I am facing an issue. I am using internet through a dongle connection and every time I connect to internet, the ip gets changed. Can anybody kindly help me with the following queries:1. How to create a database when the ip is not constant?2. Can I use DNS server ip as database engine?3. Is there any way to get the system ip?Regards,Apurva |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-01-26 : 21:16:43
|
Creating database has nothing to do with the IP. Where is the SQL Server running at ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-27 : 07:13:00
|
quote:
Originally posted by aaydee_15
Hi All,I am new to sql programming and on 1st day I am facing an issue. I am using internet through a dongle connection and every time I connect to internet, the ip gets changed. Can anybody kindly help me with the following queries:1. How to create a database when the ip is not constant?2. Can I use DNS server ip as database engine?3. Is there any way to get the system ip?Regards,Apurva
You just require access to remote machine runing the sql server if you want to connect to it. If it has a public ip you can use it otherwise you need a vpn connection to connect to domain and then use domain account to login to machine. once connected, run SQL Management studio inside and connect to your server. Then right click and choose create database to create your db.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
aaydee_15
Starting Member
2 Posts |
Posted - 2014-01-27 : 21:21:02
|
Hi Khtan / Visakh,Many thanks for your valuable suggestions. Can you please help me creating a database in my own system? Regards,Apurva |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-01-27 : 22:28:46
|
Download and install link here- SQL Server Express Edition - Management Studio Express
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
Creating a database in Virtual IP.