How to use aspnet_regsql.exe

sql-server-2008 iis-7.5 silverlight-5.0
Rafael picture Rafael · Feb 6, 2013 · Viewed 31.5k times · Source

I'm having problems Creating Users in a Silverlight Business Application that uses the Local IIS Web 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.

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

What should I enter in these parameters:

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

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

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

Please, what should I do here?

Answer

Waqar picture Waqar · Feb 6, 2013

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.

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)

Related questions

PHP 5.5.0 w/ Microsoft SQL Server 2008 R2 - No sqlsrv_connect()?

I have the following environment: Windows Server 2008 R2 IIS 7.5 Microsoft SQL Server 2008 R2 I want to use the new PHP 5.5.0 version, which works just fine per sé, but I can't connect to the MSSQL server due to the lack of …

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More