SqlConnection conn = new SqlConnection("server = (local)\\sqlexpress;integrated security = SSPI;database = Northwind");
conn.Open();
连接不上,提示:Cannot open database "Northwind" requested by the login. The login failed.
Login failed for user 'hp-326-PC\hp-326'.
初学,请指点
conn.Open();
连接不上,提示:Cannot open database "Northwind" requested by the login. The login failed.
Login failed for user 'hp-326-PC\hp-326'.
初学,请指点
"Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;");
要求登陆,但登陆失败.
Northwind一般是没有用密码的
pwd 是密码
试一下可以不
pwd
可能你连接数据库是没有写密码和用户。
SqlConnection conn = new SqlConnection(@"server = (local)\sqlexpress;integrated security = SSPI;database = Northwind;");
SqlConnection conn = new SqlConnection("server = (local);database = Northwind";uid=xxx; pwd=XXX;");密码要正确!
string strCon= "Provider=SQLOLEDB;Data Source=.;Initial Catalog= master;Integrated Security=SSPI";//Windows身份認證
string strCon = “server= .;database= master;uid=sa;pwd=sa”;//SQL身份認證
string strCon=”Provider=SQLOLEDB;Data Source=.;Initial Catalog= master;use id=sa,password=sa;" //SQL身份認證
一种是Windows模式,这种模式是SqlConnection conn = new SqlConnection("server = 服务器名;integrated security = true;database =数据库名 ");
另外一种模式是混合模式,混合模式下的integrated security = false,此时你需要通过userid和pwd登陆
SqlConnection conn = new SqlConnection("server = 服务器名;database =数据库名 user="xxx"pwd="xxx"");
你可以试试这两种方法
换
server =.
你的就是没有User ID 和Password
SqlConnection conn = new SqlConnection("server=localhost;database=NorthWind;User ID =123;Password=abc");
这个也不行
sql server开启sql账号登陆,然后给sa设个密码
最后加上uid=sa,pwd=密码就行了
其实直接在VS2005里双击你的那个数据库文件就可以打开资源管理器,然后对资源管理器里的数据库右键查看属性,接着在属性窗口就会有数据库连接符了,接着你就复现、粘贴应该就OK了
欢迎大家来我的博客
http://blog.csdn.com/csdbfans