trying to get my website working in ASP.NET

Control Panel Forum Hosting Help 6 Months free Hosting (New!) Resources

Total members: 76855
Average new registrations per day (in last 7 days): 84

New Registration: Open

Register Now

Home » Questions & Answers » trying to get my website working

trying to get my website working

3/28/2008

Author: Harold Crowell

http://aspspider.info/fundytrailriders

Fundy Trailriders Snowmobile club

I guess if I need help, I better begin by telling you what I have done so far: Development - Using VWD 2008
Have made four pages:
1) Index.aspx - no graphics - just text introducing the web page
2) Trails.aspx - gust a gridview of the Trails table - everyone is supposed to be able to see this page.
3) login.aspx - this page is for admins to login to gain access to the trailedit.aspx page.
4) trailsedit.aspx - this page is accessed by the login page and is the page where the trails table can be edited.
One database - trails.mdf - contains all information about the trails.
This setup works fine on mylocal development server.
after detaching my database, I uploaded to the APP_DATA directory, attached the database - success.
In Web Config, edited the connection string to reflect the required "fundytrailriders_trails.mdf"
Index.aspx page can be accessed from the internet no problem.
whenever access to the trails.aspx or the trailedit.aspx is attempted, following error ocurrs:
Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +133
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041

What is SP_Configure? How and what do you use to enable user instances? Is that the only problem identified in this pile of information that means absolutely noting to me?
Can anyone help with this?
what other info do you need to provide help?

Answers .............

Author: Timothy Parez

Techdeta

Posted Date: 3/28/2008

http://aspspider.info/timothyp

codem

sp_configure is a stored procedure which comes with the default SQL Server setup. This however is not something we can call directly, this is something for the ASPSpider.NET admins. I'm sorry I couldn't be of more assistance.

Perhaps you could post your connectionString just to be sure and also the code you're using to retreive data.

Author: Harold Crowell

Posted Date: 3/29/2008

http://aspspider.info/fundytrailriders

Fundy Trailriders Snowmobile club

Ok - here is my connection srting as copied directly from the web config file at AspSpider.
Now a stupid question from me:::where do I find the code that i'm using to retrieve data?

<connectionStrings>
<add name="ConnectionString" >
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\fundytrailriders_Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient"/>
<connectionStrings>

Author: Timothy Parez

Techdeta

Posted Date: 3/29/2008

http://aspspider.info/timothyp

codem

Hey,

The documentation for ASPSpiders.net says:

Use the following format:

"Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=fundytrailriders_Database"

Have you tried that, works like a charm for me

Author: Harold Crowell

Posted Date: 3/29/2008

http://aspspider.info/fundytrailriders

Fundy Trailriders Snowmobile club

Timothy;

Well, Closer - at least I now get a new error after upating (editing) my web config file

Now I get this error:
Cannot open database "fundytrailriders_trails.mdf" requested by the login. The login failed.
Login failed for user 'DOTNETSPIDER3\fundytrailriders'.

Author: Harold Crowell

Posted Date: 3/29/2008

http://aspspider.info/fundytrailriders

Fundy Trailriders Snowmobile club

Re the above post "well Closer"
I now have my second page working.
The error above indicates that I should not have included the extension (.mdf) for my database name in the web config file.
Now to my 3rd page.....One step at a time for me.
Got all this stuff documented - now will make a document of my findings and hopefully build a website for that info...
Thanks all for your help - APPRECIATED

You must login to post answer for this question.