Schema and how it can really mess your day up in sql.

in #sql • 7 years ago (edited)

The current situation.

We have a web application from back in 2009 running on windows server 2003 with apache web services. The back end server is a sql 2005 database.

The mission is to move to windows server 2008 r2 and hopefully a new sql server version.

We built out the new web server and the database server. Attached the database found the orphan user. gave it sysadmin rights.

None of the application queries were working. All tables and views had a schema name associated with them and this was not being added to any queries..

After much research i was able to deduce we gave too many rights to a user. After re-assigning the schema to the user and removing all but the default user security roles the application began to properly attach the schema to all user queries.

#database #windows #server
7 years ago in #sql by
$0.00
    1 vote
    Reply 0

    Coin Marketplace

    STEEM 0.19
    TRX 0.15
    JST 0.029
    BTC 63608.16
    ETH 2621.61
    USDT 1.00
    SBD 2.77