SQL Server 2005 Install - What Do I Need?

[pbd22]

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.

[jbennet]

is it the express or full version?

[pbd22]

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.

[jbennet]

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.

[thangarasu]

Ok

[thangarasu]

Please help programming in vb.net

[pbd22]

ok, thanks. yes, i use the same IDE. but, in VWD you can't run queries, you just have access to tables.

[jbennet]

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