issue after moving database server

Questionsissue after moving database server
mike asked 7 years ago

asked the other day but now can't find my posting. Anyway we had to move our db to a new server. I made changes to db_conf section of the php that makes up my template for the page, but grid still doesn't work. The WP site is still on the same server running IIS and the PHP ms sql driver. Only thing that changed is server name.Are there other changes I need to make I am overlooking?

5 Answers
mike answered 7 years ago

This is where it if faiing
$grade_lookup = $g->get_dropdown_values("select distinct grade as k, grade as v from Web_BoneyardTable where grade = 'SP300' or grade = 'SP350' or grade = '41X40' or grade = '00P20' or grade = 'P20HH' or grade = 'SP400' or grade = 'MEC75' or grade = 'MEC90' or grade = 'HP370'");

error is
Couldn't execute query. SQLState: IMSSP Error Code: -14 Message: An invalid parameter was passed to sqlsrv_query. – select my distinct grade as k, grade as v from Web_BoneyardTable where grade = 'SP300' or grade = 'SP350' or grade = '41X40' or grade = '00P20' or grade = 'P20HH' or grade = 'SP400' or grade = 'MEC75' or grade = 'MEC90' or grade = 'HP370'

Abu Ghufran answered 7 years ago

Hi,

Looks to be a server config setting issue. Refer this link:
https://phpgrid.desk.com/customer/portal/questions/824635-error-connecting-to-sql-server-2-8

mike answered 7 years ago

Abu, brought the old server back on-line to test and the grid works right away. So it has to be something on the new sql box itself I assume? One thing I noticed is on the old server both the sql agent and the sql server services startup as network service, while the new sql box has the services running under a domain user. Thoughts or suggestions?

mike answered 7 years ago

Got it working, it was the account that IIS is using for Anonymous Authentication. Co worker that setup the new SQL box was unaware that I had a user that needed DB rights

mike answered 7 years ago

Got it working, it was the account that IIS is using for Anonymous Authentication. Co worker that setup the new SQL box was unaware that I had a user that needed DB rights

Your Answer

16 + 2 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?