Archive

Posts Tagged ‘connect’

Connect Sql Server using windows authentication

June 7th, 2009 admin No comments

When using Sql Server Authentication to connect database on other server the connection string is :

Data Source=serverIP;Initial Catalog=databaseName;User ID=UserName;Password=Pass

If you want to connect to your own computer with windows authentication. The same connection string doesn’t work on that way. Try new connection string to :

Server=localhost;Database=databaseName;Trusted_Connection=Yes;

Let’s try and told me the result of this problem. :D

PS : ASP.NET connecting to SQL Server