Access Denied

I have a web application in one server and reporting service in another
server. This web application is to list out report items. When I call web
application in any client machine, error is always shown - 'The request
failed with HTTP status 401: Access Denied'. But if I install the reporting
service and web application in same server, there is no problem. Can anyone
help me ?Open the RSWebApplication.config file with a text editor. The first few
lines of the file will be similar to the following:
<Configuration>
<UI>
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
</UI>
Replace the text between <ReportServerUrl> and </ReportServerUrl> with the
complete address that should be used to access the Reports website like,
<Configuration>
<UI>
<ReportServerUrl>http://www.xyzname.com/ReportServer</ReportServerUrl>
</UI>
or with IP address
<Configuration>
<UI>
<ReportServerUrl>http://192.162.x.y/ReportServer</ReportServerUrl>
</UI>
Hope this helps,
Barbaros Saglamtimur
MCDBA, MCAD
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:CF1F5CDB-596B-4015-8FE4-8D9B7D85D803@.microsoft.com...
>I have a web application in one server and reporting service in another
> server. This web application is to list out report items. When I call
> web
> application in any client machine, error is always shown - 'The request
> failed with HTTP status 401: Access Denied'. But if I install the
> reporting
> service and web application in same server, there is no problem. Can
> anyone
> help me ?

Access DB vs. SQL server

Hi, I'm developing a web application that could have up to about 700 people connected to it at the same time. I love MS Access so I would love to be able to use an access database here, but I'm concerned that it won't be able to handle all the users. Should I just create an SQL server database for this application or am I worrying for nothing here? I'll be using Visual studio .NET 2003 to create this app.
ThanksPersonally, unless the application makes very light use of the database, Access will get crushed by 700 simultaneous users, even Web users.|||Thanks. Given that I'm only comfortable with Access right now, do you think SQL server is the way to go for me?|||I personally like SQL Server. The terminology and tools are different, even though they are both from Microsoft, but SQL Server is about the easiest to use full server based database system I have used. You can attach to the SQL Server database to edit/query data if you are more comfortable using Access, though for database schema changes, etc, you will need to use Enterprise manager or similar tools.

access data at web server

I have placed my sql server database files on the database webspace given for my site. I am not being able to access the tables residing in my database on web.

Same database is working well at my localhhost. Why am i getting this kind of error?

Please explain "webspace given for my site" - - is this a hosted site, etc?

what error are you actually getting?

|||

The webspace given is a www folder and a db folder. www folder to keep all my aspx pages and db to keep my sqlserver database files .

The name of my database files are dodg_data.mdf and dodge_log.ldf The database name and user id given by my webhost is different , I have changed my file names according to that before uploading.

My database is not being accessed at all. I am getting inavalid object name'detail' error . detail is my tablename.

same database is working with my localhost.

I need help...........

|||

augustwind:

Please explain "webspace given for my site" - - is this a hosted site, etc?

what error are you actually getting?

The webspace given is a www folder and a db folder. www folder to keep all my aspx pages and db to keep my sqlserver database files .

The name of my database files are dodg_data.mdf and dodge_log.ldf The database name and user id given by my webhost is different , I have changed my file names according to that before uploading.

My database is not being accessed at all. I am getting inavalid object name'detail' error . detail is my tablename.

same database is working with my localhost.

I need help...........

|||You need to work with your host on this. They have most likely NOT given you a database folder for your SQL Server database, as this would imply that they would allow you to use SQL Express 2005, which most hosts would not do. They have instead likely given you space on their SQL Server. You would need to connect to this SQL Server and transfer your database to it.|||

tmorton:

You need to work with your host on this. They have most likely NOT given you a database folder for your SQL Server database, as this would imply that they would allow you to use SQL Express 2005, which most hosts would not do. They have instead likely given you space on their SQL Server. You would need to connect to this SQL Server and transfer your database to it.

Hi Terri,

But i am not getting it.Is keeping database files into the folder given is not enough. how can i get connected to their server. I am using connection string with username and password given by them.

Access a in house sql server from a remote web server

does anybody know how I would create a connection string in asp.net 2.0express to access a database in a different location from the webserver. I have a static IP address on the web server, so I've allowedaccess from the web server through the firewall. I have a user name andpassword, and I've made sure that I have the correct database. Would Iaccess the database using the network IP address and if so, where do Iput it. Thank you to anyone that can give me some insight to thisproblem, I'm very new to asp.net so, about a weeks worth of knowledge,so if you could explain as such I would appreciate it.
Seewww.connectionstrings.com. You put the IP where you normally put the Server name, all else should be the same. That said, hitting a SQL Server on the other side of a firewall may not be the best thing to do.|||thanks
"That said, hitting a SQL Server on the other side of a firewall may not be the best thing to do."
what you recommend then, like I said, I'm pretty new to this. Theproject that I'm working on requires me to create a web form, that ison an outsourced web server, and import the data into our database thatis behind a firewall. Would this be a security issue?

|||Yes, it can be. If SQL Server was perfect, it would not be a problem to leave the SQL port open. SQL Server is not perfect (recall the Slammer virus). So, in the circumstances you describe, perhaps it is your only option. However, I would make very certain that the database server is always patched up to date.sql

Accesing the SQL Server 2005

Hi,

I have a asp.net 2.0 web applicaiton which is connecting to the remote SQL server 2005. When I run the Web app, then Iam connecting to the DB and its displaying the records on the page.

When I browse the same page from the IIS, then iam getting the following error:

"System.Data.SqlClient.SqlException: Login failed for user 'mydomain\user' "

Connection string :

connectionString="Data Source=MySystem;Initial Catalog=DBLive;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>

Please let me know if find accross a solution for this...

Thanks

Vaskam

Verify the 'user' assigned to the Web Servers' AppDomain.

Somewhere, you seem to have assigned the security to 'mydomain\user' -I hope that your domain is NOT called 'mydomain' and that you do NOT have a user named 'user'.

About Web service or HTTP ENDPOINT

Hi All,

I met some problems when I walk through a example for Native Http SOAP in SQL Server 2005 for Developers. after I create the HTTP EndPoint in the Management Studio using following code:

USE AdventureWorks
GO

CREATE PROCEDURE EmployeePhoneList
AS
SELECT C.LastName, C.FirstName, C.Phone
FROM Person.Contact AS C
INNER JOIN HumanResources.Employee AS E
ON C.ContactID = E.ContactID
ORDER BY C.LastName, C.FirstName
GO

DROP ENDPOINT HRService;
GO

CREATE ENDPOINT HRService
STATE = STARTED
AS HTTP
(
PATH='/HumanResources',
AUTHENTICATION=(INTEGRATED),
PORTS=(CLEAR)
)
FOR SOAP
(
WEBMETHOD 'EmployeePhoneList'(name='AdventureWorks.dbo.EmployeePhoneList'),
DATABASE='AdventureWorks',
WSDL=DEFAULT
)

then I can see the web service is indeed created by using following cmnd,

SELECT *
FROM sys.endpoints

SELECT *
FROM sys.soap_endpoints;

SELECT *
FROM sys.endpoint_webmethods;

but when I want to use the web service in the VS2005, I can't find it and add the web reference. Any help will be greatly appreciated. and could you please tell me how to check web services in the local computer? Thanks.

Chris

Can you try http://yourmahine/HumanResources?wsd in your browser address bar and see if you can get the wsdl document in xml?

|||

No, I couldn't get the description for the web services, just a "page not found" like error.

In fact, when I run SQL to create HTTP EndPoint, I have to stop the web server first. after the execution of the SQL, I got an internal error from IIS if I restart the server. even though I restart the computer and web server, I still couldn't get the web services description.

I talked with some programmers, none of them use web services directly from sql server2005. and I notice there is few articles about it in the forum. Maybe microsoft just create this funtion for fun?

Anyway, Thanks a lot for you information. Hope get more help from you.

Chris

|||

Chris,

There's a small typo in Nan's post. The url is http://servername/HumanResources?wsdl

His post missed the 'L' at the end. Also, I'm assuming you are using the same user to retrieve the WSDL document as the user who created the endpoint. If not, you will need to grant the user permissions. "GRANT CONNECT on ENDPOINT::<name> to [user]".

HTH
Jimmy

|||

Sorry for the typo. The wsdl url should be http://servername/HumanResources?wsdl. If you can't get the wsdl xml document, please post the error code, 4XX or 5XX.

|||

I'm using IIS 5.1 on WindowsXP SP2. and I'm using the same user account for creation and access the WS.

the error code is HTTP 404 - File not found. Thanks.

Chris

|||

Ah, since you are running on a WinXP SP2 box, please make sure that IIS is not running. SQL 2005's native web serivces uses the OS HTTP kernel mode listener, which is introduced in WinXP SP2 and W2k3, but the IIS 5.1 on WinXP OS does not make use of it. This causes a port contention.

The alternative is to create the endpoint on a different port (ie. port 8080 or 88), such that the request does not end up going to IIS.

Jimmy

|||

I had the exact same problem. I found the answer at the following URL. I have excepted the piece that helped get me on the right path.

http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/ReadmeSQL2005.htm

4.1.18 Remote Connections to a SOAP/HTTP Endpoint May Fail Using Integrated Authentication

Remote connections to a SOAP/HTTP endpoint may fail when the SQL Server service account is a domain account and authentication for the endpoint is set to INTEGRATED, even though local connections succeed. The problem can occur when the Service Principal Name (SPN) is registered to the local system account. You can work around the issue by either registering an SPN for the SQL Server Service account or specifying NTLM authentication for the endpoint. For more information about registering an SPN, see "Registering Kerberos Service Principal Names by Using Http.sys" in SQL Server Books Online.

Then in SQL Books I found the following;

To support mutual authentication under Kerberos, an instance of SQL Server 2005 must associate a Service Principal Name (SPN) with the account it will be running on, such as a local system account or domain user account. The specific details for SPN registration by a specific instance of SQL Server 2005 are determined by the type of service account it has been configured under. If SQL Server 2005 is running under the local system account or network service account, SPNs must be registered under the computer name. If SQL Server 2005 is running under a domain user account, SPNs must be registered under the domain user name.

Using SetSPN.exe

To enable association of an SPN to the account that the instance of SQL Server 2005 is running on, use the Windows SetSPN.exe support tool. The tool adds the SPN for the computer name on which the instance of SQL Server 2005 is running under the Windows domain service user account located in Active Directory. In this scenario, the SetSPN.exe tool can be used to add two SPNs: one for the NetBIOS name and another for the fully qualified DNS name.

For example, if the SetSPN.exe tool is executed from instance of SQL Server 2005 running on MyComputer, the following two SPNs are associated with the account the instance of SQL Server is running under and must be added to directory:

HTTP/MyComputer;

HTTP/MyComputer.fully.qualified.domain.name.com

If an instance of SQL Server is running as a domain user (MyDomain\MySQLAccount) on a computer that is named MySQLHost, the following commands can be used to set the appropriate SPNs:

setspn –A http/MySQLHost MyDomain\MySQLAccount

setspn –A http/MySqlHost.Mydomain.Mycorp.com MyDomain\MySQLAccount

About Web service or HTTP ENDPOINT

Hi All,

I met some problems when I walk through a example for Native Http SOAP in SQL Server 2005 for Developers. after I create the HTTP EndPoint in the Management Studio using following code:

USE AdventureWorks
GO

CREATE PROCEDURE EmployeePhoneList
AS
SELECT C.LastName, C.FirstName, C.Phone
FROM Person.Contact AS C
INNER JOIN HumanResources.Employee AS E
ON C.ContactID = E.ContactID
ORDER BY C.LastName, C.FirstName
GO

DROP ENDPOINT HRService;
GO

CREATE ENDPOINT HRService
STATE = STARTED
AS HTTP
(
PATH='/HumanResources',
AUTHENTICATION=(INTEGRATED),
PORTS=(CLEAR)
)
FOR SOAP
(
WEBMETHOD 'EmployeePhoneList'(name='AdventureWorks.dbo.EmployeePhoneList'),
DATABASE='AdventureWorks',
WSDL=DEFAULT
)

then I can see the web service is indeed created by using following cmnd,

SELECT *
FROM sys.endpoints

SELECT *
FROM sys.soap_endpoints;

SELECT *
FROM sys.endpoint_webmethods;

but when I want to use the web service in the VS2005, I can't find it and add the web reference. Any help will be greatly appreciated. and could you please tell me how to check web services in the local computer? Thanks.

Chris

Can you try http://yourmahine/HumanResources?wsd in your browser address bar and see if you can get the wsdl document in xml?

|||

No, I couldn't get the description for the web services, just a "page not found" like error.

In fact, when I run SQL to create HTTP EndPoint, I have to stop the web server first. after the execution of the SQL, I got an internal error from IIS if I restart the server. even though I restart the computer and web server, I still couldn't get the web services description.

I talked with some programmers, none of them use web services directly from sql server2005. and I notice there is few articles about it in the forum. Maybe microsoft just create this funtion for fun?

Anyway, Thanks a lot for you information. Hope get more help from you.

Chris

|||

Chris,

There's a small typo in Nan's post. The url is http://servername/HumanResources?wsdl

His post missed the 'L' at the end. Also, I'm assuming you are using the same user to retrieve the WSDL document as the user who created the endpoint. If not, you will need to grant the user permissions. "GRANT CONNECT on ENDPOINT::<name> to [user]".

HTH
Jimmy

|||

Sorry for the typo. The wsdl url should be http://servername/HumanResources?wsdl. If you can't get the wsdl xml document, please post the error code, 4XX or 5XX.

|||

I'm using IIS 5.1 on WindowsXP SP2. and I'm using the same user account for creation and access the WS.

the error code is HTTP 404 - File not found. Thanks.

Chris

|||

Ah, since you are running on a WinXP SP2 box, please make sure that IIS is not running. SQL 2005's native web serivces uses the OS HTTP kernel mode listener, which is introduced in WinXP SP2 and W2k3, but the IIS 5.1 on WinXP OS does not make use of it. This causes a port contention.

The alternative is to create the endpoint on a different port (ie. port 8080 or 88), such that the request does not end up going to IIS.

Jimmy

|||

I had the exact same problem. I found the answer at the following URL. I have excepted the piece that helped get me on the right path.

http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/ReadmeSQL2005.htm

4.1.18 Remote Connections to a SOAP/HTTP Endpoint May Fail Using Integrated Authentication

Remote connections to a SOAP/HTTP endpoint may fail when the SQL Server service account is a domain account and authentication for the endpoint is set to INTEGRATED, even though local connections succeed. The problem can occur when the Service Principal Name (SPN) is registered to the local system account. You can work around the issue by either registering an SPN for the SQL Server Service account or specifying NTLM authentication for the endpoint. For more information about registering an SPN, see "Registering Kerberos Service Principal Names by Using Http.sys" in SQL Server Books Online.

Then in SQL Books I found the following;

To support mutual authentication under Kerberos, an instance of SQL Server 2005 must associate a Service Principal Name (SPN) with the account it will be running on, such as a local system account or domain user account. The specific details for SPN registration by a specific instance of SQL Server 2005 are determined by the type of service account it has been configured under. If SQL Server 2005 is running under the local system account or network service account, SPNs must be registered under the computer name. If SQL Server 2005 is running under a domain user account, SPNs must be registered under the domain user name.

Using SetSPN.exe

To enable association of an SPN to the account that the instance of SQL Server 2005 is running on, use the Windows SetSPN.exe support tool. The tool adds the SPN for the computer name on which the instance of SQL Server 2005 is running under the Windows domain service user account located in Active Directory. In this scenario, the SetSPN.exe tool can be used to add two SPNs: one for the NetBIOS name and another for the fully qualified DNS name.

For example, if the SetSPN.exe tool is executed from instance of SQL Server 2005 running on MyComputer, the following two SPNs are associated with the account the instance of SQL Server is running under and must be added to directory:

HTTP/MyComputer;

HTTP/MyComputer.fully.qualified.domain.name.com

If an instance of SQL Server is running as a domain user (MyDomain\MySQLAccount) on a computer that is named MySQLHost, the following commands can be used to set the appropriate SPNs:

setspn –A http/MySQLHost MyDomain\MySQLAccount

setspn –A http/MySqlHost.Mydomain.Mycorp.com MyDomain\MySQLAccount

About the MSPetShop

"/Web"应用程序中的服务器错误。

---

用户 'mspetshop'登录失败。原因:未与信任 SQL Server连接相关联。

说明:执行当前 Web请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息:System.Data.SqlClient.SqlException:用户 'mspetshop'登录失败。原因:未与信任 SQL Server连接相关联。

源错误:

行 216:

行 217: if (conn.State != ConnectionState.Open)

行 218: conn.Open();

行 219:

行 220: cmd.Connection = conn;

源文件:C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs 行:218

堆栈跟踪:

[SqlException (0x80131904):用户 'mspetshop'登录失败。原因:未与信任 SQL Server连接相关联。]

System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +458

System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85

System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89

System.Data.SqlClient.SqlConnection.Open() +160

PetShop.DBUtility.SqlHelper.PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, String cmdText, SqlParameter[] cmdParms) in C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs:218

PetShop.DBUtility.SqlHelper.ExecuteReader(String connectionString, CommandType cmdType, String cmdText, SqlParameter[] commandParameters) in C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs:127

PetShop.SQLServerDAL.Category.GetCategories() in C:\Program Files\Microsoft\.NET Pet Shop 4.0\SQLServer\Category.cs:27

PetShop.BLL.Category.GetCategories() in C:\Program Files\Microsoft\.NET Pet Shop 4.0\BLL\Category.cs:20

PetShop.Web.NavigationControl.Page_Load(Object sender, EventArgs e) +51

System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13

System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45

System.Web.UI.Control.OnLoad(EventArgs e) +80

System.Web.UI.Control.LoadRecursive() +49

System.Web.UI.Control.LoadRecursive() +132

System.Web.UI.BasePartialCachingControl.LoadRecursive() +113

System.Web.UI.Control.LoadRecursive() +132

System.Web.UI.Control.LoadRecursive() +132

System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429

System.Data.ProviderBase.DbConnectionPool.PoolCreateRequest(Object state) +321

---

版本信息: Microsoft .NET Framework版本:2.0.50727.42; ASP.NET版本:2.0.50727.42

About the MSPetShop

It said user"mspetshop" distrust connect to SqlServer

What Can I Do?

why the user"MSpetshop"can't to connect the SqlServer2k?

change the Database?

SqlServer2005?

but my pc's memory is just 256mb~

|||Since Microsoft .NET Pet Shop is a winforms question, the MSDN Forums is probably a better place for this question.

It's hard to know what the problem is without seeing the exact English version of the error message. If you show us the connection string, we *might* be able to help. It sounds like you need to give the account login access to your database (viasp_grantlogin).

About storing and receiving a location from SQL SERVER.....................

hi friends,

i want to store an image in DB. but most of my friends told that, to store an image in web server then store tat location in a DB and access it anywhere. this is for asp.net in C#-code behind. how to do this? i've a table with a text field. then ......? waiting for ur reply.........

note: i need coding. not by using controls. pls...

Hi,

if you want store the image on DB, you can pass it asSqlDbType.Image, and assign a byte array to the field to be saved.

cmd.Parameters.Add("@.Image",SqlDbType.Image, 0,"Image_Data");

DataRow row = new ...

row.Image_Data =File.ReadAllBytes(pathToFile); //assuming you uploaded it and saved it somewhere.

//your update command

Hope this help

About SQL Server 7.0 Developer Edition

Hi!
We're planning to run a web application as an intranet on Windows 2000
Server + IIS (ASP) + SQLServer 7.0.
We have a BackOffice 4.5 Developer Edition which includes SQLServer
7.0.
Can we use the SQLServer Developer Edition for our intranet?
Thanks.
Sam
Hi
No. You may not use Developer Edition in a production environment., It can
only be used for development.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<sam.s.kong@.gmail.com> wrote in message
news:1133286216.659677.70150@.g47g2000cwa.googlegro ups.com...
> Hi!
> We're planning to run a web application as an intranet on Windows 2000
> Server + IIS (ASP) + SQLServer 7.0.
> We have a BackOffice 4.5 Developer Edition which includes SQLServer
> 7.0.
> Can we use the SQLServer Developer Edition for our intranet?
>
> Thanks.
> Sam
>

About SQL Server 7.0 Developer Edition

Hi!
We're planning to run a web application as an intranet on Windows 2000
Server + IIS (ASP) + SQLServer 7.0.
We have a BackOffice 4.5 Developer Edition which includes SQLServer
7.0.
Can we use the SQLServer Developer Edition for our intranet?
Thanks.
SamHi
No. You may not use Developer Edition in a production environment., It can
only be used for development.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<sam.s.kong@.gmail.com> wrote in message
news:1133286216.659677.70150@.g47g2000cwa.googlegroups.com...
> Hi!
> We're planning to run a web application as an intranet on Windows 2000
> Server + IIS (ASP) + SQLServer 7.0.
> We have a BackOffice 4.5 Developer Edition which includes SQLServer
> 7.0.
> Can we use the SQLServer Developer Edition for our intranet?
>
> Thanks.
> Sam
>

About SQL Server 7.0 Developer Edition

Hi!
We're planning to run a web application as an intranet on Windows 2000
Server + IIS (ASP) + SQLServer 7.0.
We have a BackOffice 4.5 Developer Edition which includes SQLServer
7.0.
Can we use the SQLServer Developer Edition for our intranet?
Thanks.
SamHi
No. You may not use Developer Edition in a production environment., It can
only be used for development.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<sam.s.kong@.gmail.com> wrote in message
news:1133286216.659677.70150@.g47g2000cwa.googlegroups.com...
> Hi!
> We're planning to run a web application as an intranet on Windows 2000
> Server + IIS (ASP) + SQLServer 7.0.
> We have a BackOffice 4.5 Developer Edition which includes SQLServer
> 7.0.
> Can we use the SQLServer Developer Edition for our intranet?
>
> Thanks.
> Sam
>

About SQL

Hello to everybody,

I'm learning to work with SQL, Actually I have a web site in a hosting service which setup a monthly fee for the use of a SQL Server database. I would like to know if there is a problem because I have Windows XP Home Edition most of the time I have read that it should be Windows XP professional.

No, SQL Server should work fine on XP Home. XP Pro has a web server built in and Home does not, most of the differences between the two relate to networking.

|||Thank you very much..........!!!

About ReportViewer Control

I build a web page,display a report with ReportViewer ,I set its height 100% ,but the page doesn't display anything, why?

thanks for any helps.

Can you attach an RDL (or .rdlc) file with report definition to this post?

Thanks,

|||

100% height doesn't work. For a description, see http://www.gotreportviewer.com (FAQ #14).

This is on my list of things to figure out, but just haven't had the time. It must be possible since it works in the MS Report Manager and the Dundas demo (http://demos2.dundas.com/ReportingServices/).

What I would like to find is a sample asp.net application that interfaces with the reportviewer by resizing the height and modifying report parameters.

About HTTP Endpoint/Web services

Hi All,

I met some problems when I walk through a example for Native Http SOAP in SQL Server 2005 for Developers. after I create the HTTP EndPoint in the Management Studio using following code:

USE AdventureWorks
GO

CREATE PROCEDURE EmployeePhoneList
AS
SELECT C.LastName, C.FirstName, C.Phone
FROM Person.Contact AS C
INNER JOIN HumanResources.Employee AS E
ON C.ContactID = E.ContactID
ORDER BY C.LastName, C.FirstName
GO

DROP ENDPOINT HRService;
GO

CREATE ENDPOINT HRService
STATE = STARTED
AS HTTP
(
PATH='/HumanResources',
AUTHENTICATION=(INTEGRATED),
PORTS=(CLEAR)
)
FOR SOAP
(
WEBMETHOD 'EmployeePhoneList'(name='AdventureWorks.dbo.EmployeePhoneList'),
DATABASE='AdventureWorks',
WSDL=DEFAULT
)

then I can see the web service is indeed created by using following cmnd,

SELECT *
FROM sys.endpoints

SELECT *
FROM sys.soap_endpoints;

SELECT *
FROM sys.endpoint_webmethods;

but when I want to use the web service in the VS2005, I can't find it and add the web reference. Any help will be greatly appreciated. and could you please tell me how to check web services in the local computer? Thanks.

Chris

Did you find your answer? I've been through this a little now and would be happy to help.

If, in Visual Studio, you add a web reference, you'll be asked a location in the form of a URI. In the example that you show, the URI would be something like http://localhost/HumanResources?wsdl, which, when entered, should result in the finding of services and a proposed reference name of localhost ... which you can name to something else. The default namespace that will be created in your VS project will be something like <NameOfYourProject>.localhost ... or whatever you renamed it to be.

If you use an Object Viewer to look at the contents of the namespace, you'll see a couple of clients generated ... one something like HRService, and the other HRServiceWse. From here, I would suggest you follow the link http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=536560&SiteID=1&mode=1, since this picks up from there.

Tom

About Data algorithms

I just want to know what are the data algorithms available for sql server 2005 and can i use data mining as a web service

A list of algorithms with descriptions can be found at this location: http://msdn2.microsoft.com/en-us/library/ms175595.aspx

SQL Server Data Mining can be used as a web service (by sending XML/A requests inside SOAP payloads). A (live) sample for this can be found here: http://www.sqlserverdatamining.com/XMLAThinMiner/

Our client APIs (OLE DB Provider for Analysis Services, Adomd.Net, AMO) can also be used to conect to an Analysis Services HTTP end point. In this context, the web service communication part is encapsulated in our APIs, so your application does not need to distinguish between locally-accessible servers and HTTP end points (other than providing the appropriate connection string)

About Custom SiteMapProvider

Hi,

i used the custom sqlsitemapprovider which is in this web :http://msdn.microsoft.com/msdnmag/issues/06/02/wickedcode/default.aspx?loc=&fig=true#fig5 but in this sample they used sqlsitemapprovider as a default sitemapprovider i dont wanna use it as a default and i wanna send a paramater which is used to filter datas to that class. I modified that class and i can take a sitemapprovider back and i wanna show it a sitemappath data source programmaticaly. i wanna create an instance object of sitemappath datasource and i wanna bind it to that class and then i wanna add a treeview control to the page then i wanna bind it to the sitemapdatasource programmaticaly too..

Thanks for your attetion.

Regards...

Ok i made it

if you wanna learn how i made it :

just write them written below in the specified area :

in web.config:

<connectionStrings>
<add name="SiteMapConnectionString" connectionString="Data Source=.;Initial Catalog=Sorular;Integrated Security=True;Pooling=False" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<caching>
<sqlCacheDependency enabled="true"/>
</caching>
<siteMap>
<providers>
<add name="SiteMapBenYazdim" type="SqlSiteMapProvider" connectionStringName="SiteMapConnectionString"></add>
</providers>
</siteMap
codebehind:
SiteMapDataSource data = new SiteMapDataSource();
data.SiteMapProvider = "SiteMapBenYazdim";
TreeView1.DataSource = data;
TreeNodeBinding bind = new TreeNodeBinding();
bind.TextField = "Title";
bind.ToolTipField = "Description";
bind.ValueField = "Url";
bind.SelectAction = TreeNodeSelectAction.SelectExpand;
TreeView1.DataBindings.Add(bind);

That it man.i have been working on that damn thing about 2 days. And thanks God finally i made it..

|||SqlSiteMapProvider sitemap =newSqlSiteMapProvider();SiteMapDataSource treeVeriTabani =newSiteMapDataSource();

treeVeriTabani.Provider = sitemap;

TreeKonular.DataSource = treeVeriTabani;

TreeNodeBinding alanlar =newTreeNodeBinding();

alanlar.TextField ="Title";

alanlar.ValueField ="Url";

alanlar.ToolTipField ="Title";

alanlar.SelectAction =TreeNodeSelectAction.SelectExpand;

TreeKonular.DataBindings.Add(alanlar);

Page.DataBind();

Ok thats it

About AMO

I write web service with .NET 2.0.

It's using AMO to connect SQL Server 2005 and show counts of database.

When I excute the program under debug mode in my computer for testing,it's showing the correct counts.

But when I establish this web in the server,and browse it to use, the showing counts is zero.

Could some tell me why?

Thanks~

Server OS: Windows 2003

My Computer OS: Windows XP

follow is program:

Code Snippet

<WebMethod()> _
Public Function Test() As String
Dim ConnectServer As New Server
Dim tmp As String
ConnectServer.Connect("Data Source = olapdw;Provider = MSOLAP;")

tmp = ConnectServer.Databases.Count
ConnectServer.Disconnect()
ConnectServer.Dispose()
Return tmp

End Function

It's most likely a security / authentication issue. AMO uses windows authentication, so running on your local machine might be running under your account. So it probably depends on what account is configured to run the application pool that your web service is running under. You can set up impersonation, but if the web service and IIS are on separate machines, you need to configure Kerberos authentication.

You also do not use a connection string for AMO, the connect string only needs a server name.

eg.

ConnectServer.Connect("olapdw")

|||

Thanks, my problem has already resolved.

It's the same like following link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2037078&SiteID=1&mode=1

About AMO

I write web service with .NET 2.0.

It's using AMO to connect SQL Server 2005 and show counts of database.

When I excute the program under debug mode in my computer for testing,it's showing the correct counts.

But when I establish this web in the server,and browse it to use, the showing counts is zero.

Could some tell me why?

Thanks~

Server OS: Windows 2003

My Computer OS: Windows XP

follow is program:

Code Snippet

<WebMethod()> _
Public Function Test() As String
Dim ConnectServer As New Server
Dim tmp As String
ConnectServer.Connect("Data Source = olapdw;Provider = MSOLAP;")

tmp = ConnectServer.Databases.Count
ConnectServer.Disconnect()
ConnectServer.Dispose()
Return tmp

End Function

It's most likely a security / authentication issue. AMO uses windows authentication, so running on your local machine might be running under your account. So it probably depends on what account is configured to run the application pool that your web service is running under. You can set up impersonation, but if the web service and IIS are on separate machines, you need to configure Kerberos authentication.

You also do not use a connection string for AMO, the connect string only needs a server name.

eg.

ConnectServer.Connect("olapdw")

|||

Thanks, my problem has already resolved.

It's the same like following link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2037078&SiteID=1&mode=1