SQL authentication with webhost4life

Webhost4life sql servers are using sql authentication instead of windows authentication so you will need to pay attentication in your DB connection string about this. See difference of windows authentication and sql authentication here Here is  one sample DB connection string: "Data Source=sql-server-IP;Initial Catalog=DB-name;User Id=DB-user;Password=DB-password;Integrated Security=True" It will not work with webhost4life becau...
Read the rest of this article

Posted in Database at July 10th, 2009. No Comments.

Difference between Windows Authentication and SQL Authentication

If you are new to the Microsoft SQL Server environment, you probably encountered the possibility to choose between Windows Authentication and SQL Authentication. SQL Authentication is the typical authentication used for various database systems, composed of a username and a password. Obviously, an instance of SQL Server can have multiple such user accounts (using SQL authentication) with different usernames and passwords. In shared servers whe...
Read the rest of this article

Posted in Database at July 10th, 2009. 1 Comment.
Page 1 of 11