Hi All,
My question would be very basic .because i am new bie to .net
In my windows application i have to connect to the SQL server which is in the remote server. The SQL erver shall be connected only through windows authetication mode. The user shall able to configure the database and remote server during or after installation.

How do we connect to the SQL server 2005 in remote server?
How does the user shall configure during and after installion ??
Is the connectviy made through windows authentication mode?
How can we proceed . Pls do needful.

Regards,
Jayakumar Natarajan

---

Regards,
Jayakumar Natarjan
Click Here :Blog

1. Using a connection string that allows you to use Windows Authentication.

Data Source=SomeServerName;Initial Catalog=SomeDatabaseName;Integrated Security=true;

2. A domain administrator will have to configure the permissions for the SQL server to allow the user running the application to have access to the database. This is done through SQL Server Management studio, and not through an installation script.

3. See the answer to number 1.


In the future, please ask only one question per thread. It makes followups much easier.

---

Coding Light - Illuminated Ideas and Algorithms in Software
Coding Light Wiki �LinkedIn �ForumsBrowser

1. Using a connection string that allows you to use Windows Authentication.

Data Source=SomeServerName;Initial Catalog=SomeDatabaseName;Integrated Security=true;

2. A domain administrator will have to configure the permissions for the SQL server to allow the user running the application to have access to the database. This is done through SQL Server Management studio, and not through an installation script.

3. See the answer to number 1.


In the future, please ask only one question per thread. It makes followups much easier.

---

Coding Light - Illuminated Ideas and Algorithms in Software
Coding Light Wiki �LinkedIn �ForumsBrowser