I need some help with MSSQL Driven website.
It is placed on Virtual Dedicated Server with windows server 2008 R2 and it has following:
Access with remote desktop
SQL Server Management Studio 2008 R2
SQL Database for the running website
Two Separately accessible directories with all files (Live and Beta)
The problem is that it was setup so that both sets of files Live and Beta use the main database and access it with SA user.
I would like to be able to fully separate the data, so that the beta testers do not have the access to the LIVE data of SQL database to avoid overwriting by mistake.
The website is built in .NET (I think 3.5 or 4.0). Access is available to everything including uncompiled files.
What I did:
I created through SQL Studio on the server another user and a new database for this user (restored from the backup of the live database). Username is ‘beta’ and database name ‘beta’. Beta user can login through management studio and see the beta database without any problems.
I replaced the info in the web.config (in the beta directory) with the new access info:
<add name="Application" connectionString="Data Source=(local)\SQLEXPRESS;Initial Catalog=beta;User ID=beta;Password=xxxxxxxx" />
Where I changed three fields only: catalog (I assume it is a database name), user ID and Password. name="Application" left unchanged.
However, after running the application with the modified web.config it gives me a blank white screen after I try to login.
I’m not sure what was done wrong: maybe I can not use name ‘beta’, or something wrong with permission of DB of user or maybe there is somewhere else something else needs to be changed.
It supposed to be very quick adjustment (unless I’m mistaken), but unfortunately I can not make it work.
If I need to start from scratch and create a new database and user, I could do that. I just need some help what I would need to do.
Thank you for your help.