Link to home
Start Free TrialLog in
Avatar of coecho
coecho

asked on

SQLExpress w/Windows 7 x64

I cannot get SQLExpress 2005 SP3 to run correctly on Windows 7 x64.  I'm able to install and it runs fine (I installed the 64 bit version) and I'm able to attach my local .mdf file via the command line - but when my client application tries to call the first Stored Procedure in the local SQLExpress 2005 .mdf file - I'm receiving the following error:  

System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
   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.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 Flatiron.Forecasting.BusinessServices.GetCurrentJob()
   at Flatiron.Forecasting.ForecastingForm.LoadJob()

I have this Client Code and the same .mdf and versions of SQLExpress installed on XP SP3 and Windows 2003 - and do not have any issues.  And, I did test the "attach" function via the command line and was able to "attach" my .mdf file to the SQLExpress instance.  

I also changed the ownership of the User file where the Application was installed to ensure that everyone has access to the folder.  

The specifics of what I'm trying to do:

VS 2008 Project using ClickOnce to Install Client Application via a File Share
As a part of the ClickOnce install, SQLExpress 2005 SP3 as well as a SQLExpress .mdf are installed on the Client's machine to allow users to work and save their data offline.  

Any ideas as to what may be going on here?  I've spent several days on this already and I know this is a very common SQLExpress error - but none of the online posts are relevant to what I'm tyring to do and I'm not using Terminal Services to try and run the Client Application and the SQLExpress .mdf files are correctly installed in the User Instance on the Client Machine and it's working correctly on Windows 2003 and XP.  

Any help on this would be greatly appreciated.


Avatar of graye
graye
Flag of United States of America image
I'd recommend that you install the SQL Management Studio, so that you can easily poke around the database without having to use the command line.
http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en 
After that's up and running, it will a whole lot easier to diagnose what's going on.
Avatar of coecho
coecho

ASKER

I tried installing SSMSE as you suggested, but the install failed with the following error code:  29506.  I did a quick Google search - which seems to suggest that this is a "failed to connec to server" error.  Do you know what may be wrong with this install?  I installed the prerequites first.
Avatar of graye
graye
Flag of United States of America image
Well, one approach would be to do a complete uninstall, and then go get the SQL+Advanced Services download (it contains both SQL Server Express and SQL Management Studio Express in the same package).
I typically go get PS3 immediately after installing... without ever lauching SQL Server.
Avatar of coecho
coecho

ASKER

I found the this error log for SQL Express.  It's looks as though there's an issue with the Master.log file.  It looks as though when SQLExpress SP3 x64 is installed - it sets up with the default databases in the c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf directory - but then when the Client App makes a call to dynamically attach the SQL Express .mdf file using the User Instance - there is a different master.mdf and master.ldf file at C:\Users\lhein\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\master.mdf.  Since there are 2 different versions of the master file - may this be the reason that this error message is happening and SQLExpress is not able to dynamically attach the .mdf?

Error message follows:

2010-03-04 16:31:48.66 Server      Error: 17156, Severity: 16, State: 1.
2010-03-04 16:31:48.66 Server      initeventlog: Could not initiate the EventLog Service for the key 'E031C29D-18D4-41'.
2010-03-04 16:31:48.66 Server      Error: 17054, Severity: 16, State: 1.
2010-03-04 16:31:48.66 Server      The current event was not reported to the Windows Events log. Operating system error = 6(The handle is invalid.). You may need to clear the Windows Events log if it is full.
2010-03-04 16:31:48.66 Server      Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
      Nov 24 2008 13:01:59
      Copyright (c) 1988-2005 Microsoft Corporation
      Express Edition on Windows NT 6.1 (Build 7600: )

2010-03-04 16:31:48.66 Server      (c) 2005 Microsoft Corporation.
2010-03-04 16:31:48.66 Server      All rights reserved.
2010-03-04 16:31:48.66 Server      Server process ID is 3880.
2010-03-04 16:31:48.66 Server      Authentication mode is WINDOWS-ONLY.
2010-03-04 16:31:48.66 Server      Logging SQL Server messages in file 'C:\Users\lhein\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log'.
2010-03-04 16:31:48.66 Server      Registry startup parameters:
2010-03-04 16:31:48.66 Server   -d c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-03-04 16:31:48.66 Server   -e c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-03-04 16:31:48.66 Server    -l c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-03-04 16:31:48.66 Server      Command Line Startup Parameters:
2010-03-04 16:31:48.66 Server             -d C:\Users\lhein\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\master.mdf
2010-03-04 16:31:48.66 Server             -l C:\Users\lhein\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\mastlog.ldf
2010-03-04 16:31:48.66 Server             -e C:\Users\lhein\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log
2010-03-04 16:31:48.66 Server             -c
2010-03-04 16:31:48.66 Server             -S SQLEXPRESS
2010-03-04 16:31:48.66 Server             -s E031C29D-18D4-41
2010-03-04 16:31:48.66 Server             -w 60
2010-03-04 16:31:48.68 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-03-04 16:31:48.68 Server      Detected 1 CPUs. This is an informational message; no user action is required.
2010-03-04 16:31:48.70 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2010-03-04 16:31:48.72 Server      Database mirroring has been enabled on this instance of SQL Server.
2010-03-04 16:31:48.72 spid5s      Starting up database 'master'.
2010-03-04 16:31:48.76 spid5s      Error: 9004, Severity: 21, State: 1.
2010-03-04 16:31:48.76 spid5s      An error occurred while processing the log for database 'master'.  If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

BTW - I have uninstalled and reinstalled SQLExpress several times already now.
ASKER CERTIFIED SOLUTION
Avatar of graye
graye
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of coecho
coecho

ASKER

So - I uninstalled SQLEpxress and removed all the .mdf files, and reinstalled sql express 2005 sp3 using the "Run as Administrator" option - and am now getting the following error message:

System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Users\lhein\AppData\Local\Apps\2.0\Data\Q1R7YT9C.2Z1\WKJAYYK5.CYP\fccu..tion_8389ab1e1c0fbdd9_0003.0000_8163f360d3fd452d\Data\Resources\ForecastSystem_Client.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
   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.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 Flatiron.Forecasting.BusinessServices.GetCurrentJob()
   at Flatiron.Forecasting.ForecastingForm.LoadJob()
   at Flatiron.Forecasting.ForecastingForm.ForecastingForm_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)   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.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 Flatiron.Forecasting.BusinessServices.GetCurrentJob()
   at Flatiron.Forecasting.ForecastingForm.LoadJob()
   at Flatiron.Forecasting.ForecastingForm.ForecastingForm_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

And - I'm getting the following error message in the db error log:

System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Users\lhein\AppData\Local\Apps\2.0\Data\Q1R7YT9C.2Z1\WKJAYYK5.CYP\fccu..tion_8389ab1e1c0fbdd9_0003.0000_8163f360d3fd452d\Data\Resources\ForecastSystem_Client.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
   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.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 Flatiron.Forecasting.BusinessServices.GetCurrentJob()
   at Flatiron.Forecasting.ForecastingForm.LoadJob()
   at Flatiron.Forecasting.ForecastingForm.ForecastingForm_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)   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.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 Flatiron.Forecasting.BusinessServices.GetCurrentJob()
   at Flatiron.Forecasting.ForecastingForm.LoadJob()
   at Flatiron.Forecasting.ForecastingForm.ForecastingForm_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

2010-03-08 10:14:31.35 Server      (c) 2005 Microsoft Corporation.
2010-03-08 10:14:31.35 Server      All rights reserved.
2010-03-08 10:14:31.35 Server      Server process ID is 2284.
2010-03-08 10:14:31.35 Server      Authentication mode is MIXED.
2010-03-08 10:14:31.35 Server      Logging SQL Server messages in file 'C:\Users\lhein\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log'.
2010-03-08 10:14:31.35 Server      Registry startup parameters:
2010-03-08 10:14:31.35 Server             -d c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-03-08 10:14:31.35 Server             -e c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-03-08 10:14:31.35 Server             -l c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-03-08 10:14:31.35 Server      Command Line Startup Parameters:
2010-03-08 10:14:31.35 Server             -d C:\Users\lhein\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\master.mdf
2010-03-08 10:14:31.35 Server             -l C:\Users\lhein\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\mastlog.ldf
2010-03-08 10:14:31.35 Server             -e C:\Users\lhein\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log
2010-03-08 10:14:31.35 Server             -c
2010-03-08 10:14:31.35 Server             -K
2010-03-08 10:14:31.35 Server             -S SQLEXPRESS
2010-03-08 10:14:31.35 Server             -s B230E5E6-0CF2-49
2010-03-08 10:14:31.35 Server             -w 60
2010-03-08 10:14:31.35 Server             -T 1617
2010-03-08 10:14:31.46 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-03-08 10:14:31.46 Server      Detected 1 CPUs. This is an informational message; no user action is required.
2010-03-08 10:14:31.48 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2010-03-08 10:14:31.50 Server      Database mirroring has been enabled on this instance of SQL Server.
2010-03-08 10:14:31.50 spid5s      Starting up database 'master'.
2010-03-08 10:14:31.53 spid5s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-03-08 10:14:31.62 spid5s      SQL Trace ID 1 was started by login "sa".
2010-03-08 10:14:31.64 spid5s      Starting up database 'mssqlsystemresource'.
2010-03-08 10:14:31.67 spid5s      The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
2010-03-08 10:14:31.86 spid5s      Error: 15466, Severity: 16, State: 1.
2010-03-08 10:14:31.86 spid5s      An error occurred during decryption.
2010-03-08 10:14:31.94 spid5s      The current master key cannot be decrypted. The error was ignored because the FORCE option was specified.
2010-03-08 10:14:31.99 spid5s      Error: 5602, Severity: 16, State: 1.
2010-03-08 10:14:31.99 spid5s      The service master key regeneration was successful.
2010-03-08 10:14:32.10 spid5s      Error: 5604, Severity: 16, State: 1.
2010-03-08 10:14:32.10 spid5s      The password regeneration attempt for SA was successful.
2010-03-08 10:14:32.11 spid5s      Server name is 'XXX\B230E5E6-0CF2-49'. This is an informational message only. No user action is required.
2010-03-08 10:14:32.11 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\B230E5E6-0CF2-49\tsql\query ].
2010-03-08 10:14:32.11 spid7s      Starting up database 'model'.
2010-03-08 10:14:32.12 Server      Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2010-03-08 10:14:32.13 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-03-08 10:14:32.35 spid5s      Starting up database 'msdb'.
2010-03-08 10:14:32.50 spid7s      Clearing tempdb database.
2010-03-08 10:14:33.08 spid7s      Starting up database 'tempdb'.
2010-03-08 10:14:33.21 spid5s      Recovery is complete. This is an informational message only. No user action is required.
2010-03-08 10:14:33.22 spid10s     The Service Broker protocol transport is disabled or not configured.
2010-03-08 10:14:33.23 spid10s     The Database Mirroring protocol transport is disabled or not configured.
2010-03-08 10:14:33.33 Logon       Error: 15350, Severity: 16, State: 1.
2010-03-08 10:14:33.33 Logon       An attempt to attach an auto-named database for file C:\Users\lhein\AppData\Local\Apps\2.0\Data\Q1R7YT9C.2Z1\WKJAYYK5.CYP\fccu..tion_8389ab1e1c0fbdd9_0003.0000_8163f360d3fd452d\Data\Resources\ForecastSystem_Client.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
2010-03-08 10:14:33.48 spid10s     Service Broker manager has started.
2010-03-08 10:26:02.21 Server      Server resumed execution after being idle 655 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2010-03-08 10:26:02.25 Logon       Error: 15350, Severity: 16, State: 1.
2010-03-08 10:26:02.25 Logon       An attempt to attach an auto-named database for file C:\Users\lhein\AppData\Local\Apps\2.0\Data\Q1R7YT9C.2Z1\WKJAYYK5.CYP\fccu..tion_8389ab1e1c0fbdd9_0003.0000_8163f360d3fd452d\Data\Resources\ForecastSystem_Client.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Is this still a permissions issue with the App not being able to run in Administrator mode with this Edition of SQL Server Express 2005 SP3?   Does SQL Server Exress 2008 x64 run correctly on Windows 7 x64?
Avatar of graye
graye
Flag of United States of America image

I think you've still got some leftover files from the previous attempts.  I'd recommend that you do a "search and destroy" for any files with the extension *.MDF and .LDF
 
Avatar of coecho
coecho

ASKER

thanks!  Cleaning up the files and using the "Run As Administrator" option solved my problems and I'm finally able to get a connection to SQL Express.