Home > ASP.NET > Connect Sql Server using windows authentication

Connect Sql Server using windows authentication

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

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

  1. No comments yet.
  1. No trackbacks yet.