问题描述
我正在测试一个应用程序.在tableadapter配置向导中，在服务器端:
在选择数据源时，我选择了Microsoft SQL Server数据库文件.
这样就将连接字符串设置为:
Hi,
I am testing an application. In tableadapter configuration wizard, On server side:
While choosing data source, I chose Microsoft SQL Server Database File.
This gave set the connection string as:
Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True
这样对吗?
任何以我想要的方式工作的方式.
然后，在SQL Server Mgmt Express中，我将数据库附加到我的SQL Server Express实例(到MyhomeServer \ SQLExpress"
现在，我想在客户端使用相同的应用程序(当然，数据库存储在服务器端我的应用程序的数据目录中)现在在tableadapter向导中，我选择Microsoft SQL Server Express.正确吗?
我已经完成了远程连接等的所有配置，还完成了防火墙设置.当我在客户端运行此测试时，它返回错误:
Is this correct?
Any way this works in my desired way.
Then in SQL Server Mgmt Express, I attached the database to the instance of my SQL Server Express (to MyhomeServer\SQLExpress"
Now I want to use the same application on Client side (off course databse is stored in Data Directory of my application in Server Side) Now in tableadapter wizard, I choose Microsoft SQL Server Express. Is that correct?
I have done all configurations for remote connection etc. and also done the firewall settings. When I run this test on client side, it returns error:
Cannot open database "Database1.mdf" requested by the login. The login failed. Login failed for user 'MYHOMESERVER\Kh. Furqn'.
当我给它附加数据库的SQLExpress时，为什么将它转到 Kh. Furqan .我的服务器是MyHomeServer\SQLExpress，连接是MyHomeServer\Kh. Furqan(身份验证是Windows身份验证，没有密码)
谢谢
Why does it go to Kh. Furqan while I am giving it SQLExpress, where the DB is attached. My server is MyHomeServer\SQLExpress and connection is MyHomeServer\Kh. Furqan (Authentication is Windows Authentication, and no password for it)
Thanks
推荐答案
这篇关于请求了客户端应用程序帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！