Commerce Server General - Help needed- CS2k2, SQL2005 FP1 !!!

Author

Help needed- CS2k2, SQL2005 FP1 !!!

Martin

2006-05-10, 1:15 pm

Hi, I'm trying to get a mscs2002 FP1 site to run from our app server,
to another DB server with sql 2005 developer edition on.

I just cannot get it to work!!

If I unpack a site, all the DBs are created correctly, but when I try
and use the site I get all sorts of errors. Mainly connection ones.
This is the current one:

Invalid connection (Please check the connection string). Login failed
for user 'my_user'.[42000] Data provider could not be
initialized.[42000]

I've set all the connection strings to use sql authentication, and they
all check out ok, when 'testing' them.

I heard MSCS2002 should work ok with SQL2005...

Any ideas?

David M. OHara

2006-05-12, 7:14 pm

Martin,

Although this configuration CAN work, it is unsupported by MS. Here's a link
to Ryan Donovan's (Program Director for Commerce Server) comments on the
topic of .NET 2.0, SQL 2005 and Commerce 2002
(http://blogs.msdn.com/rdonovan/arch.../07/526674.aspx). Sorry.

"Martin" wrote:

> Hi, I'm trying to get a mscs2002 FP1 site to run from our app server,
> to another DB server with sql 2005 developer edition on.
>
> I just cannot get it to work!!
>
> If I unpack a site, all the DBs are created correctly, but when I try
> and use the site I get all sorts of errors. Mainly connection ones.
> This is the current one:
>
> Invalid connection (Please check the connection string). Login failed
> for user 'my_user'.[42000] Data provider could not be
> initialized.[42000]
>
> I've set all the connection strings to use sql authentication, and they
> all check out ok, when 'testing' them.
>
> I heard MSCS2002 should work ok with SQL2005...
>
> Any ideas?
>
>

psinyc

2006-05-29, 5:21 pm

Martin,

Any luck? I have a client who is adament about running MSCS2002 and SQL2005.
We used SQL2000 to install the site, developed against the SQL2000, and once
we moved the .bak's over from 2000 to 2005, we got the same error on the 1 of
the 7 or .dll set in the config file for user access/permissions problems.

"Martin" wrote:

> Hi, I'm trying to get a mscs2002 FP1 site to run from our app server,
> to another DB server with sql 2005 developer edition on.
>
> I just cannot get it to work!!
>
> If I unpack a site, all the DBs are created correctly, but when I try
> and use the site I get all sorts of errors. Mainly connection ones.
> This is the current one:
>
> Invalid connection (Please check the connection string). Login failed
> for user 'my_user'.[42000] Data provider could not be
> initialized.[42000]
>
> I've set all the connection strings to use sql authentication, and they
> all check out ok, when 'testing' them.
>
> I heard MSCS2002 should work ok with SQL2005...
>
> Any ideas?
>
>

Vinayak Tadas[MSFT]

2006-06-19, 3:00 pm

This configuration has not been tested and is not supported
You will be better off running on Sql 2000
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only

--------------------
Thread-Topic: Help needed- CS2k2, SQL2005 FP1 !!!
thread-index: AcaCASKosUNemXglQ7OOqnBm0VyLPw==
X-WBNR-Posting-Host: 69.122.114.114
From: =?Utf-8?B?cHNpbnlj?= <psinyc@discussions.microsoft.com>
References: <1147278624.004324.245130@u72g2000cwu.googlegroups.com>
Subject: RE: Help needed- CS2k2, SQL2005 FP1 !!!
Date: Sat, 27 May 2006 19:48:01 -0700
Lines: 30
Message-ID: <B327A278-3514-4B64-B72F-88B2538FECAD@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17857
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general

Martin,

Any luck? I have a client who is adament about running MSCS2002 and
SQL2005.
We used SQL2000 to install the site, developed against the SQL2000, and
once
we moved the .bak's over from 2000 to 2005, we got the same error on the 1
of
the 7 or .dll set in the config file for user access/permissions problems.

"Martin" wrote:

> Hi, I'm trying to get a mscs2002 FP1 site to run from our app server,
> to another DB server with sql 2005 developer edition on.
>
> I just cannot get it to work!!
>
> If I unpack a site, all the DBs are created correctly, but when I try
> and use the site I get all sorts of errors. Mainly connection ones.
> This is the current one:
>
> Invalid connection (Please check the connection string). Login failed
> for user 'my_user'.[42000] Data provider could not be
> initialized.[42000]
>
> I've set all the connection strings to use sql authentication, and they
> all check out ok, when 'testing' them.
>
> I heard MSCS2002 should work ok with SQL2005...
>
> Any ideas?
>
>

Vinayak Tadas[MSFT]

2006-06-19, 7:19 pm