Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Local SQL 2005 db connection with SYSTEM user thro

Author  Topic 

anoopmk007
Starting Member

1 Post

Posted - 2014-07-05 : 01:00:37
I have a local database in my machine in SQL 2005. When i tried to connect Database with 'system' user am getting

System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\SYSTEM'.

Could you please help?

static void Main(string[] args)
{
string connectionString = "server = (local); database = XXXXX;
trusted_connection=yes";
using (SqlConnection connection = new SqlConnection())
{
connection.ConnectionString = connectionString;
connection.Open();
}
}
   

- Advertisement -