•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 392,083 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,962 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 1622 | Replies: 7
![]() |
•
•
Join Date: Apr 2007
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
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.
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.
•
•
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation:
Rep Power: 30
Solved Threads: 264
•
•
Join Date: Apr 2007
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
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.
•
•
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation:
Rep Power: 30
Solved Threads: 264
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.
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
james.bennet1@ntlworld.com
•
•
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation:
Rep Power: 30
Solved Threads: 264
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
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 11:12 am.
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
james.bennet1@ntlworld.com
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
ad advertising ajax architecture asp backup beta business cd centro crash daniweb database debian dell developer development doubleclick enterprise google hacker install internet linux longhorn mail microsoft mmorpg msdn news novell office open qmail red hat rhel security server smtp software source sql survey suse ubuntu vista windows windows server
- sql server 2005 express i need help<<<? (MS SQL)
- JDBC Driver for SQL Server 2005, Class not found Exception (Java)
- text message via sql server 2005 to mobile phone (MS SQL)
- How to connect queries from SQL Server 2005 to VB.Net Windows application (VB.NET)
- How to connect queries from SQL Server 2005 to VB.Net Windows application (MS SQL)
- Access & MS SQL Server 2005 (MS SQL)
- [For Hire] ASP.NET 2.0 (C#), Atlas, SQL Server 2005: Web Developer / Architect (Post your Resume)
Other Threads in the MS SQL Forum
- Previous Thread: Exclude duplicate records in a JOIN
- Next Thread: How to connect queries from SQL Server 2005 to VB.Net Windows application



Linear Mode