I have a merge replication, the merge agent job failed with:
step 2 :
could not retrieve generation information at the 'Subscriber'. NOTE: The
step was retried the requested number of times (10) without succeeding. The
step failed.
step 3:
The merge agent job failed. The merge process could not retrieve generation
information at the 'Subscriber'. NOTE: The step was retried the requested
number of times (10) without succeeding. The step failed. [SQLSTATE 42000]
(Error 14151). The step failed.
I am not sure what had caused the merge agent to fail but after I restarted
the merge agent , it automatically caught up. I would like to know if there
is a way to automatically re-start the merge agent after the system restored.
Thanks in advance for any help.
Wen Chang
Wen,
I'm not too sure what you mean by setting it off when the system gets
restarted. If you mean have it keep trying, then you could loop the steps in
the merge agent's job. Alternatively you could have it run on a schedule and
not continuously - eg once each minute.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Showing posts with label failed. Show all posts
Showing posts with label failed. Show all posts
Friday, March 30, 2012
Friday, March 9, 2012
How to add FILEGROUP?
Error Message
CREATE / ALTER DATABASE failed because the resulting cumulative database
size would exceed your licensed limit of 2048 MB per database.
Error 1105 Severity 17 State 2
Could not allocate space for object 'INVENTORY_OUT' in database 'INVENTORY'
because the 'PRIMARY' filegroup is full.
Inquiry
How to add SECONDARY filegroup into this database so that it will not exceed
the licensing limit?
Please advise.
Sorry, you won't be able to do it that way. It's the database that's
limited to 2 GB, not each individual filegroup. Find some data to trim
away, archive, or move to another database.
http://www.aspfaq.com/
(Reverse address to reply.)
"Sam" <cybersam88@.hotmail.com> wrote in message
news:#1E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>
|||You must be using MSDE which has a 2GB per db so it doesn't matter how many
files or filegroups you have. You need to upgrade to a licensed version to
go above 2GB per DB.
Andrew J. Kelly SQL MVP
"Sam" <cybersam88@.hotmail.com> wrote in message
news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>
|||I'm using SQL Server 2000 Standard Edition.
I just wonder whether it's really license issue or database per filegroup
issue?
If license issue, then how much SQL Server 2000 Standard Edition could cater
max size of database?
If filegroup, I had been created some which each one max size is 2GB?
Please advise.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> You must be using MSDE which has a 2GB per db so it doesn't matter how
> many
> files or filegroups you have. You need to upgrade to a licensed version
> to
> go above 2GB per DB.
> --
> Andrew J. Kelly SQL MVP
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> 'INVENTORY'
> exceed
>
|||> I'm using SQL Server 2000 Standard Edition.
Judging by that error messages, you are indeed running MSDE. Can you post back the result from:
SELECT @.@.VERSION
SE support 32TB per database file, and sum of about 1,000,000 TB totally for the db.
Your solution is not creating more files or filegroups. It is elsewhere.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
> I'm using SQL Server 2000 Standard Edition.
> I just wonder whether it's really license issue or database per filegroup
> issue?
> If license issue, then how much SQL Server 2000 Standard Edition could cater
> max size of database?
> If filegroup, I had been created some which each one max size is 2GB?
> Please advise.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
>
|||Thanks.
I checked that my server is running MSDE.
I wonder how can it MSDE override MS SQL Standard Edition.
What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Judging by that error messages, you are indeed running MSDE. Can you post
> back the result from:
> SELECT @.@.VERSION
> SE support 32TB per database file, and sum of about 1,000,000 TB totally
> for the db.
> Your solution is not creating more files or filegroups. It is elsewhere.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
>
|||Perhaps you have both MSDE and SQL Server. I.e., two instances installed?
I don't think that you can upgrade MSDE to a "regular" SQL Server, as they have different
installation programs.
So, unless you are indeed working against the incorrect instance, you are looking at backup, remove
MSDE, install SQL Server, and restore. There are lots of issues to consider here (stuff in system
databases like logins etc, collations etc). Search KB for suitable keywords...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7wEVsChEHA.3964@.TK2MSFTNGP12.phx.gbl...
> Thanks.
> I checked that my server is running MSDE.
> I wonder how can it MSDE override MS SQL Standard Edition.
> What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
>
CREATE / ALTER DATABASE failed because the resulting cumulative database
size would exceed your licensed limit of 2048 MB per database.
Error 1105 Severity 17 State 2
Could not allocate space for object 'INVENTORY_OUT' in database 'INVENTORY'
because the 'PRIMARY' filegroup is full.
Inquiry
How to add SECONDARY filegroup into this database so that it will not exceed
the licensing limit?
Please advise.
Sorry, you won't be able to do it that way. It's the database that's
limited to 2 GB, not each individual filegroup. Find some data to trim
away, archive, or move to another database.
http://www.aspfaq.com/
(Reverse address to reply.)
"Sam" <cybersam88@.hotmail.com> wrote in message
news:#1E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>
|||You must be using MSDE which has a 2GB per db so it doesn't matter how many
files or filegroups you have. You need to upgrade to a licensed version to
go above 2GB per DB.
Andrew J. Kelly SQL MVP
"Sam" <cybersam88@.hotmail.com> wrote in message
news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>
|||I'm using SQL Server 2000 Standard Edition.
I just wonder whether it's really license issue or database per filegroup
issue?
If license issue, then how much SQL Server 2000 Standard Edition could cater
max size of database?
If filegroup, I had been created some which each one max size is 2GB?
Please advise.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> You must be using MSDE which has a 2GB per db so it doesn't matter how
> many
> files or filegroups you have. You need to upgrade to a licensed version
> to
> go above 2GB per DB.
> --
> Andrew J. Kelly SQL MVP
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> 'INVENTORY'
> exceed
>
|||> I'm using SQL Server 2000 Standard Edition.
Judging by that error messages, you are indeed running MSDE. Can you post back the result from:
SELECT @.@.VERSION
SE support 32TB per database file, and sum of about 1,000,000 TB totally for the db.
Your solution is not creating more files or filegroups. It is elsewhere.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
> I'm using SQL Server 2000 Standard Edition.
> I just wonder whether it's really license issue or database per filegroup
> issue?
> If license issue, then how much SQL Server 2000 Standard Edition could cater
> max size of database?
> If filegroup, I had been created some which each one max size is 2GB?
> Please advise.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
>
|||Thanks.
I checked that my server is running MSDE.
I wonder how can it MSDE override MS SQL Standard Edition.
What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Judging by that error messages, you are indeed running MSDE. Can you post
> back the result from:
> SELECT @.@.VERSION
> SE support 32TB per database file, and sum of about 1,000,000 TB totally
> for the db.
> Your solution is not creating more files or filegroups. It is elsewhere.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
>
|||Perhaps you have both MSDE and SQL Server. I.e., two instances installed?
I don't think that you can upgrade MSDE to a "regular" SQL Server, as they have different
installation programs.
So, unless you are indeed working against the incorrect instance, you are looking at backup, remove
MSDE, install SQL Server, and restore. There are lots of issues to consider here (stuff in system
databases like logins etc, collations etc). Search KB for suitable keywords...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7wEVsChEHA.3964@.TK2MSFTNGP12.phx.gbl...
> Thanks.
> I checked that my server is running MSDE.
> I wonder how can it MSDE override MS SQL Standard Edition.
> What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
>
How to add FILEGROUP?
Error Message
--
CREATE / ALTER DATABASE failed because the resulting cumulative database
size would exceed your licensed limit of 2048 MB per database.
Error 1105 Severity 17 State 2
Could not allocate space for object 'INVENTORY_OUT' in database 'INVENTORY'
because the 'PRIMARY' filegroup is full.
Inquiry
--
How to add SECONDARY filegroup into this database so that it will not exceed
the licensing limit?
Please advise.Sorry, you won't be able to do it that way. It's the database that's
limited to 2 GB, not each individual filegroup. Find some data to trim
away, archive, or move to another database.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Sam" <cybersam88@.hotmail.com> wrote in message
news:#1E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>|||You must be using MSDE which has a 2GB per db so it doesn't matter how many
files or filegroups you have. You need to upgrade to a licensed version to
go above 2GB per DB.
--
Andrew J. Kelly SQL MVP
"Sam" <cybersam88@.hotmail.com> wrote in message
news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>|||I'm using SQL Server 2000 Standard Edition.
I just wonder whether it's really license issue or database per filegroup
issue?
If license issue, then how much SQL Server 2000 Standard Edition could cater
max size of database?
If filegroup, I had been created some which each one max size is 2GB?
Please advise.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> You must be using MSDE which has a 2GB per db so it doesn't matter how
> many
> files or filegroups you have. You need to upgrade to a licensed version
> to
> go above 2GB per DB.
> --
> Andrew J. Kelly SQL MVP
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
>> Error Message
>> --
>> CREATE / ALTER DATABASE failed because the resulting cumulative database
>> size would exceed your licensed limit of 2048 MB per database.
>> Error 1105 Severity 17 State 2
>> Could not allocate space for object 'INVENTORY_OUT' in database
> 'INVENTORY'
>> because the 'PRIMARY' filegroup is full.
>> Inquiry
>> --
>> How to add SECONDARY filegroup into this database so that it will not
> exceed
>> the licensing limit?
>> Please advise.
>>
>>
>|||> I'm using SQL Server 2000 Standard Edition.
Judging by that error messages, you are indeed running MSDE. Can you post back the result from:
SELECT @.@.VERSION
SE support 32TB per database file, and sum of about 1,000,000 TB totally for the db.
Your solution is not creating more files or filegroups. It is elsewhere.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
> I'm using SQL Server 2000 Standard Edition.
> I just wonder whether it's really license issue or database per filegroup
> issue?
> If license issue, then how much SQL Server 2000 Standard Edition could cater
> max size of database?
> If filegroup, I had been created some which each one max size is 2GB?
> Please advise.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> > You must be using MSDE which has a 2GB per db so it doesn't matter how
> > many
> > files or filegroups you have. You need to upgrade to a licensed version
> > to
> > go above 2GB per DB.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Sam" <cybersam88@.hotmail.com> wrote in message
> > news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> >> Error Message
> >> --
> >> CREATE / ALTER DATABASE failed because the resulting cumulative database
> >> size would exceed your licensed limit of 2048 MB per database.
> >>
> >> Error 1105 Severity 17 State 2
> >> Could not allocate space for object 'INVENTORY_OUT' in database
> > 'INVENTORY'
> >> because the 'PRIMARY' filegroup is full.
> >>
> >> Inquiry
> >> --
> >> How to add SECONDARY filegroup into this database so that it will not
> > exceed
> >> the licensing limit?
> >>
> >> Please advise.
> >>
> >>
> >>
> >>
> >>
> >
> >
>|||Thanks.
I checked that my server is running MSDE.
I wonder how can it MSDE override MS SQL Standard Edition.
What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
>> I'm using SQL Server 2000 Standard Edition.
> Judging by that error messages, you are indeed running MSDE. Can you post
> back the result from:
> SELECT @.@.VERSION
> SE support 32TB per database file, and sum of about 1,000,000 TB totally
> for the db.
> Your solution is not creating more files or filegroups. It is elsewhere.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
>> I'm using SQL Server 2000 Standard Edition.
>> I just wonder whether it's really license issue or database per filegroup
>> issue?
>> If license issue, then how much SQL Server 2000 Standard Edition could
>> cater
>> max size of database?
>> If filegroup, I had been created some which each one max size is 2GB?
>> Please advise.
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
>> > You must be using MSDE which has a 2GB per db so it doesn't matter how
>> > many
>> > files or filegroups you have. You need to upgrade to a licensed
>> > version
>> > to
>> > go above 2GB per DB.
>> >
>> > --
>> > Andrew J. Kelly SQL MVP
>> >
>> >
>> > "Sam" <cybersam88@.hotmail.com> wrote in message
>> > news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
>> >> Error Message
>> >> --
>> >> CREATE / ALTER DATABASE failed because the resulting cumulative
>> >> database
>> >> size would exceed your licensed limit of 2048 MB per database.
>> >>
>> >> Error 1105 Severity 17 State 2
>> >> Could not allocate space for object 'INVENTORY_OUT' in database
>> > 'INVENTORY'
>> >> because the 'PRIMARY' filegroup is full.
>> >>
>> >> Inquiry
>> >> --
>> >> How to add SECONDARY filegroup into this database so that it will not
>> > exceed
>> >> the licensing limit?
>> >>
>> >> Please advise.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>>
>|||Perhaps you have both MSDE and SQL Server. I.e., two instances installed?
I don't think that you can upgrade MSDE to a "regular" SQL Server, as they have different
installation programs.
So, unless you are indeed working against the incorrect instance, you are looking at backup, remove
MSDE, install SQL Server, and restore. There are lots of issues to consider here (stuff in system
databases like logins etc, collations etc). Search KB for suitable keywords...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7wEVsChEHA.3964@.TK2MSFTNGP12.phx.gbl...
> Thanks.
> I checked that my server is running MSDE.
> I wonder how can it MSDE override MS SQL Standard Edition.
> What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
> >> I'm using SQL Server 2000 Standard Edition.
> >
> > Judging by that error messages, you are indeed running MSDE. Can you post
> > back the result from:
> > SELECT @.@.VERSION
> >
> > SE support 32TB per database file, and sum of about 1,000,000 TB totally
> > for the db.
> >
> > Your solution is not creating more files or filegroups. It is elsewhere.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Sam" <cybersam88@.hotmail.com> wrote in message
> > news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
> >> I'm using SQL Server 2000 Standard Edition.
> >>
> >> I just wonder whether it's really license issue or database per filegroup
> >> issue?
> >>
> >> If license issue, then how much SQL Server 2000 Standard Edition could
> >> cater
> >> max size of database?
> >>
> >> If filegroup, I had been created some which each one max size is 2GB?
> >>
> >> Please advise.
> >>
> >>
> >> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> >> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> >> > You must be using MSDE which has a 2GB per db so it doesn't matter how
> >> > many
> >> > files or filegroups you have. You need to upgrade to a licensed
> >> > version
> >> > to
> >> > go above 2GB per DB.
> >> >
> >> > --
> >> > Andrew J. Kelly SQL MVP
> >> >
> >> >
> >> > "Sam" <cybersam88@.hotmail.com> wrote in message
> >> > news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> >> >> Error Message
> >> >> --
> >> >> CREATE / ALTER DATABASE failed because the resulting cumulative
> >> >> database
> >> >> size would exceed your licensed limit of 2048 MB per database.
> >> >>
> >> >> Error 1105 Severity 17 State 2
> >> >> Could not allocate space for object 'INVENTORY_OUT' in database
> >> > 'INVENTORY'
> >> >> because the 'PRIMARY' filegroup is full.
> >> >>
> >> >> Inquiry
> >> >> --
> >> >> How to add SECONDARY filegroup into this database so that it will not
> >> > exceed
> >> >> the licensing limit?
> >> >>
> >> >> Please advise.
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
--
CREATE / ALTER DATABASE failed because the resulting cumulative database
size would exceed your licensed limit of 2048 MB per database.
Error 1105 Severity 17 State 2
Could not allocate space for object 'INVENTORY_OUT' in database 'INVENTORY'
because the 'PRIMARY' filegroup is full.
Inquiry
--
How to add SECONDARY filegroup into this database so that it will not exceed
the licensing limit?
Please advise.Sorry, you won't be able to do it that way. It's the database that's
limited to 2 GB, not each individual filegroup. Find some data to trim
away, archive, or move to another database.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Sam" <cybersam88@.hotmail.com> wrote in message
news:#1E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>|||You must be using MSDE which has a 2GB per db so it doesn't matter how many
files or filegroups you have. You need to upgrade to a licensed version to
go above 2GB per DB.
--
Andrew J. Kelly SQL MVP
"Sam" <cybersam88@.hotmail.com> wrote in message
news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>|||I'm using SQL Server 2000 Standard Edition.
I just wonder whether it's really license issue or database per filegroup
issue?
If license issue, then how much SQL Server 2000 Standard Edition could cater
max size of database?
If filegroup, I had been created some which each one max size is 2GB?
Please advise.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> You must be using MSDE which has a 2GB per db so it doesn't matter how
> many
> files or filegroups you have. You need to upgrade to a licensed version
> to
> go above 2GB per DB.
> --
> Andrew J. Kelly SQL MVP
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
>> Error Message
>> --
>> CREATE / ALTER DATABASE failed because the resulting cumulative database
>> size would exceed your licensed limit of 2048 MB per database.
>> Error 1105 Severity 17 State 2
>> Could not allocate space for object 'INVENTORY_OUT' in database
> 'INVENTORY'
>> because the 'PRIMARY' filegroup is full.
>> Inquiry
>> --
>> How to add SECONDARY filegroup into this database so that it will not
> exceed
>> the licensing limit?
>> Please advise.
>>
>>
>|||> I'm using SQL Server 2000 Standard Edition.
Judging by that error messages, you are indeed running MSDE. Can you post back the result from:
SELECT @.@.VERSION
SE support 32TB per database file, and sum of about 1,000,000 TB totally for the db.
Your solution is not creating more files or filegroups. It is elsewhere.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
> I'm using SQL Server 2000 Standard Edition.
> I just wonder whether it's really license issue or database per filegroup
> issue?
> If license issue, then how much SQL Server 2000 Standard Edition could cater
> max size of database?
> If filegroup, I had been created some which each one max size is 2GB?
> Please advise.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> > You must be using MSDE which has a 2GB per db so it doesn't matter how
> > many
> > files or filegroups you have. You need to upgrade to a licensed version
> > to
> > go above 2GB per DB.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Sam" <cybersam88@.hotmail.com> wrote in message
> > news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> >> Error Message
> >> --
> >> CREATE / ALTER DATABASE failed because the resulting cumulative database
> >> size would exceed your licensed limit of 2048 MB per database.
> >>
> >> Error 1105 Severity 17 State 2
> >> Could not allocate space for object 'INVENTORY_OUT' in database
> > 'INVENTORY'
> >> because the 'PRIMARY' filegroup is full.
> >>
> >> Inquiry
> >> --
> >> How to add SECONDARY filegroup into this database so that it will not
> > exceed
> >> the licensing limit?
> >>
> >> Please advise.
> >>
> >>
> >>
> >>
> >>
> >
> >
>|||Thanks.
I checked that my server is running MSDE.
I wonder how can it MSDE override MS SQL Standard Edition.
What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
>> I'm using SQL Server 2000 Standard Edition.
> Judging by that error messages, you are indeed running MSDE. Can you post
> back the result from:
> SELECT @.@.VERSION
> SE support 32TB per database file, and sum of about 1,000,000 TB totally
> for the db.
> Your solution is not creating more files or filegroups. It is elsewhere.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
>> I'm using SQL Server 2000 Standard Edition.
>> I just wonder whether it's really license issue or database per filegroup
>> issue?
>> If license issue, then how much SQL Server 2000 Standard Edition could
>> cater
>> max size of database?
>> If filegroup, I had been created some which each one max size is 2GB?
>> Please advise.
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
>> > You must be using MSDE which has a 2GB per db so it doesn't matter how
>> > many
>> > files or filegroups you have. You need to upgrade to a licensed
>> > version
>> > to
>> > go above 2GB per DB.
>> >
>> > --
>> > Andrew J. Kelly SQL MVP
>> >
>> >
>> > "Sam" <cybersam88@.hotmail.com> wrote in message
>> > news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
>> >> Error Message
>> >> --
>> >> CREATE / ALTER DATABASE failed because the resulting cumulative
>> >> database
>> >> size would exceed your licensed limit of 2048 MB per database.
>> >>
>> >> Error 1105 Severity 17 State 2
>> >> Could not allocate space for object 'INVENTORY_OUT' in database
>> > 'INVENTORY'
>> >> because the 'PRIMARY' filegroup is full.
>> >>
>> >> Inquiry
>> >> --
>> >> How to add SECONDARY filegroup into this database so that it will not
>> > exceed
>> >> the licensing limit?
>> >>
>> >> Please advise.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>>
>|||Perhaps you have both MSDE and SQL Server. I.e., two instances installed?
I don't think that you can upgrade MSDE to a "regular" SQL Server, as they have different
installation programs.
So, unless you are indeed working against the incorrect instance, you are looking at backup, remove
MSDE, install SQL Server, and restore. There are lots of issues to consider here (stuff in system
databases like logins etc, collations etc). Search KB for suitable keywords...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7wEVsChEHA.3964@.TK2MSFTNGP12.phx.gbl...
> Thanks.
> I checked that my server is running MSDE.
> I wonder how can it MSDE override MS SQL Standard Edition.
> What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
> >> I'm using SQL Server 2000 Standard Edition.
> >
> > Judging by that error messages, you are indeed running MSDE. Can you post
> > back the result from:
> > SELECT @.@.VERSION
> >
> > SE support 32TB per database file, and sum of about 1,000,000 TB totally
> > for the db.
> >
> > Your solution is not creating more files or filegroups. It is elsewhere.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Sam" <cybersam88@.hotmail.com> wrote in message
> > news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
> >> I'm using SQL Server 2000 Standard Edition.
> >>
> >> I just wonder whether it's really license issue or database per filegroup
> >> issue?
> >>
> >> If license issue, then how much SQL Server 2000 Standard Edition could
> >> cater
> >> max size of database?
> >>
> >> If filegroup, I had been created some which each one max size is 2GB?
> >>
> >> Please advise.
> >>
> >>
> >> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> >> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> >> > You must be using MSDE which has a 2GB per db so it doesn't matter how
> >> > many
> >> > files or filegroups you have. You need to upgrade to a licensed
> >> > version
> >> > to
> >> > go above 2GB per DB.
> >> >
> >> > --
> >> > Andrew J. Kelly SQL MVP
> >> >
> >> >
> >> > "Sam" <cybersam88@.hotmail.com> wrote in message
> >> > news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> >> >> Error Message
> >> >> --
> >> >> CREATE / ALTER DATABASE failed because the resulting cumulative
> >> >> database
> >> >> size would exceed your licensed limit of 2048 MB per database.
> >> >>
> >> >> Error 1105 Severity 17 State 2
> >> >> Could not allocate space for object 'INVENTORY_OUT' in database
> >> > 'INVENTORY'
> >> >> because the 'PRIMARY' filegroup is full.
> >> >>
> >> >> Inquiry
> >> >> --
> >> >> How to add SECONDARY filegroup into this database so that it will not
> >> > exceed
> >> >> the licensing limit?
> >> >>
> >> >> Please advise.
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
How to add FILEGROUP?
Error Message
--
CREATE / ALTER DATABASE failed because the resulting cumulative database
size would exceed your licensed limit of 2048 MB per database.
Error 1105 Severity 17 State 2
Could not allocate space for object 'INVENTORY_OUT' in database 'INVENTORY'
because the 'PRIMARY' filegroup is full.
Inquiry
--
How to add SECONDARY filegroup into this database so that it will not exceed
the licensing limit?
Please advise.Sorry, you won't be able to do it that way. It's the database that's
limited to 2 GB, not each individual filegroup. Find some data to trim
away, archive, or move to another database.
http://www.aspfaq.com/
(Reverse address to reply.)
"Sam" <cybersam88@.hotmail.com> wrote in message
news:#1E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>|||You must be using MSDE which has a 2GB per db so it doesn't matter how many
files or filegroups you have. You need to upgrade to a licensed version to
go above 2GB per DB.
Andrew J. Kelly SQL MVP
"Sam" <cybersam88@.hotmail.com> wrote in message
news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>|||I'm using SQL Server 2000 Standard Edition.
I just wonder whether it's really license issue or database per filegroup
issue?
If license issue, then how much SQL Server 2000 Standard Edition could cater
max size of database?
If filegroup, I had been created some which each one max size is 2GB?
Please advise.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> You must be using MSDE which has a 2GB per db so it doesn't matter how
> many
> files or filegroups you have. You need to upgrade to a licensed version
> to
> go above 2GB per DB.
> --
> Andrew J. Kelly SQL MVP
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> 'INVENTORY'
> exceed
>|||> I'm using SQL Server 2000 Standard Edition.
Judging by that error messages, you are indeed running MSDE. Can you post ba
ck the result from:
SELECT @.@.VERSION
SE support 32TB per database file, and sum of about 1,000,000 TB totally for
the db.
Your solution is not creating more files or filegroups. It is elsewhere.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl..
.
> I'm using SQL Server 2000 Standard Edition.
> I just wonder whether it's really license issue or database per filegroup
> issue?
> If license issue, then how much SQL Server 2000 Standard Edition could cat
er
> max size of database?
> If filegroup, I had been created some which each one max size is 2GB?
> Please advise.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
>|||Thanks.
I checked that my server is running MSDE.
I wonder how can it MSDE override MS SQL Standard Edition.
What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Judging by that error messages, you are indeed running MSDE. Can you post
> back the result from:
> SELECT @.@.VERSION
> SE support 32TB per database file, and sum of about 1,000,000 TB totally
> for the db.
> Your solution is not creating more files or filegroups. It is elsewhere.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
>|||Perhaps you have both MSDE and SQL Server. I.e., two instances installed?
I don't think that you can upgrade MSDE to a "regular" SQL Server, as they h
ave different
installation programs.
So, unless you are indeed working against the incorrect instance, you are lo
oking at backup, remove
MSDE, install SQL Server, and restore. There are lots of issues to consider
here (stuff in system
databases like logins etc, collations etc). Search KB for suitable keywords.
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7wEVsChEHA.3964@.TK2MSFTNGP12.phx.gbl..
.
> Thanks.
> I checked that my server is running MSDE.
> I wonder how can it MSDE override MS SQL Standard Edition.
> What's best advise? Uninstall MS SQL and re-install MS SQL Standard Editio
n?
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
>
--
CREATE / ALTER DATABASE failed because the resulting cumulative database
size would exceed your licensed limit of 2048 MB per database.
Error 1105 Severity 17 State 2
Could not allocate space for object 'INVENTORY_OUT' in database 'INVENTORY'
because the 'PRIMARY' filegroup is full.
Inquiry
--
How to add SECONDARY filegroup into this database so that it will not exceed
the licensing limit?
Please advise.Sorry, you won't be able to do it that way. It's the database that's
limited to 2 GB, not each individual filegroup. Find some data to trim
away, archive, or move to another database.
http://www.aspfaq.com/
(Reverse address to reply.)
"Sam" <cybersam88@.hotmail.com> wrote in message
news:#1E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>|||You must be using MSDE which has a 2GB per db so it doesn't matter how many
files or filegroups you have. You need to upgrade to a licensed version to
go above 2GB per DB.
Andrew J. Kelly SQL MVP
"Sam" <cybersam88@.hotmail.com> wrote in message
news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> Error Message
> --
> CREATE / ALTER DATABASE failed because the resulting cumulative database
> size would exceed your licensed limit of 2048 MB per database.
> Error 1105 Severity 17 State 2
> Could not allocate space for object 'INVENTORY_OUT' in database
'INVENTORY'
> because the 'PRIMARY' filegroup is full.
> Inquiry
> --
> How to add SECONDARY filegroup into this database so that it will not
exceed
> the licensing limit?
> Please advise.
>
>
>|||I'm using SQL Server 2000 Standard Edition.
I just wonder whether it's really license issue or database per filegroup
issue?
If license issue, then how much SQL Server 2000 Standard Edition could cater
max size of database?
If filegroup, I had been created some which each one max size is 2GB?
Please advise.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
> You must be using MSDE which has a 2GB per db so it doesn't matter how
> many
> files or filegroups you have. You need to upgrade to a licensed version
> to
> go above 2GB per DB.
> --
> Andrew J. Kelly SQL MVP
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:%231E19P$gEHA.3016@.tk2msftngp13.phx.gbl...
> 'INVENTORY'
> exceed
>|||> I'm using SQL Server 2000 Standard Edition.
Judging by that error messages, you are indeed running MSDE. Can you post ba
ck the result from:
SELECT @.@.VERSION
SE support 32TB per database file, and sum of about 1,000,000 TB totally for
the db.
Your solution is not creating more files or filegroups. It is elsewhere.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl..
.
> I'm using SQL Server 2000 Standard Edition.
> I just wonder whether it's really license issue or database per filegroup
> issue?
> If license issue, then how much SQL Server 2000 Standard Edition could cat
er
> max size of database?
> If filegroup, I had been created some which each one max size is 2GB?
> Please advise.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:O90W85$gEHA.632@.TK2MSFTNGP12.phx.gbl...
>|||Thanks.
I checked that my server is running MSDE.
I wonder how can it MSDE override MS SQL Standard Edition.
What's best advise? Uninstall MS SQL and re-install MS SQL Standard Edition?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Judging by that error messages, you are indeed running MSDE. Can you post
> back the result from:
> SELECT @.@.VERSION
> SE support 32TB per database file, and sum of about 1,000,000 TB totally
> for the db.
> Your solution is not creating more files or filegroups. It is elsewhere.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:elcPylBhEHA.3320@.TK2MSFTNGP11.phx.gbl...
>|||Perhaps you have both MSDE and SQL Server. I.e., two instances installed?
I don't think that you can upgrade MSDE to a "regular" SQL Server, as they h
ave different
installation programs.
So, unless you are indeed working against the incorrect instance, you are lo
oking at backup, remove
MSDE, install SQL Server, and restore. There are lots of issues to consider
here (stuff in system
databases like logins etc, collations etc). Search KB for suitable keywords.
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7wEVsChEHA.3964@.TK2MSFTNGP12.phx.gbl..
.
> Thanks.
> I checked that my server is running MSDE.
> I wonder how can it MSDE override MS SQL Standard Edition.
> What's best advise? Uninstall MS SQL and re-install MS SQL Standard Editio
n?
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23i4QcSChEHA.3928@.TK2MSFTNGP11.phx.gbl...
>
How to Add ASPNET account to your database
This is the error message "Login failed for user 'SUSHMA\ASPNET'. "
I am Building a Data Form that displays data from a single table- the Customers table in the Northwind sample Database.
I have Visual Studio.Net 1.0 and SQL Server 2000.
So I feel that I need to add an ASPNET account to my database.
Please could someone tell me if this could solve the problem, if so
please could you tell me how to Add an ASPNET account to my database?
Thank you
This thread has instructions on how to grant database access to a user account.http://forums.asp.net/875897/ShowPost.aspx
|||
Hi,
Use Enterprise Manager (in SQL Server) to look at the users and groups for the database in question. If you don't see ASPNET there, you can add it, if it is there, it may be that it doesn't have sufficient permissions to do what you are asking it to do. The other thing to check applies if you are using IIS 6 (Win2k3 Server). In this case, ASP.NET uses NETWORK SERVICE, rather than ASPNET as the default worker process.
Hope it helps.
Subscribe to:
Posts (Atom)