topic Re: Can not update database schema in Server Management (Insight Manager 7)

Can not update database schema

PeteW_1 — Wed, 10 Sep 2003 13:19:13 GMT

I am trying to install IM7.2 into a either a SQL2000 default or instance, however error "can not update database schema". SQL 2000 on same server as IM72. Using account with sysadmin privaledge, windows Administrator. This is on a win2003.

Thanks!!

Re: Can not update database schema

Jeff Mathews — Wed, 10 Sep 2003 14:01:47 GMT

What SQL account are you using? There seems to be issues if you don't use the SA account.

Jeff

Re: Can not update database schema

PeteW_1 — Wed, 10 Sep 2003 14:04:06 GMT

I am using SA. Beginning to think possible problem with install on w2003?? any thoughts?

Re: Can not update database schema

Jadrice Toussaint — Wed, 10 Sep 2003 14:17:41 GMT

Peter -

Download Service Pack 3a for SQL server 2000 from microsoft. Ido know that there are issues with SQL server 2000 and Windows 2003.

Let me know how you make out.

Re: Can not update database schema

PeteW_1 — Wed, 10 Sep 2003 14:25:18 GMT

I have tried sp 3a, also tried hot fix 8.00.0762. no luck. Im loading win2000 server w \ sql 2000 and will attempt to load im72 into. as a test.
Im pretty new to sql. If I load im72 with msde it will take my default instance. However will work. I can then load my sql into a new instance and everything works. My concern was that my main database is now in the new instance. Would this create any performance issues?? That is using my main database which isnt very big 2 gbs. from a instance other than default.??

Any other concerns with running from a new instance name??

thank you!!!

Re: Can not update database schema

Jadrice Toussaint — Wed, 10 Sep 2003 14:59:24 GMT

You're fine as long as you have the proper server resources. It does not matter wheteher you run it from a new instance or the default.