Can You Implement Web Virtual Directory In SQL2005 Using ENDPOINT?

Oct 10, 2006

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.

View 3 Replies


ADVERTISEMENT

Virtual Directory

Feb 5, 2008

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

View 1 Replies View Related

Error: Create Virtual Directory

Feb 19, 2008

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

View 2 Replies View Related

Report Manager Virtual Directory

Aug 21, 2007



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

View 17 Replies View Related

Virtual Directory Access Error

Feb 19, 2008

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

View 5 Replies View Related

Cannot Create Named Instance Virtual Directory

Jun 8, 2007

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

View 1 Replies View Related

Report Manager Virtual Directory Configuration Problem

Jan 21, 2008

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 1 Replies View Related

Report Manager Virtual Directory Configuration Problem

Jan 21, 2008

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

Access Denied Virtual Directory ReportServer In Default Web Site

May 15, 2008

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.

View 1 Replies View Related

IS IT A Challenge?(cOnfigurE A VIrtuaL DIrectorY FOR SYncronizatioN WIthouT WEB SYnchronizatioN WIzarD)

May 25, 2007



if you R Right Person Help Me Please.....

View 1 Replies View Related

SQL 2012 :: SSRS Virtual Directory - HTTP GET Method Appending Default Path

Sep 27, 2015

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"?

View 0 Replies View Related

Access Control List (structure) Invalid - Updating Virtual Directory Information

Sep 26, 2005

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

View 2 Replies View Related

.mdf File In Virtual Directory And Physical Folder, Which One Should I Attach To Sql Server Management Studio Express

Jun 26, 2007

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.

View 3 Replies View Related

Sql2005 Export File To Directory

Jul 23, 2007

Hi all,
I have scheduled a package to export data from the table to the execl file in the local directory, it work fine. However, when the next time you execute the package it give error on 'file already exists'. Prephap this is due to previously already created a file in the directory.

I try to use drop option in the ssis during creating the package for export, but the result still the same. I do not know the drop option is working, can someone tell me is that working fine? if not what is the solution or possible cause.

Thanks for your help.:)

View 1 Replies View Related

Automating IUSR Access Priviledges With Anonymous Access For SRS Virtual Directory.

Feb 22, 2008

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

View 1 Replies View Related

How To Implement Alter Database Implement Restrictions On SQL2K ?

Dec 28, 2007

Hi Guyz

it is taken from SQL2K5 SP2 readme.txt. Anyone have idea what to do to implement this ?
Our sp2 is failing. we suspect the above problem and researching it.we are running on default instance of SQL2K5 on win2003 ent sp2

"When you apply SP2, Setup upgrades system databases. If you have implemented restrictions on the ALTER DATABASE syntax, this upgrade may fail. Restrictions to ALTER DATABASE may include the following:

Explicitly denying the ALTER DATABASE statement.


A data definition language (DDL) trigger on ALTER DATABASE that rolls back the transaction containing the ALTER DATABASE statement.


If you have restrictions on ALTER DATABASE, and Setup fails to upgrade system databases to SP2, you must disable these restrictions and then re-run Setup."

thanks in advance.

View 4 Replies View Related

Using Provider For Microsoft Directory Services For Querying Active Directory

Apr 6, 2007

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.

View 6 Replies View Related

Sql2005 Database Restore From Another Sql2005 Backup File Error.

Dec 15, 2005

hi

i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :

 

 

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupackup.bak'. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


 

 

 

pls some one can help me ???

 

thanks

chaus

View 62 Replies View Related

Can You Open A Database Created In SQL2005 In SQL2005 Express?

Oct 12, 2007



Can you open/use a database created in SQL2005 in SQL2005 Express?

Thanks for the help!

Max

View 4 Replies View Related

Upgraded SQL2000 To SQL2005, SQL2005 VERY Slow

Dec 27, 2005

I just upgraded my SQL 2000 server to SQL2005. I forked out all that money, and now it takes 4~5 seconds for a webpage to load. You can see for yourself. It's pathetic. When I ran SQL2000, i was getting instant results on any webpage. I can't find any tool to optimize the tables or databases. And when I used caused SQL Server to use 100% cpu and 500+MB of ram. I can't have this.Can anyone give me some tips as to why SQL 2005 is so slow?

View 3 Replies View Related

Sql2005 Standard To Sql2005 Enterprise Edition

Jan 4, 2007

Hi

We have Sql2005 x64 bit standard edition server installed in windows 2003 64 bit editio server,

currently due to buisness requirements we need to have sql2005 x64 bit enterprise edition, please let me know how do i do the upgrade or change.

is it possible to retain all our custom settings in the standard edition after changing to enterprise edition.

This has to be done for our production and very critical, please help



Thanks

Samuel I

View 4 Replies View Related

Install Sql2005 32 Bit After Removing Sql2005 64 Bit

Sep 19, 2007



I am unable to install 32-bit SQL Server Integration Services on the server due to something that was left behind by the 64-bit version.


I've uninstalled SQL Server 2005 64-bit and when I try to install the 32-bit version of Integration Services, I get this error: "Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error descrition: FATAL: Could not find component 'Microsoft.SqlServer.Dts.Task.MessageQueueTask.ServCompMQTask' we just installed."




I can't seem to figure out how to resolve this problem with the COM+ and I can't remember if Integration Services is required.

Can anybody please advise?

View 1 Replies View Related

Migrating Sql2005 Vb Dts Package To Sql2005

Jul 8, 2007

Hello,



I have a vb program that include a dts package that has been saved to vb with sql2000 dts wizard and works very good.



Now that I upgrade my website to sql2005, this vb dts package doesn't work.

The error I get is:



Microsoft Data Transformation Services (DTS) Package

Invalid STDGMEDIUM structure

(Microsoft Data Transformation Services (DTS) Package (80040066): Invalid STDGMEDIUM structure

) (Microsoft SQL-DMO (ODBC SQLState: 42000) (80004005): [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.)



I searched in the internet how to make dts package in sql2005 and save it to vb and found no information about it.

What Can I do to get the vb code of the dts package I create in sql2005 or how do i migrage the sql2000 vb dts package code to sql2005?



Thanks,

Kubyustus









View 4 Replies View Related

Endpoint (varchar(15))

Jun 6, 2007

I am trying to get my query to pull all the occurances where someone called 411 assistance. It pulls anything that has 411 in it right now, and I just need it to find where the number is just either '411' or '1411' and thats it. Here is what I have so far:

SELECT sum(PaidBalCost), sum(BonusBalCost), sum(ceiling((Cast(DurationSeconds as Decimal)/60))) as Minutes
FROM VoiceCallDetailRecord
WHERE CallDate >= '02/19/2007' and calldate < '03/19/2007'
and (Left(Endpoint,3) = '411'
or Left(Endpoint,4) = ('1411'))
UNION
SELECT sum(PaidBalCost), sum(BonusBalCost), sum(ceiling((Cast(DurationSeconds as Decimal)/60))) as Minutes
FROM ZeroChargeVCDRecord
WHERE CallDate >= '02/19/2007' and calldate < '03/19/2007'
and (Left(Endpoint,3) = '411'
or Left(Endpoint,4) = ('1411'))

View 9 Replies View Related

Can Messages Be Sent To A Wcf Endpoint From T-sql?

Aug 16, 2007

we've gotten this to work from sqlclr and understand the dependence wcf has on the framework but still feel compelled to ask if somehow t-sql can send a message to a wcf endpoint without getting sqlclr involved. I've moved this question over here from the t-sql forum.

View 1 Replies View Related

Passing XML To An Endpoint

Apr 9, 2007

Hi,

I have created an Endpoint based on a stored procedure that has a parameter of datatype XML. I have added a reference to the endpoint in a web project, I have no problems accessing but I do have a question on how to pass XML or an entire XML file to the XML datatype? How is this done in VB.net? I have loaded the XML file into a vb string but this is not compatible with the sql server xml datatype? Any examples anywhere?



Thanks!

View 5 Replies View Related

Can' Establish Endpoint

Feb 28, 2008



I have two servers both installed sql server.The name of the servers are A and B respectively.
The admin of sql server in A is 'domainuserA', and admin of sql server B is 'domainuserB'.


My purpose is create a mirroring for a database in server A, but i can establish endpoint in server A(network address can not be reached or does not exist), i have grant the 'connect to endpoint' permission to each login .




i past my code:

step1



Code Snippet
--Server A, principal
create database db_test
backup database db_test to disk='\sharefolderdb_test.bak' with init

create endpoint endpoint1
as tcp(listener_port=5002)
for database_mirroring
(role=partner)

alter endpoint endpoint1
state=started

create login [domainuserB] from windows
grant connect on endpoint::endpoint1 to [domainuserB]






step2



Code Snippet
--Server B, mirror
restore database db_test from disk='\sharefolderdb_test2.bak' with norecovery

create endpoint endpoint1
as tcp(listener_port=5002)
for database_mirroring
(role=partner)

alter endpoint endpoint1
state=started

create login [domainuserA] from windows
grant connect on endpoint::endpoint1 to [domainuserA]

alter database db_test set partner='TCP://A.corp.com:5002'


--step3



Code Snippet
----Server A, principal

alter database db_test set partner='TCP://B.corp.com:5002'


this step return a error message:

The server network address "TCP://B.corp.com:5002" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.







some wrong?

any suggestions would be appreciated.

View 5 Replies View Related

Endpoint Security ?

Jul 24, 2006

Hi There

I am trying to grasp endpoint security, or actually more security/certiicates in general, at the moment i am trying to write a distributed service broker app, all the examples i have seen use certificates for the endpoint authentication.

Why must one create a certificate at each endpoint? Why can i not create a single certificate and let all endpoints use it ?

As you can imagine of this app gets distributed to hundreds of places creating a certificate at each one is a mission?

So can i use a single certificate for all endpoints authentication?

Thanx

View 1 Replies View Related

Why Is My SQL HTTP Endpoint So Slow?

Oct 23, 2007

I have the need to have a client application connect to a remote database server for retrieval of large datasets (~13000 rows at time) and am trying to leverage existing technologies to build my solution.

To test the difference in retrieval times I created 2 test apps - testA and testB. I created an HTTP endpoint in SQL Server (2005) that exposes one web method corresponding to a sproc that executes one select query and configured testA to execute query and bind the results to a data grid. I exposed my SQL Server so that I could connect directly to the SQL Server using a connection string and configured testB to execute the same SQL statement in an ad-hoc fashion, binding the results to a data grid.

On average, the HTTP endpoint would take ~ 34 seconds to return the 13,000 row data set whereas the direct connection returned that same result set in 4 seconds or less.

I have a bunch of questions:
* Why would I be seeing such a dramatic difference in the retrieval times?
* How is SQL Server communicating when there is a direct connection?
* What are the immediate disadvantages to connecting directly to the remote SQL Server?
* If I were to consider allowing my client application to communicate directly with the SQL Server, is there any way to secure the communication without VPN?
* In addition, is it even possible to create a SQL login that has all of these requirements?
** select and update only
** cannot view schema (cannot connect to the SQL Server using SQL Server Management Studio)
** cannot view any system tables
** cannot retrieve any information about the schema of the database whatsoever

I guess I'm wondering if there is a way to overcome the obvious serialization overhead that comes with the HTTP endpoint to get the speed of the direct connection while being secure at the same time. Is that being greedy? :P

Anyhow, what are your opinions? I'm very interested to hear experiences and/or advice.

Thanks,

Paul

View 1 Replies View Related

Can Messages Be Sent To A Wcf Endpoint From Tsql?

Aug 13, 2007

it sounds like clr can send a message to a wcf endpoint from within ss2005, can tsql do the same? If so is there an example handy?

View 1 Replies View Related

Why Do My Endpoint Connections Never Close?

Jan 11, 2008

Problem: Connections to SOAP endpoints never close even if app initiating call was shutdown several days earlier. Create Endpoint statement included at bottom

Questions:
1 Why?
2. Is there a configuration option I need to set?

[1] Client side: Multiple clients from XMLSpy running on XP Pro to WebSphere Process Server running on AIX

[2] Server side:


What is the MS SQL version? SQL Server 2005 SP2

What is the SKU of MS SQL? Enterprise

What is the SQL Server Protocol enabled? Shared Memory | and TCPIP

Does the server start successfully? YES
If SQL Server is a named instance, is the SQL browser enabled? YES

What is the account that the SQL Server is running under? Domain Account
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? NO

Do you make firewall exception for SQL Browser UDP port 1434? In SQL2000, you still need to make firewall exception for UDP port 1434 in order to support named instance. NO
[2a] Tool Used to Connect: Multiple clients from XMLSpy running on XP Pro to WebSphere Process Server running on AIX


[3] Platform:

What is the OS version?Windows 2003 SP2
Do you have third party antivirus, anti-spareware software installed? McAfee. Exceptions have been set in accordance with MS SQL Server documentation

ENDPOINT:

CREATE ENDPOINT [TestEndpoint]


AUTHORIZATION [AuthID]

STATE=STARTED

AS HTTP (PATH=N'/SqlSSL/testEndpoint', PORTS = (SSL), AUTHENTICATION = (BASIC),


SITE=N'Win2003.ent.corp.net', SSL_PORT = 443, COMPRESSION=DISABLED)

FOR SOAP (


WEBMETHOD 'PutTestResponse'( NAME=N'[UserDb].[schema].[usp_test]'


, SCHEMA=DEFAULT

, FORMAT=ALL_RESULTS),

BATCHES=DISABLED,

WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]',

SESSIONS=ENABLED, SESSION_TIMEOUT=10,

DATABASE=N'UserDb',

NAMESPACE=N'http://tempTestEndpoint.org',

SCHEMA=STANDARD, CHARACTER_SET=XML)

View 1 Replies View Related

How To Enable SSL For HTTP Endpoint?

May 31, 2007

Hi,

I'd like to know how can I setup the SSL so I can secure my HTTP Endpoint.

I saw in the documentation that some settings such as SSL_PORT and PORTS should be set to SSL port number and SSL but I did not find out anywhere where they explain how to enable SSL.



Do we enable SSL the same way we enable it or SQL Server 2005 or does that have to be done through the MMC - Certificates.

I don't have any IIS server running on this server, so I was wondering if IIS is a requirement to generate and import the certificate.



I appreciate your help and comments.

Bruce.

View 3 Replies View Related

Endpoint Already Registered To Another Service

Feb 23, 2006

I am unable to create endpoint in the Windows 2003 server using SQL 2005. I also tried reserving the namespace before CREATE but i still end up with this error

Msg 7806, Level 16, State 1, Line 1
The URL specified by endpoint 'zzzzzz' is already registered to receive requests or is reserved for use by another service.

Msg 7807, Level 16, State 1, Line 1
An error ('0x800700b7') occurred while attempting to register the endpoint zzzzzz.

My code looks loke this:

IF EXISTS ( SELECT name from sys.http_endpoints WHERE name = 'zzzzzz' )
DROP ENDPOINT zzzzzz
GO

CREATE ENDPOINT zzzzzz

STATE = STARTED AS HTTP (
site='servername',
path='/sql/zzzzzz',
AUTHENTICATION=(INTEGRATED),
PORTS = (CLEAR) )
FOR SOAP(
WEBMETHOD 'http://servername/' . 'sp1' (NAME = 'dbName.dbo.sp1'), WEBMETHOD 'http://servername/' . 'sp2' (NAME = 'dbName.dbo.sp2'),
WSDL = DEFAULT,
BATCHES=ENABLED)
GO
-- End of Script --

The script that I use is correct and it works fine on my local machine (Windows XP). The user that I used to crete an endpoint on the server has 'sysadmin' level. The IIS was already turned off. Also I run the script by using the RemoteDesktop to connect to the server (Windows 2003) that has SQL Server 2005. If anyone has an idea about my problem, please help me !!!
Thank You
Zee.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved