Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need to chnage cuurent server for SQL

Hello All,

I know the subject sounds easy, but I am at a lost.

I have SAP PL 46 with Win 23k and SQL 2005 running on Citrix

My issue is when some users log on current server logs to sql 2000 # 1 which we do not have. I have changed the Params.ini to reflect #4 which equals SQL 2005, and I have even gone in and changed the reg under HKEY_CURRENT_USER\Software\Sap\Sap Manage\SAP Business One\Login, under Servertype I have change the value to 4 as well.

But yet some clients create a .dmp file because they default to sql2000 under current server when I look at change server. But after the DMP process they are able to log onto SAP.

I have installed SQL 2005 Native client on all user machines.

I have created obdc driver on all client machines.

I have reset current server to sql 2005 on all clients.

some clients keep settings and some don't.

So there is my dilemma.

Any thoughts or help would be greatly appreciated.

Thanks so Much

Allen

Former Member
Former Member replied

Good news. Actually, the long way you went through might be the only way. MS has the famous name in remembering something so stubborn that it just refuse to change. If you start this long way quicker, it could be much shorter.

Thanks,

Gordon

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question