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.
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.