Archive for category SQL Server

SQL Server 2008 “Timeout expired” error and SP1

I recently came across another error when using SQL Server 2008. I recently applied Service Pack 1 to my server’s installation of SQL Server 2008. I had not done any development since then using the full version of SQL Server on the server; instead, as you will note from my recent blog entries on the […]

10 Comments

Fixing SQL error 5170: Cannot create file ‘C:\[…]\APP_DATA\ASPNETDB_TMP.MDF’ because it already exists.in ASP.NET

The problem I recently had, for the first time, to create a brand-new ASP.NET web application that made use of the built-in Membership/Roles functionality, using the default of SQL Server Express, NOT a full installation of SQL Server. I had previously wrestled with issues when upgrading an older application using Membership/Roles to ASP.NET 4.0, and […]

1 Comment

ASP.NET/SQL Server: Failed to generate a user instance of SQL Server; Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’

While working on an ASP.NET 4.0 web application that uses the built-in Membership tools, I recently encountered the above two errors which prevented the site from working until sorted. I suspect the errors were triggered by the SP1 update to SQL Server 2008, as the application was working fine prior to my finally applying the […]

1 Comment