sql server - How can I simulate two SQL instances to test my stored procedures? -

i working on .net-based web application sql 2008 end. sql server contains dozen databases.

in our development environment, of databases live in same sql instance. however, in production, there 2 instances, half of databases on 1 instance , half on other. in production, not allowed use linked servers (for security reasons).

given above constraints, seems possible write sql statements execute fine in development environment fail miserably in production environment, because not of databases accessible single connection string.

i'm writing reports draw data these databases , testing them in development environment. how can make sure i'm writing work in production?

i thinking maybe setting sql server roles or users in manner restrict access of databases, not sure work.