SQL Server 2005 Install - What Do I Need?

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

Join Date: Apr 2007
Posts: 3
Reputation: pbd22 is an unknown quantity at this point 
Solved Threads: 0
pbd22 pbd22 is offline Offline
Newbie Poster

SQL Server 2005 Install - What Do I Need?

 
0
  #1
Apr 13th, 2007
Hi. I have just installed 2005 in my on my database server.
Now, I have a web server and will need to access my database
from my web server for simple stuff such as querying the database
and checking tables, etc, etc. What should I be installing on the
Web server? Should I be downloading the full installation like I
did on my database server? Seems like over-kill, no? What are
the 2005 basics I will need for accessing my DB server over the network?

Thanks in advance.
Reply With Quote Quick reply to this message  
Join Date: Apr 2005
Posts: 16,247
Reputation: jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all 
Solved Threads: 540
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Moderator

Re: SQL Server 2005 Install - What Do I Need?

 
0
  #2
Apr 14th, 2007
is it the express or full version?
If i am helpful, please give me reputation points.
Reply With Quote Quick reply to this message  
Join Date: Apr 2007
Posts: 3
Reputation: pbd22 is an unknown quantity at this point 
Solved Threads: 0
pbd22 pbd22 is offline Offline
Newbie Poster

Re: SQL Server 2005 Install - What Do I Need?

 
0
  #3
Apr 15th, 2007
Originally Posted by jbennet View Post
is it the express or full version?
Hi. Thanks for responding.
Its the full version of the express.
That is what I have installed on the database server.
Now, I just want to be able to query the db server from
the web server and make sure that the code I am writing
on the web server is checking out with the tables, etc.
I dont know much about networking SQL - do I need to
reinstall the full express package on my web server?

thanks for any help.
Reply With Quote Quick reply to this message  
Join Date: Apr 2005
Posts: 16,247
Reputation: jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all 
Solved Threads: 540
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Moderator

Re: SQL Server 2005 Install - What Do I Need?

 
0
  #4
Apr 15th, 2007
No i dont think so. I do alot of web development using Visual Web Developer. My development machine has jus the IDE (No SQL) and my DB server has SQL. All i do is create a connection pointing to the DB server.
If i am helpful, please give me reputation points.
Reply With Quote Quick reply to this message  
Join Date: Apr 2007
Posts: 2
Reputation: thangarasu is an unknown quantity at this point 
Solved Threads: 0
thangarasu thangarasu is offline Offline
Newbie Poster

Re: SQL Server 2005 Install - What Do I Need?

 
0
  #5
Apr 15th, 2007
Ok
Reply With Quote Quick reply to this message  
Join Date: Apr 2007
Posts: 2
Reputation: thangarasu is an unknown quantity at this point 
Solved Threads: 0
thangarasu thangarasu is offline Offline
Newbie Poster

Re: SQL Server 2005 Install - What Do I Need?

 
0
  #6
Apr 15th, 2007
Please help programming in vb.net
Reply With Quote Quick reply to this message  
Join Date: Apr 2007
Posts: 3
Reputation: pbd22 is an unknown quantity at this point 
Solved Threads: 0
pbd22 pbd22 is offline Offline
Newbie Poster

Re: SQL Server 2005 Install - What Do I Need?

 
0
  #7
Apr 15th, 2007
ok, thanks. yes, i use the same IDE. but, in VWD you can't run queries, you just have access to tables.
Reply With Quote Quick reply to this message  
Join Date: Apr 2005
Posts: 16,247
Reputation: jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all 
Solved Threads: 540
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Moderator

Re: SQL Server 2005 Install - What Do I Need?

 
0
  #8
Apr 15th, 2007
If you want a nice interface look here:

http://msdn.microsoft.com/vstudio/express/sql/download/

You want to download
"SQL Server Management Studio Express"


Queries = Views in VWD By the way
Last edited by jbennet; Apr 15th, 2007 at 12:12 pm.
If i am helpful, please give me reputation points.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC