Server Pack4 broke the code.

Last Post 18 May 2006 05:28 AM by eramgarden_SQL. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
eramgarden_SQL
New Member
New Member

--
18 May 2006 04:45 AM
Ex-developer had developed this ASP.Net/VB.Net application..only couple of pages..against SQL Server 2000 but he hadnt applied any Service Packs. It was still at RTM when I did a "select @@Version".

So, I applied it yesterday and now when I use the app, I get this erorr msg:

"Error retrieving information from DBMAST file. ---> System.Data.SqlClient.SqlException: SELECT permission denied on object 'DBMAST', database 'EDTA001', owner 'dbo'"

I looked at that table and checked "select", "update" , etc for the 4 users I see named there.

What should I do??
eramgarden_SQL
New Member
New Member

--
18 May 2006 05:28 AM

I checked and set the permissions for that user and it works now.

So SP4 took away the permissions?


Acceptable Use Policy
---