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

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

"Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote


You don't say if this is remote instance or local? If it is remote then it's
probably resorted to the default setting that doesn't allow remote
connections.

John

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

Hi Anthony

I would suggest that you used SQL profiler to see activity is occuring on
the server, but SQLExpress does not have this. You could use the
sqlexportlonly option for aspnet_regsql to get a script that you can execute
manually with sqlcmd and see where it fails. See
http://msdn.microsoft.com/en-us/libr...62(VS.80).aspx for all the
command line options. Also check that you can create database with sqlcmd
and that the command

sp_configure 'user instances enabled'

returns 1.

John


"Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote

can you post the connection string from the web.config file?

Robert


"Anthony Smith" <antsmith37 (AT) gmail (DOT) com> wrote

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

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

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

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