 | |
Upgrading to SP1 SQL 2008 Express
microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Upgrading to SP1 SQL 2008 Express -
07-20-2009
, 03:01 PM
|
Hi It looks like the cause of the problems may well be the failed install. You could look through the installation logs and try to fix it, but it may be quicker to un-install and re-install (if it lets you!). John "Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote in message news:ewKdNtzBKHA.4336 (AT) TK2MSFTNGP04 (DOT) phx.gbl... I'm not sure what you mean by user context. I only have one XP user set up. And the authentication is Windows Login not SQL server. Not sure if this will help or not. But this is the 2nd time I have tried installing SP1 and have had problems each time. The first time, I downloaded SP1 and installed in manually. Had some type of problem (different errors) access SQL server so I did a Windows restore and that basically un-installed SP1 and I haven't had any major problems with it since re-installing SP1 the second attempt. This 2nd attempt at installing SP1 for SQl Server 2008 I did it through Windows Update and let it update automatically overnight. Ever since that Monday night I believe I've been having problems with ASP.NET user config and user instances. I'm thinking about Windows Restore again and not using SP1. Please advise! Thanks again! "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote in message news:%23w6fGttBKHA.5068 (AT) TK2MSFTNGP03 (DOT) phx.gbl... This is not a connection string for a user instance (no User Instance=true)!! As this is a trusted connection what user context is the application run under? John "Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote in message news:ej3LY6gBKHA.5068 (AT) TK2MSFTNGP03 (DOT) phx.gbl... Thanks again for the reply add name="First_DatabaseConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=First_Database;Integrated Security=True" providerName="System.Data.SqlClient" / "Robert Lakinski" <rlakinski (AT) gmail (DOT) com> wrote in message news:e7f$uJVBKHA.5068 (AT) TK2MSFTNGP03 (DOT) phx.gbl... can you post the connection string from the web.config file? Robert "Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote in message news:%23A7K20TBKHA.528 (AT) TK2MSFTNGP03 (DOT) phx.gbl... Thanks for the reply Robert & John. This is a local installation. I can still access SQL Server via the management tool, I can still open up databases and run queries etc. We only have 1 instance to the best of my knowledge. I've been using the same user. The change happened since installing SP1 overnight. VWD can find the SQl connection in the database explorer but for some reason can't create a NEW database using the Solutions explorer. Also the ASP Config tool cannot connect. The browser service, Sql Service, Report Service is running ok. "Robert Lakinski" <rlakinski (AT) gmail (DOT) com> wrote in message news:uzx4wIJBKHA.5780 (AT) TK2MSFTNGP03 (DOT) phx.gbl... Hi Anthony, Can you connect to the sql server by using some other tool (ex. sql server managemet studio, query analyzer ... )? how many instances do you have? Check if the sql server is alive by pinging the host, or telnet to 1433 port for default instance. (for named instances check the port number in SQL Server Configuration Manager) Robert. "Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote in message news:ONP3q2IBKHA.4432 (AT) TK2MSFTNGP05 (DOT) phx.gbl... God Bless You Everyone, I recently upgraded from SQL Express 2008 to SP1. Now my user instances are messed up. When I go into the ASP configuration tool I get the: There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. I also ran the aspnet_regsql and I am still getting an error. When I try to add a new SQL Database in I get the: 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. Please advise, thanks! Blessed Driving School, $47 Virginia Defensive Driver Improvement Class www.blesseddrivingschool.com |
#12
| |||
| |||
|
|
Good Afternoon, I ran Windows Restore back to a date before the SP1 install. But that did NOT uninstall SP1. So I went into Control Panel | Add Remove Programs | Updates - Remove/uninstalled SQL Server 2008 SP1. The ASP config tool is working fine again and it can find user instance. Should I continue using SQL Express 2008 without SP1 or should I try to install SP1. Evidently there must be something else I must do before installing SP1 but what is it? I've tried installing from a downloaded file AND letting Windows Update install 2008 SP1 and both cases I had errors pop up. I'm a little unsure of how stable this SQL Server is now because of uninstalling SP1 twice and running Windows Restore twice also. I wondering if I just need to uninstall everything and start from scratch. Please advise. Thanks! Sincerely, Anthony Smith IN God We Trust! "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote in message news:eF2JEi5BKHA.4004 (AT) TK2MSFTNGP05 (DOT) phx.gbl... Hi It looks like the cause of the problems may well be the failed install. You could look through the installation logs and try to fix it, but it may be quicker to un-install and re-install (if it lets you!). John "Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote in message news:ewKdNtzBKHA.4336 (AT) TK2MSFTNGP04 (DOT) phx.gbl... I'm not sure what you mean by user context. I only have one XP user set up. And the authentication is Windows Login not SQL server. Not sure if this will help or not. But this is the 2nd time I have tried installing SP1 and have had problems each time. The first time, I downloaded SP1 and installed in manually. Had some type of problem (different errors) access SQL server so I did a Windows restore and that basically un-installed SP1 and I haven't had any major problems with it since re-installing SP1 the second attempt. This 2nd attempt at installing SP1 for SQl Server 2008 I did it through Windows Update and let it update automatically overnight. Ever since that Monday night I believe I've been having problems with ASP.NET user config and user instances. I'm thinking about Windows Restore again and not using SP1. Please advise! Thanks again! "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote in message news:%23w6fGttBKHA.5068 (AT) TK2MSFTNGP03 (DOT) phx.gbl... This is not a connection string for a user instance (no User Instance=true)!! As this is a trusted connection what user context is the application run under? John "Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote in message news:ej3LY6gBKHA.5068 (AT) TK2MSFTNGP03 (DOT) phx.gbl... Thanks again for the reply add name="First_DatabaseConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=First_Database;Integrated Security=True" providerName="System.Data.SqlClient" / "Robert Lakinski" <rlakinski (AT) gmail (DOT) com> wrote in message news:e7f$uJVBKHA.5068 (AT) TK2MSFTNGP03 (DOT) phx.gbl... can you post the connection string from the web.config file? Robert "Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote in message news:%23A7K20TBKHA.528 (AT) TK2MSFTNGP03 (DOT) phx.gbl... Thanks for the reply Robert & John. This is a local installation. I can still access SQL Server via the management tool, I can still open up databases and run queries etc. We only have 1 instance to the best of my knowledge. I've been using the same user. The change happened since installing SP1 overnight. VWD can find the SQl connection in the database explorer but for some reason can't create a NEW database using the Solutions explorer. Also the ASP Config tool cannot connect. The browser service, Sql Service, Report Service is running ok. "Robert Lakinski" <rlakinski (AT) gmail (DOT) com> wrote in message news:uzx4wIJBKHA.5780 (AT) TK2MSFTNGP03 (DOT) phx.gbl... Hi Anthony, Can you connect to the sql server by using some other tool (ex. sql server managemet studio, query analyzer ... )? how many instances do you have? Check if the sql server is alive by pinging the host, or telnet to 1433 port for default instance. (for named instances check the port number in SQL Server Configuration Manager) Robert. "Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote in message news:ONP3q2IBKHA.4432 (AT) TK2MSFTNGP05 (DOT) phx.gbl... God Bless You Everyone, I recently upgraded from SQL Express 2008 to SP1. Now my user instances are messed up. When I go into the ASP configuration tool I get the: There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. I also ran the aspnet_regsql and I am still getting an error. When I try to add a new SQL Database in I get the: 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. Please advise, thanks! Blessed Driving School, $47 Virginia Defensive Driver Improvement Class www.blesseddrivingschool.com |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.