How do I use SQL Server 2000 for the Application Service Database

[Guest]

Hello,
I do not have SQL Server 2005 installed on my computer and will not be able
to based on company policy. However I do have SQL Server 2000. I want to
create the application service database to store personalization setting for
using web parts.

BUT, when I try to create the database I get an error and it looks like it
is trying to connect to SQL Server 2005. How do I change the aspnet_regsql
tool to use SQL Server 2000?

Thanks in advance,
Vince

 

[Guest]

This may answer your question:

https://help.maximumasp.com/SmarterTicket/Customer/KBArticle.aspx?articleid=878

 

[Guest]

Hi Chris,

I have tried using this wizard but for some reason it thinks i'm using sql
server 2005. I have 2000 on my computer. I can enter the server name and
database name and click next. Then when it tries to build the db in the
empty db I created it gives me an error.

"Unable to connect ot sql server database. an error has occurred while
establishing a connection to the server. When connecting to sql server 2005,
this failure may be caused by the fact that under the default settings sql
server does not allow remote connections"

How do I tell it that this is sql server 2000?

Thanks,
Vince

 

[Bruce Barker]

if you look at the docs, the -S command switch identifies the sqlserver to
use. i looked at the install script, and they are fine with sql2000

-- bruce (sqlwork.com)

 

[Guest]

Got it working now, thanks

if you look at the docs, the -S command switch identifies the sqlserver to
use. i looked at the install script, and they are fine with sql2000

-- bruce (sqlwork.com)