Failed to generate a user instance of SQL Server due to failure in ret

[mxo]

Hi guyz, Im about to give up on this subject and this project. I have created a membership database with user roles and uploaded to the hosting server and i have connectionstring to connect to this database, its been good couple of months trying to login to access admin pages and i have been getting the the above error same. please see my connectionstring:

<connectionStrings>
<add name="ruralmembers" connectionString="Data lSource=.\SQLEXPRESS;Database=ruralboy_ruralmembers;Uid=xxxxx;Pwd=xxxxxxx;"
providerName="System.Data.SqlClient" />

</connectionString>

Regards

 

[jmeckley]

so what is the exception and stack trace?
if i had to guess the problem is the datasource .\SqlExpress refers to the local named instance of sql server. this will work for development, but in production environments the database is almost always on a separate box and the hosting provider will give you the userid and password to connect to the db server.

Jason Meckley
Programmer
Specialty Bakers, Inc.