I Installed SQL server 2005, installation completed with out any warnings.
but when trying to configure reporting services it is not configured and throwing error msg as create virtual directory.
and the error msg looks like
"
ReportServicesConfigUI.WMIProvider.WMIProviderException: The virtual directory specified is not valid. Make sure the specified name is not too long and doesn't contain illegal characters. (example: ;)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)
"
We regularly deploy our product to client's sites and install a named instance of SQL Server 2005 and Reporting Services on their Windows Server. We use the instance name "lgs" during SQL setup and it automatically ensures we have a http://server/Reports$lgs and http://server/ReportServer$lgs to work with.
A recent deployment had some trouble with their OS and we have needed to reinstall the Reporting Services component of SQL. After reinstalling, the virtual directories for Reports$lgs and ReportServer$lgs are gone. I have used the Reporting Services Configuration tool to create new virtual directories but when I enter Reports$lgs or ReportServer$lgs as the names I get an error. The error says that the virtual directories cannot
be created due to illegal characters in the names.
How can I create the same virtual dirs that would have normally been created during initial installation?
Im getting the message error "The page cannot be found", while trying to access the Report Manager throught its virtual directory. Otherwise the Report Server url access works fine and both virtual directories have the same configuration
Any suggestion ?!?!
Reporting Services is running on Windows Server 2003
I have written an installer that creates an MS SQL Database, creates the necessary data tables and then imports the data into the data tables. All this works fine. I now need to copy the web pages to a directory on the users machine and then make the chosen directory a virtual directory so the user can call the pages in the usual way (http://localhost/mytestsite/index.html)
Would anyone know how to create a virtual directory using dos command line parameters. I have seen something using "IIsVdir.vbs" but I do not have this script file.
I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!
In SQL2K you could implement web virtual directory (using IIS) that allowed you to query a stored procedure from any HTTP browser (e.g. IE, Netscape, Opera, ...) from anywhere in the world.
would return a HTML page of information as defined in Display_Info stored procedure. This was very useful but a little slow due to IIS overhead!
ENDPOINT & http.sys allow access SQL2005 without IIS which should be faster (?). Hence I have been trying to configure ENDPOINT to do something similar without success. Furthermore there is little information on what you can do with the "FOR TSQL" option and how to use it.
PS I don't want to use SOAP as the client will be a web browser not an apps.
Hi, I have a problem with SQL Server 2005 Reporting Service. I installed Reporting Service in my machine. When I was trying to configure the Reporting Service, Report Manager Virtual Directory got disabled. I need to enable this Report Manager Virtual directory. I can see the disabled link for Report Manager Virtual Directory and it shows the error: Report Manager Virtual Directory is not configurable for the current mode. Kindly help me out of this problem. Thanks Subhendu
Hi, I have a problem with SQL Server 2005 Reporting Service. I installed Reporting Service in my machine. When I was trying to configure the Reporting Service, Report Manager Virtual Directory got disabled. I need to enable this Report Manager Virtual directory. I can see the disabled link for Report Manager Virtual Directory and it shows the error: Report Manager Virtual Directory is not configurable for the current mode. Kindly help me out of this problem. Thanks Subhendu
I have some problem about Reporting Service integrated for SharePoint 2007.
At first, I created 1 user named "User1" under "Domain1". User1 has role "SharePointAdmin" Group and Local Admin Group.
Then I created application pool named "RSAppPool". Its identy was "Domain1User1".
After that, I install Reporting Service and SP2.
Then I config Reporting Service to Integrated Sharepoint Mode below.
Report Server Directory Setting: "ReportServer" in "Default Web Site".
Window Service Identity: Service Account : "Domain1User1" (Windows Accout)
Web Service Identity: Report Server: "RSAppPool" (that created above) Report Manager: Empty
Database Setup: Database name: Database1 (Server Mode: SharePoint Integrated) Credential Type : Windows Credentials Account Name: Domain1User1
After configuration, I reset IIS and test browse to http://servername/ReportServer/ , then there is a Windows Login dialog.
I enter "Domain1User1" and User1's password. But User1 cannot right to access to "ReportServer" virtual directory.
This is error message
You are not authorized to view this page You do not have permission to view this directory or page using the credentials that you supplied. HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials. Internet Information Services (IIS)
There was a 2008 SSRS service running on server "abc".
I have a .Net UI that uses the wsdl at [URL] ....
They deployed SSRS 2012 service on a new server "xyz".
DNS points abc to xyz. Nslookup looks right shows both xyz and abc alias to the same IP.
when I try to go to [URL] .... it redirects to xyz as expected for the host name but the HTTP GET /ReportServer is appended with GET /Reports/ReportServer which doesn't exist and I get an 404 error.
I have no admin rights to see anything and I have no idea if it was an inplace upgrade or a new server. I assume it's new since the actual server name changed in nslookup. Why would it append the default virtual directory when it makes the hop to server "xyz"?
Hi,I've just installed SQL server and then IIS and SQLCE tools.I created a virtual directory and was trying to update the NTFSpermissions from SQLServer Connectivity management when i got thefollowing error - Access Control List (structure) invalid.Has anyone come across this and if so, what did u do to fix it.ThanksLyn
I have a an asp.net application running under IIS. this application is using two folders, the virtual directory under C:Inetpubwwwroot and the application phisical folder at C:. I want to manage this applications .mdf database using microsoft sql server management studio express(iam running sql express with advanced services) which means i have to attach the database to Ms sql server managemet studio express tool. What i dont know is if i should attach the .mdf file in the physical folder's App_Data folder at C:myapplicationFolderApp_data or the .mdf file in the virtual directory under C:InetpubwwwrootMyapplicationFolderApp_Data I dont know which of the two i should attach. Where exactly is the running database, the .mdf file in the physical folder or the .mdf file in the virtual directory under wwwroot.
We have an application that requires write settings to reportserver virtual directory for the IUSR account when anonymous is turned on during the install. Once the install is complete, we lock down the IUSR account so that it only has browse access to the virtual directory when enabling anonymous access.
We automate the uninstall and install of our daily builds and I'm trying to figure out if I can automated this process somehow either through command line utility or in vbs.
I have a big problem to solve: I use MsSqlServer 2000, Analysis service. I have cubes and virtual cubes. I have a dimension of consult, they have a hierarchy that change every month. for example: In june the consult "John" is in D11, in September he is on D14,... Hierarchie: D10 -> D11, D12, D13 - > C1, C2.. For this reason when i want analysis The consult John in a year(12 months) my result is wrong. With this changes in the hierarchie my analysis become wrong! I thought in the end of every month store the cube in a local cube, like a picture of every consult, with his sales e others measures. With this i can analysis the consult in a specific month rightly, but i need the anlysis in a year. And in a year i would have 12 local cubes, then i could acess them and do a right analysis. How could i access 12 local cubes? Can i create a virtual cube with this 12 local cubes? Is there another solution for this problem?
Hello all,my question might be trivial but since my background isn't DB i'll dareto ask it any way:how to create a real (not virtual) table from view1 & view2 ni sqlserver?what should i do specificly in the sql server application & what is thesyntax for that?i thank all of you,groupy.
When I try to add a (SQL Server 2005 Express Edition) database to my project (I'v tried a windows application and an ASP.NET application) in Visual Studio 2005 Professional Edition; It fails with an error like this : "create database failed. some file names listed could not be created (...)" but when I open the project from the real path It works. Is this a bug? Is there any solution? (In many situations there is a need for working with virtual drives. There must be some work around ...)
I went ahead and installed RS even though it was clear Microsoft install was confused (re: preivous post). Now I get to experience the thrill of configuration hell.
Report Server Virtual Directory had a green check. Unfortunately the Name block says <Not Set>. When I try to create a New... default directory I get the error message: "The virtual directory could not be created. The previously set virtual directory will still be used."
Does anyone know where the <Not Set> virtual directory is stored on the computer?
addl info:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The virtual directory specified already exists. Specify a different name.
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)
Is there a way to extract (and copy to a network drive) the necessary files from the SQL Server 2000 CD for the purpose of a creating a client install directory? I would like to invoke the Setup from the network. I do not want to place the whole CD on the network. I do not necessarily want to have to re-key the serial number (product key) every time a client install takes place.
I'm having a bit of a problem implementing a File System Task to Create a directory and would appreciate some help if possible.
I want to create a date directory so I can move files to once they are imported successfully. The date portion for the directory comes from the import file whose name is variable and in the format of PerfLog_<yyyymmdd>.aud. So, in essence, if I am processing a file named Perflog_20060913.aud, when I am done processing it I want to create a directory c:myprog20060913 and move my processed file there.
at SQL Server startup, in error log: Error : 806, Severity: 21, State: 1 Could not find virtual page for logical page <number> in database 'EMGTEST'
Error : 3414, Severity: 21, State: 1 Database 'EMGTEST' (dbid 7): Recovery failed. Please contact Technical Support for further instructions.
Database 'EMGTEST' cannot be opened - it has been marked SUSPECT by recovery. The SA can drop the database with DBCC.
.....
I reset status to Emergency mode (sysdatabases.status = -32768), run dbcc checkdb, dbcc newalloc, dbcc textall...it all looks just fine. I also changed database status to 12 (sysdatabases.status = 12 - select into/bulkcopy and trunc. log on chkpt.) and then run dbcc checkdb, dbcc newalloc, dbcc textall again. looked just fine. but, if I restarted server , database will be marked 'suspect' again, because of Error 806.
Hi, Is there any setting in IS that I should have adjusted in order to avoid this message?
Information: 0x4004800C at EXTRACT from MSCRM and AX (From Source to Working Tables for Dimension), DTS.Pipeline: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 124 buffers were considered and 124 were locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked
I have a DTS package in SQL Server 2000 which brings together data from different sources, including from an Analysis Servcies cube, and compares it. Usually this runs perfectly, but sometimes I get an unexpected internal error from the Data Pump task which queries the cube - no other information, just the error.
This is usually when I have run the package once (manually from Enterprise Manager), then changed a global variable and run it again.
The cube it is querying is a virtual cube and the measures are calculated cells (NOT calculated members).
While connecting remote SQL server through upgrade advisor I am getting the below errors:
Error: Unable to connect to server. Reason: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Pls let me know if anyone has faced this issue and know how to fix.
Has anyone used this successfully from an OLEDB source component, or even from the Execute SQL Task? I've seen some examples of using a script component, but nothing that uses it through a connection manager.
I'm having trouble running jobs with my active directory (ADS) account. I've setup my SQL services to run under an ADS account, but jobs cannot seem to query ADS for user information. We're running Windows Server 2003 and SQL Server 2005 SP2.
Here is the error message:
==
The job failed. Unable to determine if the owner (ADSme) of job eFASRtest has server access (reason: Could not obtain information about Windows NT group/user 'ADSme', error code 0x5. [SQLSTATE 42000] (Error 15404)).
==
also this message in log:
==
[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'ADSme, error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
==
I have done a *lot* of searching and cannot find the solution. I believe the 0x5 code is access denied.
The same job runs if I change the owner to a SQL login that's not an ADS account.
I'm not certain how to confirm that the SQL Agent account is the account actually querying ADS, also.
I receive this error message when I try and run my DTS package:
"Error opening datafile: The filename, directory name, or volume label syntax is incorrect."
I set the file name property of the Text File (Source) to a valid file, but when I run the package and it returns the above error message, it sets the file name property to <not displayable>.
Does anyone have any experience with such a problem? If so please help!!! Thanks
