SQL Server 2005 database as role/membership datastore for Microsoft Visual Web Developer 2005 Expres

My objective is to use my discountasp.net SQL Server 2005 database as my role and membership datastore for Microsoft Visual Web Developer 2005 Express edition. To do this, I have read that I am to use theASP.net SQL server setup wizard(aspnet_regsql.exe) to set upmy dicountasp.net SQL Server 2005 database for use withMicrosoft Visual Web Developer 2005 express edition.


I can successfully connect to the SQL Server database through the databaseexplorer and the through the SQL Server Management Studio Express CTP -- so I know connectivity is not the problem, but when I click Finish on the ASP.net SQL serv er setup wizard(aspnet_regsql.exe), I getthe following error message:


>


>


>


> Setup failed.


>


> Exception:


An error occurred during the execution of the SQL file'InstallCommon.sql'. The SQL error number is 8152 and the SqlExceptionmessage is: String or binary data would be truncated.


>


> ----------------------------------------


> Details of failure


> ----------------------------------------


>


> SQL Server:


> Database: [SQL2005_150328_master]


> SQL file loaded:


> InstallCommon.sql


>


> Commands failed:


>


> CREATE TABLE #aspnet_Permissions


> (


> Owner sysname,


> Object sysname,


> Grantee sysname,


> Grantor sysname,


> ProtectType char(10),


> [Action] varchar(20),


> [Column] sysname


> )


>


> INSERT INTO #aspnet_Permissions


> EXEC sp_helprotect


>


> IF (EXISTS (SELECT name


> FROM sysobjects


> WHERE (name = N'aspnet_Setup_RestorePermissions')


> AND (type = 'P')))


> DROP PROCEDURE [dbo].aspnet_Setup_RestorePermissions


>


>


> SQL Exception:


> System.Data.SqlClient.SqlException: String or binary data would be truncated.


> 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.Data.SqlClient.SqlCommand.ExecuteNonQuery()


> at System.Web.Management.SqlServices.ExecuteFile(String file,


> String server, String database, String dbFileName, SqlConnection


> connection, Boolean sessionState, Boolean isInstall, SessionStateType


> sessionStatetype)

 

I am getting exactly the same as above using both my personal C# application for database management and using aspnet_regsql.exe from my Asp.Net 2.0 version. Are there any similar problems in SQL 2000 or is this just a 2005 version error?


------------------------------------------------
Setup failed.
Exception:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 229 and the SqlException message is: SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
----------------------------------------
Details of failure
----------------------------------------
SQL Server:
Database: [sql2005_197282_titrain]
SQL file loaded:
InstallCommon.sql
Commands failed:
CREATE TABLE #aspnet_Permissions
(
Owner sysname,
Object sysname,
Grantee sysname,
Grantor sysname,
ProtectType char(10),
[Action] varchar(20),
[Column] sysname
)
INSERT INTO #aspnet_Permissions
EXEC sp_helprotect
IF (EXISTS (SELECT name
FROM sysobjects
WHERE (name = N'aspnet_Setup_RestorePermissions')
AND (type = 'P')))
DROP PROCEDURE [dbo].aspnet_Setup_RestorePermissions

SQL Exception:
System.Data.SqlClient.SqlException: SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
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.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)



-------------------------------------
I've also tried the SQL server management studio express and keep getting this error when trying to see tables


-------------------------------------

TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
SELECT permission denied on object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476

Any ideas on what I can do at this point?

Thank you.
DRACHLE

---------
DRACHLE
TiTrain va loin...
Time to be creative!