sql2005使用windows登入连接字符串怎么写

[lvxianda]

如题

[cppfaq]

Server=machineName;Initial Catalog=DBName;Integrated Security=true

[cppfaq]

有人专门建了个网站，里面放了各种场景下链接各种数据库的连接字符串
http://www.connectionstrings.com/sql-server-2005

[baiyunyinv]

Server=主机地址（本地用'.');Initial Catalog=数据库名称;Integrated Security=true（为true表是用windows集成验证，也就是你说的用windows登录）

[neu_dfh]

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=服务器;Initial Catalog=数据库名;User ID=用户名;Password=密码";

string strSel = "select * from ";
SqlCommand selcom = new SqlCommand(strSel, conn);

[浪子-无悔]

你也可以这样写
SqlConnection conn = new SqlConnection("server=(local);database=数据库;uid=登陆名;pwd=密码");