Access Workflow Designer Server, MOD2000 and SQL 7.0 SP4

in Windows 2000 SP2. Please take a look at this article:
http://support.microsoft.com/default...b;en-us;253482
Microsoft says this issue was fixed in MOD2000 SP1. What I did is =
install MOD 2000 SP1 and then tried to install the
Access Workflow Designer. Yes it is in Per Seat Mode. Anyway the =
install still fails. So I am thinking maybe I need
to integrate this MOD2000 SP1 in with the Developer Tools which I have =
on disk so if that's right I should be able to
do it. Only I don't know how. Can anyone give any suggestions how to =
get this application in by slipstreaming the SP1
in with the developer tools? Thanks.
--=20
George Hester
_________________________________
You'll probably want to post this in one of the access
newsgroups instead. Try:
microsoft.public.access.devtoolkits
-Sue
On Wed, 26 Jan 2005 20:30:33 -0500, "George Hester"
<hesterloli@.hotmail.com> wrote:

>in Windows 2000 SP2. Please take a look at this article:
>http://support.microsoft.com/default...b;en-us;253482
>Microsoft says this issue was fixed in MOD2000 SP1. What I did is install MOD 2000 SP1 and then tried to install the
>Access Workflow Designer. Yes it is in Per Seat Mode. Anyway the install still fails. So I am thinking maybe I need
>to integrate this MOD2000 SP1 in with the Developer Tools which I have on disk so if that's right I should be able to
>do it. Only I don't know how. Can anyone give any suggestions how to get this application in by slipstreaming the SP1
>in with the developer tools? Thanks.
|||Tried. Thanks though.
--=20
George Hester
_________________________________
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message =
news:8nhgv05rc9lte54bkh5r0du4go5q07pv2p@.4ax.com... [vbcol=seagreen]
> You'll probably want to post this in one of the access
> newsgroups instead. Try:
> microsoft.public.access.devtoolkits
>=20
> -Sue
>=20
> On Wed, 26 Jan 2005 20:30:33 -0500, "George Hester"
> <hesterloli@.hotmail.com> wrote:
>=20
install MOD 2000 SP1 and then tried to install the[vbcol=seagreen]
install still fails. So I am thinking maybe I need[vbcol=seagreen]
have on disk so if that's right I should be able to[vbcol=seagreen]
to get this application in by slipstreaming the SP1
>=20

Access Workflow Designer Server, MOD2000 and SQL 7.0 SP4

in Windows 2000 SP2. Please take a look at this article:
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;253482
Microsoft says this issue was fixed in MOD2000 SP1. What I did is = install MOD 2000 SP1 and then tried to install the
Access Workflow Designer. Yes it is in Per Seat Mode. Anyway the = install still fails. So I am thinking maybe I need
to integrate this MOD2000 SP1 in with the Developer Tools which I have = on disk so if that's right I should be able to
do it. Only I don't know how. Can anyone give any suggestions how to = get this application in by slipstreaming the SP1
in with the developer tools? Thanks.
-- George Hester
_________________________________You'll probably want to post this in one of the access
newsgroups instead. Try:
microsoft.public.access.devtoolkits
-Sue
On Wed, 26 Jan 2005 20:30:33 -0500, "George Hester"
<hesterloli@.hotmail.com> wrote:
>in Windows 2000 SP2. Please take a look at this article:
>http://support.microsoft.com/default.aspx?scid=kb;en-us;253482
>Microsoft says this issue was fixed in MOD2000 SP1. What I did is install MOD 2000 SP1 and then tried to install the
>Access Workflow Designer. Yes it is in Per Seat Mode. Anyway the install still fails. So I am thinking maybe I need
>to integrate this MOD2000 SP1 in with the Developer Tools which I have on disk so if that's right I should be able to
>do it. Only I don't know how. Can anyone give any suggestions how to get this application in by slipstreaming the SP1
>in with the developer tools? Thanks.|||Tried. Thanks though.
-- George Hester
_________________________________
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message =news:8nhgv05rc9lte54bkh5r0du4go5q07pv2p@.4ax.com...
> You'll probably want to post this in one of the access
> newsgroups instead. Try:
> microsoft.public.access.devtoolkits
> > -Sue
> > On Wed, 26 Jan 2005 20:30:33 -0500, "George Hester"
> <hesterloli@.hotmail.com> wrote:
> > >in Windows 2000 SP2. Please take a look at this article:
> >
> >http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;253482
> >
> >Microsoft says this issue was fixed in MOD2000 SP1. What I did is =install MOD 2000 SP1 and then tried to install the
> >Access Workflow Designer. Yes it is in Per Seat Mode. Anyway the =install still fails. So I am thinking maybe I need
> >to integrate this MOD2000 SP1 in with the Developer Tools which I =have on disk so if that's right I should be able to
> >do it. Only I don't know how. Can anyone give any suggestions how =to get this application in by slipstreaming the SP1
> >in with the developer tools? Thanks.
>=20

access tables without schema

Hello

in my database I have schema "x". I have user "x" who is database owner, The user has schema "x" as default schema and is owner of this schema.

Now there are tables "x.mytable"

If I connect to the db as "x" and try

select * from mytable

I get an error "Invalid object name", I have to write it this way

select * from x.mytable

Why?

Thank you

Eckard

You need to check the metadata for these tables and see what might be wrong. Here is a script that I put together to demonstrate that it works, with a few select statements peppered in that you can use to check your tables:

use tempdb
go
create user bob without login
go
grant create table to bob
go
create schema bob
go
ALTER AUTHORIZATION ON schema::bob TO bob
go
ALTER USER bob WITH DEFAULT_SCHEMA = bob
GO
--check defaults
select name,default_schema_name, type_desc
from sys.database_principals
where name = 'bob'
go
--Then switch context to executing as 'bob'
execute as user = 'bob'
go
--let him (er it) create a table, so it is in the schema
create table bob.tableName
(
tableNameId int
)
create table tableName2
(
tableNameId int
)

go
select name, schema_name(schema_id)
from sys.objects where name in( 'tableName2', 'tablename')
go
select *
from tableName
select *
from tableName2
go
revert

|||

Regarding I have user "x" who is database owner,

All users belonging to the database role db_owner will create by default objects in the dbo schema. So if you make a login X as the owner of a database, and then connect as that login to the database, the default schema for that user is the dbo schema. My guess would be that this is the problem you are running into. Instead of making the login 'X' , the owner of the database, why not grant him CONTROL permission on the database ?

|||

Thank you Louis, Asvin but it is still not working for me:

The user is named "gwg01", the table name is "caddr" and the dbname is "gwgdaten". I'm connected as "gwg01" when I execute this script

use gwgdaten

go

sp_change_users_login 'auto_fix', 'gwg01'

go

grant control to gwg01

go

create schema gwg01

go

ALTER AUTHORIZATION ON schema::gwg01 TO gwg01

go

ALTER USER gwg01 WITH DEFAULT_SCHEMA = gwg01

GO

select name,default_schema_name, type_desc

from sys.database_principals

where name = 'gwg01'

>>>> gwg01 gwg01 SQL_USER

select name, schema_name(schema_id)

from sys.objects where name in( 'CADDR')

>>>> CADDR gwg01

select * from caddr

>>>> Invalid object name 'caddr'.

Any ideas?

Thank you

Eckard

|||

Hi again

after I removed the user and created it new, everything works...

Eckard

Access SQL Server 2005 database using a published website

Hi all,

I am stuck with a problem using ASP.Net website. I created a website which accesses a database table in SQL Server 2005. The default.aspx is a form which inserts/updates/deletes data from the database. After creating the website I published it to IIS (Inetpub -> wwwroot). When I use Visual Studio 2005 and build the website and start with debugging. the form comes up and i can insert/update or delete the data from the table as I want. Now, as I have the website published I can access the form from another sharepoint website using the url as

/Employee_Data/Default.aspx">http://<mydesktop>/Employee_Data/Default.aspx

the form shows up but I am not able to access any of the database. I do not see any errors either. Once I click on the button the page just refreshes but nothing else happens. I have my web.config as :-

<?

xmlversion="1.0"?>

<

configuration>

<

appSettings/>

<

connectionStrings/>

<

system.web>

<

compilationdebug="true"/>

<

authenticationmode="Windows"/>

</

system.web>

</

configuration>

Am I missing something? Ieven have Anonymous access in the IIS inetpub properties. I can even the database as I am the administrator.... I appreciate your suggestions.

Thanks,

Kavya

Can you post your connection string as well as SQL commands? Can you connect to the SQL Server from the machine (on which you can access the published website) via Management Studio?

Access is Denied in Upgrade Advisor

Hi all,

I have run the SQL Server 2005 Upgrade Advisor against a default instance of SQL Server 2000 server running on Windows Server 2003.

One thing I need to fix before I upgrade is:

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)

SVCACCTREQ

I'm not sure what this means or what I need to do before I can upgrade.

Does anyone have a clue on this one.

Thanks,

David

Hi David,

The issue you posted is actually an error encountered while processing the rule (SVCACCTREQ). I'm wondering if the account you used to run Upgrade Advisor was a member of the local administrators group on the machine in question?

jeff.

|||

Thanks Jeff,

I am running the Upgrade Advisor remotely as the server does not have .NET 2.0 Framework installed.

The first time I got the error, I connected to SQL Server using TCP/IP logging on as sa.

I got the same result where I had a mapped drive to the remote server using a Domain Administrator logon and use Named Pipes to connect to SQL Server.

We now have access to a test server where I can install the .NET 2.0 Framework and run the Upgrade Advisor locally.

Hopefully this will resolve the problem.

David.

|||

Jeff, same here using SA (remote).

I also get "Attempted to perform an unauthorized operation" on NETPROTOCOL, MDACVERSION and few more.

\Ruud

|||

Is there anyway to use the Upgrade Advisor tool remotely avoiding the .net framework installation on sql server 200?

i got the following errors:

Attempted to perform an unauthorized operation.
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Thanks

Gianfranco

|||Some of the rules executed by Upgrade Advisor require admin priviliages at the Operating System layer that won't be available when using SQL Authentication. I suspect the rules you are encountering these errors are those rules which require admin priviliages at the Operating System layer. The SA, or equivilant SQL account, does not have permission to perform the actions necessary for these rules to execute, thus the error you are seeing.|||

You should not need to install the .NET Framework on a remote install. All rules will use either a SQL Connection or WMI to perform the action requested by the rule. The .NET Framework is a requirement of the Upgrade Advisor tool itself, so only where you are running Upgrade Advisor do you need the .NET Framework.

There are additional requirements for the Upgrade Advisor client machine, such as OLAP Tools and the DTS client, so make sure you have those installed on the machine where you're Upgrade Advisor.

|||

I was trying to do the remote installation too and I got the same error too.

I was able to fix this by running Sql Server 2005 Upgrade Advisor on a machine that was on the same domain as the database server.

I was logged in as a user who had administrator rights on both machines. So when I ran Sql Server 2005 Upgrade Advisor I made it connect to the database server and to login using Windows Authentication.

Access is Denied in Upgrade Advisor

Hi all,

I have run the SQL Server 2005 Upgrade Advisor against a default instance of SQL Server 2000 server running on Windows Server 2003.

One thing I need to fix before I upgrade is:

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)

SVCACCTREQ

I'm not sure what this means or what I need to do before I can upgrade.

Does anyone have a clue on this one.

Thanks,

David

Hi David,

The issue you posted is actually an error encountered while processing the rule (SVCACCTREQ). I'm wondering if the account you used to run Upgrade Advisor was a member of the local administrators group on the machine in question?

jeff.

|||

Thanks Jeff,

I am running the Upgrade Advisor remotely as the server does not have .NET 2.0 Framework installed.

The first time I got the error, I connected to SQL Server using TCP/IP logging on as sa.

I got the same result where I had a mapped drive to the remote server using a Domain Administrator logon and use Named Pipes to connect to SQL Server.

We now have access to a test server where I can install the .NET 2.0 Framework and run the Upgrade Advisor locally.

Hopefully this will resolve the problem.

David.

|||

Jeff, same here using SA (remote).

I also get "Attempted to perform an unauthorized operation" on NETPROTOCOL, MDACVERSION and few more.

\Ruud

|||

Is there anyway to use the Upgrade Advisor tool remotely avoiding the .net framework installation on sql server 200?

i got the following errors:

Attempted to perform an unauthorized operation.
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Thanks

Gianfranco

|||Some of the rules executed by Upgrade Advisor require admin priviliages at the Operating System layer that won't be available when using SQL Authentication. I suspect the rules you are encountering these errors are those rules which require admin priviliages at the Operating System layer. The SA, or equivilant SQL account, does not have permission to perform the actions necessary for these rules to execute, thus the error you are seeing.|||

You should not need to install the .NET Framework on a remote install. All rules will use either a SQL Connection or WMI to perform the action requested by the rule. The .NET Framework is a requirement of the Upgrade Advisor tool itself, so only where you are running Upgrade Advisor do you need the .NET Framework.

There are additional requirements for the Upgrade Advisor client machine, such as OLAP Tools and the DTS client, so make sure you have those installed on the machine where you're Upgrade Advisor.

|||

I was trying to do the remote installation too and I got the same error too.

I was able to fix this by running Sql Server 2005 Upgrade Advisor on a machine that was on the same domain as the database server.

I was logged in as a user who had administrator rights on both machines. So when I ran Sql Server 2005 Upgrade Advisor I made it connect to the database server and to login using Windows Authentication.