如何使用aspnet_regsql.exe [英] How to use aspnet_regsql.exe

问题描述

我在使用本地IIS Web服务器的Silverlight业务应用程序中创建用户时遇到问题.

I'm having problems Creating Users in a Silverlight Business Application that uses the Local IIS Web Server.

如果我使用Visual Studio Development Server，则没有问题，但是每当我尝试使用登录->注册"创建新用户时，一旦在属性页中选中使用本地IIS Web服务器"并运行该应用程序，现在"，我收到无法连接到SQL Server"错误.

If I use the Visual Studio Development Server I have no problems, but once I check "Use Local IIS Web Server" in the properties page and run the application, whenever I try to create a new user using "login->Register now" I get an "Unable to connect to SQL Server" error.

我发现了与我类似的问题，解决方案是在命令提示符下使用aspnet_regsql.

I found a similar problem as mine and the solution was to use aspnet_regsql in the command prompt.

如果我必须使用此工具，那么我不知道如何使用它:

If I have to use this tool, then I don't know how to use it:

aspnet_regsql.exe -S DBServerName -U DBLogin -P DBPassword -A all -d DBName

aspnet_regsql.exe -S DBServerName -U DBLogin -P DBPassword -A all -d DBName

我应该在这些参数中输入什么:

What should I enter in these parameters:

DBServerName :我猜是.\ sqlexpress"

DBServerName: I guess it's ".\sqlexpress"

DBLogin 和 DBPassword :数据库的登录名和密码是什么?

DBLogin and DBPassword: Kind of a login and password for the database?

DBName :如果我不使用任何特定的数据库，那该怎么办?

DBName: If I'm not using any particular database, then what?

请，我应该在这里做什么?

Please, what should I do here?

推荐答案

导航到向导(C:\ Windows \ Microsoft.NET \ Framework [framework version] \ aspnet_regsql)并启动它，您将看到一个表单出现，您可以在此处输入详细信息，而不必使用命令提示符.

Navigate to the wizard(C:\Windows\Microsoft.NET\Framework[framework version]\aspnet_regsql) and launch it , you will be able to see a form appear and you can enter details here rather than using the command prompt.

也在VS中，从顶部菜单中选择WEBSITE-> ASP.Net Configuration，您应该能够看到所有用户和角色详细信息(您可以建立连接，因为这将基于web.config/app获取数据.config设置)

Also within VS , from top menu select WEBSITE -> ASP.Net Configuration you should be able to see all your user and role details (you can tst the connectivity as this will pull of data based on your web.config/app.config settings)

这篇关于如何使用aspnet_regsql.exe的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！