ASP.NET WEB HOSTING. Fast windows web hosting at discount prices. Microsoft Windows 2008 server hosting. web site hoting Home    web hosting asp net Login  

Search FAQ-Home Ask question Help

 Categories

· Show all categories

FTP
Front Page
Email
Web Site
Domain Name
MySQL
MS Access
E-Commerce
Hosting
ASP
ASP.NET
PHP
Buy Hosting Account
Upgrade
Billing
Others
PERL
CodeBank
MS SQL
Virtual Private Server

· FAQ-Home


Question:  MS SQL:
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.



Answer:   There are several reasons that this error can occur and all of them will generate the same error message. This is why we can not tell which one is your case.

In general you need to follow this potential problems:

1. The database is not fully uploaded or it does not exist on the server side in the App_DATA folder.

2. It is a good idea to assign Write permissions to App_Data folder by using your Control Panel -> Web Site manager -> manage -> Write permissions.

3. You may need to add to your web.config file the following line just before your connection string:



This is because it may inherit the same Connection String name from the Machine configuration and by explicitly removing it you make sure the names will not duplicate.


3. By Microsoft design the provider will attempt to automatically create the application services database because the provider determined that the database does not exist.
The above will fail --> you need to create the database on your local computer first and them make sure to publish the web site fully including the local copy of the aspnet.mdb.

4. Your connection string should NOT include -> User Instance=True
The correct settings is User Instance=false.
Hers is example on how to construct the connection string:

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=false;

If you have other connection strings in you program - make sure all of them have
"User Instance=false".




Last update: 2011-04-30 12:07
Author: admin

printer-friendly version Send to a friend
Show this as PDF file export as XML-File

Average rating: 2.73 from 5 (836 Votes )

Please rate this entry:
completely
useless

1

2

3

4

5
most
valuable
You cannot comment on this entry | Content Overview: MS SQL
  WINDOWS WEB HOSTING | ASP.NET HOSTING | WEB HOSTING | WINDOWS 2003 HOSTING PLANS
TERMS OF SERVICE |  CONTACT  |  PRIVACY POLICYHOMEMASTERCARDDISCOVERAMERICAN EXPRESSPAYPAL
Copyright BIZHOSTNET.COM All rights reserved.  All trademarks are property of their legal owners.
BIZHOSTNET.COM is a web hosting company specializing in the following Web Hosting Products:
Windows Hosting Windows Hosting Windows 2008 Hosting Windows 2003 Hosting Windows 2008 Hosting Windows 2008 Hosting Frame .NET Hosting Frame .NET Hosting ASP Hosting ASP Hosting ASP Web Hosting ASP Web Hosting ASP.NET Hosting ASP.NET Hosting ASP.NET 4.0 Hosting ASP.NET 4.0 Hosting ASP.NET 3.5 Hosting ASP.NET 3.5 Hosting ASP.NET 2.0 Hosting ASP.NET 2.0 Hosting ASP.NET 1.1 Hosting ASP.NET 1.1 Hosting Microsoft Frontpage Hosting Microsoft Frontpage Hosting PHP Hosting PHP Hosting PERL and CGI Web Hosting PERL and CGI Web Hosting DOMAIN NAMES STATUS CODE Domain Names Status Free Domain names Free Domain names
Free MySQL Database Free MySQL Database Free SQL Database Free SQL Database