tags:

views:

36

answers:

1
+2  Q: 

transition from developmental stage to deployment stage

Hi...I've created a web enabled database using SQL Server 2005 to store the data in the DB(back-end) and MS Visual Studio 2008 web forms to access the data(front end)....

I've sucessfully simulated the process of accessing the data from SQL Server stored in my friend's laptop through my laptop using SQL SERVER AUTHENTICATION in MS VISUAL STUDIO 2008 through a LAN Wire....

Now as a part of my project i need to deploy it in a real world server so that it can be accessed by a remote client through Intranet web browser like IE....

i'm confused as to how to go about with this transition....like what should be the connection string in web.config???....please help...

A: 

The connection string should point to your real world server address/IP, that is, where you app will be deployed. Simple as pie.

How the authentication will be performed is an option that you choose while developing your application. This can also be configured through the connection string with specific parameters.

For connection string samples, take a look at this site:

http://www.connectionstrings.com/sql-server-2005

For protection related stuff, I advise you to read this page:

Protecting Connection Strings and Other Configuration Information

Leniel Macaferi  2010-07-19 06:46:37
@Leniel Macaferi,hasn't helped too much....m still fuzzy about a few things....like i have been told that we need to take 2 servers (1 for storing the DATA i.e back end and the other for storing the front end MS Visual Studio Web forms....)
S_anand  2010-07-20 05:21:47
I see... As you asked about the connection string... I just answered about that. Indeed, it's good to separate things in different servers only if you're going to have a lot of users accessing your application.
Leniel Macaferi  2010-07-20 07:46:04

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting