Last post Sep 23, 2006 11:53 PM by jwadsworth
Sep 18, 2006 04:33 PM|phishycoder|LINK
Hi i'm new at this. I have SQL Server 2005 installed on my machine. My host is using SQL Server Express, they have given me a connection string which works fine for the remote files. However, now that I've changed the connection string so that it works with
my host, I can no longer access the security tab in asp.net configuration. I get this error:
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:
Login failed for user 'username'.
This is the connection string I was given for the remote host:
<add name="Personal" connectionString="Data Source=(local)\sqlexpress;Integrated Security=false;Initial Catalog=username_personal;User ID=username;Password=password" providerName="System.Data.SqlClient"/>
<add name="LocalSqlServer" connectionString="Data Source=(local)\sqlexpress;Integrated Security=false;Initial Catalog=username_aspnetdb;User ID=username;Password=password" providerName="System.Data.SqlClient" />
my question is, how can I get this to work locally on my machine or do I need to change the connection string back to what it was before?
This was the old connection string:
<add name="Personal" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf"
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>
Sep 19, 2006 02:46 AM|jwadsworth|LINK
Sep 19, 2006 09:49 PM|phishycoder|LINK
There are actually two databases in the App_Data folder on my local machine.
there are two other files in this folder..
Is there a way to add my remote username to these local databases? I'd like to make my machine match the way the remote machine is set up so I don't have to swap the connection strings to get it working on one or the other.
Sep 19, 2006 10:17 PM|jwadsworth|LINK
You can add the user to your database, but you need to take a little different approach to connecting to it on your local. You would need to:
Sep 21, 2006 02:20 AM|phishycoder|LINK
Thanks Jeremy, that makes sense.
I have reinstalled SQL Server Express and attached the two databases.
Can you provide me with more direction for the next two steps? I have tried looking for detailed instruction through google and have been unsuccessful. Even a link to an instruction page would be just fine. Your help is greatly appreciated.
Sep 23, 2006 11:53 PM|jwadsworth|LINK
Next you would open SQL Server Management Studio Express and do the following:
The user is now added to your database.