No mapping between account name and security ID

Hi,

I created a user account on my active directory service. I then tried
to assign a service located on my SQL server to be executed by this
account. However, when I try to configure my SQL server service, I
get the following error message:

WMI Provider Error
"No mapping between account name and security ID was done"

Do you know what I am doing wrong?

thanksOn Jul 2, 8:57 pm, Zero <talltr...@.yahoo.comwrote:

Quote:

Originally Posted by

Hi,
>
I created a user account on my active directory service. I then tried
to assign a service located on my SQL server to be executed by this
account. However, when I try to configure my SQL server service, I
get the following error message:
>
WMI Provider Error
"No mapping between account name and security ID was done"
>
Do you know what I am doing wrong?
>
thanks

Hi,

Try giving the "WMI control" full permission and also the DCOM
settings as full permission.
then restart the WMI service.

No login name for database user.

I am using SQL2000. I took a backup of the database on the live server to setup the database on my new development computer. In the tables, there are 2 owners’ dbo and indiankarma. The tables that are owned by indiankarma are the tables that the site runs from.

The problem: The database user was created by the .bak file and does not have a login name. I created a security login named indiankarma and set the password, default database, server roles, BUT when I set the database access and click OK, it says User 'Indiankarma' already exists. I tried to delete the database user and start from scratch but it tells me the selected user cannot be dropped because the user owns objects.

Now I have tried sp_changedbowner 'indiankarma' which does give the security login name indiankarma database access but it makes the user dbo not indiankarma. I need the web application to read indiankarma.[tablename] not dbo.[tablename]

Can anyone help me with this problem??

This is a common issue after restoring a database. Check the following blog

http://weblogs.asp.net/steveschofield/archive/2005/12/31/434280.aspx

Regards

|||

I don't think I explained the problem correctly. When I restored the data base it created 2 sets of tables for each table. One set owned by dbo and the other set by indiankarma. So I have a table that is indiankarma.ikuserinfo and a table right below it that is dbo.ikuserinfo. All the site data is in the indiankarma owned tables. (see below 1.1)

1.1

The problem is that the 'indiankarma' database user has no login name. (See below 1.2).

1.2

Also, the security login 'indiankarma' does not have access to the database (see below 1.3) and when I try to give it access, I get this error 'User 'Indiankarma' already exists.' (see below 1.4)

1.3

1.4

I need to know what I can do to get database user 'indiankara' a login name and how to permit security login 'indiankarma' database access with the user 'indiankarma'. So it looks like the figure below (see below 1.5) but when I click ok, it does not give me the error. Please help!!! Sorry for all the images, I am bad at explaining problems thought they might help!

1.5

|||

I don't think I explained the problem correctly. When I restored the data base it created 2 sets of tables for each table. One set owned by dbo and the other set by indiankarma. So I have a table that is indiankarma.ikuserinfo and a table right below it that is dbo.ikuserinfo. All the site data is in the indiankarma owned tables. (see below 1.1)

1.1

The problem is that the 'indiankarma' database user has no login name. (See below 1.2).

1.2

Also, the security login 'indiankarma' does not have access to the database (see below 1.3) and when I try to give it access, I get this error 'User 'Indiankarma' already exists.' (see below 1.4)

1.3

1.4

I need to know what I can do to get database user 'indiankara' a login name and how to permit security login 'indiankarma' database access with the user 'indiankarma'. So it looks like the figure below (see below 1.5) but when I click ok, it does not give me the error. Please help!!! Sorry for all the images, I am bad at explaining problems thought they might help!

1.5

|||

I don't think I explained the problem correctly. When I restored the data base it created 2 sets of tables for each table. One set owned by dbo and the other set by indiankarma. So I have a table that is indiankarma.ikuserinfo and a table right below it that is dbo.ikuserinfo. All the site data is in the indiankarma owned tables. (see below 1.1)

1.1

The problem is that the 'indiankarma' database user has no login name. (See below 1.2).

1.2

Also, the security login 'indiankarma' does not have access to the database (see below 1.3) and when I try to give it access, I get this error 'User 'Indiankarma' already exists.' (see below 1.4)

1.3

1.4

I need to know what I can do to get database user 'indiankara' a login name and how to permit security login 'indiankarma' database access with the user 'indiankarma'. So it looks like the figure below (see below 1.5) but when I click ok, it does not give me the error. Please help!!! Sorry for all the images, I am bad at explaining problems thought they might help!

1.5

|||

I don't think I explained the problem correctly. When I restored the data base it created 2 sets of tables for each table. One set owned by dbo and the other set by indiankarma. So I have a table that is indiankarma.ikuserinfo and a table right below it that is dbo.ikuserinfo. All the site data is in the indiankarma owned tables. (see below 1.1)1.1
The problem is that the 'indiankarma' database user has no login name. (See below 1.2).1.2

Also, the security login 'indiankarma' does not have access to the database (see below 1.3) and when I try to give it access, I get this error 'User 'Indiankarma' already exists.' (see below 1.4)1.3
1.4
I need to know what I can do to get database user 'indiankara' a login name and how to permit security login 'indiankarma' database access with the user 'indiankarma'. So it looks like the figure below (see below 1.5) but when I click ok, it does not give me the error. Please help!!! Sorry for all the images, I am bad at explaining problems thought they might help!1.5

No fields allowed in header/footer?!?

I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
designer friendly interface. So please be patient & simplistic with your
responses.
If you can't place fields in page headers or footers how can you get fields
to repeat on multi-page forms, like shop travelers and packing lists, which
repeat customer and order info on every page but changes line item data?Two ways:
Rather than using a page header/footer for these section breaks, use a group
header and/or footer in a table. You can set group headers to to force a
page break or to repeat on a new page.
If you must show data in a page header or footer, add a hidden field-bound
textbox to the main report and then reference it from an item in the header
or footer (ReportItems!SalesTotal.Value). This isn't elegant but it works
for most things.
Paul Turley, MCSD, MCDBA, MSF, MCT
nospam at scout-master.com
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:FE0F30A9-057B-48FB-B8F8-E7158B312724@.microsoft.com...
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get
> fields
> to repeat on multi-page forms, like shop travelers and packing lists,
> which
> repeat customer and order info on every page but changes line item data?|||You can reference the fields in the reports to do so.
HTH,, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"rs_newbie" <rsnewbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:FE0F30A9-057B-48FB-B8F8-E7158B312724@.microsoft.com...
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get
> fields
> to repeat on multi-page forms, like shop travelers and packing lists,
> which
> repeat customer and order info on every page but changes line item data?|||That is right; you cannot place fields in a page header or footer. To get
round this, put a textbox in the header and use a formula that references a
textbox with the field in the body of the report. For example:
=ReportItems!OrderNumber.Value
The above expression can be placed in the page header or footer. It is
referencing a textbox called OrderNumber. If the textbox displays the field
you want, then the value is also displayed in the textbox that has the above
formula.
Charles Kangai, MCDBA, MCT
"rs_newbie" wrote:
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get fields
> to repeat on multi-page forms, like shop travelers and packing lists, which
> repeat customer and order info on every page but changes line item data?|||Thanks everyone. That works great for a few fields. How about whole tables?
"Charles Kangai" wrote:
> That is right; you cannot place fields in a page header or footer. To get
> round this, put a textbox in the header and use a formula that references a
> textbox with the field in the body of the report. For example:
> =ReportItems!OrderNumber.Value
> The above expression can be placed in the page header or footer. It is
> referencing a textbox called OrderNumber. If the textbox displays the field
> you want, then the value is also displayed in the textbox that has the above
> formula.
> Charles Kangai, MCDBA, MCT
> "rs_newbie" wrote:
> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> > designer friendly interface. So please be patient & simplistic with your
> > responses.
> >
> > If you can't place fields in page headers or footers how can you get fields
> > to repeat on multi-page forms, like shop travelers and packing lists, which
> > repeat customer and order info on every page but changes line item data?|||Generally speaking, you don't need to do this as you can have as many tables
as you want in the body of the report. What is the specific scenario?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> Thanks everyone. That works great for a few fields. How about whole
> tables?
> "Charles Kangai" wrote:
>> That is right; you cannot place fields in a page header or footer. To get
>> round this, put a textbox in the header and use a formula that references
>> a
>> textbox with the field in the body of the report. For example:
>> =ReportItems!OrderNumber.Value
>> The above expression can be placed in the page header or footer. It is
>> referencing a textbox called OrderNumber. If the textbox displays the
>> field
>> you want, then the value is also displayed in the textbox that has the
>> above
>> formula.
>> Charles Kangai, MCDBA, MCT
>> "rs_newbie" wrote:
>> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
>> > designer friendly interface. So please be patient & simplistic with
>> > your
>> > responses.
>> >
>> > If you can't place fields in page headers or footers how can you get
>> > fields
>> > to repeat on multi-page forms, like shop travelers and packing lists,
>> > which
>> > repeat customer and order info on every page but changes line item
>> > data?|||Why the reference doesnt function after a pagebreak?
scenario:
You put the hidden field at the top of the body.
Then you insert a header-field that refere to the hidden field.
Cause the report has a lot of data there will be 2 pages and also 2 header.
The reportItem!Name.Value on the SECOND page has no Value.
Why?
thy, Michele
"Brian Welcker [MSFT]" wrote:
> Generally speaking, you don't need to do this as you can have as many tables
> as you want in the body of the report. What is the specific scenario?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> > Thanks everyone. That works great for a few fields. How about whole
> > tables?
> >
> > "Charles Kangai" wrote:
> >
> >> That is right; you cannot place fields in a page header or footer. To get
> >> round this, put a textbox in the header and use a formula that references
> >> a
> >> textbox with the field in the body of the report. For example:
> >>
> >> =ReportItems!OrderNumber.Value
> >>
> >> The above expression can be placed in the page header or footer. It is
> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> field
> >> you want, then the value is also displayed in the textbox that has the
> >> above
> >> formula.
> >>
> >> Charles Kangai, MCDBA, MCT
> >>
> >> "rs_newbie" wrote:
> >>
> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> >> > designer friendly interface. So please be patient & simplistic with
> >> > your
> >> > responses.
> >> >
> >> > If you can't place fields in page headers or footers how can you get
> >> > fields
> >> > to repeat on multi-page forms, like shop travelers and packing lists,
> >> > which
> >> > repeat customer and order info on every page but changes line item
> >> > data?
>
>|||Because there is no instance of the textbox on the second page. The
ReportItems collection in the page header / footer refer to the items on the
page. I understand this is a limitation. Instead of using the header, could
you use an outer list that repeats on new pages?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michele" <Michele@.discussions.microsoft.com> wrote in message
news:EB1F86BB-A2C6-4487-9C25-DC9ADAD69EB3@.microsoft.com...
> Why the reference doesnt function after a pagebreak?
> scenario:
> You put the hidden field at the top of the body.
> Then you insert a header-field that refere to the hidden field.
> Cause the report has a lot of data there will be 2 pages and also 2
> header.
> The reportItem!Name.Value on the SECOND page has no Value.
> Why?
> thy, Michele
> "Brian Welcker [MSFT]" wrote:
>> Generally speaking, you don't need to do this as you can have as many
>> tables
>> as you want in the body of the report. What is the specific scenario?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
>> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
>> > Thanks everyone. That works great for a few fields. How about whole
>> > tables?
>> >
>> > "Charles Kangai" wrote:
>> >
>> >> That is right; you cannot place fields in a page header or footer. To
>> >> get
>> >> round this, put a textbox in the header and use a formula that
>> >> references
>> >> a
>> >> textbox with the field in the body of the report. For example:
>> >>
>> >> =ReportItems!OrderNumber.Value
>> >>
>> >> The above expression can be placed in the page header or footer. It is
>> >> referencing a textbox called OrderNumber. If the textbox displays the
>> >> field
>> >> you want, then the value is also displayed in the textbox that has the
>> >> above
>> >> formula.
>> >>
>> >> Charles Kangai, MCDBA, MCT
>> >>
>> >> "rs_newbie" wrote:
>> >>
>> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
>> >> > Studio's
>> >> > designer friendly interface. So please be patient & simplistic with
>> >> > your
>> >> > responses.
>> >> >
>> >> > If you can't place fields in page headers or footers how can you get
>> >> > fields
>> >> > to repeat on multi-page forms, like shop travelers and packing
>> >> > lists,
>> >> > which
>> >> > repeat customer and order info on every page but changes line item
>> >> > data?
>>|||The problem is that the body has 5 tables and the detail in one of the tables
can span several pages. The other tables don't repeat after page 1. This is a
problem because the information that makes the job traceable is lost . All
you get is a continuation of the detail from the current table with page
header/footer info.
"Brian Welcker [MSFT]" wrote:
> Generally speaking, you don't need to do this as you can have as many tables
> as you want in the body of the report. What is the specific scenario?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> > Thanks everyone. That works great for a few fields. How about whole
> > tables?
> >
> > "Charles Kangai" wrote:
> >
> >> That is right; you cannot place fields in a page header or footer. To get
> >> round this, put a textbox in the header and use a formula that references
> >> a
> >> textbox with the field in the body of the report. For example:
> >>
> >> =ReportItems!OrderNumber.Value
> >>
> >> The above expression can be placed in the page header or footer. It is
> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> field
> >> you want, then the value is also displayed in the textbox that has the
> >> above
> >> formula.
> >>
> >> Charles Kangai, MCDBA, MCT
> >>
> >> "rs_newbie" wrote:
> >>
> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> >> > designer friendly interface. So please be patient & simplistic with
> >> > your
> >> > responses.
> >> >
> >> > If you can't place fields in page headers or footers how can you get
> >> > fields
> >> > to repeat on multi-page forms, like shop travelers and packing lists,
> >> > which
> >> > repeat customer and order info on every page but changes line item
> >> > data?
>
>|||Can you put the tables in a list and say 'repeat on new page'? If they are
not bound to the same data source, you will need to use a subreport.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> The problem is that the body has 5 tables and the detail in one of the
> tables
> can span several pages. The other tables don't repeat after page 1. This
> is a
> problem because the information that makes the job traceable is lost . All
> you get is a continuation of the detail from the current table with page
> header/footer info.
> "Brian Welcker [MSFT]" wrote:
>> Generally speaking, you don't need to do this as you can have as many
>> tables
>> as you want in the body of the report. What is the specific scenario?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
>> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
>> > Thanks everyone. That works great for a few fields. How about whole
>> > tables?
>> >
>> > "Charles Kangai" wrote:
>> >
>> >> That is right; you cannot place fields in a page header or footer. To
>> >> get
>> >> round this, put a textbox in the header and use a formula that
>> >> references
>> >> a
>> >> textbox with the field in the body of the report. For example:
>> >>
>> >> =ReportItems!OrderNumber.Value
>> >>
>> >> The above expression can be placed in the page header or footer. It is
>> >> referencing a textbox called OrderNumber. If the textbox displays the
>> >> field
>> >> you want, then the value is also displayed in the textbox that has the
>> >> above
>> >> formula.
>> >>
>> >> Charles Kangai, MCDBA, MCT
>> >>
>> >> "rs_newbie" wrote:
>> >>
>> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
>> >> > Studio's
>> >> > designer friendly interface. So please be patient & simplistic with
>> >> > your
>> >> > responses.
>> >> >
>> >> > If you can't place fields in page headers or footers how can you get
>> >> > fields
>> >> > to repeat on multi-page forms, like shop travelers and packing
>> >> > lists,
>> >> > which
>> >> > repeat customer and order info on every page but changes line item
>> >> > data?
>>|||Hello-
Best I can tell this technique (ReportItems!SalesTotal.Value) only
displays data on the first page... fairly worthless for my purposes
anyway...
JCF|||It displays data on every page in which ReportItems!SalesTotal.Value exists.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"CodeFester" <fischerjc@.hotmail.com> wrote in message
news:1114809018.195146.312890@.f14g2000cwb.googlegroups.com...
> Hello-
> Best I can tell this technique (ReportItems!SalesTotal.Value) only
> displays data on the first page... fairly worthless for my purposes
> anyway...
> JCF
>|||Thanks Brian!
The list is working great in Visual Studio. The Preview ,Run and Print
Preview all show a proper rendering of the reports.
However, after deployment, the Report Manager shows several blank data
fields. The print preview is not pulling in the 0.000in margins that I've set
in my report properties. The settings are all 0.500in. If I change them to 0
the preview shows the missing data, and so does the printout. Any ideas?
Is there a way to use the same Preview/Print Preview in Report Manager that
Visual Studio uses?
"Brian Welcker [MSFT]" wrote:
> Can you put the tables in a list and say 'repeat on new page'? If they are
> not bound to the same data source, you will need to use a subreport.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> > The problem is that the body has 5 tables and the detail in one of the
> > tables
> > can span several pages. The other tables don't repeat after page 1. This
> > is a
> > problem because the information that makes the job traceable is lost . All
> > you get is a continuation of the detail from the current table with page
> > header/footer info.
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Generally speaking, you don't need to do this as you can have as many
> >> tables
> >> as you want in the body of the report. What is the specific scenario?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> >> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> >> > Thanks everyone. That works great for a few fields. How about whole
> >> > tables?
> >> >
> >> > "Charles Kangai" wrote:
> >> >
> >> >> That is right; you cannot place fields in a page header or footer. To
> >> >> get
> >> >> round this, put a textbox in the header and use a formula that
> >> >> references
> >> >> a
> >> >> textbox with the field in the body of the report. For example:
> >> >>
> >> >> =ReportItems!OrderNumber.Value
> >> >>
> >> >> The above expression can be placed in the page header or footer. It is
> >> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> >> field
> >> >> you want, then the value is also displayed in the textbox that has the
> >> >> above
> >> >> formula.
> >> >>
> >> >> Charles Kangai, MCDBA, MCT
> >> >>
> >> >> "rs_newbie" wrote:
> >> >>
> >> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
> >> >> > Studio's
> >> >> > designer friendly interface. So please be patient & simplistic with
> >> >> > your
> >> >> > responses.
> >> >> >
> >> >> > If you can't place fields in page headers or footers how can you get
> >> >> > fields
> >> >> > to repeat on multi-page forms, like shop travelers and packing
> >> >> > lists,
> >> >> > which
> >> >> > repeat customer and order info on every page but changes line item
> >> >> > data?
> >>
> >>
> >>
>
>|||Do you have an example of how to get a specific table to repeat on every page
as well as individual fields (that change depending on the group) from a
table?
I'm pretty new to SRS and I need to get up to speed really fast.
Thanks in advance.
"Brian Welcker [MSFT]" wrote:
> Can you put the tables in a list and say 'repeat on new page'? If they are
> not bound to the same data source, you will need to use a subreport.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> > The problem is that the body has 5 tables and the detail in one of the
> > tables
> > can span several pages. The other tables don't repeat after page 1. This
> > is a
> > problem because the information that makes the job traceable is lost . All
> > you get is a continuation of the detail from the current table with page
> > header/footer info.
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Generally speaking, you don't need to do this as you can have as many
> >> tables
> >> as you want in the body of the report. What is the specific scenario?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> >> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> >> > Thanks everyone. That works great for a few fields. How about whole
> >> > tables?
> >> >
> >> > "Charles Kangai" wrote:
> >> >
> >> >> That is right; you cannot place fields in a page header or footer. To
> >> >> get
> >> >> round this, put a textbox in the header and use a formula that
> >> >> references
> >> >> a
> >> >> textbox with the field in the body of the report. For example:
> >> >>
> >> >> =ReportItems!OrderNumber.Value
> >> >>
> >> >> The above expression can be placed in the page header or footer. It is
> >> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> >> field
> >> >> you want, then the value is also displayed in the textbox that has the
> >> >> above
> >> >> formula.
> >> >>
> >> >> Charles Kangai, MCDBA, MCT
> >> >>
> >> >> "rs_newbie" wrote:
> >> >>
> >> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
> >> >> > Studio's
> >> >> > designer friendly interface. So please be patient & simplistic with
> >> >> > your
> >> >> > responses.
> >> >> >
> >> >> > If you can't place fields in page headers or footers how can you get
> >> >> > fields
> >> >> > to repeat on multi-page forms, like shop travelers and packing
> >> >> > lists,
> >> >> > which
> >> >> > repeat customer and order info on every page but changes line item
> >> >> > data?
> >>
> >>
> >>
>
>

No dbo in the database!

Hi All
I have a database where there is no dbo user. There seems
to be some login mismatch that I can't fix up.
The master shows sa (in fact sa is the dbo in another db
on the same server) but sa, dbo does not appear in one of
the other databases and I can't add it.
I've checked out KB 305711 but it doesn't help.
Thanks
JIn Query Analyzer,
USE the database and issue this command:
EXEC sp_changedbowner 'sa'
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:000501c3af13$941724d0$a001280a@.phx.gbl...
> Hi All
> I have a database where there is no dbo user. There seems
> to be some login mismatch that I can't fix up.
> The master shows sa (in fact sa is the dbo in another db
> on the same server) but sa, dbo does not appear in one of
> the other databases and I can't add it.
> I've checked out KB 305711 but it doesn't help.
> Thanks
> J

No dbo for a database - but there are db_owner users

I have a number of user databases who have lost their owner. That is, displaying properties for the database says the owner is unknown.

I assume that any user for such a database that's assigned to the db_owner role can admin everything in this database? Which means that the lack of a dbo doesn't cause any other problem than making it impossible to run a sp_helpdb for the database, or...?

Of course I'd like to make someone the owner, but it seems difficult to make an already existing database user the owner, without dropping the user and re-creating it.Methinks you need sp_changedbowner (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_30s2.asp), which makes the fix trivial anywhere you can execute a stored procedure (such as in Query Analyzer).

-PatP|||Yes, but it doesn't work if the user to be the new owner is already a user in that database. Seems like I need to drop the user and re-create it?|||Yep. Otherwise, SQL Server would have to make a choice about what permissions to grant that user. Especially if that user were dropped from db_owners. The user should see no difference, unless they have created objects under their own username.

No Data returned from OPENQUERY to Active Directory

I am trying to query our active directory for user information, but even
though I get the query to work I am getting no data back. I have a linked
server to the active directory from SQL Server 2000 and I am running the
query in the Query Analyzer.
My query is as follows:
select * from openquery(adsi, 'select name, homephone from
''ldap://DC=mydomain,DC=com'' where objectclass = ''User'' ')
This query will complete without error, but no data is returned. I have
seen one other question of this nature here, but I saw no final resolution.
What is wrong?
Alan
Message posted via http://www.sqlmonster.com
Bruce,
thanks for the response, but I tried what you suggested and still the query
returned no data. It completed without error just no data.
Thanks,
Alan
Message posted via http://www.sqlmonster.com
|||Alan, not sure why youre getting no data back then.
You're sure of the domain name? there's no special
security on your AD to prevent you from accessing? The
linked sever is setup correctly? like so..?
sp_addlinkedserver 'ADSI', 'Active Directory Service
Interfaces', 'ADSDSOObject', 'adsdatasource'
go
Are you sure the data sits in the User ObjectClass?
Might be somewhere else, check it.
There was a max 1000 row limit by default and we had to
have that kicked up to get more then 1000 rows returned.
These links talk about that...
http://support.novell.com/cgi-
bin/search/searchtid.cgi?/10081596.htm
http://www.ldapadministrator.com/for...topic.php?t=14

>--Original Message--
>Bruce,
>thanks for the response, but I tried what you suggested
and still the query
>returned no data. It completed without error just no
data.
>Thanks,
>Alan
>--
>Message posted via http://www.sqlmonster.com
>.
>
|||Bruce,
I ran an export of the data in the user objects using ldifde and got back
exactly what I expected, but the same query in SQL Server Query Analyzer
comes back empty.
I guess it could be something with the link, but it was set up according to
the instructions I found on the web. The link was created in Enterprise
manager, but using the same settings that you specified in the
sp_addlinkedserver statement. It could also be a user security issue, but
I have tried logining in as the admin, SQL Sever admin and myself with no
data back.
Still playing around with it.
Alan
Message posted via http://www.sqlmonster.com
|||Finally, thanks Bruce. I was reading your posting and I was finally able to
pull data.
I'm trying to pull just users that are a member of a certain group, how can
I do that?
This is what I have but not working; however, I was able to used your query
just to get a start and that was a big help.
SELECT *
FROM OPENQUERY( ADSI,
'SELECT cn
FROM ''LDAP://internal/OU=Account
Executives,DC=internal,DC=homequest,DC=com''
WHERE objectClass = ''users''')
GO
"Bruce de Freitas" wrote:

> Alan, not sure if it matters, but I usually do the
> ADIS/LDAP calls more like this format... Check the
> Linked Server also, for correct setup and security. Bruce
>
> SELECT * FROM OPENQUERY( ADSI,'<LDAP://mydomain>;
> ((objectClass=User));distinguishedname,homePhone')
> where distinguishedname like '%a%'
>
> information, but even
> back. I have a linked
> I am running the
> from
> = ''User'' ')
> returned. I have
> no final resolution.
>
|||Sonya, this query would list all the GROUPs.
SELECT * FROM OPENQUERY( adsi,'<ldap://mydomain>;
(&(objectCategory=GROUP)); distinguishedname,CN')
You'd then have to join all the Users to what groups they are in, if
that is what youre trying to do... Bruce
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Thank you, after playing with it for awhile I was able to get it to work.
Do you know if there is a way to extract users' contact folder from the
server-level?
"Bruce de Freitas" wrote:

> Sonya, this query would list all the GROUPs.
> SELECT * FROM OPENQUERY( adsi,'<ldap://mydomain>;
> (&(objectCategory=GROUP)); distinguishedname,CN')
>
> You'd then have to join all the Users to what groups they are in, if
> that is what youre trying to do... Bruce
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>

No Data returned from OPENQUERY to Active Directory

I am trying to query our active directory for user information, but even
though I get the query to work I am getting no data back. I have a linked
server to the active directory from SQL Server 2000 and I am running the
query in the Query Analyzer.
My query is as follows:
select * from openquery(adsi, 'select name, homephone from
''ldap://DC=mydomain,DC=com'' where objectclass = ''User'' ')
This query will complete without error, but no data is returned. I have
seen one other question of this nature here, but I saw no final resolution.
What is wrong?
Alan
--
Message posted via http://www.sqlmonster.comAlan, not sure if it matters, but I usually do the
ADIS/LDAP calls more like this format... Check the
Linked Server also, for correct setup and security. Bruce
SELECT * FROM OPENQUERY( ADSI,'<LDAP://mydomain>;
((objectClass=User));distinguishedname,homePhone')
where distinguishedname like '%a%'
>--Original Message--
>I am trying to query our active directory for user
information, but even
>though I get the query to work I am getting no data
back. I have a linked
>server to the active directory from SQL Server 2000 and
I am running the
>query in the Query Analyzer.
>My query is as follows:
>select * from openquery(adsi, 'select name, homephone
from
>''ldap://DC=mydomain,DC=com'' where objectclass
= ''User'' ')
>This query will complete without error, but no data is
returned. I have
>seen one other question of this nature here, but I saw
no final resolution.
>What is wrong?
>Alan
>--
>Message posted via http://www.sqlmonster.com
>.
>|||Bruce,
thanks for the response, but I tried what you suggested and still the query
returned no data. It completed without error just no data.
Thanks,
Alan
--
Message posted via http://www.sqlmonster.com|||Alan, not sure why youre getting no data back then.
You're sure of the domain name? there's no special
security on your AD to prevent you from accessing? The
linked sever is setup correctly? like so..'
sp_addlinkedserver 'ADSI', 'Active Directory Service
Interfaces', 'ADSDSOObject', 'adsdatasource'
go
Are you sure the data sits in the User ObjectClass?
Might be somewhere else, check it.
There was a max 1000 row limit by default and we had to
have that kicked up to get more then 1000 rows returned.
These links talk about that...
http://support.novell.com/cgi-
bin/search/searchtid.cgi?/10081596.htm
http://www.ldapadministrator.com/forum/viewtopic.php?t=14
>--Original Message--
>Bruce,
>thanks for the response, but I tried what you suggested
and still the query
>returned no data. It completed without error just no
data.
>Thanks,
>Alan
>--
>Message posted via http://www.sqlmonster.com
>.
>|||Bruce,
I ran an export of the data in the user objects using ldifde and got back
exactly what I expected, but the same query in SQL Server Query Analyzer
comes back empty.
I guess it could be something with the link, but it was set up according to
the instructions I found on the web. The link was created in Enterprise
manager, but using the same settings that you specified in the
sp_addlinkedserver statement. It could also be a user security issue, but
I have tried logining in as the admin, SQL Sever admin and myself with no
data back.
Still playing around with it.
Alan
--
Message posted via http://www.sqlmonster.com|||Finally, thanks Bruce. I was reading your posting and I was finally able to
pull data.
I'm trying to pull just users that are a member of a certain group, how can
I do that?
This is what I have but not working; however, I was able to used your query
just to get a start and that was a big help.
SELECT *
FROM OPENQUERY( ADSI,
'SELECT cn
FROM ''LDAP://internal/OU=Account
Executives,DC=internal,DC=homequest,DC=com''
WHERE objectClass = ''users''')
GO
"Bruce de Freitas" wrote:
> Alan, not sure if it matters, but I usually do the
> ADIS/LDAP calls more like this format... Check the
> Linked Server also, for correct setup and security. Bruce
>
> SELECT * FROM OPENQUERY( ADSI,'<LDAP://mydomain>;
> ((objectClass=User));distinguishedname,homePhone')
> where distinguishedname like '%a%'
>
> >--Original Message--
> >I am trying to query our active directory for user
> information, but even
> >though I get the query to work I am getting no data
> back. I have a linked
> >server to the active directory from SQL Server 2000 and
> I am running the
> >query in the Query Analyzer.
> >
> >My query is as follows:
> >
> >select * from openquery(adsi, 'select name, homephone
> from
> >''ldap://DC=mydomain,DC=com'' where objectclass
> = ''User'' ')
> >
> >This query will complete without error, but no data is
> returned. I have
> >seen one other question of this nature here, but I saw
> no final resolution.
> >What is wrong?
> >
> >Alan
> >
> >--
> >Message posted via http://www.sqlmonster.com
> >.
> >
>|||Thank you, after playing with it for awhile I was able to get it to work.
Do you know if there is a way to extract users' contact folder from the
server-level?
"Bruce de Freitas" wrote:
> Sonya, this query would list all the GROUPs.
> SELECT * FROM OPENQUERY( adsi,'<ldap://mydomain>;
> (&(objectCategory=GROUP)); distinguishedname,CN')
>
> You'd then have to join all the Users to what groups they are in, if
> that is what youre trying to do... Bruce
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>sql

No data retuned

Hi,
Does anyone know of a way to show a user that there is no data returned into a report from a query, I am using ASP.NET with reportviewer and if the report does not return data I want to tell the user and not let them wait for no response. Is there a method or property within crystal that I can use?CrystalViewer control provides two functions called GetCurrentPageNumber() and ShowFirstPage(). Using these two functions you could move your cursor to page 1 and then try getting Getcurrentpagenumber or either call GetCurrentPageNumber which if returns 0 then there is no data else there is a data.

Thanks

No compatibilty level 90 option after upgrade from SQL 2000 to 2005

I did an in place upgrade of my SQL 2000 server to SQL 2005.

Now all the system and user databases are set to compatibilty mode 80 and in the options tab there is no compatibilty mode 90 option.

How can I set the databasbes to compatibility mode 90?

Thanks!

Stange thing, did you try using the TSQL command for that ?

sp_dbcmptlevel [ [ @.dbname = ] name ]
[ , [ @.new_cmptlevel = ] version ]
90 = SQL Server 2005

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

No Commit at end of program processing on 2005

Hi All,
I have written some ETL software that allows the user to turn off
autocommit and then set the commit frequency. It is C++ talking via
ODBC.
We are testing on an SQL Server 2005 machine and the behavior we are
seeing is that the rows written after the last commit issued by the
program are not being reflected into the database. These are the
error messages...
It seems like 2005 is not performing a commit when the program
terminates successfully. So rows written between the last commit
issued by the program and program close are not showing up in the
database.
This seems strange as 2000 did issue a commit for these message at the
end of processing...that is...if we used autocommit turned off and
committed every say 10,000 rows...the messages that were written
after the last commmit have always been there...same on oracle and
other databases..
Is there a database level option to make a commit happen at the end of
processing? Or perhaps an option for the MSFT SQL Server ODBC driver
to commit when the connection is closed?
Thanks
Peter
www.peternolan.com
Hi Peter
"Peter Nolan" wrote:

> Hi All,
> I have written some ETL software that allows the user to turn off
> autocommit and then set the commit frequency. It is C++ talking via
> ODBC.
> We are testing on an SQL Server 2005 machine and the behavior we are
> seeing is that the rows written after the last commit issued by the
> program are not being reflected into the database. These are the
> error messages...
> It seems like 2005 is not performing a commit when the program
> terminates successfully. So rows written between the last commit
> issued by the program and program close are not showing up in the
> database.
> This seems strange as 2000 did issue a commit for these message at the
> end of processing...that is...if we used autocommit turned off and
> committed every say 10,000 rows...the messages that were written
> after the last commmit have always been there...same on oracle and
> other databases..
> Is there a database level option to make a commit happen at the end of
> processing? Or perhaps an option for the MSFT SQL Server ODBC driver
> to commit when the connection is closed?
> Thanks
> Peter
> www.peternolan.com
>
I am not sure why you are setting autocommit off!! If you have not
explicitly started a transaction or you are using implicit transaction any
data changed after the transaction (implicitly or explicitly) started will be
rolled back. If you allowed autocommit to be on and you did not explicitly
start the transaction then the data changed will be committed.
I don't think this behaviour has changed, but you it is not good practice to
assume that a feature of the driver is going be a shortcut to handling the
transactions properly.
John

No Commit at end of program processing on 2005

Hi All,
I have written some ETL software that allows the user to turn off
autocommit and then set the commit frequency. It is C++ talking via
ODBC.
We are testing on an SQL Server 2005 machine and the behavior we are
seeing is that the rows written after the last commit issued by the
program are not being reflected into the database. These are the
error messages...
It seems like 2005 is not performing a commit when the program
terminates successfully. So rows written between the last commit
issued by the program and program close are not showing up in the
database.
This seems strange as 2000 did issue a commit for these message at the
end of processing...that is...if we used autocommit turned off and
committed every say 10,000 rows...the messages that were written
after the last commmit have always been there...same on oracle and
other databases..
Is there a database level option to make a commit happen at the end of
processing? Or perhaps an option for the MSFT SQL Server ODBC driver
to commit when the connection is closed?
Thanks
Peter
www.peternolan.comHi Peter
"Peter Nolan" wrote:
> Hi All,
> I have written some ETL software that allows the user to turn off
> autocommit and then set the commit frequency. It is C++ talking via
> ODBC.
> We are testing on an SQL Server 2005 machine and the behavior we are
> seeing is that the rows written after the last commit issued by the
> program are not being reflected into the database. These are the
> error messages...
> It seems like 2005 is not performing a commit when the program
> terminates successfully. So rows written between the last commit
> issued by the program and program close are not showing up in the
> database.
> This seems strange as 2000 did issue a commit for these message at the
> end of processing...that is...if we used autocommit turned off and
> committed every say 10,000 rows...the messages that were written
> after the last commmit have always been there...same on oracle and
> other databases..
> Is there a database level option to make a commit happen at the end of
> processing? Or perhaps an option for the MSFT SQL Server ODBC driver
> to commit when the connection is closed?
> Thanks
> Peter
> www.peternolan.com
>
I am not sure why you are setting autocommit off!! If you have not
explicitly started a transaction or you are using implicit transaction any
data changed after the transaction (implicitly or explicitly) started will be
rolled back. If you allowed autocommit to be on and you did not explicitly
start the transaction then the data changed will be committed.
I don't think this behaviour has changed, but you it is not good practice to
assume that a feature of the driver is going be a shortcut to handling the
transactions properly.
Johnsql

No Commit at end of program processing on 2005

Hi All,
I have written some ETL software that allows the user to turn off
autocommit and then set the commit frequency. It is C++ talking via
ODBC.
We are testing on an SQL Server 2005 machine and the behavior we are
seeing is that the rows written after the last commit issued by the
program are not being reflected into the database. These are the
error messages...
It seems like 2005 is not performing a commit when the program
terminates successfully. So rows written between the last commit
issued by the program and program close are not showing up in the
database.
This seems strange as 2000 did issue a commit for these message at the
end of processing...that is...if we used autocommit turned off and
committed every say 10,000 rows...the messages that were written
after the last commmit have always been there...same on oracle and
other databases..
Is there a database level option to make a commit happen at the end of
processing? Or perhaps an option for the MSFT SQL Server ODBC driver
to commit when the connection is closed?
Thanks
Peter
www.peternolan.comHi Peter
"Peter Nolan" wrote:

> Hi All,
> I have written some ETL software that allows the user to turn off
> autocommit and then set the commit frequency. It is C++ talking via
> ODBC.
> We are testing on an SQL Server 2005 machine and the behavior we are
> seeing is that the rows written after the last commit issued by the
> program are not being reflected into the database. These are the
> error messages...
> It seems like 2005 is not performing a commit when the program
> terminates successfully. So rows written between the last commit
> issued by the program and program close are not showing up in the
> database.
> This seems strange as 2000 did issue a commit for these message at the
> end of processing...that is...if we used autocommit turned off and
> committed every say 10,000 rows...the messages that were written
> after the last commmit have always been there...same on oracle and
> other databases..
> Is there a database level option to make a commit happen at the end of
> processing? Or perhaps an option for the MSFT SQL Server ODBC driver
> to commit when the connection is closed?
> Thanks
> Peter
> www.peternolan.com
>
I am not sure why you are setting autocommit off!! If you have not
explicitly started a transaction or you are using implicit transaction any
data changed after the transaction (implicitly or explicitly) started will b
e
rolled back. If you allowed autocommit to be on and you did not explicitly
start the transaction then the data changed will be committed.
I don't think this behaviour has changed, but you it is not good practice to
assume that a feature of the driver is going be a shortcut to handling the
transactions properly.
John

No Access to the PropertiesTab

Hello Community
I've setup a Reporting Server with different reports and users, most of
the features work fine. I'm now tring to add a user which is able to
modifiy the security roles assignment for his reports. I granted him
Content Manager, but I couldn't even access the PropertiesTab from
Reports or Folders.
Is it possible to grant a user the right to modifiy the security
settings from his reports?
Thanks for any helpFound the Solution: The user need access (at least Browser) to the Root
Folder of Reporting Service..
ulrich@.webrevolution.ch schrieb:
> Hello Community
> I've setup a Reporting Server with different reports and users, most of
> the features work fine. I'm now tring to add a user which is able to
> modifiy the security roles assignment for his reports. I granted him
> Content Manager, but I couldn't even access the PropertiesTab from
> Reports or Folders.
> Is it possible to grant a user the right to modifiy the security
> settings from his reports?
> Thanks for any help

Next step after Access?

I've been an Access user for years designing and running desktop database
app's. My work, however, has taken the size of my Access databases to half a
million records and 1.5GB. Access completely crawls at this level.
Furthermore, I need to perform more statistical analysis that Access seems to
be designed for. I feel like I'm needing to take the next step in database
usage. Unfortunately, there don't seem to be any other "desktop" database
app's that are significantly more capable than Access. Thus, I'm guessing I
need to bite the bullet and begrudgingly buy and learn the server /
enterprise database software. What would be the best one to ease into for a
MS Access user like me? Would it be MS SQL Server Personal, for instance?
What's the learning curve like for an Access user? And finally, will it run
on a desktop computer running Windows XP?
Bill_S wrote:
> I've been an Access user for years designing and running desktop
> database app's. My work, however, has taken the size of my Access
> databases to half a million records and 1.5GB. Access completely
> crawls at this level. Furthermore, I need to perform more statistical
> analysis that Access seems to be designed for. I feel like I'm
> needing to take the next step in database usage. Unfortunately,
> there don't seem to be any other "desktop" database app's that are
> significantly more capable than Access. Thus, I'm guessing I need to
> bite the bullet and begrudgingly buy and learn the server /
> enterprise database software. What would be the best one to ease
> into for a MS Access user like me? Would it be MS SQL Server
> Personal, for instance? What's the learning curve like for an Access
> user? And finally, will it run on a desktop computer running Windows
> XP?
Personal Edition only exists as an add-on for Standard/EE/and Developer.
You can download the MS Data Engine (MSDE) - which is essentially a
stripped down version of SQL Server 2000 without any client tools and a
2GB limit on database size. It may not take you very far, given you're
already at 1.5GB, but at least it's free. You can download the MS Web
Data Administrator to help manage the database.
If this is a development project, you can purchase Developer Edition
from MS for about $50. It's obviously not licensed for use in
production.
You'll need to read about SQL Server to get started. There are number of
good web sites (sqlserverperformance.com, SQLServerCentral.com, etc).
Get a book as well - I prefer Kalen Delaney's Inside SQL Server 2000 -
MS Press.
David Gugick
Imceda Software
www.imceda.com

Next step after Access?

I've been an Access user for years designing and running desktop database
app's. My work, however, has taken the size of my Access databases to half
a
million records and 1.5GB. Access completely crawls at this level.
Furthermore, I need to perform more statistical analysis that Access seems t
o
be designed for. I feel like I'm needing to take the next step in database
usage. Unfortunately, there don't seem to be any other "desktop" database
app's that are significantly more capable than Access. Thus, I'm guessing I
need to bite the bullet and begrudgingly buy and learn the server /
enterprise database software. What would be the best one to ease into for a
MS Access user like me? Would it be MS SQL Server Personal, for instance?
What's the learning curve like for an Access user? And finally, will it run
on a desktop computer running Windows XP?Bill_S wrote:
> I've been an Access user for years designing and running desktop
> database app's. My work, however, has taken the size of my Access
> databases to half a million records and 1.5GB. Access completely
> crawls at this level. Furthermore, I need to perform more statistical
> analysis that Access seems to be designed for. I feel like I'm
> needing to take the next step in database usage. Unfortunately,
> there don't seem to be any other "desktop" database app's that are
> significantly more capable than Access. Thus, I'm guessing I need to
> bite the bullet and begrudgingly buy and learn the server /
> enterprise database software. What would be the best one to ease
> into for a MS Access user like me? Would it be MS SQL Server
> Personal, for instance? What's the learning curve like for an Access
> user? And finally, will it run on a desktop computer running Windows
> XP?
Personal Edition only exists as an add-on for Standard/EE/and Developer.
You can download the MS Data Engine (MSDE) - which is essentially a
stripped down version of SQL Server 2000 without any client tools and a
2GB limit on database size. It may not take you very far, given you're
already at 1.5GB, but at least it's free. You can download the MS Web
Data Administrator to help manage the database.
If this is a development project, you can purchase Developer Edition
from MS for about $50. It's obviously not licensed for use in
production.
You'll need to read about SQL Server to get started. There are number of
good web sites (sqlserverperformance.com, SQLServerCentral.com, etc).
Get a book as well - I prefer Kalen Delaney's Inside SQL Server 2000 -
MS Press.
David Gugick
Imceda Software
www.imceda.com

Next step after Access?

I've been an Access user for years designing and running desktop database
app's. My work, however, has taken the size of my Access databases to half a
million records and 1.5GB. Access completely crawls at this level.
Furthermore, I need to perform more statistical analysis that Access seems to
be designed for. I feel like I'm needing to take the next step in database
usage. Unfortunately, there don't seem to be any other "desktop" database
app's that are significantly more capable than Access. Thus, I'm guessing I
need to bite the bullet and begrudgingly buy and learn the server /
enterprise database software. What would be the best one to ease into for a
MS Access user like me? Would it be MS SQL Server Personal, for instance?
What's the learning curve like for an Access user? And finally, will it run
on a desktop computer running Windows XP?Bill_S wrote:
> I've been an Access user for years designing and running desktop
> database app's. My work, however, has taken the size of my Access
> databases to half a million records and 1.5GB. Access completely
> crawls at this level. Furthermore, I need to perform more statistical
> analysis that Access seems to be designed for. I feel like I'm
> needing to take the next step in database usage. Unfortunately,
> there don't seem to be any other "desktop" database app's that are
> significantly more capable than Access. Thus, I'm guessing I need to
> bite the bullet and begrudgingly buy and learn the server /
> enterprise database software. What would be the best one to ease
> into for a MS Access user like me? Would it be MS SQL Server
> Personal, for instance? What's the learning curve like for an Access
> user? And finally, will it run on a desktop computer running Windows
> XP?
Personal Edition only exists as an add-on for Standard/EE/and Developer.
You can download the MS Data Engine (MSDE) - which is essentially a
stripped down version of SQL Server 2000 without any client tools and a
2GB limit on database size. It may not take you very far, given you're
already at 1.5GB, but at least it's free. You can download the MS Web
Data Administrator to help manage the database.
If this is a development project, you can purchase Developer Edition
from MS for about $50. It's obviously not licensed for use in
production.
You'll need to read about SQL Server to get started. There are number of
good web sites (sqlserverperformance.com, SQLServerCentral.com, etc).
Get a book as well - I prefer Kalen Delaney's Inside SQL Server 2000 -
MS Press.
David Gugick
Imceda Software
www.imceda.com

next 30 days or all values

Hi,
I have a dataset and I need to be able to filter that data based on
Completion Date.
I have created a user parameter is SSRS with the following values:
0 = All Dates
1 = Next 30 days
I am trying to filter my dataset but I don't know how to filter this
based on my user parameter.
Help!
JasonI figured it out
if the user selects "All" then Parameter!Completion.Value = 0
if the user selects "Next 30 Days" then Parameter!Completion.Value = 1
so my filter looks like:
=iif (Parameters!Completion.Value=1, date.Today.AddDays(30),
date.MaxValue)

Newbie:Why this Select doesn't work ?

On ASP.NET 2.0, VB, I try to let user input data on TxtBox1.Text. Then I
would like to go to SQL database named PUBS and compare the "TxtBox1.Text"
against the table "job_id". If the results match, I return on the screen
"Information matched. Your password will be reset".
First, how can I establish the connection to the "pubs" and retrieve such
information ? The code below return error "job_id" not declared. Do I really
have to declare the "job_id" or something else I did is not working ?
rtial Class Default_aspx
Sub btnDefault_Click(ByVal sender As Object, ByVal e As
System.EventArgs)
Dim sConnect As String = ConfigurationSettings.ConnectionStrings_
("pubs").ConnectionString
Dim sSQL As String = "SELECT Employee, " _
& "WHERE job_id = TxtBox1.Text"
End Sub
End Class> Dim sSQL As String = "SELECT Employee, " _
> & "WHERE job_id = TxtBox1.Text"
Your query string should be "Select * from Employee where job_id = '" &
TxtBox1.Text & "'"
"Mr. Magoo" <maggo@.nospasm.com> wrote in message
news:ub3B3mUJFHA.1176@.TK2MSFTNGP12.phx.gbl...
> On ASP.NET 2.0, VB, I try to let user input data on TxtBox1.Text. Then I
> would like to go to SQL database named PUBS and compare the
> "TxtBox1.Text" against the table "job_id". If the results match, I return
> on the screen "Information matched. Your password will be reset".
> First, how can I establish the connection to the "pubs" and retrieve such
> information ? The code below return error "job_id" not declared. Do I
> really have to declare the "job_id" or something else I did is not working
> ?
> rtial Class Default_aspx
> Sub btnDefault_Click(ByVal sender As Object, ByVal e As
> System.EventArgs)
> Dim sConnect As String = ConfigurationSettings.ConnectionStrings_
> ("pubs").ConnectionString
> Dim sSQL As String = "SELECT Employee, " _
> & "WHERE job_id = TxtBox1.Text"
> End Sub
> End Class
>|||There is no From clause in this select statement. You need to specify that.
Dim sSQL As String = "SELECT Employee From Pubs " _
& "WHERE job_id = " & TxtBox1.Text
Thanks
Baiju
"Mr. Magoo" <maggo@.nospasm.com> wrote in message
news:ub3B3mUJFHA.1176@.TK2MSFTNGP12.phx.gbl...
> On ASP.NET 2.0, VB, I try to let user input data on TxtBox1.Text. Then I
> would like to go to SQL database named PUBS and compare the
"TxtBox1.Text"
> against the table "job_id". If the results match, I return on the screen
> "Information matched. Your password will be reset".
> First, how can I establish the connection to the "pubs" and retrieve such
> information ? The code below return error "job_id" not declared. Do I
really
> have to declare the "job_id" or something else I did is not working ?
> rtial Class Default_aspx
> Sub btnDefault_Click(ByVal sender As Object, ByVal e As
> System.EventArgs)
> Dim sConnect As String = ConfigurationSettings.ConnectionStrings_
> ("pubs").ConnectionString
> Dim sSQL As String = "SELECT Employee, " _
> & "WHERE job_id = TxtBox1.Text"
> End Sub
> End Class
>|||You guys are rocking !!
"Baiju" <baiju@.indus-systems.com> wrote in message
news:eBE94EVJFHA.2640@.TK2MSFTNGP09.phx.gbl...
> There is no From clause in this select statement. You need to specify
> that.
> Dim sSQL As String = "SELECT Employee From Pubs " _
> & "WHERE job_id = " & TxtBox1.Text
> Thanks
> Baiju
> "Mr. Magoo" <maggo@.nospasm.com> wrote in message
> news:ub3B3mUJFHA.1176@.TK2MSFTNGP12.phx.gbl...
> "TxtBox1.Text"
> really
>

Newbie: Updating record with User information

Hello,

I have a table that has a UserUpdated field which has a default value of
SUSER_SNAME(). This works great when the record is created, but I'd like to
also update this value when the record is changed. If I understand things
correctly, I'll need a trigger to do this, but I've never created a trigger
before. Is this an easy thing to accomplish?

Thanks!

RickRico (you@.me.com) writes:

Quote:

Originally Posted by

I have a table that has a UserUpdated field which has a default value of
SUSER_SNAME(). This works great when the record is created, but I'd
like to also update this value when the record is changed. If I
understand things correctly, I'll need a trigger to do this, but I've
never created a trigger before. Is this an easy thing to accomplish?

CREATE TRIGGER tbltri ON tbl FOR INSERT,UPDATE AS
UPDATE tbl
SET moduser = SYSTEM_USER
FROM tbl t
JOIN inserted i ON t.pkcol = i.pkcol

SYSTEM_USER is the ANSI version of suser_sname() and easier to spell. :-)

The table "inserted" is a virtual tables that holds the rows that
were inserted or the after-image of the updated rows. There is also
a table "deleted" which holds deleted rows and the before-image of
updated rows.

A trigger fires once per statement, so there can be many rows in these
tables.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||That's excellent! Thank you very much for your help Erland, that was
exactly what I needed! (that will make coding in VB much easier. ;)

Rick

"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
news:Xns98ADF09B38EBDYazorman@.127.0.0.1...

Quote:

Originally Posted by

Rico (you@.me.com) writes:

Quote:

Originally Posted by

>I have a table that has a UserUpdated field which has a default value of
>SUSER_SNAME(). This works great when the record is created, but I'd
>like to also update this value when the record is changed. If I
>understand things correctly, I'll need a trigger to do this, but I've
>never created a trigger before. Is this an easy thing to accomplish?

>
CREATE TRIGGER tbltri ON tbl FOR INSERT,UPDATE AS
UPDATE tbl
SET moduser = SYSTEM_USER
FROM tbl t
JOIN inserted i ON t.pkcol = i.pkcol
>
SYSTEM_USER is the ANSI version of suser_sname() and easier to spell. :-)
>
The table "inserted" is a virtual tables that holds the rows that
were inserted or the after-image of the updated rows. There is also
a table "deleted" which holds deleted rows and the before-image of
updated rows.
>
A trigger fires once per statement, so there can be many rows in these
tables.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||On Jan 3, 4:38 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

Rico (y...@.me.com) writes:

Quote:

Originally Posted by

I have a table that has a UserUpdatedfieldwhich has adefaultvalueof
SUSER_SNAME(). This works great when the record is created, but I'd
like to alsoupdatethisvaluewhen the record is changed. If I
understand things correctly, I'll need a trigger to do this, but I've
never created a trigger before. Is this an easy thing to accomplish?

>
CREATE TRIGGER tbltri ON tbl FOR INSERT,UPDATEASUPDATEtbl
SET moduser = SYSTEM_USER
FROM tbl t
JOIN inserted i ON t.pkcol = i.pkcol
>
SYSTEM_USER is the ANSI version of suser_sname() and easier to spell. :-)
>
The table "inserted" is a virtual tables that holds the rows that
were inserted or the after-image of the updated rows. There is also
a table "deleted" which holds deleted rows and the before-image of
updated rows.
>
A trigger fires once per statement, so there can be many rows in these
tables.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

I've come across this same issue...so I basically have to create a
trigger for each table in my database to update the username/modified
fields on each update. Is there a way to create a global update
trigger that will fire when any table with those fields is updated?

Thanks.
Rayne|||Rayne (wifetalks@.gmail.com) writes:

Quote:

Originally Posted by

I've come across this same issue...so I basically have to create a
trigger for each table in my database to update the username/modified
fields on each update. Is there a way to create a global update
trigger that will fire when any table with those fields is updated?

No, but you could write a program to generate them.

You could also consider third-party tools ApexSql (www.apexsql.com)
has SQL Audit, for instance. I have not tried it myself.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Newbie: I don't understand user permissions for table access

I have a SQL Server database that has database userid/password protection.
When I open the database through EM I can add/delete/modify any table, but
when I look at the permissions for any of the tables there are NO options
set for any user of the database! I don't understand the purpose of the
permissions, I guess, since they don't have to be set in order to get access
to the tables.
TIA,
Larry Woods
wrong
table permissions are important. They are required in order to
access/update/delete data.
HOW are you connecting to SQL Server?
NT Authentication?
SQL Server Authentication?
If SQL Server auth, what account are you using? sa? If so, that is the
"GOD" account. You have full permissions to do anything and everything.
If you are using NT auth, what rights does your NT account have? Is it
assigned server or database roles that allow the activities that you are
performing?
Finally, what rights/permissions have been granted to the PUBLIC role?
Often (unfortunately) companies simply grant all rights to the public
role...and then evey account (SQL and NT) inherit the rights assigned to the
public role. For obvious reasons this is a bad security model.
SQL Server has a strong security model and it works well when it is setup by
someone who knows what they are doing. In the wrong hands...
Keith
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:eM31J1KdEHA.3864@.TK2MSFTNGP10.phx.gbl...
> I have a SQL Server database that has database userid/password protection.
> When I open the database through EM I can add/delete/modify any table, but
> when I look at the permissions for any of the tables there are NO options
> set for any user of the database! I don't understand the purpose of the
> permissions, I guess, since they don't have to be set in order to get
access
> to the tables.
> TIA,
> Larry Woods
>
|||My database is remote to my workstation. I am using EM on the workstation.
The database has a userid/password (not 'sa') but the userid has "public"
and "db_owner" roles. Does the "db_owner" have complete access to all
tables/fields WITHOUT specifying anything in the permissions dialogs?
My "public" role only has "SELECT" and "EXEC" permissions.
Thanks, again.
Larry Woods
And,
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:%23PTfc5KdEHA.3728@.TK2MSFTNGP09.phx.gbl...
> wrong
> table permissions are important. They are required in order to
> access/update/delete data.
> HOW are you connecting to SQL Server?
> NT Authentication?
> SQL Server Authentication?
> If SQL Server auth, what account are you using? sa? If so, that is the
> "GOD" account. You have full permissions to do anything and everything.
> If you are using NT auth, what rights does your NT account have? Is it
> assigned server or database roles that allow the activities that you are
> performing?
> Finally, what rights/permissions have been granted to the PUBLIC role?
> Often (unfortunately) companies simply grant all rights to the public
> role...and then evey account (SQL and NT) inherit the rights assigned to
the
> public role. For obvious reasons this is a bad security model.
> SQL Server has a strong security model and it works well when it is setup
by[vbcol=seagreen]
> someone who knows what they are doing. In the wrong hands...
> --
> Keith
>
> "Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
> news:eM31J1KdEHA.3864@.TK2MSFTNGP10.phx.gbl...
protection.[vbcol=seagreen]
but[vbcol=seagreen]
options
> access
>
|||Correct. The dbo_owner role allows you complete access to everything.
From Books Online
Roles
Fixed database role Description
db_owner Has all permissions in the database.
You can get to this page yourself. right-click on the Books Online icon in
your task bar. Select Jump to URL
enter the following:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\arc
hitec.chm::/8_ar_da_3xns.htm
Keith
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:uNv%23vFLdEHA.3380@.TK2MSFTNGP12.phx.gbl...
> My database is remote to my workstation. I am using EM on the
workstation.[vbcol=seagreen]
> The database has a userid/password (not 'sa') but the userid has "public"
> and "db_owner" roles. Does the "db_owner" have complete access to all
> tables/fields WITHOUT specifying anything in the permissions dialogs?
> My "public" role only has "SELECT" and "EXEC" permissions.
> Thanks, again.
> Larry Woods
> And,
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:%23PTfc5KdEHA.3728@.TK2MSFTNGP09.phx.gbl...
> the
setup[vbcol=seagreen]
> by
> protection.
> but
> options
the
>
|||Hi Larry,
ob_owner means you can do anything to that particular
database. If there are other databases you can attack to
then you may have different access rights.
I would sugest you have a look at
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/architec/8_ar_da_8yur.asp and its sub
groups for a bit of background
Peter
MCDBA

>--Original Message--
>My database is remote to my workstation. I am using EM
on the workstation.
>The database has a userid/password (not 'sa') but the
userid has "public"
>and "db_owner" roles. Does the "db_owner" have complete
access to all
>tables/fields WITHOUT specifying anything in the
permissions dialogs?
>My "public" role only has "SELECT" and "EXEC" permissions.
>Thanks, again.
>Larry Woods
>And,
>"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in
message[vbcol=seagreen]
>news:%23PTfc5KdEHA.3728@.TK2MSFTNGP09.phx.gbl...
order to[vbcol=seagreen]
If so, that is the[vbcol=seagreen]
anything and everything.[vbcol=seagreen]
account have? Is it[vbcol=seagreen]
activities that you are[vbcol=seagreen]
the PUBLIC role?[vbcol=seagreen]
to the public[vbcol=seagreen]
rights assigned to[vbcol=seagreen]
>the
security model.[vbcol=seagreen]
well when it is setup[vbcol=seagreen]
>by
hands...[vbcol=seagreen]
userid/password[vbcol=seagreen]
>protection.
add/delete/modify any table,[vbcol=seagreen]
>but
there are NO[vbcol=seagreen]
>options
the purpose of the[vbcol=seagreen]
in order to get
>
>.
>
|||Thanks for the quick response from all you guys. Now, tackle the other
email that I sent! ;-)
Why can I get to my SQL Server db tables through EM but NOT through a Access
project? In the Access project I can read/select any table in the database,
but no modify/add/delete capabilities.
??
Thanks, again.
Larry Woods
"Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:5c1a01c474b4$b6cba070$a301280a@.phx.gbl...[vbcol=seagreen]
> Hi Larry,
> ob_owner means you can do anything to that particular
> database. If there are other databases you can attack to
> then you may have different access rights.
> I would sugest you have a look at
> http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/architec/8_ar_da_8yur.asp and its sub
> groups for a bit of background
> Peter
> MCDBA
>
> on the workstation.
> userid has "public"
> access to all
> permissions dialogs?
> message
> order to
> If so, that is the
> anything and everything.
> account have? Is it
> activities that you are
> the PUBLIC role?
> to the public
> rights assigned to
> security model.
> well when it is setup
> hands...
> userid/password
> add/delete/modify any table,
> there are NO
> the purpose of the
> in order to get
|||Probably because you do not have permissions in Access to
chenge the database, however in SQL Server you have
db_owner permission that does allow you to.
Peter

>--Original Message--
>Thanks for the quick response from all you guys. Now,
tackle the other
>email that I sent! ;-)
>Why can I get to my SQL Server db tables through EM but
NOT through a Access
>project? In the Access project I can read/select any
table in the database,
>but no modify/add/delete capabilities.
>??
>Thanks, again.
>Larry Woods
>"Peter the Spate" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:5c1a01c474b4$b6cba070$a301280a@.phx.gbl...
complete[vbcol=seagreen]
permissions.[vbcol=seagreen]
in[vbcol=seagreen]
rights[vbcol=seagreen]
message[vbcol=seagreen]
tables[vbcol=seagreen]
understand[vbcol=seagreen]
set
>
>.
>
|||Thanks, Peter.
That may be, but I can't find any place in Access where you can set
permissions.
Any suggestions?
Larry Woods
"Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:5dfb01c474b8$6cc4d560$a501280a@.phx.gbl...[vbcol=seagreen]
> Probably because you do not have permissions in Access to
> chenge the database, however in SQL Server you have
> db_owner permission that does allow you to.
> Peter
>
> tackle the other
> NOT through a Access
> table in the database,
> wrote in message
> complete
> permissions.
> in
> rights
> message
> tables
> understand
> set
|||How do you link your tables? Try using a specific user that has the
appropriate permissions within SQL Server.
Keith
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:elv2x3LdEHA.3792@.TK2MSFTNGP09.phx.gbl...
> Thanks, Peter.
> That may be, but I can't find any place in Access where you can set
> permissions.
> Any suggestions?
> Larry Woods
> "Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
> news:5dfb01c474b8$6cc4d560$a501280a@.phx.gbl...
>