VSTS and SQL 2005

[Zachary Burns]

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 Allen]

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"
<Za**********@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

[Zachary Burns]

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 VS2005
when I go to Website-> ASP.NET Configuration. I get an error page.

I've run "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>asp net_regsql.exe",
then went into
"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CON FIG\machine.config" and
changed the LocalSqlServer to the connection information on this machine, but
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"
<Za**********@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 Allen]

Hey Zack:

On Fri, 11 Nov 2005 06:58:08 -0800, "Zachary Burns"
<Za**********@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>asp net_regsql.exe",
then went into
"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CO NFIG\machine.config" and
changed the LocalSqlServer to the connection information on this machine, but
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/

[Zachary Burns]

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|Z BASPNET.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"
<Za**********@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>asp net_regsql.exe",
then went into
"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CO NFIG\machine.config" and
changed the LocalSqlServer to the connection information on this machine, but
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 Allen]

On Fri, 11 Nov 2005 10:51:00 -0800, "Zachary Burns"
<Za**********@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/