Search results matching tag 'SQLExpress'

Re: System.Data.EntityException :: "The underlying provider failed on Open."

gerrylowry — Tue, 30 Jun 2009 04:00:00 GMT

This really slows down testing and debugging. vw2008 Pro SP1 could detect and prevent this. Ideally, I would like to programmatically detect and correct this issue.

As I wrote, a try/catch may detect but I do not know how to correct. ??? is there a way to correct without some silly manual kludge?

return View(_db.ArticleSet.ToList());

Regards,
Gerry (Lowry)

System.Data.EntityException was unhandled by user code
Message="The underlying provider failed on Open."
Source="System.Data.Entity"
StackTrace:
       at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
       at System.Data.EntityClient.EntityConnection.Open()
       at System.Data.Objects.ObjectContext.EnsureConnection()
       at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
       at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at mne.Controllers.ArticleController.ArticlesIndex(String chooseAuthor, String showHideALL) in C:\!!!!!mne\mne\mne\Controllers\ArticleController.cs:line 111
       at lambda_method(ExecutionScope , ControllerBase , Object[] )
       at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
       at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassa.<InvokeActionMethodWithFilters>b__7()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
InnerException: System.Data.SqlClient.SqlException
       Message="Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
       Source=".Net SqlClient Data Provider"
       ErrorCode=-2146232060

       LineNumber=0
       Number=-2
       Procedure=""
       Server=".\\SQLEXPRESS"
       State=0
       StackTrace:
            at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
            at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
            at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
            at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
            at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
            at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
            at System.Data.SqlClient.TdsParserStateObject.ReadByte()
            at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
            at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
            at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
            at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
            at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
            at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
            at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
            at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
            at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
            at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
            at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
            at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
            at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
            at System.Data.SqlClient.SqlConnection.Open()
            at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
       InnerException:

Error while attaching data in SQLexpress 2005 on windows vista!

corsairdee — Sun, 28 Jun 2009 04:00:00 GMT

i have windows vista, and it gave me hell already installing sql server on it , and now i can't seem to attach a database that i have, whenever i try i right click on the database, then attach, and whenever i click add i get this error msg :

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)

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

The server principal "Dina\Dee" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

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

BUTTONS:

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

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)

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

The server principal "Dina\Dee" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

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

BUTTONS:

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

and i've tried everything i could think of, i made sure the permission on the data is accessable, and that they are not set to read only, i am very new to this and i am very desperate for a solution,any help would be appreciated, thanx in advance.

Moving .mdf from development to server for forms authentication

cgaraffa — Thu, 11 Jun 2009 04:00:00 GMT

Hi all,

I'm finishing up my first ASP.NET application (in C#). I've used Visual Web Developer 2008 Express Edition to build it. One page requires logging in - I was able to configure a LoginForm that worked properly on my local machine. Authentication was configured in the web configuration interface. From my understanding, this creates the SQL Express database ASPNETDB.MDF in App_Data.

The rest of my code was moved successfully from development to the production server. All the pages (including those that hit SQL Server 2005 databases) are working correctly but I get the following error when authenticating:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

In desperation, I tried to set up credentials in web.config, per this article: http://authors.aspalliance.com/aspxtreme/aspnet/syntax/authentication_forms_credentials.aspx - that returns the same error. I'm clearly missing something here but am not sure how to go forward. How to I tell the application on the production server to use ASPNETDB.MDF for credentials? Or is there another way to go about this?

Thank you,

Cannot use VWD 2008 with SQL Server 2005 Express on Vista

sauravraaj — Sat, 02 May 2009 04:00:00 GMT

Hi,

I had VWD 2008 Express SP1 with SQL Server 2008 Express.

I uninstalled SQL 2008 and installed SQL 2005 express, but now I cannot create/database from VWD 2008. It always says SQL 2005 should work properly.

My OS is Vista Enterprise.

What is possibly wrong here?

I have uninstalled/installed 4-5 times in following order:

1. Uninstall SQL 2008 express

2. Install SQL 2005 express with advanced services (the download site at MSFT does not say Vista is supported - file SQLEXPR_ADV)

3. uninstall SQL 2005 express with advanced services

4. Install IIS (6) on Vista

5. Install SQL 2005 express with advanced services

6. uninstall SQL 2005 express with advanced services

7. uninstall VWD 2008

8. Install SQL 2005 express with advanced services

9. uninstall SQL 2005 express with advanced services

10. Install VWD 2008

11. Install SQL Express 2005 SP3 (this does list vista as supported file - SQLEXPR)

I still have the same error.

Any help is greatly appreciated!

Re: An attempt to attach an auto-named database for file C:..... failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

ingenforum — Thu, 05 Mar 2009 05:00:00 GMT

[quote user="Jian Kang - MSFT"]

Are you trying to run the application and connect to the database while the database is been using in VWD? If so, please right-click on the data connection in Server Explorer, and chose "Close Connection", then rerun the application.

[/quote]

Yes , I start my test-application in a test-run at the localhost-server. I use SQLEXPRESS Server. I can start a test-session out of my vwd2008ee.

But I have no Server Explorer, only a Database Explorer. I use SQL Server Management Studio for databases. But allways in own sessions with copies of my databases.

Re: An ASPNETDB DB-Procedure 'aspnet_Membership_createUser' doesn't get a @....... - OutPut-Parameter

ingenforum — Sat, 28 Feb 2009 05:00:00 GMT

Hallo !

This problem is solved for 100%! Thanks for Your hints.

In my case I found my SQLEXPRESS-Icon after using the option for hidden icons in my Search. So I could delete this icon.

sum the Time in Sql

vijaywebnet — Mon, 26 Jan 2009 05:00:00 GMT

I have a time values in my table..

12:45 PM

1:45 PM

10.59 AM

i like to sum the time in the table...

Also divide the Sum of time (Sum(Time)/2)

Help me.

how to make SQLExpress behave like Sql2k5

ruchitgarg — Sun, 21 Dec 2008 05:00:00 GMT

I developed a web app, published on the webspace which has sql2k5 only to find out that some of the datatypes are not suported like Date.

is there anyway i can make sure that what i develop on sqlexpress would work on Sql2k5? any config file changes?

Or are there any way for me to test locally for 2k5

How to get the value of primary key to the row just added?

ruchitgarg — Sun, 21 Dec 2008 05:00:00 GMT

I am adding a row to a table A and then want to add primary key value of this row to another table.

How to achieve that? I have tried SELECT SCOPY_IDENTITY(), but what i always get is number '1', which i think is number of row affected.

moreover, i believe in the sql query builder of VWD, i am doing some mistake writing complex queries(more than one statements).

I am using VWD + SQLExpress.

Help appreciated.

Help needed writing query for autocomplete feature

ruchitgarg — Sun, 21 Dec 2008 05:00:00 GMT

I am trying to write a autocompelete service and looking for appriopriate query which works on SQLExpress and SQL2k5.

SELECT book FROM library WHERE book LIKE @var+'%' is not accepted by Query builder in VWD+SQLExpress. I tried several other combination but nothing works out.

Help Appreciated.

Also, if I want to run LIKEness against other column in the same query, how to do that.