测试代码 using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient;namespace ConsoleApplication1 { class Program { static void Main(string[] args) { string connectionString = "server=localhost;database=master;uid=sa;pwd=sa;";//这句用windows验证登陆成功,换成sa就失败 SqlConnection connection = new SqlConnection(connectionString);
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
string connectionString = "server=localhost;database=master;uid=sa;pwd=sa;";//这句用windows验证登陆成功,换成sa就失败
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();//从这里跳出错误:用户‘sa’登录失败
Console.WriteLine("ServerVersion: {0}", connection.ServerVersion);
Console.WriteLine("State: {0}", connection.State);
}
}
}
改成windows+sql sever
但是用代码连接不就是个SqlConnection传入字符串格式不同的问题...?.
点击工具>点连接数据库>点高级 最下面有系统自动生成的代码