Hi,
I've just installed SQL server and then IIS and SQLCE tools.
I created a virtual directory and was trying to update the NTFS
permissions from SQLServer Connectivity management when i got the
following error - Access Control List (structure) invalid.
Has anyone come across this and if so, what did u do to fix it.
Thanks
Lyn
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.
Your help is greatly appreciated...
Eric
Hello, everybody.
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
Hi all,
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)
I'm not sure. Where is I config wrong? ....
Please help me.
Thank you very much.
Hi Guys,
Windows XP, IIS 5.1
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.
Any help would be really appreciated.
Best Regards,
Steve.
Steve
hi all,
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)
"
pls give me any suggestions, Thanks for any help
sql9
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)!
Any ideas??
Thanks
Tom
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?
Thanks,
- Jason
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.
For example:
http://www.mywebsvr.com/WEB_VDN?sql=exec%20Display_Info%20&contenttype=text/html
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
View 3 Replies View Related
if you R Right Person Help Me Please.....
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"?
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.
I need to be able to import a directory file list into a sql table.
i.e. table contains fields for filename, date etc...
is this possible?
thanks?
Say I do File -> New -> Project and make a new project called RedApple under C:. For simplicy, I chose root, but I would designate location for all my SSIS projects. I also check the box "Create directory for solution".
I see that this creates C:RedApple
Under this, I have another RedApple directory with a .sln and .suo files.
In this 2dn RedApple directory, I have .database, .dtproj, and .dtproj.user files.
I deleted the default package1, so I don't have any .dtsx files yet.
As far as the above files are concerned (.sln, .suo, .database, .dtproj, .dtproj.user), I understand these are some kind of system or meta data files and I shouldn't be messing around with them. And that's as far as I need to concern myself on these files.
As I add packages to my project, I see that it is creating .dtsx files under the 2nd RedApple directory. So, I'm thinking these are the package files, one for each package I see in my solution explorer, correct?
MY QUESTION:
Now, I am looking at another SSIS directory tree for a project that I created before I started to pay attention to all this. In this other directory tree, I see that there is also a bin directory, which I do not yet have in C:RedAppleRedApple. In this bin directory I see more .dtsx files, the same ones as I see in the directory above it, but also other .dtsx files that have the names of other packages that I onoce created and deleted along the development of this particular project. What are these .dtsx files?
Hi,
As stated in the subject, I need to import a complete directory structure, from a root folder that I specify into a SQL Server database. To add further complexity, I also need to see what files exist in each directory.
At the end of the day what I am trying to achieve is to populate a table that will essentially have two columns, the filename and the directory that the file resides in. I am running SQL Server 2005.
Has anybody ever done anything like this before using T-SQL?
Thanks in advance.
Hi,
--I am trying to run queries in SQLServer management studio and getting the error "
An error occurred while executing batch. Error message is: The directory name is invalid.". This is when I logon to server itself and run but from my client with cleint I am able to run the same queries.
Can anybody help me in suggesting what is the cause for this
THanks
Deepak
I am trying to save a dts package that I modified to sql server and am getting the following error:
"The directory name is invalid"
I've also tried saving it as a structured storage file and get the same error!
I've been working with dts packages for years and I've never gotten this error.
Can anyone help?
Pete
Hi All....
I am facing troubles while transferring SQL 2000 Objects using the DTS, First I got connection timeout, after I set this parameter to a Higher Value, I got an "Invalid OLEVERB structure" message , followed by " [Microsoft][ODBC SQL Server DRiver] Timeout expired " ...
I tried to trace the problem as much as I can, but I didn't find a way (I am newbie in SQL 2000).. So please , any help, hint is very much appreciated..
Thanks in advance
Hi,
I am adding a file to a filegroup on a remote system, and i don't know the direcotry structure of that machine, how can i provide the path for FILENAME param. :eek:
ALTER DATABASE TESTDB ADD FILE (NAME = N'TESTFILE', FILENAME = N'physicalfilepath.ndf') TO FILEGROUP TESTFILEGROUP
Warm Regards,
Mushq
Is there an Admin script that yields the following directories?
Data
Data Root
Log
TempDB
Shared Feature
Backup
Hi,
I'm using Database Maintenance Plans in Enterprise Manager and I'm trying to backup a database to a different server using a UNC (i.e. \servernameackupdirectory).
I have done this successfully with two SQL Servers but every time I try to set the third SQL Server to backup to a UNC I get this message:
The complete database backup directory '\servernameackupdirectory' is invalid.
The only differences that I can think of is that the server is Win2000 Advanced Server and the SQL Server is Enterprise Edn, where as the two that work are Standard Edn and are on Win2000 Servers (not Advanced).
Does anyone know why I am unable to do this on one SQL Server when I have had no trouble on the other two SQL Servers?
Any help would be greatly appreciated
Thanks,
Troy
In SQL Server 2005 Management Studio I get an error pop up that reads "The directory name is invalid."
This error occured after I installed SQL Server 2005 and added my first database. It went away when I applied all the service packs. It is now occuring again. Would this happen if the temporary files on the computer are cleaned? If so, how do I recover from this. The temp files no longer exist...
This error occurs when I right click on a table and click Open table.
I can click design and that works. But open and edit does not work.
Note: I can open, edit, etc in Visual Studio.
When I click edit I get a more detail message that reads:
===================================
The directory name is invalid.
(mscorlib)
------------------------------
Program Location:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.__Error.WinIOError()
at System.IO.Path.GetTempFileName()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.ScriptToQueryEditor(String text, IManagedConnection mc)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.ScriptTableToWindow(IManagedConnection mc)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.InvokeTextObject(IManagedConnection connection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.Invoke()
I’m trying to create a modified catalog tree out from two tables in sql
The catalog is created from two tables.
Table 1 has the lowest level and is showing the connection with the item and the lowest ItemGroup. It also shows the connection with the MainCatalog
MainCatalogId, ItemGroupId, ItemId
Example data:
(sorry for the tabs that won't work)
MainCatalogIdItemGroupIdItemId
715063823
715073824
715093825
715093826
The catalog structure is in table 2. Here are the connections between the different
ItemGroupId, ParentId
Example data:
ItemGroupIdParentId
15061365
15071365
15091364
13641066
13651066
1066NULL
To be able to use create the tree structure and not getting the result set to big, I need it to look something like this:
ItemGroupIdItemIdLevel 2 level 3Level4
1506 3823136510667
1507 3824136510667
1509 3825136410667
1509 3826136410667
I have tried many ways, but I’m not getting the result I want.
Hope this was understandable, and that someone has an idea if this is manageable
Thanks :)
Hi,
I have the following query I am bulding, its returning the desired results I am just really bad at control statements in TSQL.
What I want to do is dynamically pass the "and landingPage like '/products%' to the SPROC. If I pass nothing this part of the query is not added.
Also, I am wondering how difficult it would be to pass some RegEx into the "landingpage like '%asdf' " part of the query ?
I have started reading some articles but it seems pretty complicated. I am running sql2005 so I am clear on that part.
Any help is much appreicated!!
Thanks again,
mike123
CREATE PROCEDURE [dbo].[select_google_referrers_groupByQueryDate_OrderByQueryDate]
(
@numDays int,
@landingPage varchar(50) = NULL
)
AS SET NOCOUNT ON
SELECT CONVERT(varchar(10),GO.queryDate,112) as referDate,
COUNT(GO.queryID) AS TotalReferrers FROM tblgoogle_referrerDetails GO
WHERE DateDiff(dd, GO.queryDate, GetDate()) < @numDays and landingpage like '/products%'
GROUP BY CONVERT(varchar(10),GO.queryDate,112)
ORDER BY referDate DESC
GO
I have all the config files for my various packages in a folder call configs. It seems that I cannot add folders to the SSIS solution. I can add config files, but they get copied into the root folder, which breaks the directory structure that I have.
Am I missing something? Is there a recommended to manage config files, and other external files used by the SSIS package, in SourceSafe and in the SSIS solution? Thank you.
We have table where we want to populate the fields from Active Directory using Script Task in ssis 2008 .
CREATE TABLE [ZPTSMGR].[ActiveDirectoryRaw](
[Id] [int] IDENTITY(1,1) NOT NULL,
[LoginName] [nvarchar](50) NULL,
[LastName] [nvarchar](100) NULL,
[MiddleName] [nvarchar](50) NULL,
[FirstName] [nvarchar](100) NULL,
[code]...
Hi all
Error string: Invalid OLEVERB structure
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error Detail Records:
Error: -2147221504 (80040000); Provider Error: 0 (0)
Error string: Invalid OLEVERB structure
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error: -2147221504 (80040000); Provider Error: 0 (0)
Error string: Invalid OLEVERB structure
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 5700
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: [SQL-DMO]CreateFile error on '<xxxxxxxxx.yyyyyyyyy>'.
Error source: Microsoft SQL-DMO
Help file: SQLDMO80.hlp
Help context: 1131
DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1
DTSRun: Package execution complete.
Any body experianced same problem.
your help is Appreciated.
I a DB deployed in the field at numerous customer sites. I have made changes
to the DB in my dev environment and now I need a way to update the DBs out in
the field to the new DB structure. Examples of updates are adding a new column
to a table, or adding some more code to a stored proc.
So what do I do ? I need to be able to email comething to the customer that
they can run that will make my recent updates to their DB structure. It can't
screw up their existing data either.
So what's the solution ? A big SQL script wil ALTER TABLE commands ?
How do I updated stored procs through a script ? I need help seriously.
What is the accepted industry standard method of updating deployed DBs
when a new version is released ? Please Please help.
Thanks in advance
Josh
I can log in to a database with administrator account, but not with an user account.
I am getting "Invalid login information" error message. What will be the likely cause for this?
I am using Winodws authentication.
I am trying to run a query on my sql server and get the following error message:
"An error occurred while executing batch. Error message is: The directory name is invalid."
how do I fix?
Is there an XP/SP out there that will return a list of files residingin a specified directory?I'm looking for something simlar toExecute master..xp_subdirs N'C:'But instead of it returning a list of subdirs I want it to return alist of files in that directory.Jeff
View 5 Replies View Related