VSTS and SQL 2005

What is the suggested install order. I've got SQL 2005 Dev Edition and VS
2005 for Devs. I don't want to install SQL 2005 Express. Do I install
VS2005 first or second?
I am trying to track down an error in ASP.NET Configuration (see my other
post on November 9)
ZackPersonally, I did SQL 2005 first, followed by VS 2005 without SQL
Express.
All of the application services (membership, profile, health
monitoring) are configured to use a SQL Express database by default,
but it's easy to configure them to point to an aspnetdb in a regular
SQL instance.
Any help?
Scott
http://www.OdeToCode.com/blogs/scott/
On Thu, 10 Nov 2005 10:33:51 -0800, "Zachary Burns"
<ZacharyBurns@.discussions.microsoft.com> wrote:

>What is the suggested install order. I've got SQL 2005 Dev Edition and VS
>2005 for Devs. I don't want to install SQL 2005 Express. Do I install
>VS2005 first or second?
>I am trying to track down an error in ASP.NET Configuration (see my other
>post on November 9)
>Zack
Scott,
Thanks. This is what I tried to do but not sure if I've missed a step.
Is this what you've done to get ASP.NET configuration to work?
I didn't install SQL Server Express 2005 when I installed VS 2005 Team Dev
Edition because I installed SQL Server 2005 Developer Edition. Now in VS200
5
when I go to Website-> ASP.NET Configuration. I get an error page.
I've run "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe",
then went into
"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config" and
changed the LocalSqlServer to the connection information on this machine, bu
t
I still get errors.
I'm assuming I just have the connection string information wrong. I don't
have to change it anywhere else do I?
Zack
"Scott Allen" wrote:

> Personally, I did SQL 2005 first, followed by VS 2005 without SQL
> Express.
> All of the application services (membership, profile, health
> monitoring) are configured to use a SQL Express database by default,
> but it's easy to configure them to point to an aspnetdb in a regular
> SQL instance.
> Any help?
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
> On Thu, 10 Nov 2005 10:33:51 -0800, "Zachary Burns"
> <ZacharyBurns@.discussions.microsoft.com> wrote:
>
>
Hey Zack:
On Fri, 11 Nov 2005 06:58:08 -0800, "Zachary Burns"
<ZacharyBurns@.discussions.microsoft.com> wrote:

>Now in VS2005
>when I go to Website-> ASP.NET Configuration. I get an error page.
>
Hmm, what's the error?

>I've run "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe",
>then went into
>"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config" and
>changed the LocalSqlServer to the connection information on this machine, b
ut
>I still get errors.
>I'm assuming I just have the connection string information wrong. I don't
>have to change it anywhere else do I?
>
You changed the LocalSqlServer connection string entry, right?
Did you change the name of the connection string from LocalSqlServer
to something else? If so, you'll need to modify all the provider
sections to point to the modified connection string name.
If the name is the same, that should be the only place you need to
modify.
Scott
http://www.OdeToCode.com/blogs/scott/
Scott,
I get the error page:
Server Error in '/asp.netwebadminfiles' Application. (It's a 401.2 error)
My machine.config page shows:
<connectionStrings>
<add name="LocalSqlServer" connectionString="data
source=127.0.0. 1;AttachDBFilename=|DataDirectory|ZBASPN
ET.mdf;User
Instance=true; User ID=sa; Password=SQL2005Dev!"
providerName="System.Data.SqlClient" />
</connectionStrings>
Zack
"Scott Allen" wrote:

> Hey Zack:
> On Fri, 11 Nov 2005 06:58:08 -0800, "Zachary Burns"
> <ZacharyBurns@.discussions.microsoft.com> wrote:
>
> Hmm, what's the error?
>
> You changed the LocalSqlServer connection string entry, right?
> Did you change the name of the connection string from LocalSqlServer
> to something else? If so, you'll need to modify all the provider
> sections to point to the modified connection string name.
> If the name is the same, that should be the only place you need to
> modify.
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
>
On Fri, 11 Nov 2005 10:51:00 -0800, "Zachary Burns"
<ZacharyBurns@.discussions.microsoft.com> wrote:
>Server Error in '/asp.netwebadminfiles' Application. (It's a 401.2 error)
>
Oh, that would be an authorization failure. Do you have an
authorization section specified in your web.config that might be
keeping you out? Perhaps file permissions are set against you?
Scott
http://www.OdeToCode.com/blogs/scott/