A. CREATE REPORT (.rdl) 1. Create new project from VS2005 (installer from SQL Server 2005), NEW > Business Intelelligence Projects > Report Server Project 2. At Solustion Explorer right pane, right click Report > Add New Report >. Set your dataset and query. 3. Using tab dataset if you want add new Dataset 4. Parameter. … Continue reading
The permissions granted to user ‘NT AUTHORITY\NETWORK SERVICE’ are insufficient for performing this operation. (rsAccessDenied) I had come across this error a few years ago but had forgotten what the fix was for this. We faced the same error while configuring the reports on one of our production servers. We were trying to access the … Continue reading
Below the best freeware remote computer : 1. mstsc (Remote Dekstop by Windows) using start menu > run > type “mstsc” without “. After that, windows will showing form input box for input IP address destination, ex: 192.168.1.1 . If remote connection is full / maximum exceeded using cmd : “mstsc -console” 2. TightVNC website … Continue reading
Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 ERROR: Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 SOLUTION: run this command in the query editor window for each database exec sp_changedbowner ‘sa’,’true’ _____________________________________________________________ I Have this issue running SQL Server 2008 and this message was in the log: “Login … Continue reading
REGSVR32 Register or unregister a DLL. Syntax REGSVR32 [/U] [/S] [/C] [/I:[Command_Line]] DLL_Name REGSVR32 [/U] [/S] [/C] /N /I:[Command_Line] DLL_Name Key /u Unregister Server. /s Silent – no dialogue boxes. /c Console output. /n Don’t call DllRegisterServer /i Call DllInstall (or DllUninstall if /u is specified) Command_Line An optional command line for DllInstall Examples Unregister … Continue reading