连接字符串问题sql server 2008 R2 [英] connection string problem sql server 2008 R2

问题描述

我上传了我的申请.一切都很好.但浏览器只是向我显示
System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''myusername name Password=mypwd''
问题是什么 ?！
这是我的连接字符串

i uploaded my application . every things are ok . but the browser just shows me
System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''myusername name Password=mypwd''
what is the problem ?!
here is my connection string

<add name="conStr" connectionString="Server=Ipaddress Database=mydb;User Id=myusernamePassword=mypwd;Trusted_Connection=False;" providerName="System.Data.SqlClient"/>

用户名和密码都可以，因为当我通过sql server 2008 R2登录时，它们可以正常工作！

the username and the password are ok because when i login via sql server 2008 R2 they work fine !

推荐答案

尝试如下，用'';''

try as below, separate each parameter with '';''

Server=myServerAddress;Database=myDataBase;User Id=myUsername;
Password=myPassword;

这篇关于连接字符串问题sql server 2008 R2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！