Ok, here is the situation...
I have created an Access Project application which connects to our SQL
Server.
SQL server is not behind a proxy, it listens to the default port
Most of our users are outside the LAN and thus they connect through the
internet.
One of our users works in a university environment which controls the
outbound connections through proxy.
I want this user to be able to connect to the SQL server through this
proxy (which i cant control ofcourse)
Is this possible? What settings are required in the proxy (no idea if
it is an MS proxy or not). Does the user has to change anything inside
the MS access connection dialog?
Plz help me on this
If it is not possible please provide some alternatives...
Thanks in advance
Noone knows anything about that? Plz help me on this
On Oct 21, 4:45 pm, IoannisKirmitzog...@.gmail.com wrote:
> Ok, here is the situation...
> I have created an Access Project application which connects to our SQL
> Server.
> SQL server is not behind a proxy, it listens to the default port
> Most of our users are outside the LAN and thus they connect through the
> internet.
> One of our users works in a university environment which controls the
> outbound connections through proxy.
> I want this user to be able to connect to the SQL server through this
> proxy (which i cant control ofcourse)
> Is this possible? What settings are required in the proxy (no idea if
> it is an MS proxy or not). Does the user has to change anything inside
> the MS access connection dialog?
> Plz help me on this
> If it is not possible please provide some alternatives...
> Thanks in advance
sqlsql
Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts
Tuesday, 20 March 2012
Connect to an SQL 2005 server through proxy
Ok, here is the situation...
I have created an Access Project application which connects to our SQL
Server.
SQL server is not behind a proxy, it listens to the default port
Most of our users are outside the LAN and thus they connect through the
internet.
One of our users works in a university environment which controls the
outbound connections through proxy.
I want this user to be able to connect to the SQL server through this
proxy (which i cant control ofcourse)
Is this possible? What settings are required in the proxy (no idea if
it is an MS proxy or not). Does the user has to change anything inside
the MS access connection dialog'
Plz help me on this
If it is not possible please provide some alternatives...
Thanks in advanceNoone knows anything about that? Plz help me on this
On Oct 21, 4:45 pm, IoannisKirmitzog...@.gmail.com wrote:
> Ok, here is the situation...
> I have created an Access Project application which connects to our SQL
> Server.
> SQL server is not behind a proxy, it listens to the default port
> Most of our users are outside the LAN and thus they connect through the
> internet.
> One of our users works in a university environment which controls the
> outbound connections through proxy.
> I want this user to be able to connect to the SQL server through this
> proxy (which i cant control ofcourse)
> Is this possible? What settings are required in the proxy (no idea if
> it is an MS proxy or not). Does the user has to change anything inside
> the MS access connection dialog'
> Plz help me on this
> If it is not possible please provide some alternatives...
> Thanks in advance
I have created an Access Project application which connects to our SQL
Server.
SQL server is not behind a proxy, it listens to the default port
Most of our users are outside the LAN and thus they connect through the
internet.
One of our users works in a university environment which controls the
outbound connections through proxy.
I want this user to be able to connect to the SQL server through this
proxy (which i cant control ofcourse)
Is this possible? What settings are required in the proxy (no idea if
it is an MS proxy or not). Does the user has to change anything inside
the MS access connection dialog'
Plz help me on this
If it is not possible please provide some alternatives...
Thanks in advanceNoone knows anything about that? Plz help me on this
On Oct 21, 4:45 pm, IoannisKirmitzog...@.gmail.com wrote:
> Ok, here is the situation...
> I have created an Access Project application which connects to our SQL
> Server.
> SQL server is not behind a proxy, it listens to the default port
> Most of our users are outside the LAN and thus they connect through the
> internet.
> One of our users works in a university environment which controls the
> outbound connections through proxy.
> I want this user to be able to connect to the SQL server through this
> proxy (which i cant control ofcourse)
> Is this possible? What settings are required in the proxy (no idea if
> it is an MS proxy or not). Does the user has to change anything inside
> the MS access connection dialog'
> Plz help me on this
> If it is not possible please provide some alternatives...
> Thanks in advance
Sunday, 11 March 2012
connect by prior
Hello,
I have to migrate an application from oracle to sqlserver but i habe query with
connect by prior
What is the equivalent in sqlserver 2000.
Please help me.The CONNECT BY PRIOR syntax is an Oracle (and now DB2) specific add-on to the SQL-92 standard. Similar functionality is comming in Yukon, the next version of SQL Server, but for now you can write a User Defined Function in SQL-2000 to get the same effect.
-PatP|||The CONNECT BY PRIOR syntax is an Oracle (and now DB2)
-PatP
Not if you're stuck with V7 on OS/390...
Give me a big block V8 PLEASE!
I have to migrate an application from oracle to sqlserver but i habe query with
connect by prior
What is the equivalent in sqlserver 2000.
Please help me.The CONNECT BY PRIOR syntax is an Oracle (and now DB2) specific add-on to the SQL-92 standard. Similar functionality is comming in Yukon, the next version of SQL Server, but for now you can write a User Defined Function in SQL-2000 to get the same effect.
-PatP|||The CONNECT BY PRIOR syntax is an Oracle (and now DB2)
-PatP
Not if you're stuck with V7 on OS/390...
Give me a big block V8 PLEASE!
Thursday, 8 March 2012
Conncetiviti error
I have this error only when reading a certain file from SQL
server, and not with all the other files, so it's very strange.
I have a Visual FoxPro cursoradapter who gets populated with a
record from a table in SQL server, and the CursorFill method of
the CursorAdapter (which populates it using the CursorAdapter
properties) raises this error:
Connectivity error: [ODBS SQL Server driver] [SQL Server] Line 1:
incorrect sintax near ")".
The message was in italian so I translated it.
I checked the CursorAdapter's SelList, the SelectCmd, the
KeyFieldList, the Cursorschema... none of them contains
parentheses except the selectcmd, as modified in the
BeforeCursorfill event. The selectcmd is the command that Visual
FoxPro will internally use to call SQL server and populate the
cursoradapter.
This select statement contains the list of fields, the FROM
clause and the following "WHERE" condition:
WHERE FLG_LOAD=0 and (substring(TAG1,1,16) >= ' '
and substring(TAG1,1,16)<=(SELECT
COALESCE(min(substring(TAG1,1,16)),'') FROM AR_ANAGR_ANA_IP WHERE
substring(TAG1,1,16) > ' ' and FLG_LOAD = .F.))
FLO_LOAD and TAG1 are both fields of that table.
Someone sees something strange, in that condition?
TIA
VilliHi
FLG_LOAD = .F.))
The ".F." is not a valid expression in SQL Server. Is it a variable, a value
or ?
Regards
Mike
"Villi Bernaroli" wrote:
> I have this error only when reading a certain file from SQL
> server, and not with all the other files, so it's very strange.
> I have a Visual FoxPro cursoradapter who gets populated with a
> record from a table in SQL server, and the CursorFill method of
> the CursorAdapter (which populates it using the CursorAdapter
> properties) raises this error:
> Connectivity error: [ODBS SQL Server driver] [SQL Server] Line 1:
> incorrect sintax near ")".
> The message was in italian so I translated it.
> I checked the CursorAdapter's SelList, the SelectCmd, the
> KeyFieldList, the Cursorschema... none of them contains
> parentheses except the selectcmd, as modified in the
> BeforeCursorfill event. The selectcmd is the command that Visual
> FoxPro will internally use to call SQL server and populate the
> cursoradapter.
> This select statement contains the list of fields, the FROM
> clause and the following "WHERE" condition:
> WHERE FLG_LOAD=0 and (substring(TAG1,1,16) >= ' '
> and substring(TAG1,1,16)<=(SELECT
> COALESCE(min(substring(TAG1,1,16)),'') FROM AR_ANAGR_ANA_IP WHERE
> substring(TAG1,1,16) > ' ' and FLG_LOAD = .F.))
> FLO_LOAD and TAG1 are both fields of that table.
> Someone sees something strange, in that condition?
> TIA
> Villi
>
>|||Mi e' parso che Mike Epprecht (SQL MVP) abbia scritto:
> Hi
> FLG_LOAD = .F.))
> The ".F." is not a valid expression in SQL Server. Is it
> a variable, a value or ?
Ooooooooooooooops!
Thanks, Mike :)
--
The answer to the ethernal question is:
put a read events after the launch of the form
server, and not with all the other files, so it's very strange.
I have a Visual FoxPro cursoradapter who gets populated with a
record from a table in SQL server, and the CursorFill method of
the CursorAdapter (which populates it using the CursorAdapter
properties) raises this error:
Connectivity error: [ODBS SQL Server driver] [SQL Server] Line 1:
incorrect sintax near ")".
The message was in italian so I translated it.
I checked the CursorAdapter's SelList, the SelectCmd, the
KeyFieldList, the Cursorschema... none of them contains
parentheses except the selectcmd, as modified in the
BeforeCursorfill event. The selectcmd is the command that Visual
FoxPro will internally use to call SQL server and populate the
cursoradapter.
This select statement contains the list of fields, the FROM
clause and the following "WHERE" condition:
WHERE FLG_LOAD=0 and (substring(TAG1,1,16) >= ' '
and substring(TAG1,1,16)<=(SELECT
COALESCE(min(substring(TAG1,1,16)),'') FROM AR_ANAGR_ANA_IP WHERE
substring(TAG1,1,16) > ' ' and FLG_LOAD = .F.))
FLO_LOAD and TAG1 are both fields of that table.
Someone sees something strange, in that condition?
TIA
VilliHi
FLG_LOAD = .F.))
The ".F." is not a valid expression in SQL Server. Is it a variable, a value
or ?
Regards
Mike
"Villi Bernaroli" wrote:
> I have this error only when reading a certain file from SQL
> server, and not with all the other files, so it's very strange.
> I have a Visual FoxPro cursoradapter who gets populated with a
> record from a table in SQL server, and the CursorFill method of
> the CursorAdapter (which populates it using the CursorAdapter
> properties) raises this error:
> Connectivity error: [ODBS SQL Server driver] [SQL Server] Line 1:
> incorrect sintax near ")".
> The message was in italian so I translated it.
> I checked the CursorAdapter's SelList, the SelectCmd, the
> KeyFieldList, the Cursorschema... none of them contains
> parentheses except the selectcmd, as modified in the
> BeforeCursorfill event. The selectcmd is the command that Visual
> FoxPro will internally use to call SQL server and populate the
> cursoradapter.
> This select statement contains the list of fields, the FROM
> clause and the following "WHERE" condition:
> WHERE FLG_LOAD=0 and (substring(TAG1,1,16) >= ' '
> and substring(TAG1,1,16)<=(SELECT
> COALESCE(min(substring(TAG1,1,16)),'') FROM AR_ANAGR_ANA_IP WHERE
> substring(TAG1,1,16) > ' ' and FLG_LOAD = .F.))
> FLO_LOAD and TAG1 are both fields of that table.
> Someone sees something strange, in that condition?
> TIA
> Villi
>
>|||Mi e' parso che Mike Epprecht (SQL MVP) abbia scritto:
> Hi
> FLG_LOAD = .F.))
> The ".F." is not a valid expression in SQL Server. Is it
> a variable, a value or ?
Ooooooooooooooops!
Thanks, Mike :)
--
The answer to the ethernal question is:
put a read events after the launch of the form
Sunday, 19 February 2012
Configuring SQLXML IIS
I have configured a virtual directory with my local SQL
Server and local IIS. I am able to execute my templates
without any problems. Pretty cool stuff!
Now I would like to do the same on our production SQL
Server and web server. The SQL Server and web server are
on two different machines. I have read that it is
possible to do this but I am confused as to which
computer I need to connect to through the IIS Virtual
Directory Management console. I am assuming it is the
web server. I tried both the SQL and web server and got
the same error - "An error occured connecting to
<server>. This server does not exist or is unavailable."
1. Can the web server reside on another machine?
2. Which server needs to be configured?
3. Why would I receive the error that I am getting?
Thank you for any assistance that you can provide.
Jason
Yes, the Web Server can be separate from the SQL Server. It's the Web server
you need to configure with the IIS Virtual Directory Management tool, but it
will need to have SQLXML installed. You'll also need to think carefully
about how you configure authentication in your SQLISAPI Virtual Directory.
As for the error, at face-value it looks like a networking issue - I assume
you've tried the usual troubleshooting approaches (i.e. pinging the server
by name or by IP address)?
Graeme Malcolm
Principal Technologist
Content Master Ltd.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:19bc001c42247$c41fd760$a601280a@.phx.gbl...
> I have configured a virtual directory with my local SQL
> Server and local IIS. I am able to execute my templates
> without any problems. Pretty cool stuff!
> Now I would like to do the same on our production SQL
> Server and web server. The SQL Server and web server are
> on two different machines. I have read that it is
> possible to do this but I am confused as to which
> computer I need to connect to through the IIS Virtual
> Directory Management console. I am assuming it is the
> web server. I tried both the SQL and web server and got
> the same error - "An error occured connecting to
> <server>. This server does not exist or is unavailable."
> 1. Can the web server reside on another machine?
> 2. Which server needs to be configured?
> 3. Why would I receive the error that I am getting?
> Thank you for any assistance that you can provide.
> Jason
>
|||Thanks Graeme, what do you mean about configuring
authentication? Are you referring to a user's ability to
access the templates? That was going to be my next
question!
Say I have these templates in my virtual directory that
can be called via HTTP. Anyone can get at them. Is
there a way to pass user credentials to the template in
order to authenticate the user who is trying to access
the template?
Jason
>--Original Message--
>Yes, the Web Server can be separate from the SQL Server.
It's the Web server
>you need to configure with the IIS Virtual Directory
Management tool, but it
>will need to have SQLXML installed. You'll also need to
think carefully
>about how you configure authentication in your SQLISAPI
Virtual Directory.
>As for the error, at face-value it looks like a
networking issue - I assume
>you've tried the usual troubleshooting approaches (i.e.
pinging the server
>by name or by IP address)?
>--
>Graeme Malcolm
>Principal Technologist
>Content Master Ltd.
>"Jason" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:19bc001c42247$c41fd760$a601280a@.phx.gbl...
templates[vbcol=seagreen]
are[vbcol=seagreen]
unavailable."
>
>.
>
|||There are two things that require authentication here.
1. The virtual directory (and the physical template file). You'll need to
decide if your going to allow anonymous access to the virtual directory, in
which case the IUSR_computername accunt will need NTFS file permissions on
the virtual directory folder and the folder containing the templates (if
different), or whether you'll use Windows authentication (in which case the
user's domain account needs the appropriate NTFS permissions. This is just
like any other IIS Web site, and you can use the standard IIS admin tool to
configure site authentication.
2. SQL Server. You've got 4 choices here: (a) Have IIS connect to SQL Server
on the user's behalf, using Windows authentication (select "Always log on
as" and specify the Windows credentials in the virtual directory properties
Security tab - by default it will use the IUSR_computername account and
allow you to automatically synchronize the password. Alternatively, you can
specify any Windows account that you want to and specify the password), (b)
Have IIS connect to SQL Server on the user's behalf, using SQL Server
authentication (select "Always log on as" and specify the SQL Server login
credentials in the virtual directory properties Security tab - you might
also need to enable SQL Server authentication on the SQL Server since by
default it only uses Windows authentication), (c) Have IIS impersonate the
user's Windows credentials when accessing SQL Server (Select "Use Windows
Integrated Authentication" in the virtual directory properties Security
tab), or (d) Have IIS prompt for the user's SQL Server credentials and pass
them to SQL Server using clear text (Select "Use Basic Authentication (Clear
Text) to SQL Server account" in the virtual directory properties Security
tab).
In more general terms (a) and (b) are a form of the "Trusted Server" model
(in which the Web Server application is trusted to use its own credentials
to access the database on the user's behalf), while (c) and (d) are forms of
the "Impersonation/Delegation" model, in which the Web Server accesses the
database using the user's credentials.
In most cases, I'd tend to recommend (a), because it will allow IIS to use
connection pooling (and therefore make the application more scalable).
However, it does mean that everyone who accesses the database through the
Web site uses the same login to SQL Server. If your application is on an
Intranet and you need to force users to use their own account when accessing
SQl Server, then I'd go for (c), in which case Internet Explorer will
automatically send their domain credentials (assuming they're logged into a
domain) or prompt them for their Windows login. The main thing is that the
credentials are encrypted on the network. If you were to use (d) you'd have
to configure the virtual directory to use SSL in order to pass the login
details securely.
Hope that helps,
Graeme
Graeme Malcolm
Principal Technologist
Content Master Ltd.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:1d43801c422ec$75616580$a101280a@.phx.gbl...[vbcol=seagreen]
> Thanks Graeme, what do you mean about configuring
> authentication? Are you referring to a user's ability to
> access the templates? That was going to be my next
> question!
> Say I have these templates in my virtual directory that
> can be called via HTTP. Anyone can get at them. Is
> there a way to pass user credentials to the template in
> order to authenticate the user who is trying to access
> the template?
> Jason
>
> It's the Web server
> Management tool, but it
> think carefully
> Virtual Directory.
> networking issue - I assume
> pinging the server
> message
> templates
> are
> unavailable."
Server and local IIS. I am able to execute my templates
without any problems. Pretty cool stuff!
Now I would like to do the same on our production SQL
Server and web server. The SQL Server and web server are
on two different machines. I have read that it is
possible to do this but I am confused as to which
computer I need to connect to through the IIS Virtual
Directory Management console. I am assuming it is the
web server. I tried both the SQL and web server and got
the same error - "An error occured connecting to
<server>. This server does not exist or is unavailable."
1. Can the web server reside on another machine?
2. Which server needs to be configured?
3. Why would I receive the error that I am getting?
Thank you for any assistance that you can provide.
Jason
Yes, the Web Server can be separate from the SQL Server. It's the Web server
you need to configure with the IIS Virtual Directory Management tool, but it
will need to have SQLXML installed. You'll also need to think carefully
about how you configure authentication in your SQLISAPI Virtual Directory.
As for the error, at face-value it looks like a networking issue - I assume
you've tried the usual troubleshooting approaches (i.e. pinging the server
by name or by IP address)?
Graeme Malcolm
Principal Technologist
Content Master Ltd.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:19bc001c42247$c41fd760$a601280a@.phx.gbl...
> I have configured a virtual directory with my local SQL
> Server and local IIS. I am able to execute my templates
> without any problems. Pretty cool stuff!
> Now I would like to do the same on our production SQL
> Server and web server. The SQL Server and web server are
> on two different machines. I have read that it is
> possible to do this but I am confused as to which
> computer I need to connect to through the IIS Virtual
> Directory Management console. I am assuming it is the
> web server. I tried both the SQL and web server and got
> the same error - "An error occured connecting to
> <server>. This server does not exist or is unavailable."
> 1. Can the web server reside on another machine?
> 2. Which server needs to be configured?
> 3. Why would I receive the error that I am getting?
> Thank you for any assistance that you can provide.
> Jason
>
|||Thanks Graeme, what do you mean about configuring
authentication? Are you referring to a user's ability to
access the templates? That was going to be my next
question!
Say I have these templates in my virtual directory that
can be called via HTTP. Anyone can get at them. Is
there a way to pass user credentials to the template in
order to authenticate the user who is trying to access
the template?
Jason
>--Original Message--
>Yes, the Web Server can be separate from the SQL Server.
It's the Web server
>you need to configure with the IIS Virtual Directory
Management tool, but it
>will need to have SQLXML installed. You'll also need to
think carefully
>about how you configure authentication in your SQLISAPI
Virtual Directory.
>As for the error, at face-value it looks like a
networking issue - I assume
>you've tried the usual troubleshooting approaches (i.e.
pinging the server
>by name or by IP address)?
>--
>Graeme Malcolm
>Principal Technologist
>Content Master Ltd.
>"Jason" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:19bc001c42247$c41fd760$a601280a@.phx.gbl...
templates[vbcol=seagreen]
are[vbcol=seagreen]
unavailable."
>
>.
>
|||There are two things that require authentication here.
1. The virtual directory (and the physical template file). You'll need to
decide if your going to allow anonymous access to the virtual directory, in
which case the IUSR_computername accunt will need NTFS file permissions on
the virtual directory folder and the folder containing the templates (if
different), or whether you'll use Windows authentication (in which case the
user's domain account needs the appropriate NTFS permissions. This is just
like any other IIS Web site, and you can use the standard IIS admin tool to
configure site authentication.
2. SQL Server. You've got 4 choices here: (a) Have IIS connect to SQL Server
on the user's behalf, using Windows authentication (select "Always log on
as" and specify the Windows credentials in the virtual directory properties
Security tab - by default it will use the IUSR_computername account and
allow you to automatically synchronize the password. Alternatively, you can
specify any Windows account that you want to and specify the password), (b)
Have IIS connect to SQL Server on the user's behalf, using SQL Server
authentication (select "Always log on as" and specify the SQL Server login
credentials in the virtual directory properties Security tab - you might
also need to enable SQL Server authentication on the SQL Server since by
default it only uses Windows authentication), (c) Have IIS impersonate the
user's Windows credentials when accessing SQL Server (Select "Use Windows
Integrated Authentication" in the virtual directory properties Security
tab), or (d) Have IIS prompt for the user's SQL Server credentials and pass
them to SQL Server using clear text (Select "Use Basic Authentication (Clear
Text) to SQL Server account" in the virtual directory properties Security
tab).
In more general terms (a) and (b) are a form of the "Trusted Server" model
(in which the Web Server application is trusted to use its own credentials
to access the database on the user's behalf), while (c) and (d) are forms of
the "Impersonation/Delegation" model, in which the Web Server accesses the
database using the user's credentials.
In most cases, I'd tend to recommend (a), because it will allow IIS to use
connection pooling (and therefore make the application more scalable).
However, it does mean that everyone who accesses the database through the
Web site uses the same login to SQL Server. If your application is on an
Intranet and you need to force users to use their own account when accessing
SQl Server, then I'd go for (c), in which case Internet Explorer will
automatically send their domain credentials (assuming they're logged into a
domain) or prompt them for their Windows login. The main thing is that the
credentials are encrypted on the network. If you were to use (d) you'd have
to configure the virtual directory to use SSL in order to pass the login
details securely.
Hope that helps,
Graeme
Graeme Malcolm
Principal Technologist
Content Master Ltd.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:1d43801c422ec$75616580$a101280a@.phx.gbl...[vbcol=seagreen]
> Thanks Graeme, what do you mean about configuring
> authentication? Are you referring to a user's ability to
> access the templates? That was going to be my next
> question!
> Say I have these templates in my virtual directory that
> can be called via HTTP. Anyone can get at them. Is
> there a way to pass user credentials to the template in
> order to authenticate the user who is trying to access
> the template?
> Jason
>
> It's the Web server
> Management tool, but it
> think carefully
> Virtual Directory.
> networking issue - I assume
> pinging the server
> message
> templates
> are
> unavailable."
Sunday, 12 February 2012
configuring a database in sqlserver?
I am learning dotnet thru Microsoft Official Curriculum and I got stuck up at one point. That is I couldn't configure the required databases according to the sql server I have installed and configured. I created a doctors database and while configuring using the below code I couldn't know what is '\ASPNET' in "SELECT @.s = @.@.servername + '\ASPNET'"
Also what is 'webuser'
Configure Doctors
USE doctors
GO
DECLARE @.s varchar(50)
SELECT @.s = @.@.servername + '\ASPNET'
EXECUTE sp_grantlogin @.s
EXECUTE sp_grantdbaccess @.s, 'webuser'
GO
GRANT EXECUTE ON [getUniqueCities] TO webuser
GRANT EXECUTE ON [getDrSpecialty] TO webuser
GRANT SELECT ON [specialties] TO webuser
GRANT SELECT ON [doctors] TO webuser
GRANT SELECT ON [drspecialties] TO webuser
GO
Can anyone help me how to solve my problem?
Your help would be very much appreciated
Thanks and Regards
Kavitha
Probably best to consult the TSQL forum.
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=85&SiteID=1
Friday, 10 February 2012
Configure SQL XML Support...
We have a Windows 2003 Server with SQL Server and IIS. I tried to use the SQ
L
Server Configure SQL XML Support on IIS and can not get it to work.
On my local machine, Windows 2000 Profression, SQL Server 200 and IIS, I
have no problem..
Are there any articles that can help me with setting up this option on
Windows 2003 Server?
I have deleted the one I created. This one was returning Permission denied.
Newer ones report Page Not Found.
I can now not created a new one with the same name as the first one that I
deleted.
Thanks,
ThomasLLHi
These may help:
http://support.microsoft.com/defaul...kb;en-us;820728
http://msdn.microsoft.com/library/d...9
m4.asp
http://sqlxml.org/faqs.aspx?faq=79
John
"Thomas.LeBlanc@.NoSpam.Com"
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
news:F67A6FAD-A1B9-4120-9E2F-C72DDD458CEA@.microsoft.com...
> We have a Windows 2003 Server with SQL Server and IIS. I tried to use the
> SQL
> Server Configure SQL XML Support on IIS and can not get it to work.
> On my local machine, Windows 2000 Profression, SQL Server 200 and IIS, I
> have no problem..
> Are there any articles that can help me with setting up this option on
> Windows 2003 Server?
> I have deleted the one I created. This one was returning Permission
> denied.
> Newer ones report Page Not Found.
> I can now not created a new one with the same name as the first one that I
> deleted.
> --
> Thanks,
> ThomasLL
>|||I am getting a "You are not authrized to view this page" error.
I have set this up on my client machine (Windows 200 Profressional/IIS/SQL
Server 200) and it works. No changes needed.
But on the Windows 2003 Server/IIS/SQL Server 200) I get this error above
"John Bell" wrote:
> Hi
> These may help:
> http://support.microsoft.com/defaul...kb;en-us;820728
> http://msdn.microsoft.com/library/d...br />
59m4.asp
> http://sqlxml.org/faqs.aspx?faq=79
> John
> "Thomas.LeBlanc@.NoSpam.Com"
> <ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
> news:F67A6FAD-A1B9-4120-9E2F-C72DDD458CEA@.microsoft.com...
>
>|||Hi
Windows 2003 has a tighter security model and this may be causing a
problem, so make sure that the permissions are correct in IIS and on for
the location.
Also read:
http://support.microsoft.com/defaul...10784&Product=s
ql2k
http://groups-beta.google.com/group...erver.xml/brows
e_thread/thread/e2f12e4e84dea10b/8da2b87b1e0112b2#8da2b87b1e0112b2
John
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!
L
Server Configure SQL XML Support on IIS and can not get it to work.
On my local machine, Windows 2000 Profression, SQL Server 200 and IIS, I
have no problem..
Are there any articles that can help me with setting up this option on
Windows 2003 Server?
I have deleted the one I created. This one was returning Permission denied.
Newer ones report Page Not Found.
I can now not created a new one with the same name as the first one that I
deleted.
Thanks,
ThomasLLHi
These may help:
http://support.microsoft.com/defaul...kb;en-us;820728
http://msdn.microsoft.com/library/d...9
m4.asp
http://sqlxml.org/faqs.aspx?faq=79
John
"Thomas.LeBlanc@.NoSpam.Com"
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
news:F67A6FAD-A1B9-4120-9E2F-C72DDD458CEA@.microsoft.com...
> We have a Windows 2003 Server with SQL Server and IIS. I tried to use the
> SQL
> Server Configure SQL XML Support on IIS and can not get it to work.
> On my local machine, Windows 2000 Profression, SQL Server 200 and IIS, I
> have no problem..
> Are there any articles that can help me with setting up this option on
> Windows 2003 Server?
> I have deleted the one I created. This one was returning Permission
> denied.
> Newer ones report Page Not Found.
> I can now not created a new one with the same name as the first one that I
> deleted.
> --
> Thanks,
> ThomasLL
>|||I am getting a "You are not authrized to view this page" error.
I have set this up on my client machine (Windows 200 Profressional/IIS/SQL
Server 200) and it works. No changes needed.
But on the Windows 2003 Server/IIS/SQL Server 200) I get this error above
"John Bell" wrote:
> Hi
> These may help:
> http://support.microsoft.com/defaul...kb;en-us;820728
> http://msdn.microsoft.com/library/d...br />
59m4.asp
> http://sqlxml.org/faqs.aspx?faq=79
> John
> "Thomas.LeBlanc@.NoSpam.Com"
> <ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
> news:F67A6FAD-A1B9-4120-9E2F-C72DDD458CEA@.microsoft.com...
>
>|||Hi
Windows 2003 has a tighter security model and this may be causing a
problem, so make sure that the permissions are correct in IIS and on for
the location.
Also read:
http://support.microsoft.com/defaul...10784&Product=s
ql2k
http://groups-beta.google.com/group...erver.xml/brows
e_thread/thread/e2f12e4e84dea10b/8da2b87b1e0112b2#8da2b87b1e0112b2
John
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!
Subscribe to:
Posts (Atom)