Image rendering with IIS Virtual Directory

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.
> >

Image Not Displaying; SRC=""

I have a report server: DEV05
I have a web/data server: DEV14. It also has a SQL Server Database for
data to be displayed.
I have my pc: DEV01
IIS on the Report Server:
Reports ? anonymous is disabled
ReportServer ? anonymous is disabled
On the web server I have a virtual directory that houses images. From
a browser, on my machine I can see the image using:
http://dev14/images/sketcha.jpg. I can also see the image from the
report server using the same url.
When I'm designing a report in VS.NET on my machine and issue a new
image control and select ?web' as the source,
(http://dev14/images/sketcha.jpg.) the image is resolved.
However, when I deploy the report to the report server DEV05, and view
the report through report manager, the image (located on the web
server) is not displayed, a red X is displayed. The report data is
displayed though, which is stored in a SQL server on the same server
(DEV14).
The report uses a shared data Source. The data source uses stored
credentials to connect to the database on DEV14. The credentials are
SQL Logins, not NT.
Anyone have any suggestions on what permissions I need to change or
set so I can get the images to display?
All help and suggestions are greatly appreciated.
Thanks
Rwiethorn
rwiethorn@.remove-nospam-belcan.comRwiethorn,
How is dev14/images vroot configured?
Please note that when images are fetched by URL, a special unattended
execution Windows account is used.
From SP1 readme file:
"When the report is previewed in Report Designer, preview uses the
credentials of the user to display the image. When the report is run on the
report server, the report server uses the unattended execution account to
retrieve the image. If the unattended execution account is not specified,
the image is retrieved using no credentials (anonymous user account). If
either of these accounts have insufficient rights to access the image, the
image will not be displayed in the report. For more information about
setting the unattended execution account on the report server, see
"Configuring an Account for Unattended Report Processing" in Reporting
Services Books Online."
For more information check this thread: http://tinyurl.com/42738
Ii addition, check the "Configuring an Account for Unattended Report
Processing" topic in BOL.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com : http://tinyurl.com/3l49j
Home page and blog: http://www.prologika.com/
----
"rwiethorn" <rwiethorn2002@.yahoo.com> wrote in message
news:553a0349.0408260649.70d95c7c@.posting.google.com...
> I have a report server: DEV05
> I have a web/data server: DEV14. It also has a SQL Server Database for
> data to be displayed.
> I have my pc: DEV01
> IIS on the Report Server:
> Reports - anonymous is disabled
> ReportServer - anonymous is disabled
>
> On the web server I have a virtual directory that houses images. From
> a browser, on my machine I can see the image using:
> http://dev14/images/sketcha.jpg. I can also see the image from the
> report server using the same url.
> When I'm designing a report in VS.NET on my machine and issue a new
> image control and select 'web' as the source,
> (http://dev14/images/sketcha.jpg.) the image is resolved.
> However, when I deploy the report to the report server DEV05, and view
> the report through report manager, the image (located on the web
> server) is not displayed, a red X is displayed. The report data is
> displayed though, which is stored in a SQL server on the same server
> (DEV14).
> The report uses a shared data Source. The data source uses stored
> credentials to connect to the database on DEV14. The credentials are
> SQL Logins, not NT.
> Anyone have any suggestions on what permissions I need to change or
> set so I can get the images to display?
> All help and suggestions are greatly appreciated.
> Thanks
> Rwiethorn
> rwiethorn@.remove-nospam-belcan.com

IIS5 & SQL Server 2000

First off, I'm not sure whether this is an IIS or SQL question so forgive me
if I'm posting off topic.
I am in the process of moving a number of webs from a single box running NT4
(sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
with SQL Server 2000 on one and IIS 5 on the other. The webs are asp based.
The connection strings are configured to use SQLOLEDB with the server name
appearing somewhere in the string.
The problem is that when you try to connect the web to SQL Server it
generates an "SQL Server Does Not Exist or Access Denied" error message (as
per kb328306). I have gone through all of the options in this article and
am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
fully functional. However when I change the server name to the server IP
address in the connection string, it works.
Oh, while I remember, both servers have valid dns entries so it shouldn't be
a cased of unresolved names.
The question then is, is this something to do with differences in the way
IIS 5 works as against IIS 4.
Long life and prosperity to anyone who can help me out with this - my head
hurts and the wall is about to collapse...
TIA
NigelUse Query Analyzer and select @.@.servername.
If this name is DIFFERENT than the Windows name of that server, you have
identified the problem... This occurs whenever a server is renamed, and when
master is moved from one server to another...
If that is the case
sp_dropserver oldservername
sp_addserver newservername, local
Otherwise I would still suspect it is a DNS problem .
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> First off, I'm not sure whether this is an IIS or SQL question so forgive
me
> if I'm posting off topic.
> I am in the process of moving a number of webs from a single box running
NT4
> (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
> with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
based.
> The connection strings are configured to use SQLOLEDB with the server name
> appearing somewhere in the string.
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message
(as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
> Oh, while I remember, both servers have valid dns entries so it shouldn't
be
> a cased of unresolved names.
> The question then is, is this something to do with differences in the way
> IIS 5 works as against IIS 4.
> Long life and prosperity to anyone who can help me out with this - my
head
> hurts and the wall is about to collapse...
> TIA
> Nigel
>|||Thanks for the reply Wayne
The server is a new build and the Windows name & SQL name are identical.
Cheers
Nigel
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:utU7XrZPEHA.1312@.TK2MSFTNGP12.phx.gbl...
> Use Query Analyzer and select @.@.servername.
> If this name is DIFFERENT than the Windows name of that server, you have
> identified the problem... This occurs whenever a server is renamed, and
when
> master is moved from one server to another...
> If that is the case
> sp_dropserver oldservername
> sp_addserver newservername, local
> Otherwise I would still suspect it is a DNS problem .
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
> news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
forgive[vbcol=seagreen]
> me
> NT4
(sp4),[vbcol=seagreen]
> based.
name[vbcol=seagreen]
> (as
and[vbcol=seagreen]
are[vbcol=seagreen]
IP[vbcol=seagreen]
shouldn't[vbcol=seagreen]
> be
way[vbcol=seagreen]
> head
>|||If you can use the ip address to connect but not the server name, then it
is a name resolution problem of some kind.
If you go to a command prompt on the IIS machine and issue the following
command:
ping -a <ip address of SQL Server machine>
does it return the proper machine name. If not then the problem is name
resolution.
Is this a default instance or is it a named instance. If it is the latter
are you specifying the full name <machine\instnce>.
Use the cliconfg utility on the IIS machien to make sure there is no alias
pointing incorrectly to the SQL Server machine.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Ping <ServerName> returns correct IP
Ping -a <IP> returns correct Servername
This is a default instance of SQL Server, & no aliases have been set.
Nigel
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:jHi8wXaPEHA.3080@.cpmsftngxa10.phx.gbl...
> If you can use the ip address to connect but not the server name, then it
> is a name resolution problem of some kind.
> If you go to a command prompt on the IIS machine and issue the following
> command:
> ping -a <ip address of SQL Server machine>
> does it return the proper machine name. If not then the problem is name
> resolution.
> Is this a default instance or is it a named instance. If it is the latter
> are you specifying the full name <machine\instnce>.
> Use the cliconfg utility on the IIS machien to make sure there is no alias
> pointing incorrectly to the SQL Server machine.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>|||"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message news:<#326oeYPEHA.556
@.tk2msftngp13.phx.gbl>...
<snip>

> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message (a
s
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
This sounds very similar to the problem I have been experiencing
recently. (See msg ID
<Xns94E76C28F7CF6canimalmydejacom@.207.46.248.16> ).
When I got those errors, the security log on the SQL server showed
hundreds of failed logins for WORKSTATION/aspnet. You might see if
you have the same thing. I am wondering if using a name rather than
an IP address is forcing a named pipes connection (overriding even
Net=dbmssocn). Just a wild guess, haven't tried to explore that.
This problem includes apps that worked fine until recently. I have
also had similar problems connecting by server name with WinForms .NET
apps.
Regrettably, I do not have a solution, other than using IP instead of
name.
Since the problem appeared out of the blue, I am guessing that running
one of the recent security updates is the cause. With luck, MS will
recognize this as an issue and correct it. I would be happy to post
more info if someone from MS has questions. (Note that the email
address above is broken, I'll only see newsgroup postings.)
Matt

IIS5 & SQL Server 2000

First off, I'm not sure whether this is an IIS or SQL question so forgive me
if I'm posting off topic.
I am in the process of moving a number of webs from a single box running NT4
(sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
with SQL Server 2000 on one and IIS 5 on the other. The webs are asp based.
The connection strings are configured to use SQLOLEDB with the server name
appearing somewhere in the string.
The problem is that when you try to connect the web to SQL Server it
generates an "SQL Server Does Not Exist or Access Denied" error message (as
per kb328306). I have gone through all of the options in this article and
am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
fully functional. However when I change the server name to the server IP
address in the connection string, it works.
Oh, while I remember, both servers have valid dns entries so it shouldn't be
a cased of unresolved names.
The question then is, is this something to do with differences in the way
IIS 5 works as against IIS 4.
Long life and prosperity to anyone who can help me out with this - my head
hurts and the wall is about to collapse...
TIA
NigelUse Query Analyzer and select @.@.servername.
If this name is DIFFERENT than the Windows name of that server, you have
identified the problem... This occurs whenever a server is renamed, and when
master is moved from one server to another...
If that is the case
sp_dropserver oldservername
sp_addserver newservername, local
Otherwise I would still suspect it is a DNS problem .
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> First off, I'm not sure whether this is an IIS or SQL question so forgive
me
> if I'm posting off topic.
> I am in the process of moving a number of webs from a single box running
NT4
> (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
> with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
based.
> The connection strings are configured to use SQLOLEDB with the server name
> appearing somewhere in the string.
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message
(as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
> Oh, while I remember, both servers have valid dns entries so it shouldn't
be
> a cased of unresolved names.
> The question then is, is this something to do with differences in the way
> IIS 5 works as against IIS 4.
> Long life and prosperity to anyone who can help me out with this - my
head
> hurts and the wall is about to collapse...
> TIA
> Nigel
>|||Thanks for the reply Wayne
The server is a new build and the Windows name & SQL name are identical.
Cheers
Nigel
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:utU7XrZPEHA.1312@.TK2MSFTNGP12.phx.gbl...
> Use Query Analyzer and select @.@.servername.
> If this name is DIFFERENT than the Windows name of that server, you have
> identified the problem... This occurs whenever a server is renamed, and
when
> master is moved from one server to another...
> If that is the case
> sp_dropserver oldservername
> sp_addserver newservername, local
> Otherwise I would still suspect it is a DNS problem .
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
> news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> > First off, I'm not sure whether this is an IIS or SQL question so
forgive
> me
> > if I'm posting off topic.
> >
> > I am in the process of moving a number of webs from a single box running
> NT4
> > (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server
(sp4),
> > with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
> based.
> > The connection strings are configured to use SQLOLEDB with the server
name
> > appearing somewhere in the string.
> >
> > The problem is that when you try to connect the web to SQL Server it
> > generates an "SQL Server Does Not Exist or Access Denied" error message
> (as
> > per kb328306). I have gone through all of the options in this article
and
> > am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc)
are
> > fully functional. However when I change the server name to the server
IP
> > address in the connection string, it works.
> >
> > Oh, while I remember, both servers have valid dns entries so it
shouldn't
> be
> > a cased of unresolved names.
> >
> > The question then is, is this something to do with differences in the
way
> > IIS 5 works as against IIS 4.
> >
> > Long life and prosperity to anyone who can help me out with this - my
> head
> > hurts and the wall is about to collapse...
> >
> > TIA
> >
> > Nigel
> >
> >
>|||If you can use the ip address to connect but not the server name, then it
is a name resolution problem of some kind.
If you go to a command prompt on the IIS machine and issue the following
command:
ping -a <ip address of SQL Server machine>
does it return the proper machine name. If not then the problem is name
resolution.
Is this a default instance or is it a named instance. If it is the latter
are you specifying the full name <machine\instnce>.
Use the cliconfg utility on the IIS machien to make sure there is no alias
pointing incorrectly to the SQL Server machine.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Ping <ServerName> returns correct IP
Ping -a <IP> returns correct Servername
This is a default instance of SQL Server, & no aliases have been set.
Nigel
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:jHi8wXaPEHA.3080@.cpmsftngxa10.phx.gbl...
> If you can use the ip address to connect but not the server name, then it
> is a name resolution problem of some kind.
> If you go to a command prompt on the IIS machine and issue the following
> command:
> ping -a <ip address of SQL Server machine>
> does it return the proper machine name. If not then the problem is name
> resolution.
> Is this a default instance or is it a named instance. If it is the latter
> are you specifying the full name <machine\instnce>.
> Use the cliconfg utility on the IIS machien to make sure there is no alias
> pointing incorrectly to the SQL Server machine.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>|||"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message news:<#326oeYPEHA.556@.tk2msftngp13.phx.gbl>...
<snip>
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message (as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
This sounds very similar to the problem I have been experiencing
recently. (See msg ID
<Xns94E76C28F7CF6canimalmydejacom@.207.46.248.16>).
When I got those errors, the security log on the SQL server showed
hundreds of failed logins for WORKSTATION/aspnet. You might see if
you have the same thing. I am wondering if using a name rather than
an IP address is forcing a named pipes connection (overriding even
Net=dbmssocn). Just a wild guess, haven't tried to explore that.
This problem includes apps that worked fine until recently. I have
also had similar problems connecting by server name with WinForms .NET
apps.
Regrettably, I do not have a solution, other than using IP instead of
name.
Since the problem appeared out of the blue, I am guessing that running
one of the recent security updates is the cause. With luck, MS will
recognize this as an issue and correct it. I would be happy to post
more info if someone from MS has questions. (Note that the email
address above is broken, I'll only see newsgroup postings.)
Matt

IIS5 & SQL Server 2000

First off, I'm not sure whether this is an IIS or SQL question so forgive me
if I'm posting off topic.
I am in the process of moving a number of webs from a single box running NT4
(sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
with SQL Server 2000 on one and IIS 5 on the other. The webs are asp based.
The connection strings are configured to use SQLOLEDB with the server name
appearing somewhere in the string.
The problem is that when you try to connect the web to SQL Server it
generates an "SQL Server Does Not Exist or Access Denied" error message (as
per kb328306). I have gone through all of the options in this article and
am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
fully functional. However when I change the server name to the server IP
address in the connection string, it works.
Oh, while I remember, both servers have valid dns entries so it shouldn't be
a cased of unresolved names.
The question then is, is this something to do with differences in the way
IIS 5 works as against IIS 4.
Long life and prosperity to anyone who can help me out with this - my head
hurts and the wall is about to collapse...
TIA
Nigel
Use Query Analyzer and select @.@.servername.
If this name is DIFFERENT than the Windows name of that server, you have
identified the problem... This occurs whenever a server is renamed, and when
master is moved from one server to another...
If that is the case
sp_dropserver oldservername
sp_addserver newservername, local
Otherwise I would still suspect it is a DNS problem .
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
> First off, I'm not sure whether this is an IIS or SQL question so forgive
me
> if I'm posting off topic.
> I am in the process of moving a number of webs from a single box running
NT4
> (sp6a), IIS 4 & SQL Server 7 to separate boxes running Win2k Server (sp4),
> with SQL Server 2000 on one and IIS 5 on the other. The webs are asp
based.
> The connection strings are configured to use SQLOLEDB with the server name
> appearing somewhere in the string.
> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message
(as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
> Oh, while I remember, both servers have valid dns entries so it shouldn't
be
> a cased of unresolved names.
> The question then is, is this something to do with differences in the way
> IIS 5 works as against IIS 4.
> Long life and prosperity to anyone who can help me out with this - my
head
> hurts and the wall is about to collapse...
> TIA
> Nigel
>
|||Thanks for the reply Wayne
The server is a new build and the Windows name & SQL name are identical.
Cheers
Nigel
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:utU7XrZPEHA.1312@.TK2MSFTNGP12.phx.gbl...
> Use Query Analyzer and select @.@.servername.
> If this name is DIFFERENT than the Windows name of that server, you have
> identified the problem... This occurs whenever a server is renamed, and
when[vbcol=seagreen]
> master is moved from one server to another...
> If that is the case
> sp_dropserver oldservername
> sp_addserver newservername, local
> Otherwise I would still suspect it is a DNS problem .
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message
> news:%23326oeYPEHA.556@.tk2msftngp13.phx.gbl...
forgive[vbcol=seagreen]
> me
> NT4
(sp4),[vbcol=seagreen]
> based.
name[vbcol=seagreen]
> (as
and[vbcol=seagreen]
are[vbcol=seagreen]
IP[vbcol=seagreen]
shouldn't[vbcol=seagreen]
> be
way
> head
>
|||If you can use the ip address to connect but not the server name, then it
is a name resolution problem of some kind.
If you go to a command prompt on the IIS machine and issue the following
command:
ping -a <ip address of SQL Server machine>
does it return the proper machine name. If not then the problem is name
resolution.
Is this a default instance or is it a named instance. If it is the latter
are you specifying the full name <machine\instnce>.
Use the cliconfg utility on the IIS machien to make sure there is no alias
pointing incorrectly to the SQL Server machine.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Ping <ServerName> returns correct IP
Ping -a <IP> returns correct Servername
This is a default instance of SQL Server, & no aliases have been set.
Nigel
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:jHi8wXaPEHA.3080@.cpmsftngxa10.phx.gbl...
> If you can use the ip address to connect but not the server name, then it
> is a name resolution problem of some kind.
> If you go to a command prompt on the IIS machine and issue the following
> command:
> ping -a <ip address of SQL Server machine>
> does it return the proper machine name. If not then the problem is name
> resolution.
> Is this a default instance or is it a named instance. If it is the latter
> are you specifying the full name <machine\instnce>.
> Use the cliconfg utility on the IIS machien to make sure there is no alias
> pointing incorrectly to the SQL Server machine.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||"Nigel Q" <nigel.quiggin@.rnib.org.uk> wrote in message news:<#326oeYPEHA.556@.tk2msftngp13.phx.gbl>...
<snip>

> The problem is that when you try to connect the web to SQL Server it
> generates an "SQL Server Does Not Exist or Access Denied" error message (as
> per kb328306). I have gone through all of the options in this article and
> am certain that all the SQL protocols in use (TCP/IP, Named Pipes etc) are
> fully functional. However when I change the server name to the server IP
> address in the connection string, it works.
This sounds very similar to the problem I have been experiencing
recently. (See msg ID
<Xns94E76C28F7CF6canimalmydejacom@.207.46.248.16>).
When I got those errors, the security log on the SQL server showed
hundreds of failed logins for WORKSTATION/aspnet. You might see if
you have the same thing. I am wondering if using a name rather than
an IP address is forcing a named pipes connection (overriding even
Net=dbmssocn). Just a wild guess, haven't tried to explore that.
This problem includes apps that worked fine until recently. I have
also had similar problems connecting by server name with WinForms .NET
apps.
Regrettably, I do not have a solution, other than using IP instead of
name.
Since the problem appeared out of the blue, I am guessing that running
one of the recent security updates is the cause. With luck, MS will
recognize this as an issue and correct it. I would be happy to post
more info if someone from MS has questions. (Note that the email
address above is broken, I'll only see newsgroup postings.)
Matt

IIS/MSSQL

I have an SQL 2000 server set up that runs perfectly, and an IIS set up that runs perfectly but I
can not get the webpage to read data from the dbase. Is there a connection that I have to make or a
program I have to load? The page is a .asp page, and when I run the page that should connect
I do not get any errors in the dbase at all, so I can only imagine that it is not even seeing an attempt
at a connection. Any help is appreciated.This page shows how to add a connection to an aspx page, and display the information:
http://aspnet101.com/aspnet101/aspnet/codesample.aspx?code=simple
There's also a link to a tutorial which explains how it to do it.

IIS/MS SQL/ASP... cant connect

I have an ASP script with the following code in the global.asa:

Application("DBConnectString")="DSN=Test_Server;UID=Michael;PWD=xxxx"

But I get the error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/TheResort/i_asputils.asp, line 8

Problem:

I setup the ODBC portion and it correctly saw the MS SQL server, and the test connection worked fine. Yet when I ever I enter that ODBC name "Test_Server", and the password of the Win XP Pro user I am signed in as, it fails to connect.

How can I be sure what domain,user,password I need to enter?Ttry using "DSN=asset;UID=;PWD=" and don't forget to insert the user id and password.

Also, when you set up the odbc "system" dsn, remember to click on the test connection button to verify the connection.

http://www.google.com/url?sa=U&start=9&q=http://support.microsoft.com/support/kb/articles/Q169/3/77.asp&e=7415 information.

IIS Virtual Server for SQLServer ... not authorised to view

I'm sorry if this q has already been answered, however after looking through
the posts I cannot find a resolution.
I have a W2K Pro Machine installed with IIS and SQLServer 2K (let's call
this Dev1)
I have a XP Pro Machine installed with IIS and SQLServer 2K (let's call this
Dev2)
Dev1 is used for day to day development. I have several SQL scripts to set
up a database, whereby I create a databse, 2 (two) SQL user accounts, some
Views, several stored procedures, and populate with some initial data. -No
problems so far.
I use the "Configure SQL XML Support in IIS" menu option and I do just that,
i.e. I set up a VDir with a sub directory for my templates (xml files) which
contain stuff for calling the stored procedures formatting the returned data
etc. I configure the VDir security method to use one of the SQL user accounts
that I have created in my SQL script. Using my IE browser, I navigate to the
templates dir and retrieve the data as expected.-No problems so far.
Now, I want to take this stuff and show to a client, so I want to install it
on my laptop (Dev2). I follow the exact same routine as for Dev1, however
when I come to view the data in my browser, I get
HTTP 401.1 Unauthorized: Logon Failed
I cannot for the life of me figure out the difference. As far as I can tell,
everything is the same except for Dev2 has XP Pro and Dev1 has 2K Pro.
Can somebody please help me out with this ... and tell me what other info
you need to know.
Thanks in advance.
Hmmm...You have ensured that Dev2 allows Sql Logins and not just windows,
correct? And that the account is properly set up with permission on the
right database, tables, etc?
Thanks,
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"billr" <billr@.discussions.microsoft.com> wrote in message
news:B784272C-D070-4C8A-89F4-4CB64072D710@.microsoft.com...
> I'm sorry if this q has already been answered, however after looking
> through
> the posts I cannot find a resolution.
> I have a W2K Pro Machine installed with IIS and SQLServer 2K (let's call
> this Dev1)
> I have a XP Pro Machine installed with IIS and SQLServer 2K (let's call
> this
> Dev2)
> Dev1 is used for day to day development. I have several SQL scripts to set
> up a database, whereby I create a databse, 2 (two) SQL user accounts, some
> Views, several stored procedures, and populate with some initial data. -No
> problems so far.
> I use the "Configure SQL XML Support in IIS" menu option and I do just
> that,
> i.e. I set up a VDir with a sub directory for my templates (xml files)
> which
> contain stuff for calling the stored procedures formatting the returned
> data
> etc. I configure the VDir security method to use one of the SQL user
> accounts
> that I have created in my SQL script. Using my IE browser, I navigate to
> the
> templates dir and retrieve the data as expected.-No problems so far.
> Now, I want to take this stuff and show to a client, so I want to install
> it
> on my laptop (Dev2). I follow the exact same routine as for Dev1, however
> when I come to view the data in my browser, I get
> HTTP 401.1 Unauthorized: Logon Failed
> I cannot for the life of me figure out the difference. As far as I can
> tell,
> everything is the same except for Dev2 has XP Pro and Dev1 has 2K Pro.
> Can somebody please help me out with this ... and tell me what other info
> you need to know.
> Thanks in advance.
>
|||Yes, I have,
I use exactly the same sql script to create the user accounts and the
database,
SQLaccount1 owns all stored procedures, views and tables
SQLaccoutn2 is granted executable permissions on the relevant stored procs
When I create the vdir I select to use SQL Server login details, and I enter
the details for SQLaccount2. Then I can select the database from the list in
the IIS configuration tool so I know it is not a problem with SQL
authentication.
If I inspect the virtual dir using the IIS snapin, on both machines the
details are exactly the same ... I select the DirectorySecurity tab and
select the Anonymous access and authentication button, and in the dialog that
pops up I can see that Anonymous access is enabled, the username text box is
empty and the option to Allow IIS to control passwword is selected.
"Irwin Dolobowsky [MS]" wrote:

> Hmmm...You have ensured that Dev2 allows Sql Logins and not just windows,
> correct? And that the account is properly set up with permission on the
> right database, tables, etc?
> --
> Thanks,
> Irwin
> Irwin Dolobowsky
> Program Manager, SqlXml
> http://blogs.msdn.com/irwando
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "billr" <billr@.discussions.microsoft.com> wrote in message
> news:B784272C-D070-4C8A-89F4-4CB64072D710@.microsoft.com...
>
>

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
>

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

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"

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"

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]

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

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

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

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.

IIS version

How can I find out what version is my IIS Server (Windows 2000)?
Can I upgrade this version ?if you open IIS from the Administrative tools, you can see the version of your IIS in the help --> About Internet Information Services. For Windows 2000 this is standard version 5. Not sure if you can upgrade to a newer version.|||Originally posted by jora
if you open IIS from the Administrative tools, you can see the version of your IIS in the help --> About Internet Information Services. For Windows 2000 this is standard version 5. Not sure if you can upgrade to a newer version.

This might seem silly, but I don't think I have a 'About Internet Information Services' section in the help app of IIS. My computer is win2k so I assume I have v. 5.0, but I have Visual Studio 2003 (and hence .NET Framework 1.1) so it might be v. 6.0.

It says something about documentation being available at http://localhost/iisHelp/ but I just get a 'Page cannot be Found' error.

Any suggestions?

MNJ

IIS v6.0

Where can I download this IIS v6.0.

IIS 6.0 is not downloadable. It's part of Windows 2003 and you just need to install it. See here for install steps:

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/fb42a5d5-8ade-4dda-8bbd-f63e38e602b9.mspx?mfr=true

|||thanks Mike!|||

how to install iis v6.0 in windows xp professional?

well, it works with windows server 2003 very well.

Thanks,

Jwalant Natvarlal Soneji

|||You can't. IIS 6.0 only works on Windows 2003 Server.|||

Dear friends, got the point, the iis 6.0 works with windows server 2003, iis 5.1 works with windows xp and iis 7 .... works with windows vista.

but one can download and install iis 6.0 manager to manage the sites hosted on an iis 6.0 from windows xp.

thanks,

|||

Try

http://www.microsoft.com/downloads/details.aspx?FamilyID=f9c1fb79-c903-4842-9f6c-9db93643fdb7&DisplayLang=en

IIS Synchronizing Data Error

hi..need help here,
I sometime get error when syncronizing data at New Subscription Wizard, and sometime I dont.but right now i cant sync, this is me error messages :
"Synchronizing Data (Error)
Messages
A request to send data to the computer running IIS has failed. For more information, see HRESULT.
HRESULT 0x80070002 (28037)
The operation could not be completed."

I've turn off the firewall, turn off the antivirus, plug the LAN cable but still error (Maybe it has to do with it).A long time a go I've had this error, and then I decided to reinstall SQL Server and try it again and it work, now it back to me again, do I have to reinstalled it again(hopefully it solved my problem)?or any otherway?

And want to ask about SQL Mobile, When I choose the Merge, the uniqueidentifier will be add at my table right?what should I do at inserting query process, I cant just insert it with NULL value right?
After my subscription doing input data, is it my publications will be automatic updated?
I'm little lost here..need advise

Its a miracle.. "_" now I can sync it without any changes on my computer, I give one more shot try to sync after I write this thread and then it works!!

but still curious why sometime I can, sometime I cant?

and still know about uniqueidentifier, please..