|
|
You're in the
sql server msde
group:sql server desktop engine problem
sql server msde:
I just changed my wsus server. I want to use a new server for this application. I have follwed the step described in the article Backup Windows Server Update Services. After the restoration of the data and the wsus database I have this error Event Type: Error Event Source: Windows Server Update Services Event Category: Update Services Service Event ID: 421 Date: 10/27/2005 Time: 3:31:56 PM User: N/A Computer: ESALESMTL Description: Connection to database failed. Reason=Cannot open database requested in login 'SUSDB'. Login fails. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.. Connection string: Data Source=ESALESMTL\WSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100 How can I change the login credentials if it is the solution ? Thanks
Hi,
You may perform the statements below and then let me know whether it works EXEC sp_grantlogin @loginame = 'NT AUTHORITY\NETWORK SERVICE' USE <destination database> GO EXEC sp_grantdbaccess @loginame = 'NT AUTHORITY\NETWORK SERVICE' EXEC sp_addrolemember @membername = 'NT AUTHORITY\NETWORK SERVICE', @rolename = '<role name>' Thank you for your patience and cooperation. If you have any questions or concerns, don't hesitate to let me know. We are always here to be of assistance! Sincerely yours, Michael Cheng Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Micheal
I'm not very used to SQL. Where I can do that ? [quoted text, click to view] "Michael Cheng [MSFT]" wrote:
> Hi, > > You may perform the statements below and then let me know whether it works > > EXEC sp_grantlogin @loginame = 'NT AUTHORITY\NETWORK SERVICE' > > USE <destination database> > GO > > EXEC sp_grantdbaccess @loginame = 'NT AUTHORITY\NETWORK SERVICE' > EXEC sp_addrolemember @membername = 'NT AUTHORITY\NETWORK SERVICE', > @rolename = '<role name>' > > Thank you for your patience and cooperation. If you have any questions or > concerns, don't hesitate to let me know. We are always here to be of > assistance! > > > Sincerely yours, > > Michael Cheng > Microsoft Online Partner Support > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > ===================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. >
hi,
[quoted text, click to view] totomaster wrote: > Micheal > > I'm not very used to SQL. Where I can do that ? > > "Michael Cheng [MSFT]" wrote: > >> Hi, >> >> You may perform the statements below and then let me know whether it >> works >> >> EXEC sp_grantlogin @loginame = 'NT AUTHORITY\NETWORK SERVICE' >> >> USE <destination database> >> GO >> >> EXEC sp_grantdbaccess @loginame = 'NT AUTHORITY\NETWORK SERVICE' >> EXEC sp_addrolemember @membername = 'NT AUTHORITY\NETWORK SERVICE', >> @rolename = '<role name>' run the command line utility provided as long as MSDE, oSql.exe http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp, and type the statement provided by Micheal... -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
Hi,
Thanks so much for MVP Andrea's detailed information and links. Yes, you should use osql.exe to execute these T-SQL codes. For example (assuming you are executing the statements on MSDE local machine) c:\>osql -S localhost -E 1>EXEC sp_grantlogin @loginame = 'NT AUTHORITY\NETWORK SERVICE' 2>GO .... (all the statements in the previous post) For detailed descriptions about osql switches, check MVP's link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp _osql_1wxl.asp If you have any questions or concerns, don't hesitate to let me know. We are always here to be of assistance! Sincerely yours, Michael Cheng Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Guys
Thanks for your answer. Wich role I have to write for the role name parameters, I tried sa and it's not working. Also osql -S localhost -E was not working I use osql -S esalesmtl\wsus -E instead Thanks [quoted text, click to view] "Michael Cheng [MSFT]" wrote:
> Hi, > > Thanks so much for MVP Andrea's detailed information and links. > > Yes, you should use osql.exe to execute these T-SQL codes. > > For example (assuming you are executing the statements on MSDE local > machine) > > c:\>osql -S localhost -E > 1>EXEC sp_grantlogin @loginame = 'NT AUTHORITY\NETWORK SERVICE' > 2>GO > .... > (all the statements in the previous post) > > For detailed descriptions about osql switches, check MVP's link > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp > _osql_1wxl.asp > > If you have any questions or concerns, don't hesitate to let me know. We > are always here to be of assistance! > > > Sincerely yours, > > Michael Cheng > Microsoft Online Partner Support > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > ===================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. >
Hi,
I am using an example and you must change it correctly for your scenairo :) @rolename is the name of the SQL Server role in the current database. role is sysname. Each database has a set of fixed database roles. While roles with the same names exist in each database, the scope of an individual role is only within a specific database. Fixed database roles are db_owner db_accessadmin db_securityadmin db_ddladmin db_backupoperator db_datareader db_datawriter db_denydatareader db_denydatawriter You can also get a list of the fixed database roles from sp_helpdbfixedrole, and get the specific permissions for each role from sp_dbfixedrolepermission. For more information about roles, please check the Books Online article "Logins, Users, Roles, and Groups". Thank you for your patience and cooperation. If you have any questions or concerns, don't hesitate to let me know. We are always here to be of assistance! Sincerely yours, Michael Cheng Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |