I've inherited a version of Umbraco that I've installed on a Win Server 2008, IIS7 and SQL Server 2008 R2. I've created a user and restored the database, but I'm getting this error:
Login failed for user 'MyUser'
I can't see the reason for it - the user exists in the db and has owner permissions. When I try and access the database using Management Studio, both on the server and remotely, the login works correctly. Anyone come across this?
Login failed for user 'MyUser'. - moved umbraco installation
I've inherited a version of Umbraco that I've installed on a Win Server 2008, IIS7 and SQL Server 2008 R2. I've created a user and restored the database, but I'm getting this error:
Login failed for user 'MyUser'
I can't see the reason for it - the user exists in the db and has owner permissions. When I try and access the database using Management Studio, both on the server and remotely, the login works correctly. Anyone come across this?
Thanks
Sorted, was trying to connect to the wrong instance of SQL server.
is working on a reply...