We migrate our database from MS SQL 2008 to MS SQL 2012, but, when I tried access our app, the app show me the follows error:
We generated a dump from our production environment and we imported into our developing environment, after imported, the CF show for us the error above.
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Hi BKBK,
The solution was....
Go to SQL Server >> Security >> Logins and right click on NT AUTHORITY\NETWORK SERVICE and select Properties
In newly opened screen of Login Properties, go to the “User Mapping” tab. Then, on the “User Mapping” tab, select the desired database – especially the database for which this error message is displayed. On the lower screen, check the role db_owner. Click OK.
Tks,
Best Regards,
Fabiano Magno Pechibella
/t5/coldfusion-discussions/vendor-error-code-4060-sql-server/m-p/8601507#M174284
Sep 05, 2016
Sep 05, 2016
It tells you what the problem is.
The login failed
. There is a problem with your authentication.
You need to start there and make sure all the authentication is setup the same way as it was before the migration.
How did you migrate the SQL? AS this is a Coldfusion forum you may get a better chance asking this somewhere SQL related.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
/t5/coldfusion-discussions/vendor-error-code-4060-sql-server/m-p/8601508#M174285
Sep 05, 2016
Sep 05, 2016
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
/t5/coldfusion-discussions/vendor-error-code-4060-sql-server/m-p/8601509#M174286
Sep 05, 2016
Sep 05, 2016
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
/t5/coldfusion-discussions/vendor-error-code-4060-sql-server/m-p/8601510#M174287
Sep 06, 2016
Sep 06, 2016
Hi BKBK,
The solution was....
Go to SQL Server >> Security >> Logins and right click on NT AUTHORITY\NETWORK SERVICE and select Properties
In newly opened screen of Login Properties, go to the “User Mapping” tab. Then, on the “User Mapping” tab, select the desired database – especially the database for which this error message is displayed. On the lower screen, check the role db_owner. Click OK.
Tks,
Best Regards,
Fabiano Magno Pechibella
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
/t5/coldfusion-discussions/vendor-error-code-4060-sql-server/m-p/8601511#M174288
Sep 06, 2016
Sep 06, 2016
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
/t5/coldfusion-discussions/vendor-error-code-4060-sql-server/m-p/8601512#M174289
Sep 07, 2016
Sep 07, 2016
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
