install SQL on WinXP: application

Showing posts with label application. Show all posts

Tuesday, March 27, 2012

can not generate SSPI Context

Hello everybody
I have a VB6 app using Trusted Connection to a SQL Server 2000.
This application can also run when creating a VPN Connection and using a
TCP/IP Connectionstring
I upgrade my MDAC installation (2.8) and now when I tried to run my app over
VPN, I obtain: "cannot generate SSPI Context"
It runs without problem in LAN using Trusted but not anymore over VPN.
Can anyone help me ?!?
Have a look at
HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/default...b;en-us;811889
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:%23xis2GBPEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>
|||Also don't forget to look at the hosts and lmhosts files in your system32
folder.
You need the correct hosts configuration in there. There are a variety of
problems that can cause the SSPI error and a change of hosts file config
sorted mine out on most client machines but I still have the problem on two
of them where it drops off after 45 mins for no apparent rhyme or reason.
The hosts file that works for me looks like this (bar the IBM manufactured
PC's)
127.0.0.1 localhost.uk-resources.net
127.0.0.1 mypc.uk-resources.net
192.168.16.2 ourserver.uk-resources.net
Don't forget to backup the original hosts and lmhost file before changing
anything.
There is some issue I recall seeing when researching the problem a few
months ago about the way the DNS resolves when using vpn and it may be
router related.
Regards,
Paul
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:%23xis2GBPEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>

can not generate SSPI Context

Hello everybody
I have a VB6 app using Trusted Connection to a SQL Server 2000.
This application can also run when creating a VPN Connection and using a
TCP/IP Connectionstring
I upgrade my MDAC installation (2.8) and now when I tried to run my app over
VPN, I obtain: "cannot generate SSPI Context"
It runs without problem in LAN using Trusted but not anymore over VPN.
Can anyone help me ?!?Try switching the protocol using the Client Network Utility to Named Pipes.
See if the problem goes away.
Instead of using your vb app, you can test with the following command line
tool.
-To test Named Pipes
ISQL -Snp:ServerNameHere -E -Q"select @.@.version"
-To test TCP/IP
ISQL -Stcp:ServerNameHere -E -Q"select @.@.version"
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hello
i don't want to use name pipes because i want to supply an access over
internet.
My connectionstring look likes
.Properties("Network address").value = "MyPublicIPAdress"
.Provider = "sqloledb"
.ConnectionTimeout = 15
.CommandTimeout = 300
.CursorLocation = adUseClient
.Properties("Application Name") = "MyApp"
.Properties("Network Library").value = "DBMSSOCN"
.Properties("Integrated Security").value = "SSPI"
I made a few others Test:
*I try to configure (via cliconfg.exe) the SQL access from my client: I set
"Enabled protocols" only to TCP/IP
I didn't sove my problems.
* I make a Rollback of MDAC 2.8 (dasetup -u), It rollbacks to MDAC 2.7 (the
one supplies with XP) -> It RUNS again;
Is there any know bugs in the MDAC 2.8 when accessing a SQL Server with
TCP/IP and in a Trusted Mode ?!?
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:qaI9eeCPEHA.304@.cpmsftngxa10.phx.gbl...
> Try switching the protocol using the Client Network Utility to Named
Pipes.
> See if the problem goes away.
> Instead of using your vb app, you can test with the following command line
> tool.
> -To test Named Pipes
> ISQL -Snp:ServerNameHere -E -Q"select @.@.version"
> -To test TCP/IP
> ISQL -Stcp:ServerNameHere -E -Q"select @.@.version"
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||One of the goals of MDAC 2.8 was to tighten security .
SSPI (Security Support Provider Interface ) is used when you are using
Windows Authentication to connect to the SQL server. That is to say the
domain account of the interactive user trying to connect to SQL server is
used.
Sounds like the authentication token is lost or corrupted or something over
the VPN and SQL Server does not see the user as a valid domain account.
Here are some links that I hope help:
http://support.microsoft.com/defaul...kb;en-us;820761
http://support.microsoft.com/defaul...kb;en-us;814401
http://support.microsoft.com/defaul...kb;en-us;821373
Good luck,
Mike
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:ez6RRaBPEHA.3476@.tk2msftngp13.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>
>

can not generate SSPI Context

Hello everybody
I have a VB6 app using Trusted Connection to a SQL Server 2000.
This application can also run when creating a VPN Connection and using a
TCP/IP Connectionstring
I upgrade my MDAC installation (2.8) and now when I tried to run my app over
VPN, I obtain: "cannot generate SSPI Context"
It runs without problem in LAN using Trusted but not anymore over VPN.
Can anyone help me ?!?Have a look at
HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/defaul...kb;en-us;811889
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:%23xis2GBPEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>|||Also don't forget to look at the hosts and lmhosts files in your system32
folder.
You need the correct hosts configuration in there. There are a variety of
problems that can cause the SSPI error and a change of hosts file config
sorted mine out on most client machines but I still have the problem on two
of them where it drops off after 45 mins for no apparent rhyme or reason.
The hosts file that works for me looks like this (bar the IBM manufactured
PC's)
127.0.0.1 localhost.uk-resources.net
127.0.0.1 mypc.uk-resources.net
192.168.16.2 ourserver.uk-resources.net
Don't forget to backup the original hosts and lmhost file before changing
anything.
There is some issue I recall seeing when researching the problem a few
months ago about the way the DNS resolves when using vpn and it may be
router related.
Regards,
Paul
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:%23xis2GBPEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>sql

Thursday, March 22, 2012

Can not connect to MSDE 2000 through my PDA application

Hi, I am new to MSDE and am having a problem connecting to it through my PDA
application. Everytime i try to open the connection i get a exception of
PlatformNotSupportedException.
I have checked this problem for many times and fail to find an ideal
solution. My question is whether it was caused by an low version of MSDE? I
have tried to update the MSDE with SP4, but it failed. The error message is
:The instance name specified is invalid.
Anyone can help me ? Thanks!
hi,
phil wrote:
> Hi, I am new to MSDE and am having a problem connecting to it through
> my PDA application. Everytime i try to open the connection i get a
> exception of PlatformNotSupportedException.
> I have checked this problem for many times and fail to find an ideal
> solution. My question is whether it was caused by an low version of
> MSDE? I have tried to update the MSDE with SP4, but it failed. The
> error message is
> Anyone can help me ? Thanks!
I recently wote a little 300k PocketPC app using Vb.Net and the Compact
Framework for our inhouse order entry management... it is a connected app,
as it works connected via wi-fi with the main SQL Server engine... and it
works great :D
I think you've better ask in the specific compiler/language ng for better
luck...
as regard the MSDE upgrade to sp4, I've found that the instance name is
better understood by the setup.exe boostrap installer if provided without
quotes, in the form
c:\...\>setup.exe /upgradesp SQLRUN INSTANCENAME=whatever ..(other params)
/L*v "c:\MsdeSP4.txt"
but this is my own experience...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi Andrea Montanari, thanks for ur reply. As to the installation of SP4, i
have solved the problem with ur great suggestion. Thanks again.
But i still sufferd the problem with my pda app to connect with a MSDE
DATABSE. When I'd like to use SqlConnection.Open() in a Pocket PC 2002
application, I get an error message - PlatformNotSupportedException. I've
tryed it on Windows CE Emulator and my PDA Device, but the result was the
same.
There is my code snippet:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim cn As New System.Data.SqlClient.SqlConnection("User
ID=sa;password=sa;database=Test;server=192.168.1.5 ")
cn.Open()
Catch exSQL As SqlException
Dim errSQL As SqlError
For Each errSQL In exSQL.Errors
MessageBox.Show(errSQL.Message)
Next
Catch ex1 As Exception
MessageBox.Show(ex1.Message)
Finally
MessageBox.Show("test fail")
End Sub
When i try to build a windows application project with this code, it works
well, Can anybody give me a tip, how can i solve the problem?
Thank's in advance.
Operating system: Windows XP professional + sp2
Development Tool: Visual Studion 2003
Database: MSDE 2000 Release A
PDA device: iPaq H3870, Windows CE 4.1
|||hi,
phil wrote:
> hi Andrea Montanari, thanks for ur reply. As to the installation of
> SP4, i have solved the problem with ur great suggestion. Thanks again.

> But i still sufferd the problem with my pda app to connect with a MSDE
> DATABSE. When I'd like to use SqlConnection.Open() in a Pocket PC 2002
> application, I get an error message - PlatformNotSupportedException.
> I've tryed it on Windows CE Emulator and my PDA Device, but the
> result was the same.
>
> There is my code snippet:
> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles Button1.Click
> Dim cn As New System.Data.SqlClient.SqlConnection("User
> ID=sa;password=sa;database=Test;server=192.168.1.5 ")
>
it seems fine, to me... but unfortunately have no further hints.. try in the
DotNet compact framework ngs...
sorry..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You need to use the System.Data.SqlServerCe namespace and make sure you are
not referencing anything in then 1.1 framework. All references need to be
to the compact framework
http://msdn.microsoft.com/library/de...qlserverce.asp
In c#
SqlCeConnection conn = new SqlCeConnection( connString );
conn.Open();
"phil" <phil@.discussions.microsoft.com> wrote in message
news:02E40A6C-48C3-4DAD-9EDB-3F7B76CFA027@.microsoft.com...
> hi Andrea Montanari, thanks for ur reply. As to the installation of SP4, i
> have solved the problem with ur great suggestion. Thanks again.
> But i still sufferd the problem with my pda app to connect with a MSDE
> DATABSE. When I'd like to use SqlConnection.Open() in a Pocket PC 2002
> application, I get an error message - PlatformNotSupportedException. I've
> tryed it on Windows CE Emulator and my PDA Device, but the result was the
> same.
>
> There is my code snippet:
> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles Button1.Click
> Dim cn As New System.Data.SqlClient.SqlConnection("User
> ID=sa;password=sa;database=Test;server=192.168.1.5 ")
> cn.Open()
> Catch exSQL As SqlException
> Dim errSQL As SqlError
> For Each errSQL In exSQL.Errors
> MessageBox.Show(errSQL.Message)
> Next
> Catch ex1 As Exception
> MessageBox.Show(ex1.Message)
> Finally
> MessageBox.Show("test fail")
> End Sub
> When i try to build a windows application project with this code, it
works
> well, Can anybody give me a tip, how can i solve the problem?
> Thank's in advance.
>
> Operating system: Windows XP professional + sp2
> Development Tool: Visual Studion 2003
> Database: MSDE 2000 Release A
> PDA device: iPaq H3870, Windows CE 4.1
>
|||hi Darren
Darren wrote:
> You need to use the System.Data.SqlServerCe namespace and make sure
> you are not referencing anything in then 1.1 framework. All
> references need to be to the compact framework
> http://msdn.microsoft.com/library/de...qlserverce.asp
> In c#
> SqlCeConnection conn = new SqlCeConnection( connString );
> conn.Open();
>
this is true for a SQLCe connection, but not for a connection to a
"standard" SQL Server/MSDE remote instance via wi-fi..
in this case, the System.Data.SqlClient reference is needed as already
indicated by Phil...
and the compact framework includes SqlClient component...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for the info.
I didn't realize that namespace was available in the CF.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3k2698Fs76uvU1@.individual.net...[vbcol=seagreen]
> hi Darren
> Darren wrote:
http://msdn.microsoft.com/library/de...qlserverce.asp
> this is true for a SQLCe connection, but not for a connection to a
> "standard" SQL Server/MSDE remote instance via wi-fi..
> in this case, the System.Data.SqlClient reference is needed as already
> indicated by Phil...
> and the compact framework includes SqlClient component...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Can not connect to desktop sql database from mobile device (Pocket PC)

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.

Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System

Public Class Form1

Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."

ReadOrderData()

End Sub

Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

Please see this:

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

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

If it still does not work after you fixed your 'localhost' issue:

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

Also, we have forum dedicated to SQL Mobile. Please post to it should you have any SQL or SQL Mobile related questions:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

|||

Thanks for your reply.

I would like to install vxUtil, and I have already read the readme.txt file. But I still have some questions about that. Should vxUtil be installed on my personal PC or the Pocket PC(PPC)? If it should be installed in the PPC, how can I install? In the readme.txt, I get the following information:

Open the appropriate folder on the hard drive then double-click
on the InstallCE icon to start the install process for the correct device.

From this information, I feel that vxUtil should be installed in my personal PC. Is it correct?

Could you please answer me about that?

Thanks a lot.

|||

vxUtil should be ultimately installed on device. However, like pretty much all Pocket PC products, it goes through desktop and Active Sync. You install/unzip application on to desktop, then you (or desktop installer) execute something which would push it to device via AS. As a developer you would have to do the same for your application eventually. In some cases there's no desktop installer, just a device CAB file. In that case simply copy CAB to device and click on it from device's file explorer.

|||

Dear Ilya Tumanov,

Your answer is so great. I have already installed it into the PPC, and it scanned the ports in my desktop PC. From the result, the ports 25, 80, 135, 139, 443, 445, 990 and1025 are all open. But the program that I posted yesterday and listed above can not still work. What do I need in the next step?

Moreover, I have changed the connection string to

Dim strConnection As String = "Server=Server1;Integrated Security=SSPI;database=AdventureWorks"

Thanks a lot.

|||

Hi,

I have already installed vxUtil into the PPC, and Ping is OK. I use it to scan the ports in my desktop PC. From the result, the ports 25, 80, 135, 139, 443, 445, 990 and1025 are all open. But the program can not still work.

Any ideas? Thanks a lot.

Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System

Public Class Form1

Dim strConnection As String = "Server=server1;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."

ReadOrderData()

End Sub

Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

|||

Default SQL Server port is 1433 which is not opened so it's not going to work until your SQL Server is properly configured. Also you have to provide credential in connection string, this string is not going to work.

I'm moving this thread to appropriate forum.

|||

Hi,

Thanks for your answer, and right now 1433 port is open. I would like to use windows authentication protocol. Could you please provide a sample for the connection string? Thanks a lot.

|||

Hi,

Thanks for your answer, and right now 1433 port is open. I would like to use windows authentication protocol. Could you please provide a sample for the connection string? Thanks a lot.

|||

This should work:

"Server=YourServerHere,1433;Initial Catalog=YourDataBaseHere;User ID=YourLoginHere;Password=YourPasswordHere;Integrated Security=SSPI;"

Note you have to provide login and password even though windows authentication will be used. That's because there's no login procedure on devices.

|||

Dear Ilya Tumanov,

Thanks a lot for your so many helps, and it works.

|||

so..It must have a password?is it same with windows user's password?what if blank?

if I'm not wrong, if we set the windows password, we should change the SQL password too right?

|||

you should check this link http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=709129&SiteID=1&mode=1

It works for me after a loooooonggg time testing

Monday, March 19, 2012

Can my ASP.NET dev workstation see remote SQL server?

I would like to develop my ASP.NET application against a SQL 2000 database
residing on another server, rather than against the SQL server installed
locally. We're using Windows integrated security. When I'm using Visual
Studio the ASP.NET user belongs to my XP machine's local domain, which is
not recognized by the remote SQL server as belong to its domain. It is
possible to set up the SQL Server, my local XP machine, or my web.config
file so that when I develop an app in Visual Studio (Debug -> Start), I can
access the remote SQL database?
Thanks !You should be able to register the server using the format domain\username
and then develop against it. NOTE that, by default, the method of security
is windows and not mixed, but that sounds fine in your case.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
****************************************
******************************
Think Outside the Box!
****************************************
******************************
"Timo" <timo@.anonymous.com> wrote in message
news:uPs3ZS4BEHA.624@.TK2MSFTNGP10.phx.gbl...
> I would like to develop my ASP.NET application against a SQL 2000 database
> residing on another server, rather than against the SQL server installed
> locally. We're using Windows integrated security. When I'm using Visual
> Studio the ASP.NET user belongs to my XP machine's local domain, which is
> not recognized by the remote SQL server as belong to its domain. It is
> possible to set up the SQL Server, my local XP machine, or my web.config
> file so that when I develop an app in Visual Studio (Debug -> Start), I
can
> access the remote SQL database?
> Thanks !
>|||Timo wrote:

> I would like to develop my ASP.NET application against a SQL 2000 database
> residing on another server, rather than against the SQL server installed
> locally. We're using Windows integrated security. When I'm using Visual
> Studio the ASP.NET user belongs to my XP machine's local domain, which is
> not recognized by the remote SQL server as belong to its domain. It is
> possible to set up the SQL Server, my local XP machine, or my web.config
> file so that when I develop an app in Visual Studio (Debug -> Start), I ca
n
> access the remote SQL database?
> Thanks !
In order to have ASP.NET connect to the database server, you must
configure ASP.NET to run as a domain account. I believe it is the
machine.config file that you will need to modify on Windows XP to change
what user ASP.NET runs as. It is different on different OSes. The good
thing is that with Windows 2003 you configure it directly in IIS and
each application can run under a different user.
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/|||You certainly can
A couple of ways to do it (one OR the other)
1) Edit machine.config (C:\WINNT\Microsoft.NET\Framework\v.....\Config) and
change the userName / password of the <processModel ..> element as described
in the same file
That way you can run the ASP.NET working process on the identity of a domain
account that may be allowed access to the SQL Server
2) For your Web application (on the IIS console), replace the default
anonymous user (IUSR_xxxxxxx) with a domain user / password and allow access
to that user in the SQL Server. You should also set <identity
impersonate=true> in your Web.config
Regards
Jose.
"Timo" <timo@.anonymous.com> escribi en el mensaje
news:uPs3ZS4BEHA.624@.TK2MSFTNGP10.phx.gbl...
> I would like to develop my ASP.NET application against a SQL 2000 database
> residing on another server, rather than against the SQL server installed
> locally. We're using Windows integrated security. When I'm using Visual
> Studio the ASP.NET user belongs to my XP machine's local domain, which is
> not recognized by the remote SQL server as belong to its domain. It is
> possible to set up the SQL Server, my local XP machine, or my web.config
> file so that when I develop an app in Visual Studio (Debug -> Start), I
can
> access the remote SQL database?
> Thanks !
>|||I follow step #1 below (it seems preferable to editing the live IIS server).
On my local PC, I edit the userName element replacing the value with
DOMAIN\USERNAME
This domain user has been granted login on the remote SQL server, has been
granted dbaccess, and has been added as a member of a role which can access
the relevant tables.When I try to run my ASP.NET page, I get the following
error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection
I don't know what our network admin has done when setting up my PC, which
has XP Pro on it; he is used to Win2K. He knows only a little more than I do
about Windows authentication, which has me worried :-) Why does the error
message have 'null' for the username? Because SQL does not recognize it and
so refuses to repeat the name?
Thanks
Timo
"Jose Marcenaro" <josem@.nospam.da-vinci.com.ar> wrote in message
news:eDZZXh4BEHA.3568@.tk2msftngp13.phx.gbl...
> You certainly can
> A couple of ways to do it (one OR the other)
> 1) Edit machine.config (C:\WINNT\Microsoft.NET\Framework\v.....\Config)
and
> change the userName / password of the <processModel ..> element as
described
> in the same file
> That way you can run the ASP.NET working process on the identity of a
domain
> account that may be allowed access to the SQL Server
> 2) For your Web application (on the IIS console), replace the default
> anonymous user (IUSR_xxxxxxx) with a domain user / password and allow
access
> to that user in the SQL Server. You should also set <identity
> impersonate=true> in your Web.config
> Regards
> Jose.
> "Timo" <timo@.anonymous.com> escribi en el mensaje
> news:uPs3ZS4BEHA.624@.TK2MSFTNGP10.phx.gbl...
database
Visual
is
> can
>|||Thanks for responding. But I don't know what is meant by "register the
server". Is that something I do with Visual Studio.NET? Do I need a special
"enterprise" level of VS.NET for that?
Timo
"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@.comcast.netNoSpamM> wrote in
message news:u2P1gd4BEHA.2380@.TK2MSFTNGP10.phx.gbl...
> You should be able to register the server using the format domain\username
> and then develop against it. NOTE that, by default, the method of security
> is windows and not mixed, but that sounds fine in your case.
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
> "Timo" <timo@.anonymous.com> wrote in message
> news:uPs3ZS4BEHA.624@.TK2MSFTNGP10.phx.gbl...
database
Visual
is
> can|||Login failed for user 'null' means that we were unable to 'impersonate' the
user. We need to be able to impersonate when we authenticate to SQL using
your Windows NT credentials.
Typical client server environment:
Scenario 1:
Client --> SQL
If this fails, then it may be a problem with the communication between the
client and the Domain Controller. You can make network traces from the
client and /or enable Kerberos logging to verify if this is the case. This
may occur when using sockets, but not with Named Pipes connections.
Scenario 2:
Web Server/SQL Environment
Client-->IIS-->SQL.
If your scenario looks like the Scenario 2 (Web Server/SQL Environment),
then this scenario is more complicated to configure.
The middle machine (IIS) must be trusted for Security Delegation. And the
Domain Admin needs to set the spn for SQL Server.
The client machine must use TCP/IP and authenticate via Kerberos
authentication. If it uses NTLM, then this will fail with "Login failed
for user 'null'".
This article goes over various scenarios:
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/SecNetch05.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||If you want to use step #1 (ASPNET account) make sure you dont have
<impersonate="true"> in Web.config (you should keep the default which is
false or absent).
Otherwise, the local IUSR_xxxxx identity would be used.
If you do not currently have <impersonate="true"> ... then I guess it may be
some "extra-cautious" security setting of XPPro which prevents the identity
to be passed along.. sorry for not being able to help there
"Timo" <timo@.anonymous.com> escribi en el mensaje
news:e7M3M$4BEHA.3472@.TK2MSFTNGP09.phx.gbl...
> I follow step #1 below (it seems preferable to editing the live IIS
server).
> On my local PC, I edit the userName element replacing the value with
> DOMAIN\USERNAME
> This domain user has been granted login on the remote SQL server, has been
> granted dbaccess, and has been added as a member of a role which can
access
> the relevant tables.When I try to run my ASP.NET page, I get the following
> error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection
> I don't know what our network admin has done when setting up my PC, which
> has XP Pro on it; he is used to Win2K. He knows only a little more than I
do
> about Windows authentication, which has me worried :-) Why does the error
> message have 'null' for the username? Because SQL does not recognize it
and
> so refuses to repeat the name?
> Thanks
> Timo
>
> "Jose Marcenaro" <josem@.nospam.da-vinci.com.ar> wrote in message
> news:eDZZXh4BEHA.3568@.tk2msftngp13.phx.gbl...
> and
> described
> domain
> access
> database
installed
> Visual
> is
is
web.config
I
>

Can multiple apps connect to the same database?

I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:

"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf'. (Microsoft SQL Server, Error: 5123)"

Here is the connection string in the VB application:

"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf";Integrated Security=True;User Instance=True"

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Jens, I'm confused. You say that multiple connections to user instances are not possible, but then you say to attach the database to the Express intances to make that possible. Is it possible or not? And if it is possible, could you go into more detail to explain how?

Thanks,

Tim

|||You'd need to shut down SQL before you can copy the files.|||I would suggest reading something about the priciples of user instance and regular SQl Server instances. SQL Server instances are permanatly attached to the SQL Server service, while user instances are only attached during the usage of any application. If one application gains access to the file, it is opened exclusivly for the user, therefore cannot be opened through another user instance connection. The Server permanently attached file on the other site will allow though the service to handle multiple user requests.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||I would be careful which such assumptions. Sure the files can be copied during the usage, but shutting down SQL Server will make the datafile be consistent. If you do not shut down the server service, the information of datafile and logfile can differ making the database after a restore inaccessible. So the better way would be to shutdown the service and therefore close the files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

Jens,

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Basically, the application needs to be running first, and then you connect to the user instance with a named pipe protocol. However, the Select statement they use in the example didn't work for me as is;

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Then, from the new connection listed in the object explorer I drilled down to the folder containing the user instance database (the folder name having the same path as my application's database) and was able to "manage objects related to your user instance" as they put it.

Tim

Can multiple apps connect to the same database?

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

Here is the connection string in the VB application:

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks,

Tim

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens,

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Tim

Can multiple apps connect to the same database?

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

Here is the connection string in the VB application:

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks,

Tim

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens,

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Tim

Can MSS 2005 be clustered using VM images i.e. with out a SAN

We would like to do MSS 2005 cluster failover testing with out Application,
however we do not have a SAN (or shared disk storage). Oracle provide the
ablity to create a 10G cluster using 2 Virtual Machines, so we were wondering
if Micrsoosft provides a a similiar solution for MSS 2005 and if so if there
is any documentation?
The lab manual from the course at www.clusterhelp.com does the whole thing
in Virtual Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
news:872804DE-56CD-454C-80E1-AD196E043D29@.microsoft.com...
We would like to do MSS 2005 cluster failover testing with out Application,
however we do not have a SAN (or shared disk storage). Oracle provide the
ablity to create a 10G cluster using 2 Virtual Machines, so we were
wondering
if Micrsoosft provides a a similiar solution for MSS 2005 and if so if there
is any documentation?
|||How about a TechNet webcast?
TechNet Support WebCast: How to cluster Microsoft SQL Server 2005 by using
Microsoft Virtual Server
http://support.microsoft.com/kb/891798/en-us
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
news:872804DE-56CD-454C-80E1-AD196E043D29@.microsoft.com...
> We would like to do MSS 2005 cluster failover testing with out
> Application,
> however we do not have a SAN (or shared disk storage). Oracle provide the
> ablity to create a 10G cluster using 2 Virtual Machines, so we were
> wondering
> if Micrsoosft provides a a similiar solution for MSS 2005 and if so if
> there
> is any documentation?
>
|||Geoff, Tom,
Thanjs for this. We will give it a ago.
Regards Mike Kimber
"Geoff N. Hiten" wrote:

> How about a TechNet webcast?
> TechNet Support WebCast: How to cluster Microsoft SQL Server 2005 by using
> Microsoft Virtual Server
> http://support.microsoft.com/kb/891798/en-us
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "mikekimber1" <mikekimber1@.discussions.microsoft.com> wrote in message
> news:872804DE-56CD-454C-80E1-AD196E043D29@.microsoft.com...
>

Thursday, March 8, 2012

can i/should i worry about fragmentation in catalog files?

Hello all,
I have an application that grew to 1.5 million records and saw poor
performance for a variety of reasons, but one huge 'doh' reason was that I
didn't think to pre-allocate the database and the poor database file was
fragmented as it grew from its default size in increments When we moved to a
new server I pre-allocated the file and made sure it was contiguous.
Is there a correllary with full-text indexing? Are there full-text catalog
files I can or should be creating as contiguous files, or should i be
running defrag on them?
thanks,
john
John,
Yes, there is. It is call "Master Merge" and smaller index files (shadow
files) are merged together at Midnight (controlled via registry key). While
this is not directly controllable in SQL Server 2000, can be managed via the
following TSQL code in SQL Server 2005:
Reorganize the full-text catalog using ALTER FULLTEXT CATALOG REORGANIZE. It
is important to do this before performance testing because it results in a
master merge of the full-text indexes in that catalog.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Mott" <johnmott59@.hotmail.com> wrote in message
news:%23lsVUjy0FHA.612@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> I have an application that grew to 1.5 million records and saw poor
> performance for a variety of reasons, but one huge 'doh' reason was that I
> didn't think to pre-allocate the database and the poor database file was
> fragmented as it grew from its default size in increments When we moved to
> a
> new server I pre-allocated the file and made sure it was contiguous.
> Is there a correllary with full-text indexing? Are there full-text catalog
> files I can or should be creating as contiguous files, or should i be
> running defrag on them?
> thanks,
> john
>
|||Thank you for your response. Unfortunately this is SQL Server 2000. Does it
make enough of a difference that its worth defragging the individual catalog
files with something like www.defragmentor.com?
john
"John Kane" <jt-kane@.comcast.net> wrote in message
news:%23A7C4vy0FHA.560@.TK2MSFTNGP12.phx.gbl...
> John,
> Yes, there is. It is call "Master Merge" and smaller index files (shadow
> files) are merged together at Midnight (controlled via registry key).
While
> this is not directly controllable in SQL Server 2000, can be managed via
the
> following TSQL code in SQL Server 2005:
> Reorganize the full-text catalog using ALTER FULLTEXT CATALOG REORGANIZE.
It[vbcol=seagreen]
> is important to do this before performance testing because it results in a
> master merge of the full-text indexes in that catalog.
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "John Mott" <johnmott59@.hotmail.com> wrote in message
> news:%23lsVUjy0FHA.612@.TK2MSFTNGP10.phx.gbl...
I[vbcol=seagreen]
to[vbcol=seagreen]
catalog
>
|||You're welcome, John,
I suspected that you were using SQL Server 2000 as the SQL 2005 info was
just FYI as Microsoft now recognizes this as a 'tunable' knob... As for
using Defragmentor or other utilities, in a word: No. The FT Catalog files
are managed by the "Microsoft Search" (mssearch.exe) service and are
compressed internally, so these utilities will do more harm than good.
For SQL Server 2000, the Master Merge" and smaller index files (shadow
files) are merged together at Midnight, so you may want to monitor your
server's app log for this recorded event at midnight.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Mott" <johnmott59@.hotmail.com> wrote in message
news:OFouh$y0FHA.2884@.TK2MSFTNGP09.phx.gbl...
> Thank you for your response. Unfortunately this is SQL Server 2000. Does
> it
> make enough of a difference that its worth defragging the individual
> catalog
> files with something like www.defragmentor.com?
> john
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:%23A7C4vy0FHA.560@.TK2MSFTNGP12.phx.gbl...
> While
> the
> It
> I
> to
> catalog
>

Can I work with abril ctp and migrate later to an express version?

Hello

The final customers of my application should have sql server express. Can I work with sql abril ctp and then when the final version of sql express has been released install it and migrate the database?

You should use June CTP (build 1187), not April CTP.

June CTP to RTM (Release) migration is a supported scenario. However, since you will be downgrading the SKU (e.g. Developer SKU to Express SKU) certain features may/will be unavailable. Some of this is transparent to the app (e.g. you won't get AWE support), but some may impact functionality (e.g. feature functionality is limited). It depends on what your application uses.

If you are concerned about databases only, upgrade should work fine from June CTP.

Regards,
Boris.

|||The only thing I need to create is tables, views, triggers and CLR stored procedures. So If I create these objects with sql 2005 june ctp and visual studio 2005 june ctp.

And when the final version of sql express and vs 2005 had been released it should work? I guess i only have to make a backup of the sql june ctp database, uninstall june ctp, uninstall vs 2005 june ctp, and then install vs 2005 profesional or team system , and then install final version of sql express and restore the database and it should work?

Am I missing something?|||

Yes, what you describe should work.

There are two parts to your question:

1. Going from June CTP to RTM – this should be just fine
2. Going from Developer SKU to Express SKU – this has caveats as outlined below

Caveat: if you use a feature that is available only on Dev/Enterprise SKU, once you migrate to Express you may run into problems. Most notable features that may create problems are database mirroring, database snapshot, failover clustering and table partitioning.

At release time there will be a document describing upgrade/downgrade process.

HTH,
Boris.

Wednesday, March 7, 2012

Can I use SQL Server 2005 Workgroup Edition for ADO.net 2?

Good day,

We have developed an application using VS 2005 and SQL Server 2005 Developer Edition.

Currently, our client is asking if they could buy the SQL Server 2005 Workgroup Edition.

Is it ok? I'm afraid that the SP we made using CLR and any other functionality might not work.

We are suggesting our client to use the SQL Server 2005 Standard Edition instead. But for them to save money, can they use the Workgroup Edition instead?

I would really appreciate your help.

Thanks and more power,

Arthur

Yes, sure this is possible. Due to the lack of knowing of what your application concists, you should doublecheck the feature comparison on your own:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

But for the "normal" and common features and programming this should be just fine unless you did not use any BI functionality.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thank you very much Jens for the information.

Can i use sql reporting svc with asp3.0 classic

Hi ,
I have to develop an application developed in asp 3.0 and now was wondering
if i could use MSSQL reproting services instead of using Crystal Reports.?
i know for design u need to have .net framework but can i integrate it while
using asp 3.0 and IIS 5.0
Thanks.
--KingIf you can figure out what the URL would be for a report, you can put
the report in an iframe, or even it's own page (i.e. a new window). Try
looking through the Reporting Services documentation for "URL Access."
Once you get the format of the URL down, it's pretty easy to customize
how the page loads. I do this to redirect users directly to PDFs of
reports.
~Andy
king wrote:
> Hi ,
> I have to develop an application developed in asp 3.0 and now was wondering
> if i could use MSSQL reproting services instead of using Crystal Reports.?
> i know for design u need to have .net framework but can i integrate it while
> using asp 3.0 and IIS 5.0
> Thanks.
> --King|||Thanks Andy.
That was helpful. Another question i have is if want the reports be
generated whenever the user clicks on the link ( i mean i wanna see latest
report everytime is it possible to do.
Also how can i implement security so that only authorized people can see
those reports . I am thinking of providing a login page and based on login
and password a person is able to see a particular report. so on the asp side
i can do it by authenticating the user against a table in database but what
about rs side .
If a person knows the url of the report can he see the report without login
?
THanks
"Andy Hardin" wrote:
> If you can figure out what the URL would be for a report, you can put
> the report in an iframe, or even it's own page (i.e. a new window). Try
> looking through the Reporting Services documentation for "URL Access."
> Once you get the format of the URL down, it's pretty easy to customize
> how the page loads. I do this to redirect users directly to PDFs of
> reports.
> ~Andy
> king wrote:
> > Hi ,
> > I have to develop an application developed in asp 3.0 and now was wondering
> > if i could use MSSQL reproting services instead of using Crystal Reports.?
> > i know for design u need to have .net framework but can i integrate it while
> > using asp 3.0 and IIS 5.0
> >
> > Thanks.
> >
> > --King
>|||The report should be freshly generated everytime someone accesses it.
I'm still trying to wrap my head around the security stuff. Every where
I've used RS has been in a domain environment where everyone has access
to all of the reports. You may want to search on google and the
newsgroup for information about implementing your own security.
~Andy
king wrote:
> Thanks Andy.
> That was helpful. Another question i have is if want the reports be
> generated whenever the user clicks on the link ( i mean i wanna see latest
> report everytime is it possible to do.
> Also how can i implement security so that only authorized people can see
> those reports . I am thinking of providing a login page and based on login
> and password a person is able to see a particular report. so on the asp side
> i can do it by authenticating the user against a table in database but what
> about rs side .
> If a person knows the url of the report can he see the report without login
> ?
> THanks
>
> "Andy Hardin" wrote:
>
>>If you can figure out what the URL would be for a report, you can put
>>the report in an iframe, or even it's own page (i.e. a new window). Try
>>looking through the Reporting Services documentation for "URL Access."
>>Once you get the format of the URL down, it's pretty easy to customize
>>how the page loads. I do this to redirect users directly to PDFs of
>>reports.
>>~Andy
>>king wrote:
>>Hi ,
>>I have to develop an application developed in asp 3.0 and now was wondering
>>if i could use MSSQL reproting services instead of using Crystal Reports.?
>>i know for design u need to have .net framework but can i integrate it while
>>using asp 3.0 and IIS 5.0
>>Thanks.
>>--King|||You may want to look at these articles on security in Reporting Services.
http://www.devx.com/dotnet/Article/26759/0/page/1
http://www.devx.com/dotnet/Article/27133/0
~Andy
king wrote:
> Thanks Andy.
> That was helpful. Another question i have is if want the reports be
> generated whenever the user clicks on the link ( i mean i wanna see latest
> report everytime is it possible to do.
> Also how can i implement security so that only authorized people can see
> those reports . I am thinking of providing a login page and based on login
> and password a person is able to see a particular report. so on the asp side
> i can do it by authenticating the user against a table in database but what
> about rs side .
> If a person knows the url of the report can he see the report without login
> ?
> THanks
>
> "Andy Hardin" wrote:
>
>>If you can figure out what the URL would be for a report, you can put
>>the report in an iframe, or even it's own page (i.e. a new window). Try
>>looking through the Reporting Services documentation for "URL Access."
>>Once you get the format of the URL down, it's pretty easy to customize
>>how the page loads. I do this to redirect users directly to PDFs of
>>reports.
>>~Andy
>>king wrote:
>>Hi ,
>>I have to develop an application developed in asp 3.0 and now was wondering
>>if i could use MSSQL reproting services instead of using Crystal Reports.?
>>i know for design u need to have .net framework but can i integrate it while
>>using asp 3.0 and IIS 5.0
>>Thanks.
>>--King

can I use sql profiler to debug stored procedure

can I use sql profiler to debug stored procedure, for example, when application runing, can I get infomation in profiler, such as value of variable in stored procedure, especially input parameter. Because I need to know what is value of input parameter I
get from client side. Thanks
Asked and answered in .programming group... Please do not multi-post.
"iter" <anonymous@.discussions.microsoft.com> wrote in message
news:17B8A330-6E4E-487A-9229-6493EF9DBBA5@.microsoft.com...
> can I use sql profiler to debug stored procedure, for example, when
application runing, can I get infomation in profiler, such as value of
variable in stored procedure, especially input parameter. Because I need to
know what is value of input parameter I get from client side. Thanks
>

Can I use SQL Express database inside full blown SQL 2005?

Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
Probably. You may have to deal with some user mapping and permissions issue because your production system will have different logins than your SQL Express instance.
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
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP10.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
|||It does not work saying "The user instance login flag is not supported on this version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message news:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue because your production system will have different logins than your SQL Express instance.
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
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP10.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
|||You will have to take the User Instance flag out of your connections strings, attach the database to the production system and then establish users and permissions in the production system.
There's some discussion of converting to User Instance to normal connections here:
http://msdn.microsoft.com/sql/expres...xpuserinst.asp
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
"GS" <nospam@.nowhere.com> wrote in message news:ucH0y7SHGHA.3916@.TK2MSFTNGP10.phx.gbl...
It does not work saying "The user instance login flag is not supported on this version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message news:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue because your production system will have different logins than your SQL Express instance.
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
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP10.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?

Can I use SQL Express database inside full blown SQL 2005?

Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
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
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?|||It does not work saying "The user instance login flag is not supported on th
is version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message new
s:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
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
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?|||You will have to take the User Instance flag out of your connections strings
, attach the database to the production system and then establish users and
permissions in the production system.
There's some discussion of converting to User Instance to normal connections
here:
http://msdn.microsoft.com/sql/expre...expuserinst.asp
--
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
"GS" <nospam@.nowhere.com> wrote in message news:ucH0y7SHGHA.3916@.TK2MSFTNGP1
0.phx.gbl...
It does not work saying "The user instance login flag is not supported on th
is version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message new
s:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
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
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?

Can I use Reporting Services within a C# windows application

Can I use sql Server 2000 Reporting Services within a C# windows application
--
Thanks!You can either use webservices or you can embed an IE control and use URL
integration. With Visual Studio 2005 (released in November I believe) there
is both a winform and webform controls. They work with RS 2005 (released in
November). My suggestion is learn how to create the reports and get the
reports working and then use the new controls. Much easier than any other
way that is possible today.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
> Can I use sql Server 2000 Reporting Services within a C# windows
> application
> --
> Thanks!|||Thanks Bruce,
But I'm not sure how to proceed. First of all I have a C# .net 2003 windows
application where I need to embed the report.
I have the report built in a separate project. I can preview the report
just fine. But when I want to Debug the report I get the following error
message:
No Report Server was found at http://mshqsql/reports
Can you explain why this occurs and what I need to do to get the report to
display?
I have never embedded an IE control or used URL integration. Can I do this
within a windows application and if so, how do I proceed or can you direct me
to a website so I can learn how to do this?
--
Thanks!
rmstaylor
"Bruce L-C [MVP]" wrote:
> You can either use webservices or you can embed an IE control and use URL
> integration. With Visual Studio 2005 (released in November I believe) there
> is both a winform and webform controls. They work with RS 2005 (released in
> November). My suggestion is learn how to create the reports and get the
> reports working and then use the new controls. Much easier than any other
> way that is possible today.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
> > Can I use sql Server 2000 Reporting Services within a C# windows
> > application
> > --
> > Thanks!
>
>|||I'm sorry I forgot to ask previously when I use an IE control and url
integration can I also print the report?
--
Thanks!
"Bruce L-C [MVP]" wrote:
> You can either use webservices or you can embed an IE control and use URL
> integration. With Visual Studio 2005 (released in November I believe) there
> is both a winform and webform controls. They work with RS 2005 (released in
> November). My suggestion is learn how to create the reports and get the
> reports working and then use the new controls. Much easier than any other
> way that is possible today.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
> > Can I use sql Server 2000 Reporting Services within a C# windows
> > application
> > --
> > Thanks!
>
>|||First off, RS 2000 requires a server. Reports have to be deployed to a
server. Until you get reports working it is a moot point to worry about
integrating it. You can build a report and preview it without the server.
You must have the server for anything to work in production. Do you have a
server installed? Have you deployed.
IE is componentized. There is a component for rendering, it has a property
where you set the URL. So, this is embedding an ocx in your C# application.
I have done this years ago with VB6 but not with dotnet. I suggest asking in
a dotnet newsgroup. First step would be to embed the control and then set
the URL to some website. Next you need to make sure you understand how to
create the URL. Test this outside your app by creating the url and just
pasting it into IE.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
news:DF5F50C0-3B16-46A9-A185-F47816681206@.microsoft.com...
> Thanks Bruce,
> But I'm not sure how to proceed. First of all I have a C# .net 2003
> windows
> application where I need to embed the report.
> I have the report built in a separate project. I can preview the report
> just fine. But when I want to Debug the report I get the following error
> message:
> No Report Server was found at http://mshqsql/reports
> Can you explain why this occurs and what I need to do to get the report to
> display?
> I have never embedded an IE control or used URL integration. Can I do
> this
> within a windows application and if so, how do I proceed or can you direct
> me
> to a website so I can learn how to do this?
> --
> Thanks!
> rmstaylor
> "Bruce L-C [MVP]" wrote:
>> You can either use webservices or you can embed an IE control and use URL
>> integration. With Visual Studio 2005 (released in November I believe)
>> there
>> is both a winform and webform controls. They work with RS 2005 (released
>> in
>> November). My suggestion is learn how to create the reports and get the
>> reports working and then use the new controls. Much easier than any other
>> way that is possible today.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
>> > Can I use sql Server 2000 Reporting Services within a C# windows
>> > application
>> > --
>> > Thanks!
>>|||Hi Bruce,
Have you done anything with using the webservices to create a menu control to
display the reports and folders that the user has access to? I was building
several user controls for each group of users, but was wondering if I could
build one generic menu type control that would read the webservices results
and populate the control with the reports that the user has access to. One
control for all the users.
Do you have any thoughts on this? Can you point me in the right direction?
I appreciate any help or insight you can provide.
Dennis
dennisp@.mayschem.com
Bruce L-C [MVP] wrote:
>You can either use webservices or you can embed an IE control and use URL
>integration. With Visual Studio 2005 (released in November I believe) there
>is both a winform and webform controls. They work with RS 2005 (released in
>November). My suggestion is learn how to create the reports and get the
>reports working and then use the new controls. Much easier than any other
>way that is possible today.
>> Can I use sql Server 2000 Reporting Services within a C# windows
>> application
Message posted via http://www.sqlmonster.com|||Nope, I use Report Manager. I would post a specific question about web
services separately.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dennis P via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:54B323D205480@.SQLMonster.com...
> Hi Bruce,
> Have you done anything with using the webservices to create a menu control
> to
> display the reports and folders that the user has access to? I was
> building
> several user controls for each group of users, but was wondering if I
> could
> build one generic menu type control that would read the webservices
> results
> and populate the control with the reports that the user has access to.
> One
> control for all the users.
> Do you have any thoughts on this? Can you point me in the right
> direction?
> I appreciate any help or insight you can provide.
> Dennis
> dennisp@.mayschem.com
> Bruce L-C [MVP] wrote:
>>You can either use webservices or you can embed an IE control and use URL
>>integration. With Visual Studio 2005 (released in November I believe)
>>there
>>is both a winform and webform controls. They work with RS 2005 (released
>>in
>>November). My suggestion is learn how to create the reports and get the
>>reports working and then use the new controls. Much easier than any other
>>way that is possible today.
>> Can I use sql Server 2000 Reporting Services within a C# windows
>> application
>
> --
> Message posted via http://www.sqlmonster.com|||The print icon on the toolbar of Report Manager is an ActiveX control. The
toolbar will not show only the report so you would have to have your own
print button, I believe it is possible to use the ActiveX control but I have
not done it.
Again, if you can get the OK to use VS 2005 (they have go-live licenses)
then this would be slam dunk easy with the new controls.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
news:FC09F199-6153-48D9-856B-745121561E47@.microsoft.com...
> I'm sorry I forgot to ask previously when I use an IE control and url
> integration can I also print the report?
> --
> Thanks!
>
> "Bruce L-C [MVP]" wrote:
>> You can either use webservices or you can embed an IE control and use URL
>> integration. With Visual Studio 2005 (released in November I believe)
>> there
>> is both a winform and webform controls. They work with RS 2005 (released
>> in
>> November). My suggestion is learn how to create the reports and get the
>> reports working and then use the new controls. Much easier than any other
>> way that is possible today.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
>> > Can I use sql Server 2000 Reporting Services within a C# windows
>> > application
>> > --
>> > Thanks!
>>|||Yes RS has been load to a server. I can type
http://mshqsql/reports/Pages/Folder.aspx into a browser and view the Report
Manager. However, when I type this address into the projects
TargetServerURL, then run the application in Debug mode I get the following
error:
No Report Server was found at http://mshqsql/reports
I'm not the one who loaded RS onto the server, but since we can see it in a
browser I am making an assumption that it is loaded corrected. And that
possibly I am not doing something in the application to point to the server.
I do appreciate any help you can give.
--
Thanks!
rmstaylor
"Bruce L-C [MVP]" wrote:
> First off, RS 2000 requires a server. Reports have to be deployed to a
> server. Until you get reports working it is a moot point to worry about
> integrating it. You can build a report and preview it without the server.
> You must have the server for anything to work in production. Do you have a
> server installed? Have you deployed.
> IE is componentized. There is a component for rendering, it has a property
> where you set the URL. So, this is embedding an ocx in your C# application.
> I have done this years ago with VB6 but not with dotnet. I suggest asking in
> a dotnet newsgroup. First step would be to embed the control and then set
> the URL to some website. Next you need to make sure you understand how to
> create the URL. Test this outside your app by creating the url and just
> pasting it into IE.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> news:DF5F50C0-3B16-46A9-A185-F47816681206@.microsoft.com...
> > Thanks Bruce,
> >
> > But I'm not sure how to proceed. First of all I have a C# .net 2003
> > windows
> > application where I need to embed the report.
> >
> > I have the report built in a separate project. I can preview the report
> > just fine. But when I want to Debug the report I get the following error
> > message:
> >
> > No Report Server was found at http://mshqsql/reports
> >
> > Can you explain why this occurs and what I need to do to get the report to
> > display?
> >
> > I have never embedded an IE control or used URL integration. Can I do
> > this
> > within a windows application and if so, how do I proceed or can you direct
> > me
> > to a website so I can learn how to do this?
> > --
> > Thanks!
> > rmstaylor
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You can either use webservices or you can embed an IE control and use URL
> >> integration. With Visual Studio 2005 (released in November I believe)
> >> there
> >> is both a winform and webform controls. They work with RS 2005 (released
> >> in
> >> November). My suggestion is learn how to create the reports and get the
> >> reports working and then use the new controls. Much easier than any other
> >> way that is possible today.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> >> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
> >> > Can I use sql Server 2000 Reporting Services within a C# windows
> >> > application
> >> > --
> >> > Thanks!
> >>
> >>
> >>
>
>|||There are two websites. One is report manager (reports) and one is
reportserver. Report Manager is a portal into reportserver and uses
reportserver. Change your URL to:
http://mshqsql/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
news:0C763DA5-23A1-4A1B-AAFA-7FEABC2018EA@.microsoft.com...
> Yes RS has been load to a server. I can type
> http://mshqsql/reports/Pages/Folder.aspx into a browser and view the
> Report
> Manager. However, when I type this address into the projects
> TargetServerURL, then run the application in Debug mode I get the
> following
> error:
> No Report Server was found at http://mshqsql/reports
> I'm not the one who loaded RS onto the server, but since we can see it in
> a
> browser I am making an assumption that it is loaded corrected. And that
> possibly I am not doing something in the application to point to the
> server.
> I do appreciate any help you can give.
> --
> Thanks!
> rmstaylor
>
> "Bruce L-C [MVP]" wrote:
>> First off, RS 2000 requires a server. Reports have to be deployed to a
>> server. Until you get reports working it is a moot point to worry about
>> integrating it. You can build a report and preview it without the server.
>> You must have the server for anything to work in production. Do you have
>> a
>> server installed? Have you deployed.
>> IE is componentized. There is a component for rendering, it has a
>> property
>> where you set the URL. So, this is embedding an ocx in your C#
>> application.
>> I have done this years ago with VB6 but not with dotnet. I suggest asking
>> in
>> a dotnet newsgroup. First step would be to embed the control and then set
>> the URL to some website. Next you need to make sure you understand how to
>> create the URL. Test this outside your app by creating the url and just
>> pasting it into IE.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> news:DF5F50C0-3B16-46A9-A185-F47816681206@.microsoft.com...
>> > Thanks Bruce,
>> >
>> > But I'm not sure how to proceed. First of all I have a C# .net 2003
>> > windows
>> > application where I need to embed the report.
>> >
>> > I have the report built in a separate project. I can preview the
>> > report
>> > just fine. But when I want to Debug the report I get the following
>> > error
>> > message:
>> >
>> > No Report Server was found at http://mshqsql/reports
>> >
>> > Can you explain why this occurs and what I need to do to get the report
>> > to
>> > display?
>> >
>> > I have never embedded an IE control or used URL integration. Can I do
>> > this
>> > within a windows application and if so, how do I proceed or can you
>> > direct
>> > me
>> > to a website so I can learn how to do this?
>> > --
>> > Thanks!
>> > rmstaylor
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> You can either use webservices or you can embed an IE control and use
>> >> URL
>> >> integration. With Visual Studio 2005 (released in November I believe)
>> >> there
>> >> is both a winform and webform controls. They work with RS 2005
>> >> (released
>> >> in
>> >> November). My suggestion is learn how to create the reports and get
>> >> the
>> >> reports working and then use the new controls. Much easier than any
>> >> other
>> >> way that is possible today.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> >> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
>> >> > Can I use sql Server 2000 Reporting Services within a C# windows
>> >> > application
>> >> > --
>> >> > Thanks!
>> >>
>> >>
>> >>
>>|||I changed the URL to the ReportServer however, I got the following error:
The permissions granted to user 'MSHQ\staylor' are insufficient for
performing this operation.
If I have permission to use mshq, then why am I gettng the error.
--
Thanks!
"Bruce L-C [MVP]" wrote:
> There are two websites. One is report manager (reports) and one is
> reportserver. Report Manager is a portal into reportserver and uses
> reportserver. Change your URL to:
> http://mshqsql/ReportServer
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> news:0C763DA5-23A1-4A1B-AAFA-7FEABC2018EA@.microsoft.com...
> > Yes RS has been load to a server. I can type
> > http://mshqsql/reports/Pages/Folder.aspx into a browser and view the
> > Report
> > Manager. However, when I type this address into the projects
> > TargetServerURL, then run the application in Debug mode I get the
> > following
> > error:
> >
> > No Report Server was found at http://mshqsql/reports
> >
> > I'm not the one who loaded RS onto the server, but since we can see it in
> > a
> > browser I am making an assumption that it is loaded corrected. And that
> > possibly I am not doing something in the application to point to the
> > server.
> >
> > I do appreciate any help you can give.
> > --
> > Thanks!
> > rmstaylor
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> First off, RS 2000 requires a server. Reports have to be deployed to a
> >> server. Until you get reports working it is a moot point to worry about
> >> integrating it. You can build a report and preview it without the server.
> >> You must have the server for anything to work in production. Do you have
> >> a
> >> server installed? Have you deployed.
> >>
> >> IE is componentized. There is a component for rendering, it has a
> >> property
> >> where you set the URL. So, this is embedding an ocx in your C#
> >> application.
> >> I have done this years ago with VB6 but not with dotnet. I suggest asking
> >> in
> >> a dotnet newsgroup. First step would be to embed the control and then set
> >> the URL to some website. Next you need to make sure you understand how to
> >> create the URL. Test this outside your app by creating the url and just
> >> pasting it into IE.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> >> news:DF5F50C0-3B16-46A9-A185-F47816681206@.microsoft.com...
> >> > Thanks Bruce,
> >> >
> >> > But I'm not sure how to proceed. First of all I have a C# .net 2003
> >> > windows
> >> > application where I need to embed the report.
> >> >
> >> > I have the report built in a separate project. I can preview the
> >> > report
> >> > just fine. But when I want to Debug the report I get the following
> >> > error
> >> > message:
> >> >
> >> > No Report Server was found at http://mshqsql/reports
> >> >
> >> > Can you explain why this occurs and what I need to do to get the report
> >> > to
> >> > display?
> >> >
> >> > I have never embedded an IE control or used URL integration. Can I do
> >> > this
> >> > within a windows application and if so, how do I proceed or can you
> >> > direct
> >> > me
> >> > to a website so I can learn how to do this?
> >> > --
> >> > Thanks!
> >> > rmstaylor
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> You can either use webservices or you can embed an IE control and use
> >> >> URL
> >> >> integration. With Visual Studio 2005 (released in November I believe)
> >> >> there
> >> >> is both a winform and webform controls. They work with RS 2005
> >> >> (released
> >> >> in
> >> >> November). My suggestion is learn how to create the reports and get
> >> >> the
> >> >> reports working and then use the new controls. Much easier than any
> >> >> other
> >> >> way that is possible today.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> >> >> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
> >> >> > Can I use sql Server 2000 Reporting Services within a C# windows
> >> >> > application
> >> >> > --
> >> >> > Thanks!
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Report Server is an asp.net application. If you are in the local admin group
on the server then you will have the rights you need. Otherwise you need to
be added to the appropriate role. Read up on roles in the books on line.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
news:83791D24-0A7E-4A73-856C-5C7FEEFDD8E2@.microsoft.com...
>I changed the URL to the ReportServer however, I got the following error:
> The permissions granted to user 'MSHQ\staylor' are insufficient for
> performing this operation.
> If I have permission to use mshq, then why am I gettng the error.
> --
> Thanks!
>
> "Bruce L-C [MVP]" wrote:
>> There are two websites. One is report manager (reports) and one is
>> reportserver. Report Manager is a portal into reportserver and uses
>> reportserver. Change your URL to:
>> http://mshqsql/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> news:0C763DA5-23A1-4A1B-AAFA-7FEABC2018EA@.microsoft.com...
>> > Yes RS has been load to a server. I can type
>> > http://mshqsql/reports/Pages/Folder.aspx into a browser and view the
>> > Report
>> > Manager. However, when I type this address into the projects
>> > TargetServerURL, then run the application in Debug mode I get the
>> > following
>> > error:
>> >
>> > No Report Server was found at http://mshqsql/reports
>> >
>> > I'm not the one who loaded RS onto the server, but since we can see it
>> > in
>> > a
>> > browser I am making an assumption that it is loaded corrected. And
>> > that
>> > possibly I am not doing something in the application to point to the
>> > server.
>> >
>> > I do appreciate any help you can give.
>> > --
>> > Thanks!
>> > rmstaylor
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> First off, RS 2000 requires a server. Reports have to be deployed to a
>> >> server. Until you get reports working it is a moot point to worry
>> >> about
>> >> integrating it. You can build a report and preview it without the
>> >> server.
>> >> You must have the server for anything to work in production. Do you
>> >> have
>> >> a
>> >> server installed? Have you deployed.
>> >>
>> >> IE is componentized. There is a component for rendering, it has a
>> >> property
>> >> where you set the URL. So, this is embedding an ocx in your C#
>> >> application.
>> >> I have done this years ago with VB6 but not with dotnet. I suggest
>> >> asking
>> >> in
>> >> a dotnet newsgroup. First step would be to embed the control and then
>> >> set
>> >> the URL to some website. Next you need to make sure you understand how
>> >> to
>> >> create the URL. Test this outside your app by creating the url and
>> >> just
>> >> pasting it into IE.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> >> news:DF5F50C0-3B16-46A9-A185-F47816681206@.microsoft.com...
>> >> > Thanks Bruce,
>> >> >
>> >> > But I'm not sure how to proceed. First of all I have a C# .net 2003
>> >> > windows
>> >> > application where I need to embed the report.
>> >> >
>> >> > I have the report built in a separate project. I can preview the
>> >> > report
>> >> > just fine. But when I want to Debug the report I get the following
>> >> > error
>> >> > message:
>> >> >
>> >> > No Report Server was found at http://mshqsql/reports
>> >> >
>> >> > Can you explain why this occurs and what I need to do to get the
>> >> > report
>> >> > to
>> >> > display?
>> >> >
>> >> > I have never embedded an IE control or used URL integration. Can I
>> >> > do
>> >> > this
>> >> > within a windows application and if so, how do I proceed or can you
>> >> > direct
>> >> > me
>> >> > to a website so I can learn how to do this?
>> >> > --
>> >> > Thanks!
>> >> > rmstaylor
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> You can either use webservices or you can embed an IE control and
>> >> >> use
>> >> >> URL
>> >> >> integration. With Visual Studio 2005 (released in November I
>> >> >> believe)
>> >> >> there
>> >> >> is both a winform and webform controls. They work with RS 2005
>> >> >> (released
>> >> >> in
>> >> >> November). My suggestion is learn how to create the reports and get
>> >> >> the
>> >> >> reports working and then use the new controls. Much easier than any
>> >> >> other
>> >> >> way that is possible today.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> >> >> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
>> >> >> > Can I use sql Server 2000 Reporting Services within a C# windows
>> >> >> > application
>> >> >> > --
>> >> >> > Thanks!
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

Tuesday, March 27, 2012

can not generate SSPI Context

can not generate SSPI Context

can not generate SSPI Context

Thursday, March 22, 2012

Can not connect to MSDE 2000 through my PDA application

Can not connect to desktop sql database from mobile device (Pocket PC)

Monday, March 19, 2012

Can my ASP.NET dev workstation see remote SQL server?

Can multiple apps connect to the same database?

Can multiple apps connect to the same database?

Can multiple apps connect to the same database?

Can MSS 2005 be clustered using VM images i.e. with out a SAN

Thursday, March 8, 2012

can i/should i worry about fragmentation in catalog files?

Can I work with abril ctp and migrate later to an express version?

Wednesday, March 7, 2012

Can I use SQL Server 2005 Workgroup Edition for ADO.net 2?

Can i use sql reporting svc with asp3.0 classic

can I use sql profiler to debug stored procedure

Can I use SQL Express database inside full blown SQL 2005?

Can I use SQL Express database inside full blown SQL 2005?

Can I use Reporting Services within a C# windows application

install SQL on WinXP

Blog Archive

About Me