upgrade GP 10 from MSDE 2000 to MS SQL Server 2005

(0) Share

Report

Posted on by Community Member

Hi,

We are currently using GP 10 with MSDE 2000.

I want to upgrade this installation to MS SQL Server 2005.

Any pointers on what I need to do for this upgrade?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

sandipdjadhav 18,306 on at

Like (0)

Report

Are you going to use same server and instance or different? If different server then following KB will be perfect to move GP DB to new server.

support.microsoft.com/.../878449

Thanks

Sandip

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Sandip is correct, follow that KB and you will be fine.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It is the same server that is undergoing the upgrade.

So the KB article is not of much help.

Can you please suggest something else ...

Thx

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Hi Sam,

Thanks for that information it would have been helpful from the begining. We need to know what you are planning to do for the SQL upgrade. Are you going to actually upgrade SQL or install a new SQL instance and then move the databases?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I want to do an inplace upgrade on the same server.

I just installed SQL Server 2005 Express, but it didnt do the upgrade.

Instead it installed a new instance.

1) Do I just backup the current databases and move them to SQL 2005?

2) Do I need to move the master, model,temp and msdb databases also?

Thanks.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Hi Sam,

Since you are moving the databases to a new SQL instance you will want to follow the steps in the KB I first provided. That has all the information you need to accomplish the move.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am using the KB you suggested. On number 13)

i am trying to run the Grant.sql script against the Dyanmics database (on the same server, sql 2005 instance) ... and I get the following error:

Msg 15151, Level 16, State 1, Line 1

Cannot find the user 'DYNGRP', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 1

Cannot find the user 'DYNGRP', because it does not exist or you do not have permission.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

SOunds like the Dyngrp doesnt exist. Did you run the capture login script? This script will recreate Dyngrp:

/*Begin_Create Group */

if not exists(select * from sysusers where name = 'DYNGRP')

exec sp_addrole 'DYNGRP'

go

grant create procedure, create default, create view to DYNGRP

go

revoke create rule, dump database, dump transaction from DYNGRP

go

/*End_Create Group */

If you run into any further issues I would again recommend that you create a support case as the forums are not ment to troubleshoot issues like this.

Was this reply helpful? Yes No