| A.J. van der Burg 2004-03-11, 10:40 pm |
| Hi Juan,
Maybe a stupid thing to ask, but are you 100% sure you
changed all the database connection strings for the CS
site? There's one DB connection string that resides in the
profiles resource (ProfileService_SQLSource), which can
easily be overlooked.
Other than that, does the account under which all CS
services are running have rights on the DB server?
Hope this helps,
Arnold Jan van der Burg
>-----Original Message-----
>We had a perfectly installed commerce server site for
some
>time. One dya we had some issues with our database server
>(we have one db server and one iis server). In short, the
>db server was hacked, we decided to hide it from the
>internet (it had remote desktop access before) and set a
>10.1 ip address for it. Actually the guys at hostway did
>that. After that, the site simply wouldn't work. Firt it
>showed the SQL server does not exist or login failed
>error, which i solved by changing the ip addresses that
>were configured in the commerce server manager. Just to
>make things clear, the both servers see each other
>perfectly, there is an enterprise manager on the iis
>server and i connect through it to the db server, plus
the
>test connection is always successful. So... no that they
>could see each other, everything should have been ok...
>but nope, onw i get the Cannot create SSPI context error,
>which i have tried to solve without any luck. The account
>used to connect to the db server is the same it had
before
>the problem with the db server, nothing was changed (at
>least intentionally). What other commerce server config
>should i consider in order to set up and running the site
>once more?
>any help GREATLY appreciated
>
>
>.
>
|