开发者

How to verify permissions on all SQL accounts along request sequence of ASPX page

I have a previously working ASPX website which also supports AJAX. However, we just upgraded our SQL Server from 2008 Evaluation to 2008 R2 version 10.50.16 and now this website is no longer working.

I believe the problem is that now we need to again restore original SQ开发者_运维技巧L accounts and settings prior to this upgrade. This website also uses AJAX. Which accounts need to be created to fix this problem? When I navigate to this URL, I get the message below:

The address is not valid.


Yes, logins aren't part of the backup/restore process - you need to recreate them (assuming they don't already exist) and then sync the 2008R2 users with the user references in the backup - MSDN is down ATM, but you want to use ALTER USER syntax to do this (sp_change_users_login is likely deprecated). http://blog.gre-sqlserver-solutions.com/2010/03/spchangeuserslogin-and-sql-server-2008.html

Sorry, I don't know where in ASPX or the AJAX to find a connection string - look for anything that referenced the old server - a hostname or IP, the catalog/database name, the default port is 1433...

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜