September 2, 2008 at 1:49 pm
hi I am a newbie here
And I have been learning SQL I am kind of beginner. I have a question here. My machine is in a networked environment where the network is managed by others/Admin. Is there any possibility to make my own machine(runs on XP 2003) as a server for a database to be run on SQL server 2005 express edition to make cleints with in the same network/subnet access my machine (server). Should my machine really be server(ex WINDOWS server 2000/03)?
Thanx
September 2, 2008 at 2:13 pm
Sure you can, but if you want to restrict access based on IP address you will need a firewall setup to do that. You also will want to have admin access to your PC.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 2, 2008 at 2:17 pm
You can definitely set up Express Edition to run on XP and have people on the same network access it. Has to be XP Pro, not XP Home, but it can certainly work so long as that's true.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 2, 2008 at 2:17 pm
Thanks for the reply
I don't think i need access to restrict, since it is like 5-6 people updating reports everyday. So i would give them username and pwd in the application itself.
September 2, 2008 at 2:19 pm
That should work.
You could possibly use domain security instead. But use whatever works best for you for that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 2, 2008 at 2:33 pm
Hi Jack
Here I have a question..
I am good at PHP mysql and java basics(not thru web applications/J2EE). I would love to learn ASP.NET and SQL...to develop applications. So where to start? I have been trying but I was not sure how to do systematically. To build a web application using ASP.NET do u know any books or reference which gives me celar details on how to build a web based application using asp.net n SQL server 2005
Thanks in adv
September 2, 2008 at 2:53 pm
As long as you have SQL client tools installed and enabled protocols(TCP/IP, Named Pipes) on other computers to connect to your SQL server. you can
September 2, 2008 at 2:58 pm
jojovenkat (9/2/2008)
Hi JackHere I have a question..
I am good at PHP mysql and java basics(not thru web applications/J2EE). I would love to learn ASP.NET and SQL...to develop applications. So where to start? I have been trying but I was not sure how to do systematically. To build a web application using ASP.NET do u know any books or reference which gives me celar details on how to build a web based application using asp.net n SQL server 2005
Thanks in adv
Your best reference is MSDN and Books Online, plus sites like this one.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply