Iâ'm trying to show images in my report using a url path since I the pics are
many and ever changing. Iâ've set the image source=external;
Image value= http://<webserver>/<IISVirtualDirectoryName>/filename.jpg
If I set the IIS Directory security to â'Anonymous Accessâ' with a proper
Account name/pass, the image renders properly.
If I try to set the IIS Directory security to â'Windows authenticationâ', the
image does not render-- even though all the other report fields are populated.
So it appears to me the credentials are not being passed to IIS for the
virtual directory authentication when the report is rendered.
How can I pass the report credentials to IIS?
Btw-Iâ'm running SP1 on Win2K, and have set the unattended user/pass, and
have tried various datasource options in Report Manager without success.Tony,
I am not sure if this is what you are looking for but this is what we did.
We generated the image in an aspx page that only contains the image. We then
set the image value = to the URL of that aspx page and works without a hitch.
In our case we were generating Trend graphs in a third party graphing tool
and exporting them as bitmaps and having Reporting Services display the
image. We had to do this because Reporting Services graphing ability is
rather lacking and we are in the process of moving all of the companies
reports to reporting services.
Hope this helps
"Tony Ballman" wrote:
> Iâ'm trying to show images in my report using a url path since I the pics are
> many and ever changing. Iâ've set the image source=external;
> Image value= http://<webserver>/<IISVirtualDirectoryName>/filename.jpg
> If I set the IIS Directory security to â'Anonymous Accessâ' with a proper
> Account name/pass, the image renders properly.
> If I try to set the IIS Directory security to â'Windows authenticationâ', the
> image does not render-- even though all the other report fields are populated.
> So it appears to me the credentials are not being passed to IIS for the
> virtual directory authentication when the report is rendered.
> How can I pass the report credentials to IIS?
> Btw-Iâ'm running SP1 on Win2K, and have set the unattended user/pass, and
> have tried various datasource options in Report Manager without success.
>|||Thanks that's a great idea. I suppose you're also able to thumbnail or reduce
the image size that way too.
My thought was to create an IIS web site set to localhost of the box running
the report server, and then placing the IIS Virtual directory there with
anonymous access- so the virtual directory access is at least limited to
inside the firewall.
"KBurnell" wrote:
> Tony,
> I am not sure if this is what you are looking for but this is what we did.
> We generated the image in an aspx page that only contains the image. We then
> set the image value = to the URL of that aspx page and works without a hitch.
> In our case we were generating Trend graphs in a third party graphing tool
> and exporting them as bitmaps and having Reporting Services display the
> image. We had to do this because Reporting Services graphing ability is
> rather lacking and we are in the process of moving all of the companies
> reports to reporting services.
> Hope this helps
> "Tony Ballman" wrote:
> > Iâ'm trying to show images in my report using a url path since I the pics are
> > many and ever changing. Iâ've set the image source=external;
> > Image value= http://<webserver>/<IISVirtualDirectoryName>/filename.jpg
> > If I set the IIS Directory security to â'Anonymous Accessâ' with a proper
> > Account name/pass, the image renders properly.
> > If I try to set the IIS Directory security to â'Windows authenticationâ', the
> > image does not render-- even though all the other report fields are populated.
> > So it appears to me the credentials are not being passed to IIS for the
> > virtual directory authentication when the report is rendered.
> >
> > How can I pass the report credentials to IIS?
> >
> > Btw-Iâ'm running SP1 on Win2K, and have set the unattended user/pass, and
> > have tried various datasource options in Report Manager without success.
> >
Showing posts with label directory. Show all posts
Showing posts with label directory. Show all posts
Friday, March 23, 2012
Friday, March 9, 2012
IIS Virtual Directory Settings
Hi and hopefully thanks for the help.
I have some issues with regard to deploying reports that I can design and
preview.
When I try to deploy I get the 'no report server found' at the directory I
have created in IIS.
Is this to do with settings in the virtual directory or something else?
The Report Server service is running. I am using this on a demo machine with
everything on one machine, sql etc.
ThanksAlso when I try to open report manager, I get an error/welcome page for IIS
as well as the IIS page. Any ideas would be welcome.
Thanks
"Are friends electric?" wrote:
> Hi and hopefully thanks for the help.
> I have some issues with regard to deploying reports that I can design and
> preview.
> When I try to deploy I get the 'no report server found' at the directory I
> have created in IIS.
> Is this to do with settings in the virtual directory or something else?
> The Report Server service is running. I am using this on a demo machine with
> everything on one machine, sql etc.
> Thanks
>
I have some issues with regard to deploying reports that I can design and
preview.
When I try to deploy I get the 'no report server found' at the directory I
have created in IIS.
Is this to do with settings in the virtual directory or something else?
The Report Server service is running. I am using this on a demo machine with
everything on one machine, sql etc.
ThanksAlso when I try to open report manager, I get an error/welcome page for IIS
as well as the IIS page. Any ideas would be welcome.
Thanks
"Are friends electric?" wrote:
> Hi and hopefully thanks for the help.
> I have some issues with regard to deploying reports that I can design and
> preview.
> When I try to deploy I get the 'no report server found' at the directory I
> have created in IIS.
> Is this to do with settings in the virtual directory or something else?
> The Report Server service is running. I am using this on a demo machine with
> everything on one machine, sql etc.
> Thanks
>
IIS Virtual Directory Manager and IIS 6: Template requests not being actioned.
Hi,
I have XML Data Islands on my page that are correctly requesting data
from the Virtual Directory. I can see the requests in the IIS log.
However the virtual directory doesn't seem to be returning anything -
no error message no nothing. When I run the same query from IE6
directly it runs fine.
I have run a trace on the database and nothing is being requested.
How can I debug this - is there an error log somewhere that I could
look at? What am I missing?
Info: SQL Server 2000 SP4 is on a separate database. I am using
Integrated Windows Authentication and delegation.
Cheers,
JamesSorry, this was specific to our setup... ignore.
JimLad wrote:
> Hi,
> I have XML Data Islands on my page that are correctly requesting data
> from the Virtual Directory. I can see the requests in the IIS log.
> However the virtual directory doesn't seem to be returning anything -
> no error message no nothing. When I run the same query from IE6
> directly it runs fine.
> I have run a trace on the database and nothing is being requested.
> How can I debug this - is there an error log somewhere that I could
> look at? What am I missing?
> Info: SQL Server 2000 SP4 is on a separate database. I am using
> Integrated Windows Authentication and delegation.
> Cheers,
> James
I have XML Data Islands on my page that are correctly requesting data
from the Virtual Directory. I can see the requests in the IIS log.
However the virtual directory doesn't seem to be returning anything -
no error message no nothing. When I run the same query from IE6
directly it runs fine.
I have run a trace on the database and nothing is being requested.
How can I debug this - is there an error log somewhere that I could
look at? What am I missing?
Info: SQL Server 2000 SP4 is on a separate database. I am using
Integrated Windows Authentication and delegation.
Cheers,
JamesSorry, this was specific to our setup... ignore.
JimLad wrote:
> Hi,
> I have XML Data Islands on my page that are correctly requesting data
> from the Virtual Directory. I can see the requests in the IIS log.
> However the virtual directory doesn't seem to be returning anything -
> no error message no nothing. When I run the same query from IE6
> directly it runs fine.
> I have run a trace on the database and nothing is being requested.
> How can I debug this - is there an error log somewhere that I could
> look at? What am I missing?
> Info: SQL Server 2000 SP4 is on a separate database. I am using
> Integrated Windows Authentication and delegation.
> Cheers,
> James
IIS Virtual Directory Management for SQL Server Utility Problem with IIS 6
I have employed the virtual directory management for SQL Server utility
successfully in my office on two machines (which are part of a network
using Windows NT logins), to enable them to access SQL 2000 via HTTP.
Both machines run Windows XP Professional and IIS 5.1. On both
machines, it worked without any problems, and it also works on my home
machine, which also runs Windows XP Professional and IIS 5.1.
However, I have tried to use the utility to create a virtual directory
for an identical SQL database on a server running Windows 2003 and IIS
6.0, and I always receive the page cannot be found error. I have
ensured that everything is identical on all machines with regard to
security and permissions (although the server only offers Application
pool options rather than high, medium and low security options). They
all require Integrated Windows Authentication for both IIS and SQL, and
the permissions for the database tables are identical in all cases. I
have also installed a simple HTML page into the virtual directory on
the Windows 2003 server, and can view that, so I would be extremely
grateful if anyone could tell me what I need to do with IIS 6.0 and
Windows 2003 to enable the virtual directory to grant access to the SQL
database. I have installed the new service pack 4 for SQL 2000 on all
machines.
Hello,
I believe you have to enable the Isapi extensions in IIS for Windows Server
2003.The following link should help you :
http://support.microsoft.com/default...&Product=sql2k
Thanks,
Monica Frintu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"
successfully in my office on two machines (which are part of a network
using Windows NT logins), to enable them to access SQL 2000 via HTTP.
Both machines run Windows XP Professional and IIS 5.1. On both
machines, it worked without any problems, and it also works on my home
machine, which also runs Windows XP Professional and IIS 5.1.
However, I have tried to use the utility to create a virtual directory
for an identical SQL database on a server running Windows 2003 and IIS
6.0, and I always receive the page cannot be found error. I have
ensured that everything is identical on all machines with regard to
security and permissions (although the server only offers Application
pool options rather than high, medium and low security options). They
all require Integrated Windows Authentication for both IIS and SQL, and
the permissions for the database tables are identical in all cases. I
have also installed a simple HTML page into the virtual directory on
the Windows 2003 server, and can view that, so I would be extremely
grateful if anyone could tell me what I need to do with IIS 6.0 and
Windows 2003 to enable the virtual directory to grant access to the SQL
database. I have installed the new service pack 4 for SQL 2000 on all
machines.
Hello,
I believe you have to enable the Isapi extensions in IIS for Windows Server
2003.The following link should help you :
http://support.microsoft.com/default...&Product=sql2k
Thanks,
Monica Frintu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"
IIS Virtual Directory Management for SQL Server Utility Problem with IIS 6
I have employed the virtual directory management for SQL Server utility
successfully in my office on two machines (which are part of a network
using Windows NT logins), to enable them to access SQL 2000 via HTTP.
Both machines run Windows XP Professional and IIS 5.1. On both
machines, it worked without any problems, and it also works on my home
machine, which also runs Windows XP Professional and IIS 5.1.
However, I have tried to use the utility to create a virtual directory
for an identical SQL database on a server running Windows 2003 and IIS
6.0, and I always receive the page cannot be found error. I have
ensured that everything is identical on all machines with regard to
security and permissions (although the server only offers Application
pool options rather than high, medium and low security options). They
all require Integrated Windows Authentication for both IIS and SQL, and
the permissions for the database tables are identical in all cases. I
have also installed a simple HTML page into the virtual directory on
the Windows 2003 server, and can view that, so I would be extremely
grateful if anyone could tell me what I need to do with IIS 6.0 and
Windows 2003 to enable the virtual directory to grant access to the SQL
database. I have installed the new service pack 4 for SQL 2000 on all
machines.Hello,
I believe you have to enable the Isapi extensions in IIS for Windows Server
2003.The following link should help you :
http://support.microsoft.com/defaul...4&Product=sql2k
Thanks,
Monica Frintu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"
successfully in my office on two machines (which are part of a network
using Windows NT logins), to enable them to access SQL 2000 via HTTP.
Both machines run Windows XP Professional and IIS 5.1. On both
machines, it worked without any problems, and it also works on my home
machine, which also runs Windows XP Professional and IIS 5.1.
However, I have tried to use the utility to create a virtual directory
for an identical SQL database on a server running Windows 2003 and IIS
6.0, and I always receive the page cannot be found error. I have
ensured that everything is identical on all machines with regard to
security and permissions (although the server only offers Application
pool options rather than high, medium and low security options). They
all require Integrated Windows Authentication for both IIS and SQL, and
the permissions for the database tables are identical in all cases. I
have also installed a simple HTML page into the virtual directory on
the Windows 2003 server, and can view that, so I would be extremely
grateful if anyone could tell me what I need to do with IIS 6.0 and
Windows 2003 to enable the virtual directory to grant access to the SQL
database. I have installed the new service pack 4 for SQL 2000 on all
machines.Hello,
I believe you have to enable the Isapi extensions in IIS for Windows Server
2003.The following link should help you :
http://support.microsoft.com/defaul...4&Product=sql2k
Thanks,
Monica Frintu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"
IIS Virtual Directory Management for SQL Server
I got the IIS Virtual Directory Management for SQL Server working but I
deleted the Virtual Directory and then went to reinstate it I got the error
"An Error occurred creating virtual directory [VD Name] The virtual
directory already exists"
Do I need to reinstall anything?
What are the correct service packs to have on a server Windows 2003 and SQL
2000?
"Dean" wrote:
> I got the IIS Virtual Directory Management for SQL Server working but I
> deleted the Virtual Directory and then went to reinstate it I got the error
> "An Error occurred creating virtual directory [VD Name] The virtual
> directory already exists"
> Do I need to reinstall anything?
|||Hi Dean,
There is no special requirements for a specific service pack for Windows
2003. For SQL 2000, you should have SP3 with you.
Are you using the MMC tool from the SQL 2000 installation or have you
installed the latest version of SQLXML from
(http://msdn.microsoft.com/library/de...-us/dnanchor/h
tml/anch_SQLXML.asp)
Generally this kind of error should not happen and is not dependent on the
version of the operating system. In your case you should check using the
Internet Information Services manager on the machine to see if the Virtual
Directory still exists If it is not there and you still see the error you
can use the Metabase edit tool from http://support.microsoft.com/kb/840671
to check and edit the IIS metabase store.
Thank you,
Amar Nalla [MSFT]
"Dean" <Dean@.discussions.microsoft.com> wrote in message
news:EA982781-9011-4121-B266-A45ECF5D864D@.microsoft.com...
> What are the correct service packs to have on a server Windows 2003 and
SQL[vbcol=seagreen]
> 2000?
> "Dean" wrote:
error[vbcol=seagreen]
deleted the Virtual Directory and then went to reinstate it I got the error
"An Error occurred creating virtual directory [VD Name] The virtual
directory already exists"
Do I need to reinstall anything?
What are the correct service packs to have on a server Windows 2003 and SQL
2000?
"Dean" wrote:
> I got the IIS Virtual Directory Management for SQL Server working but I
> deleted the Virtual Directory and then went to reinstate it I got the error
> "An Error occurred creating virtual directory [VD Name] The virtual
> directory already exists"
> Do I need to reinstall anything?
|||Hi Dean,
There is no special requirements for a specific service pack for Windows
2003. For SQL 2000, you should have SP3 with you.
Are you using the MMC tool from the SQL 2000 installation or have you
installed the latest version of SQLXML from
(http://msdn.microsoft.com/library/de...-us/dnanchor/h
tml/anch_SQLXML.asp)
Generally this kind of error should not happen and is not dependent on the
version of the operating system. In your case you should check using the
Internet Information Services manager on the machine to see if the Virtual
Directory still exists If it is not there and you still see the error you
can use the Metabase edit tool from http://support.microsoft.com/kb/840671
to check and edit the IIS metabase store.
Thank you,
Amar Nalla [MSFT]
"Dean" <Dean@.discussions.microsoft.com> wrote in message
news:EA982781-9011-4121-B266-A45ECF5D864D@.microsoft.com...
> What are the correct service packs to have on a server Windows 2003 and
SQL[vbcol=seagreen]
> 2000?
> "Dean" wrote:
error[vbcol=seagreen]
IIS Virtual Directory for SQL
On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any clues
Hi
Maybe
http://support.microsoft.com/default...b;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any clues
Hi
Maybe
http://support.microsoft.com/default...b;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
IIS Virtual Directory for SQL
On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/default.aspx?scid=kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/default.aspx?scid=kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
IIS Virtual Directory for SQL
On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=dat
a
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/defaul...kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=dat
a
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/defaul...kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
IIS virtual directory - what to do?
Why why why do I get the message "an error occured connecting to the server 'servername'. This server does not exist or is unavailable" when trying to connect to a server in IIS. I know the server exists (it's the same computer I'm using) and that is up and running. Also, why do I need to connect, can I use the SQLXML features without a virtual directory? I have no need to access my DB from the Internet.
Thank you,
HelenaHi
Is the SQL account you are using to connect ot SQL Server, actually exist on the SQL server?
Is the SQL server oyu are trying to connect to the default instance or a named instance?
Are you using OLEDB or ODBC connection to SQL from IIS?
Cheers
SG|||Yes, the SQL account exists.
The server I'm trying to connect is a named instance. (But it should be the default as well since i only have one server?)
I have no idea whether I use OLEDB and ODBC connection, how do I know..?
Thank you, Helena
Originally posted by sqlguy7777
Hi
Is the SQL account you are using to connect ot SQL Server, actually exist on the SQL server?
Is the SQL server oyu are trying to connect to the default instance or a named instance?
Are you using OLEDB or ODBC connection to SQL from IIS?
Cheers
SG|||Hi Helena,
If you are using OLEDB ( i.e a DSN-less connection ) you will see the connection string like this in your ASP page :
Connection.Open "PROVIDER=SQLOLEDB;DATA SOURCE=SQLADMIN1;UID=testiis1sql;PWD=password;DATA BASE=ServerMon"
If you had an ODBC ( i.e. a DSN connection ) it would look like this :
"Provider=MSDASQL;DSN=dsnName;UID=MyUserID;PWD=MyPa ssword;"
see also :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/pg_ado_providers_2.asp
See also :
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForODBCDatabases
What does your connection look like?
Cheers
SG.
Thank you,
HelenaHi
Is the SQL account you are using to connect ot SQL Server, actually exist on the SQL server?
Is the SQL server oyu are trying to connect to the default instance or a named instance?
Are you using OLEDB or ODBC connection to SQL from IIS?
Cheers
SG|||Yes, the SQL account exists.
The server I'm trying to connect is a named instance. (But it should be the default as well since i only have one server?)
I have no idea whether I use OLEDB and ODBC connection, how do I know..?
Thank you, Helena
Originally posted by sqlguy7777
Hi
Is the SQL account you are using to connect ot SQL Server, actually exist on the SQL server?
Is the SQL server oyu are trying to connect to the default instance or a named instance?
Are you using OLEDB or ODBC connection to SQL from IIS?
Cheers
SG|||Hi Helena,
If you are using OLEDB ( i.e a DSN-less connection ) you will see the connection string like this in your ASP page :
Connection.Open "PROVIDER=SQLOLEDB;DATA SOURCE=SQLADMIN1;UID=testiis1sql;PWD=password;DATA BASE=ServerMon"
If you had an ODBC ( i.e. a DSN connection ) it would look like this :
"Provider=MSDASQL;DSN=dsnName;UID=MyUserID;PWD=MyPa ssword;"
see also :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/pg_ado_providers_2.asp
See also :
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForODBCDatabases
What does your connection look like?
Cheers
SG.
IIS for SQL Server - problem
I configured IIS Virtual Directory Management for SQL Server Utility as
is described in Books Online, but I receive 404 error.
I gave everywhere everyone full access where I can…. But I don’t know
where to look for an error…
IIS seems to work properly because other WWW are working OK.
My SQL Server is from Small Business Server, maybe it shouldn’t work
under SBS?
Hello,
Please let me know the SQL server version you use. For example, SQL server
2000 Standard Edition with SP3. I suggest that you perform the following
steps to narrow down the issue:
1. Make sure your IIS server works fine.
2. Create the virtual directory <nwind>. For more information about how to
configure a virtual directory by using the IIS Virtual Directory Management
SQL Server utility, visit the following MSDN Web site:
http://msdn.microsoft.com/library/en..._xml1_2xvd.asp
3. Open Microsoft Internet Explorer and locate:
http://IISServer/nwind?sql=SELECT+*+...TO&roo t=root
If you receive the error message "HTTP error 404 - File or directory not
found", please perform the steps in the following article 810784:
810784 Error message "HTTP error 404 - File or directory not found" occurs
when
http://support.microsoft.com/?id=810784
Check the issue again. I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
is described in Books Online, but I receive 404 error.
I gave everywhere everyone full access where I can…. But I don’t know
where to look for an error…
IIS seems to work properly because other WWW are working OK.
My SQL Server is from Small Business Server, maybe it shouldn’t work
under SBS?
Hello,
Please let me know the SQL server version you use. For example, SQL server
2000 Standard Edition with SP3. I suggest that you perform the following
steps to narrow down the issue:
1. Make sure your IIS server works fine.
2. Create the virtual directory <nwind>. For more information about how to
configure a virtual directory by using the IIS Virtual Directory Management
SQL Server utility, visit the following MSDN Web site:
http://msdn.microsoft.com/library/en..._xml1_2xvd.asp
3. Open Microsoft Internet Explorer and locate:
http://IISServer/nwind?sql=SELECT+*+...TO&roo t=root
If you receive the error message "HTTP error 404 - File or directory not
found", please perform the steps in the following article 810784:
810784 Error message "HTTP error 404 - File or directory not found" occurs
when
http://support.microsoft.com/?id=810784
Check the issue again. I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
IIS for SQL Server - problem
I configured IIS Virtual Directory Management for SQL Server Utility as
is described in Books Online, but I receive 404 error.
I gave everywhere everyone full access where I can…. But I don’t know
where to look for an error…
IIS seems to work properly because other WWW are working OK.
My SQL Server is from Small Business Server, maybe it shouldn’t work
under SBS?Hello,
Please let me know the SQL server version you use. For example, SQL server
2000 Standard Edition with SP3. I suggest that you perform the following
steps to narrow down the issue:
1. Make sure your IIS server works fine.
2. Create the virtual directory <nwind>. For more information about how to
configure a virtual directory by using the IIS Virtual Directory Management
SQL Server utility, visit the following MSDN Web site:
http://msdn.microsoft.com/library/e...c_xml1_2xvd.asp
3. Open Microsoft Internet Explorer and locate:
http://IISServer/nwind? sql=SELECT+...r />
&root=root
If you receive the error message "HTTP error 404 - File or directory not
found", please perform the steps in the following article 810784:
810784 Error message "HTTP error 404 - File or directory not found" occurs
when
http://support.microsoft.com/?id=810784
Check the issue again. I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
is described in Books Online, but I receive 404 error.
I gave everywhere everyone full access where I can…. But I don’t know
where to look for an error…
IIS seems to work properly because other WWW are working OK.
My SQL Server is from Small Business Server, maybe it shouldn’t work
under SBS?Hello,
Please let me know the SQL server version you use. For example, SQL server
2000 Standard Edition with SP3. I suggest that you perform the following
steps to narrow down the issue:
1. Make sure your IIS server works fine.
2. Create the virtual directory <nwind>. For more information about how to
configure a virtual directory by using the IIS Virtual Directory Management
SQL Server utility, visit the following MSDN Web site:
http://msdn.microsoft.com/library/e...c_xml1_2xvd.asp
3. Open Microsoft Internet Explorer and locate:
http://IISServer/nwind? sql=SELECT+...r />
&root=root
If you receive the error message "HTTP error 404 - File or directory not
found", please perform the steps in the following article 810784:
810784 Error message "HTTP error 404 - File or directory not found" occurs
when
http://support.microsoft.com/?id=810784
Check the issue again. I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)