Last post Jul 26, 2011 10:58 PM by jacobambat
Apr 07, 2006 06:02 PM|y71chen|LINK
1. Double click
aspnet_regsql.exe in E:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
2. The asp.net sql server wizard will start
3. Choose configure SQL Server
and click next
4. Select Server and database;
Give database a name, default name is aspnetdb.mdf and choose type of authentication
Apr 09, 2006 02:39 PM|DesertRacer|LINK
Apr 10, 2006 05:11 PM|neo302|LINK
Apr 10, 2006 06:54 PM|y71chen|LINK
Apr 27, 2006 04:25 AM|lxdff|LINK
thanks a lot
May 26, 2006 07:26 PM|bettyb|LINK
When I enter machinename\servername instead of servername, I no longer get the Name Pies Provider, error 40. However I do get the following error: Failed to query a list of database names from the SQL Server. Invalid object name 'sysdatabases'.
I do have an instance of SQL Server 2000 and a named instance of SQL Server 2005 on the same machine.
May 31, 2006 08:00 PM|y71chen|LINK
May 31, 2006 08:15 PM|bettyb|LINK
Fortunately, that is not true. You can have only one default instance but multiple named instances of any combination of 2000 and 2005. My 2000 is my default and my 2005 is named. See the following link:
Jun 22, 2007 03:36 PM|sarah56565|LINK
I have been trying to run this aspnet_regsql all day for 7 hours and this post just solved my problem. I added the SQL server name after the server name and it worked like a charm.
THANK YOU SO MUCH!!!!!!!!!!!
Aug 07, 2007 01:46 PM|toy|LINK
Jan 31, 2008 10:00 AM|ardmore|LINK
Hi, I followed the wizard and input the server name as
Then I chose a database named as "Players".
After two Next, finally I got an error
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 262 and the SqlException message is: CREATE PROCEDURE permission denied in database 'Players'.
Details of failure
SQL file loaded:
CREATE PROCEDURE [dbo].aspnet_Setup_RestorePermissions
DECLARE @object sysname
DECLARE @protectType char(10)
DECLARE @action varchar(60)
DECLARE @grantee sysname
DECLARE @cmd nvarchar(500)
DECLARE c1 cursor FORWARD_ONLY FOR
SELECT Object, ProtectType, [Action], Grantee FROM #aspnet_Permissions where Object = @name
FETCH c1 INTO @object, @protectType, @action, @grantee
WHILE (@@fetch_status = 0)
SET @cmd = @protectType + ' ' + @action + ' on ' + @object + ' TO [' + @grantee + ']'
System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'Players'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)
May 20, 2008 04:18 PM|Ronalda|LINK
Did you ever figure out this problem? B/C I'm expierencing the same thing.
Jul 25, 2008 06:13 AM|danasegarane|LINK
Try this one
Mar 12, 2009 03:26 AM|plum|LINK
Problem solved...it turn out that in ASP.NET SQL server setup wizard when it asks for server name, I have to specifiy the
instance name as well as the server name when MS refer to "Server Name" they really mean "Server Instance Name") eg if your server was named 'bigturnip' then you need to specify 'bigturnip\sqlexpress' (where sqlexpress is the instance name
- this one just happens to be the default used by SQL Server 2005 SQLExpress). By default the server name was entered as merely "bigturnip" but after i added "\sqlexpress", then everything worked. If anyone else is having this remote connection problem and
when they did select remote connection and still does not work this is the way to solve the problem.....
This helped me greatly, Thanks!
Jul 23, 2010 02:45 AM|Anupama96|LINK
thank you very much
it is really useful
Nov 26, 2010 08:22 PM|abilgic|LINK
thanks a lot it solved my problem
May 31, 2011 04:30 PM|mkamoski2|LINK
This is a follow-up to the thread above with (yet another) workaround.
I had tried fully qualifing the server name as...
...but I was still getting the dreaded error...
Failed to query a list of database names from the SQL server. Invalid object name 'sysdatabases'.
...so then I found a hint that one can try to manually type in the database name (rather than use the dropdownlist) and that worked for me.
- Mark Kamoski
Jul 26, 2011 10:58 PM|jacobambat|LINK
Thanks a lot .Even I had the same issue