When you are using Skyline you get a Server Error in '/' Application message stating:
"The SELECT permission was denied on the object 'Website', 'database Skyline', schema 'dbo'."
Make sure that the connection setting to the database is correct.
data source=.\Skyline The data source is the name of the SQL server and the name of the instance of SQL on that server. The server name can be in the form \\servername or .\ where \\servername is the name of an external SQL server or .\ indicates that the SQL database in on the same server as the Skyline website. The instance name needs to be Skyline. Microsoft SQL Server supports multiple instances of the SQL Server database engine running concurrently on the same computer. Each instance of the SQL Server database engine has its own set of system and user databases that are not shared between instances.
initial catalog=skyline The initial catalog is the name of the database. This must be set to skyline.
user id=Skyline The user id is the username that will access the databases. This is set to Skyline by default and should only be changed by a database administrator if the local security policies require it.
password=Skyline The password is set to Skyline by default and should only be changed by a database administrator if the local security policies require it.
If all the settings above are correct, you will need to check that the SQL user is set up correctly. Open Microsoft SQL Management Studio Express. If this is not installed, it can be downloaded for free from the Microsoft website.
Make sure that you install the correct version for SQL 2005 or SQL 2008.
Enter the server name defined in web.config and click Connect
Open the container Security / Log ins, right-click the user Skyline and select Properties.
In the General settings, set the password to the one defined in web.config By default this is set to Skyline.
Make sure that the option "Enforce password policy" is unchecked.
Under User Mappings, check that the user Skyline Default Schema is set to "dbo" for the Skyline and SkylineMembership databases.
Click the Skyline database and check that the options db_owner and Public are selected.
Click the SkylineMembership database and check that the options db_owner and Public are selected.
If all the settings are correct, click OK and close Microsoft SQL Management Studio Express.