sql error: asp

Showing posts with label asp. Show all posts

Monday, March 19, 2012

"User does not have permission to perform this action." problem

hey people

having a nightmare getting asp.net 2.0 to work with sql server 2005 express, bit of a newbie with it. trying to display a table from my sql database and every time i run the aspx table im getting this error.

 User does not have permission to performthis action.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack tracefor more information about the error and where it originatedin the code.Exception Details: System.Data.SqlClient.SqlException: User does not have permission to performthis action.Source Error:An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identifiedusing the exception stack trace below.Stack Trace:[SqlException (0x80131904): User does not have permission to performthis action.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734995 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +41 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

 keep getting the user permission error, even though it says on the management console that i have access to the database

any ideas?

rob

ok the error doesnt tell you that you cant login

the problem is you already login but you cant do action.

can you look your connection string and find out what account are you using.

then check that account's right in your SQL 2005 database,

maybe the right in that account is very small

|||

check if you user have not only rights to connect to database but also right to select from tables you use or execute rights to stored procedures so check database security and your user effective permissions on database objects

Thanks

|||

(having a nightmare getting asp.net 2.0 to work with sql server 2005 express, bit of a newbie with it. trying to display a table from my sql database and every time i run the aspx table im getting this error.)

If you don't have Management Studio you can download it in the first link below and the second link covers how to add object permissions for the Asp.net account post again if you still have question. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/download/

http://forums.asp.net/thread/1492092.aspx

Friday, March 16, 2012

"Timeout expired" error occuring while fetching the data with SQL Server 2000

Hello,
I have one application which is having written inasp.net & plainasp.
I am having one button on asp page,
when i will click on that button, then itwill execute one other asp page.
And after the execution of that second asp page, I redirect it to some
ASPX page with some values.
On the ASPX page, it will connect to the Database, and insert the values.
Thus, sometime, the following error is occuring :
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

Main thing is that i am testing it on my local machine, then also it is giving me this error ...
Insert into statement is also not much complicated :
just I inserted three values in one table.
Is this occuring due to the mixer of asp & aspx??
Plz give me some proper solution.
I want it in efficient manner, because this application will be accessed by number of users at the same time.
Plz help me.

Thanks,
Sandy
Have you been able to pointpint exactly where the bottleneck is occuring? Is the INSERT statement definitely the culprit?
|||Yes...
for insert statement.
But I think this is not creating any matter.
matter is the connection with DB.
This is not occuring everytime.
It's frequancy is 30%.
But for number of users concurrent access, i am not sure is it same or may be increase.
Currently I am using the following connection string :
ConnectionString="Data Source=localhost;Initial Catalog=myDataBase;User ID=test;Password=test;min pool size=1; max pool size=300"

If there is any issue in this string, plz let me know.
Plz give me the feasible solution ASAP.
Thanks,
Sandy
|||I'd use Performance Monitor to check how well your connection pooling is working for you. See this article:Tuning Up ADO.NET Connection Pooling in ASP.NET Applications, in particular the Monitoring Connection Pooling Behavior section

"Timeout expired"

In a legacy project on the production server, we have a database which
generated the following error when executing a report (written in ASP).
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
I then created a SQL dump of this database and exported the tables to Access
MDB file.
Using another test server, I re-created the entire database using the SQL
dump file and imported the data using Access MDB file. Next, I copied the
entire ASP source tree over to this test server.
Lo and behold, when I ran the same report program, it ran successfully!
Could someone tell me why the legacy project running on the production
server caused this timeout error, while the exact same program running on a
test server runs without problem?
Could it be an indexing issue?
Thanks.Ed,
"Ed" <eddiemarino@.hotmail.com> wrote in message
news:OjVEPFt6DHA.2392@.TK2MSFTNGP11.phx.gbl...
> Could someone tell me why the legacy project running on the production
> server caused this timeout error, while the exact same program running on
a
> test server runs without problem?
> Could it be an indexing issue?
Yes, it could be indexing.
It could also be locks, server load, etc.
Dev servers tend to be less busy than production machines, and what works
well in the sandbox might not be so hot when the server's really up against
it.
If you've not done so, start by having ASP developers set a custom timeout
value to something other than the default.
(Assuming, of course, identical schema between test and production <g>)
James Hokes

Sunday, March 11, 2012

"SQL Server does not exist or access denied." after installing XP SP2

Hi!

I just installed Windows XP Service Pack 2 on my pc and I cannot make my asp.net applications access any database any more.

I tried starting the application up from the debugger in vs.net, but I got the same behaviour: I can open the login page but as soon as the application tries to connect to SQLServer I get the "SQL Server does not exist or access denied." error message.

I'm trying to connect with trusted_connection.

Can you guys help me out?Try this Microsoft KB article:

http://support.microsoft.com/default.aspx?kbid=839269|||Hi TechMickey,

Did you find a solution to the problem? As you remember I have the same problem and it is still not working.|||Hi bws,

no, I just removed sp2 :-(|||So you took the drastic step. I disabled the firewall but without improvement. I will do like you, get rid of the whole sp2-thing. until I see a solution.

"SQL Server does not exist or access denied" error message

Hello!

When I start my .aspx with ASP.NET Web Matrix Server, it work, but when i try to start it with IIS I get error message.

TIA,

Misha

What is your connection string to the database like? Are you using a trusted connection? Is IIS running under a different account than Web Matrix? SQL Server needs to know about which accounts are acceptable.

|||string ConnectionString = "server=SERVER;database=pubs;trusted_connection=true";
SQL is on server PC, Web Matrix on Workstation.

"Sql server does not exist or access denied"

Hello,

I am walking step y step with this tour:

http://www.asp.net/webmatrix/tour/section2/createnewdb.aspx

But when I came to this step:

http://www.asp.net/webmatrix/tour/section2/image/22_EnterDbName.jpg

I got the fallowing error message:

Could not create the database.

Sql server does not exist or access denied ConnectionOpen (Connect()).

I just installed:

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

Your help is greatly appreciated.that error is based on the connection string. where's the sql server/msde, and are you using the right login info?

by the way, the angrycoder might be offended you took his name.|||As I mentioned I am using WebMatrix.

- I guess If the name was token I weren't be able to register it! :D|||when you set up your msde/sql server, did you allow for sa passwords? or did you use nt security?|||Never mind... I merly had to reboot my machine!

"Server Application Unavailable" error on generating PDF reports

Hi,
I'm using ASP.NET with SQL Reporting Service to generate PDF reports.
Most of the time it works well.
But sometimes PDF doesn't come out (esp. if the report is complicated),
with the error message at below.
I use 2 separate servers for Web Server / Reporting Service.
And i suspect a cause is not enough memory?
Thanks,
Azul
-- error message --
Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser
to retry your request.
Administrator Note: An error message detailing the cause of this specific
request failure can be found in the application event log of the web server.
Please review this log entry to discover what caused this error to occur.
--.: at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(...)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(...)
at LYNX.ReportServices.ReportingService.Render(...) in ...
at LYNX.BLL.reportServices.getCustomReport(...) in ...
at LYNX.BLL.reportServices.getPDFReport(...) in ...
at LYNX.Components.Report.RunningAverage.PreviewGraph() in ...
-- end of error message --I found the solution from another post in this newsgroup!
Just downloaded and installed Reporting Services SP1, everything works fine
Although the earlier post talked about long long table,
the solution also applies in my case of generating complicated graphs.
"Azul" <a@.b.c> wrote in message
news:ebcX1F1qEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm using ASP.NET with SQL Reporting Service to generate PDF reports.
> Most of the time it works well.
> But sometimes PDF doesn't come out (esp. if the report is complicated),
> with the error message at below.
> I use 2 separate servers for Web Server / Reporting Service.
> And i suspect a cause is not enough memory?
> Thanks,
> Azul
>
> -- error message --
> Server Application Unavailable
> The web application you are attempting to access on this web server is
> currently unavailable. Please hit the "Refresh" button in your web
> browser to retry your request.
> Administrator Note: An error message detailing the cause of this specific
> request failure can be found in the application event log of the web
> server. Please review this log entry to discover what caused this error to
> occur.
> --.: at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(...)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(...)
> at LYNX.ReportServices.ReportingService.Render(...) in ...
> at LYNX.BLL.reportServices.getCustomReport(...) in ...
> at LYNX.BLL.reportServices.getPDFReport(...) in ...
> at LYNX.Components.Report.RunningAverage.PreviewGraph() in ...
> -- end of error message --
>

Thursday, March 8, 2012

"query contained only ignored words "?

When I try to search a word by an ASP web page, it returns error '80040e14
, The query contained only ignored words'. I know the question maybe asked
for many many times and I do search the Internet but cannot find the answer
right for me.
I use Windows 2003 SP1 and SQL server 2000, all are Chinese Simplified
Edition. According to some articles, I empty the noise.chs in the C:
\windows\system32 and C:\Program Files\Common Files\System\MSSearch\Data
\Config, then re-index the fulltext. But the error still exists. Pls help
me, thanks.
Hi. I've got the answer. I add a space to the noise.chs instead of clear
all the content. thanks!
mizi <haha@.haha.com> wrote in
news:Xns9725D5AB6E7B0hahahahacom@.207.46.248.16:

> When I try to search a word by an ASP web page, it returns error
> '80040e14 , The query contained only ignored words'. I know the
> question maybe asked for many many times and I do search the Internet
> but cannot find the answer right for me.
> I use Windows 2003 SP1 and SQL server 2000, all are Chinese Simplified
> Edition. According to some articles, I empty the noise.chs in the C:
> \windows\system32 and C:\Program Files\Common
> Files\System\MSSearch\Data \Config, then re-index the fulltext. But
> the error still exists. Pls help me, thanks.
>

"PRIMARY" filegroup is full

Hello,
We have an SQL Server app written in ASP that suddenly has an error after 2
years of operation, and we're having trouble locating the problem. Here is
the error message below. The reference in the Knowledgebase for this error
doesn't seem to apply to us. There is plenty of space left on the drive. I
believe we're using SP3 of SQL Server 2000. Can anyone point us in the right
direction? Thanks!!
a.. Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for
object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
is full.
/Household.asp, line 298
a.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
a.. Page:
POST 700 bytes to /Household.asp
a.. POST Data:
submitAction=Save&InID=25449&SSN=531067163&FileClo sedDate=&FileNumber=&FirstName=MARY&MiddleInitial= &DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02% 2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
.. . .
You say there is plenty of space left on the disk, but is there a max
size limit set on the file(s) contained in the PRIMARY filegroup? Can
you post the results of this (for your particular DB name that is):
USE <dbname>;
EXEC sp_helpfile;
*mike hodgson*
http://sqlnerd.blogspot.com
Dean J Garrett wrote:

>Hello,
>We have an SQL Server app written in ASP that suddenly has an error after 2
>years of operation, and we're having trouble locating the problem. Here is
>the error message below. The reference in the Knowledgebase for this error
>doesn't seem to apply to us. There is plenty of space left on the drive. I
>believe we're using SP3 of SQL Server 2000. Can anyone point us in the right
>direction? Thanks!!
>
>a.. Error Type:
>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for
>object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
>is full.
>/Household.asp, line 298
>a.. Browser Type:
>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
>a.. Page:
>POST 700 bytes to /Household.asp
>a.. POST Data:
>submitAction=Save&InID=25449&SSN=531067163&FileCl osedDate=&FileNumber=&FirstName=MARY&MiddleInitial =&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02 %2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>.. . .
>
>
|||I would also assume taht the datafile in the filegroup are not setup
for automatic growth.
HTH, Jens Suessmeyer.
|||Hi,
The database properties is set to "Unrestricted Growth" but for some reason when the data file gets to 928MB, we get that error message even though there is plenty of free space on the drive. Why would that happen?
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:Ocs8eJFLGHA.984@.tk2msftngp13.phx.gbl...
You say there is plenty of space left on the disk, but is there a max size limit set on the file(s) contained in the PRIMARY filegroup? Can you post the results of this (for your particular DB name that is):
USE <dbname>;
EXEC sp_helpfile;
mike hodgson
http://sqlnerd.blogspot.com
Dean J Garrett wrote:
Hello,
We have an SQL Server app written in ASP that suddenly has an error after 2
years of operation, and we're having trouble locating the problem. Here is
the error message below. The reference in the Knowledgebase for this error
doesn't seem to apply to us. There is plenty of space left on the drive. I
believe we're using SP3 of SQL Server 2000. Can anyone point us in the right
direction? Thanks!!
a.. Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for
object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
is full.
/Household.asp, line 298
a.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
a.. Page:
POST 700 bytes to /Household.asp
a.. POST Data:
submitAction=Save&InID=25449&SSN=531067163&FileClo sedDate=&FileNumber=&FirstName=MARY&MiddleInitial= &DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02% 2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
... . .
|||THe database is set up for automatic unrestricted growth, and there is
plenty of disk space on the drive. For some reason, whenever the data file
gets to 928MB, we get the error message and can't run the app until we
shrink the database to below 928MB. Why does that happen?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139382110.154689.191800@.o13g2000cwo.googlegr oups.com...
>I would also assume taht the datafile in the filegroup are not setup
> for automatic growth.
> HTH, Jens Suessmeyer.
>
|||"The database"? Which part of the database? Are you talking about the
log file(s)? One of the files in the PRIMARY filegroup? All of the
files in the PRIMARY filegroup? Files in some secondary filegroup?
Can you please post the results of:
EXEC sp_helpfile;
In the DB in question. It's not that we don't trust you, it's just that
we prefer to deal in black & white (this is a troubleshooting process).
*mike hodgson*
http://sqlnerd.blogspot.com
Dean J Garrett wrote:

>THe database is set up for automatic unrestricted growth, and there is
>plenty of disk space on the drive. For some reason, whenever the data file
>gets to 928MB, we get the error message and can't run the app until we
>shrink the database to below 928MB. Why does that happen?
>
>"Jens" <Jens@.sqlserver2005.de> wrote in message
>news:1139382110.154689.191800@.o13g2000cwo.googleg roups.com...
>
>
>
|||Here is the output from sp_helpfile. When I use Enterprise Mgr. and edit the properties for the database "CAA" I see that the Checkbox for "Unrestricted Growth" is checked. There is several GB on the drive, so we thought the database would continue to grow unrestricted until all the space is taken up. Instead we get the error once the CAA_Data.MDF file grows to around 928MB. The only way we can get the ASP application running again is to delete records thus reducing the size of the .MDF file.
CAA_Data
1 F:\MSSQL\Data\CAA_Data.MDF PRIMARY 950272 KB Unlimited 5% data only
CAA_Log
2 F:\MSSQL\Data\CAA_Log.MDF NULL 5120 KB Unlimited 5% log only
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:%23UNbpnQLGHA.3944@.tk2msftngp13.phx.gbl...
"The database"? Which part of the database? Are you talking about the log file(s)? One of the files in the PRIMARY filegroup? All of the files in the PRIMARY filegroup? Files in some secondary filegroup?
Can you please post the results of:
EXEC sp_helpfile;
In the DB in question. It's not that we don't trust you, it's just that we prefer to deal in black & white (this is a troubleshooting process).
mike hodgson
http://sqlnerd.blogspot.com
Dean J Garrett wrote:
THe database is set up for automatic unrestricted growth, and there is
plenty of disk space on the drive. For some reason, whenever the data file
gets to 928MB, we get the error message and can't run the app until we
shrink the database to below 928MB. Why does that happen?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139382110.154689.191800@.o13g2000cwo.googlegr oups.com...
I would also assume taht the datafile in the filegroup are not setup
for automatic growth.
HTH, Jens Suessmeyer.
|||I don't know either.
There are some funky things that Windows sometimes does in the way of
reserving disk space for virtual files, that could be involved.
Have you tried the simple expedient of rebooting the server?
Josh
On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
wrote:
>We have an SQL Server app written in ASP that suddenly has an error after 2
>years of operation, and we're having trouble locating the problem. Here is
>the error message below. The reference in the Knowledgebase for this error
>doesn't seem to apply to us. There is plenty of space left on the drive. I
>believe we're using SP3 of SQL Server 2000. Can anyone point us in the right
>direction? Thanks!!
>
>a.. Error Type:
>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for
>object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
>is full.
>/Household.asp, line 298
>a.. Browser Type:
>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
>a.. Page:
>POST 700 bytes to /Household.asp
>a.. POST Data:
>submitAction=Save&InID=25449&SSN=531067163&FileCl osedDate=&FileNumber=&FirstName=MARY&MiddleInitial =&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02 %2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>. . .
>
|||OH yes, we've tried everything. We keep trimming out records to allow the
app to keep running, but over time (usually just a few days), the MDF file
size grows to that magical limit of around 928MB and then we see the error
again. The drive has 17GB of available storage.
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.4ax.com...
>I don't know either.
> There are some funky things that Windows sometimes does in the way of
> reserving disk space for virtual files, that could be involved.
> Have you tried the simple expedient of rebooting the server?
>
> Josh
>
> On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
> wrote:
>
|||Why would you notice this several times? If the file grow to this limit (and the problem occurs),
then clearly you need a database size > that size. So just expand the database size and monitor so
you have fr ee space. Autogrow has its issues and these things does happen (files doesn't
autogrow -> error message), search the archives for old posts and technical details. So, just expand
the file size manually and you will be fine. Oh, and don't shrink:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dean J Garrett" <info@.amuletc.com> wrote in message news:unlvTmmLGHA.3144@.TK2MSFTNGP11.phx.gbl...
> OH yes, we've tried everything. We keep trimming out records to allow the app to keep running, but
> over time (usually just a few days), the MDF file size grows to that magical limit of around 928MB
> and then we see the error again. The drive has 17GB of available storage.
>
>
> "JXStern" <JXSternChangeX2R@.gte.net> wrote in message
> news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.4ax.com...
>

"PRIMARY" filegroup is full

Hello,
We have an SQL Server app written in ASP that suddenly has an error after 2
years of operation, and we're having trouble locating the problem. Here is
the error message below. The reference in the Knowledgebase for this error
doesn't seem to apply to us. There is plenty of space left on the drive. I
believe we're using SP3 of SQL Server 2000. Can anyone point us in the right
direction? Thanks!!
a.. Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocat
e space for
object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
is full.
/Household.asp, line 298
a.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
a.. Page:
POST 700 bytes to /Household.asp
a.. POST Data:
submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&First
Name=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2F
06%2F2006&EffectiveDate=10%2F17%2F2003&Las
. . .You say there is plenty of space left on the disk, but is there a max
size limit set on the file(s) contained in the PRIMARY filegroup? Can
you post the results of this (for your particular DB name that is):
USE <dbname>;
EXEC sp_helpfile;
*mike hodgson*
http://sqlnerd.blogspot.com
Dean J Garrett wrote:

>Hello,
>We have an SQL Server app written in ASP that suddenly has an error after 2
>years of operation, and we're having trouble locating the problem. Here is
>the error message below. The reference in the Knowledgebase for this error
>doesn't seem to apply to us. There is plenty of space left on the drive. I
>believe we're using SP3 of SQL Server 2000. Can anyone point us in the righ
t
>direction? Thanks!!
>
>a.. Error Type:
>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not alloca
te space for
>object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
>is full.
>/Household.asp, line 298
>a.. Browser Type:
>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
>a.. Page:
>POST 700 bytes to /Household.asp
>a.. POST Data:
>submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&Firs
tName=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2
F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>.. . .
>
>|||I would also assume taht the datafile in the filegroup are not setup
for automatic growth.
HTH, Jens Suessmeyer.|||Hi,
The database properties is set to "Unrestricted Growth" but for some reason
when the data file gets to 928MB, we get that error message even though ther
e is plenty of free space on the drive. Why would that happen?
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:Ocs8eJFLGHA.984@.t
k2msftngp13.phx.gbl...
You say there is plenty of space left on the disk, but is there a max size l
imit set on the file(s) contained in the PRIMARY filegroup? Can you post th
e results of this (for your particular DB name that is):
USE <dbname>;
EXEC sp_helpfile;
mike hodgson
http://sqlnerd.blogspot.com
Dean J Garrett wrote:
Hello,
We have an SQL Server app written in ASP that suddenly has an error after 2
years of operation, and we're having trouble locating the problem. Here is
the error message below. The reference in the Knowledgebase for this error
doesn't seem to apply to us. There is plenty of space left on the drive. I
believe we're using SP3 of SQL Server 2000. Can anyone point us in the right
direction? Thanks!!
a.. Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocat
e space for
object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
is full.
/Household.asp, line 298
a.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
a.. Page:
POST 700 bytes to /Household.asp
a.. POST Data:
submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&First
Name=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2F
06%2F2006&EffectiveDate=10%2F17%2F2003&Las
.. . .|||THe database is set up for automatic unrestricted growth, and there is
plenty of disk space on the drive. For some reason, whenever the data file
gets to 928MB, we get the error message and can't run the app until we
shrink the database to below 928MB. Why does that happen?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139382110.154689.191800@.o13g2000cwo.googlegroups.com...
>I would also assume taht the datafile in the filegroup are not setup
> for automatic growth.
> HTH, Jens Suessmeyer.
>|||"The database"? Which part of the database? Are you talking about the
log file(s)? One of the files in the PRIMARY filegroup? All of the
files in the PRIMARY filegroup? Files in some secondary filegroup?
Can you please post the results of:
EXEC sp_helpfile;
In the DB in question. It's not that we don't trust you, it's just that
we prefer to deal in black & white (this is a troubleshooting process).
*mike hodgson*
http://sqlnerd.blogspot.com
Dean J Garrett wrote:

>THe database is set up for automatic unrestricted growth, and there is
>plenty of disk space on the drive. For some reason, whenever the data file
>gets to 928MB, we get the error message and can't run the app until we
>shrink the database to below 928MB. Why does that happen?
>
>"Jens" <Jens@.sqlserver2005.de> wrote in message
>news:1139382110.154689.191800@.o13g2000cwo.googlegroups.com...
>
>
>|||Here is the output from sp_helpfile. When I use Enterprise Mgr. and edit the
properties for the database "CAA" I see that the Checkbox for "Unrestricted
Growth" is checked. There is several GB on the drive, so we thought the dat
abase would continue to grow unrestricted until all the space is taken up. I
nstead we get the error once the CAA_Data.MDF file grows to around 928MB. Th
e only way we can get the ASP application running again is to delete records
thus reducing the size of the .MDF file.
CAA_Data
1 F:\MSSQL\Data\CAA_Data.MDF PRIMARY 950272 KB Unlimited 5% data only
CAA_Log
2 F:\MSSQL\Data\CAA_Log.MDF NULL 5120 KB Unlimited 5% log only
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:%23UNbpnQLGHA.394
4@.tk2msftngp13.phx.gbl...
"The database"? Which part of the database? Are you talking about the log
file(s)? One of the files in the PRIMARY filegroup? All of the files in th
e PRIMARY filegroup? Files in some secondary filegroup?
Can you please post the results of:
EXEC sp_helpfile;
In the DB in question. It's not that we don't trust you, it's just that we
prefer to deal in black & white (this is a troubleshooting process).
mike hodgson
http://sqlnerd.blogspot.com
Dean J Garrett wrote:
THe database is set up for automatic unrestricted growth, and there is
plenty of disk space on the drive. For some reason, whenever the data file
gets to 928MB, we get the error message and can't run the app until we
shrink the database to below 928MB. Why does that happen?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139382110.154689.191800@.o13g2000cwo.googlegroups.com...
I would also assume taht the datafile in the filegroup are not setup
for automatic growth.
HTH, Jens Suessmeyer.|||I don't know either.
There are some funky things that Windows sometimes does in the way of
reserving disk space for virtual files, that could be involved.
Have you tried the simple expedient of rebooting the server?
Josh
On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
wrote:
>We have an SQL Server app written in ASP that suddenly has an error after 2
>years of operation, and we're having trouble locating the problem. Here is
>the error message below. The reference in the Knowledgebase for this error
>doesn't seem to apply to us. There is plenty of space left on the drive. I
>believe we're using SP3 of SQL Server 2000. Can anyone point us in the righ
t
>direction? Thanks!!
>
>a.. Error Type:
>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not alloca
te space for
>object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
>is full.
>/Household.asp, line 298
>a.. Browser Type:
>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
>a.. Page:
>POST 700 bytes to /Household.asp
>a.. POST Data:
>submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&Firs
tName=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2
F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>. . .
>|||OH yes, we've tried everything. We keep trimming out records to allow the
app to keep running, but over time (usually just a few days), the MDF file
size grows to that magical limit of around 928MB and then we see the error
again. The drive has 17GB of available storage.
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.
4ax.com...
>I don't know either.
> There are some funky things that Windows sometimes does in the way of
> reserving disk space for virtual files, that could be involved.
> Have you tried the simple expedient of rebooting the server?
>
> Josh
>
> On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
> wrote:
>|||Why would you notice this several times? If the file grow to this limit (and
the problem occurs),
then clearly you need a database size > that size. So just expand the databa
se size and monitor so
you have fr ee space. Autogrow has its issues and these things does happen (
files doesn't
autogrow -> error message), search the archives for old posts and technical
details. So, just expand
the file size manually and you will be fine. Oh, and don't shrink:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dean J Garrett" <info@.amuletc.com> wrote in message news:unlvTmmLGHA.3144@.TK2MSFTNGP11.phx.
gbl...
> OH yes, we've tried everything. We keep trimming out records to allow the
app to keep running, but
> over time (usually just a few days), the MDF file size grows to that magic
al limit of around 928MB
> and then we see the error again. The drive has 17GB of available storage.
>
>
> "JXStern" <JXSternChangeX2R@.gte.net> wrote in message
> news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.
4ax.com...
>

"PRIMARY" filegroup is full

Hi,
The database properties is set to ="Unrestricted Growth" but for some reason when the data file gets to 928MB, we get =that error message even though there is plenty of free space on the drive. Why =would that happen?
"Mike Hodgson" wrote =in message news:Ocs8eJFLGHA.984@.t=k2msftngp13.phx.gbl...You say there is plenty of space left on the disk, but is there a max size =limit set on the file(s) contained in the PRIMARY filegroup? Can you =post the results of this (for your particular DB name that is): USE =; EXEC sp_helpfile;
--mike =hodgsonhttp://sqlnerd.blogspot.com Dean J Garrett wrote: Hello,
We have an SQL Server app written in ASP that suddenly has an error =after 2 years of operation, and we're having trouble locating the problem. Here =is the error message below. The reference in the Knowledgebase for this =error doesn't seem to apply to us. There is plenty of space left on the drive. =I believe we're using SP3 of SQL Server 2000. Can anyone point us in the =right direction? Thanks!!
a.. Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space =for object 'tblTabl31' in database 'Database1' because the 'PRIMARY' =filegroup is full.
/Household.asp, line 298
a.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR =1.0.3705)
a.. Page:
POST 700 bytes to /Household.asp
a.. POST Data:
submitAction=3DSave&InID=3D25449&SSN=3D531067163&FileClosedDa=te=3D&FileNumber=3D&FirstName=3DMARY&MiddleInitial=3D&DAP==3D1&LastName=3DTARDIN&SAT=3D101&ApplicationDate=3D02%2F06%2F=2006&EffectiveDate=3D10%2F17%2F2003&Las .. . .

--=_NextPart_000_0007_01C62CB5.99712670--|||THe database is set up for automatic unrestricted growth, and there is
plenty of disk space on the drive. For some reason, whenever the data file
gets to 928MB, we get the error message and can't run the app until we
shrink the database to below 928MB. Why does that happen?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139382110.154689.191800@.o13g2000cwo.googlegroups.com...
>I would also assume taht the datafile in the filegroup are not setup
> for automatic growth.
> HTH, Jens Suessmeyer.
>|||This is a multi-part message in MIME format.
--030903070503060406070405
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
"The database"? Which part of the database? Are you talking about the
log file(s)? One of the files in the PRIMARY filegroup? All of the
files in the PRIMARY filegroup? Files in some secondary filegroup?
Can you please post the results of:
EXEC sp_helpfile;
In the DB in question. It's not that we don't trust you, it's just that
we prefer to deal in black & white (this is a troubleshooting process).
--
*mike hodgson*
http://sqlnerd.blogspot.com
Dean J Garrett wrote:
>THe database is set up for automatic unrestricted growth, and there is
>plenty of disk space on the drive. For some reason, whenever the data file
>gets to 928MB, we get the error message and can't run the app until we
>shrink the database to below 928MB. Why does that happen?
>
>"Jens" <Jens@.sqlserver2005.de> wrote in message
>news:1139382110.154689.191800@.o13g2000cwo.googlegroups.com...
>
>>I would also assume taht the datafile in the filegroup are not setup
>>for automatic growth.
>>HTH, Jens Suessmeyer.
>>
>
>
--030903070503060406070405
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>"The database"? Which part of the database? Are you talking about
the log file(s)? One of the files in the PRIMARY filegroup? All of
the files in the PRIMARY filegroup? Files in some secondary filegroup? 
 
Can you please post the results of: 
</tt><tt> EXEC sp_helpfile; 
In the DB in question. It's not that we don't trust you, it's just
that we prefer to deal in black & white (this is a troubleshooting
process).</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson 
<a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a>

</div>
 
 
Dean J Garrett wrote:
<blockquote cite="midO3v5omPLGHA.2300@.TK2MSFTNGP15.phx.gbl" type="cite">
<pre wrap="">THe database is set up for automatic unrestricted growth, and there is
plenty of disk space on the drive. For some reason, whenever the data file
gets to 928MB, we get the error message and can't run the app until we
shrink the database to below 928MB. Why does that happen?
"Jens" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:Jens@.sqlserver2005.de"><Jens@.sqlserver2005.de></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:1139382110.154689.191800@.o13g2000cwo.googlegroups.com">news:1139382110.154689.191800@.o13g2000cwo.googlegroups.com</a>...
</pre>
<blockquote type="cite">
<pre wrap="">I would also assume taht the datafile in the filegroup are not setup
for automatic growth.
HTH, Jens Suessmeyer.
</pre>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
</body>
</html>
--030903070503060406070405--|||This is a multi-part message in MIME format.
--=_NextPart_000_0007_01C62CD1.B9030E10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Here is the output from sp_helpfile. When I use Enterprise Mgr. and edit =the properties for the database "CAA" I see that the Checkbox for ="Unrestricted Growth" is checked. There is several GB on the drive, so =we thought the database would continue to grow unrestricted until all =the space is taken up. Instead we get the error once the CAA_Data.MDF =file grows to around 928MB. The only way we can get the ASP application =running again is to delete records thus reducing the size of the .MDF =file.
CAA_Data
1 F:\MSSQL\Data\CAA_Data.MDF PRIMARY 950272 KB Unlimited 5% data only
CAA_Log
2 F:\MSSQL\Data\CAA_Log.MDF NULL 5120 KB Unlimited 5% log only
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message =news:%23UNbpnQLGHA.3944@.tk2msftngp13.phx.gbl...
"The database"? Which part of the database? Are you talking about =the log file(s)? One of the files in the PRIMARY filegroup? All of the =files in the PRIMARY filegroup? Files in some secondary filegroup?
Can you please post the results of:
EXEC sp_helpfile;
In the DB in question. It's not that we don't trust you, it's just =that we prefer to deal in black & white (this is a troubleshooting =process).
--
mike hodgson
http://sqlnerd.blogspot.com=20
Dean J Garrett wrote: THe database is set up for automatic unrestricted growth, and there is plenty of disk space on the drive. For some reason, whenever the data =file gets to 928MB, we get the error message and can't run the app until we shrink the database to below 928MB. Why does that happen?
"Jens" <Jens@.sqlserver2005.de> wrote in message news:1139382110.154689.191800@.o13g2000cwo.googlegroups.com...
I would also assume taht the datafile in the filegroup are not setup
for automatic growth.
HTH, Jens Suessmeyer.

--=_NextPart_000_0007_01C62CD1.B9030E10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Here is the output from sp_helpfile. =When I use Enterprise Mgr. and edit the properties for the database "CAA" I see =that the Checkbox for "Unrestricted Growth" is checked. There is several GB on =the drive, so we thought the database would continue to grow unrestricted until all =the space is taken up. Instead we get the error once the CAA_Data.MDF file =grows to around 928MB. The only way we can get the ASP application running again =is to delete records thus reducing the size of the .MDF file.
CAA_Data
1 F:\MSSQL\Data\CAA_Data.MDF PRIMARY 950272 KB =Unlimited 5% data only
CAA_Log
2 F:\MSSQL\Data\CAA_Log.MDF NULL 5120 KB Unlimited =5% log only
"Mike Hodgson" wrote =in message news:%23UNbpnQLGHA.=3944@.tk2msftngp13.phx.gbl..."The database"? Which part of the database? Are you talking =about the log file(s)? One of the files in the PRIMARY filegroup? =All of the files in the PRIMARY filegroup? Files in some secondary filegroup?Can you please post the results of: EXEC sp_helpfile;In the DB in question. It's not that we don't trust you, it's just that we =prefer to deal in black & white (this is a troubleshooting =process).
--mike =hodgsonhttp://sqlnerd.blogspot.com Dean J Garrett wrote: THe database is set up for automatic =unrestricted growth, and there is plenty of disk space on the drive. For some reason, whenever the data =file gets to 928MB, we get the error message and can't run the app until we shrink the database to below 928MB. Why does that happen?
"Jens" =wrote in message news:=1139382110.154689.191800@.o13g2000cwo.googlegroups.com...
I would also assume taht =the datafile in the filegroup are not setup
for automatic growth.
HTH, Jens Suessmeyer.
--=_NextPart_000_0007_01C62CD1.B9030E10--|||I don't know either.
There are some funky things that Windows sometimes does in the way of
reserving disk space for virtual files, that could be involved.
Have you tried the simple expedient of rebooting the server?
Josh
On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
wrote:
>We have an SQL Server app written in ASP that suddenly has an error after 2
>years of operation, and we're having trouble locating the problem. Here is
>the error message below. The reference in the Knowledgebase for this error
>doesn't seem to apply to us. There is plenty of space left on the drive. I
>believe we're using SP3 of SQL Server 2000. Can anyone point us in the right
>direction? Thanks!!
>
>a.. Error Type:
>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for
>object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
>is full.
>/Household.asp, line 298
>a.. Browser Type:
>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
>a.. Page:
>POST 700 bytes to /Household.asp
>a.. POST Data:
>submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&FirstName=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>. . .
>|||OH yes, we've tried everything. We keep trimming out records to allow the
app to keep running, but over time (usually just a few days), the MDF file
size grows to that magical limit of around 928MB and then we see the error
again. The drive has 17GB of available storage.
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.4ax.com...
>I don't know either.
> There are some funky things that Windows sometimes does in the way of
> reserving disk space for virtual files, that could be involved.
> Have you tried the simple expedient of rebooting the server?
>
> Josh
>
> On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
> wrote:
>>We have an SQL Server app written in ASP that suddenly has an error after
>>2
>>years of operation, and we're having trouble locating the problem. Here is
>>the error message below. The reference in the Knowledgebase for this error
>>doesn't seem to apply to us. There is plenty of space left on the drive. I
>>believe we're using SP3 of SQL Server 2000. Can anyone point us in the
>>right
>>direction? Thanks!!
>>
>>a.. Error Type:
>>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space
>>for
>>object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
>>is full.
>>/Household.asp, line 298
>>a.. Browser Type:
>>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
>>a.. Page:
>>POST 700 bytes to /Household.asp
>>a.. POST Data:
>>submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&FirstName=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>>. . .
>|||Why would you notice this several times? If the file grow to this limit (and the problem occurs),
then clearly you need a database size > that size. So just expand the database size and monitor so
you have fr ee space. Autogrow has its issues and these things does happen (files doesn't
autogrow -> error message), search the archives for old posts and technical details. So, just expand
the file size manually and you will be fine. Oh, and don't shrink:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dean J Garrett" <info@.amuletc.com> wrote in message news:unlvTmmLGHA.3144@.TK2MSFTNGP11.phx.gbl...
> OH yes, we've tried everything. We keep trimming out records to allow the app to keep running, but
> over time (usually just a few days), the MDF file size grows to that magical limit of around 928MB
> and then we see the error again. The drive has 17GB of available storage.
>
>
> "JXStern" <JXSternChangeX2R@.gte.net> wrote in message
> news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.4ax.com...
>>I don't know either.
>> There are some funky things that Windows sometimes does in the way of
>> reserving disk space for virtual files, that could be involved.
>> Have you tried the simple expedient of rebooting the server?
>>
>> Josh
>>
>> On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
>> wrote:
>>We have an SQL Server app written in ASP that suddenly has an error after 2
>>years of operation, and we're having trouble locating the problem. Here is
>>the error message below. The reference in the Knowledgebase for this error
>>doesn't seem to apply to us. There is plenty of space left on the drive. I
>>believe we're using SP3 of SQL Server 2000. Can anyone point us in the right
>>direction? Thanks!!
>>
>>a.. Error Type:
>>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for
>>object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
>>is full.
>>/Household.asp, line 298
>>a.. Browser Type:
>>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
>>a.. Page:
>>POST 700 bytes to /Household.asp
>>a.. POST Data:
>>submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&FirstName=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>>. . .
>>
>|||We tried to expand the size, but it won't let us type in a value larger than
1200MB for some reason. I have no idea why since the drive has 17GB is free
space. So our problem is that we must keep deleting records in the database
so the MDF file won't exceed this "magical" limit.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23f2krjnLGHA.2124@.TK2MSFTNGP14.phx.gbl...
> Why would you notice this several times? If the file grow to this limit
> (and the problem occurs), then clearly you need a database size > that
> size. So just expand the database size and monitor so you have fr ee
> space. Autogrow has its issues and these things does happen (files doesn't
> autogrow -> error message), search the archives for old posts and
> technical details. So, just expand the file size manually and you will be
> fine. Oh, and don't shrink:
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:unlvTmmLGHA.3144@.TK2MSFTNGP11.phx.gbl...
>> OH yes, we've tried everything. We keep trimming out records to allow the
>> app to keep running, but over time (usually just a few days), the MDF
>> file size grows to that magical limit of around 928MB and then we see the
>> error again. The drive has 17GB of available storage.
>>
>>
>> "JXStern" <JXSternChangeX2R@.gte.net> wrote in message
>> news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.4ax.com...
>>I don't know either.
>> There are some funky things that Windows sometimes does in the way of
>> reserving disk space for virtual files, that could be involved.
>> Have you tried the simple expedient of rebooting the server?
>>
>> Josh
>>
>> On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
>> wrote:
>>We have an SQL Server app written in ASP that suddenly has an error
>>after 2
>>years of operation, and we're having trouble locating the problem. Here
>>is
>>the error message below. The reference in the Knowledgebase for this
>>error
>>doesn't seem to apply to us. There is plenty of space left on the drive.
>>I
>>believe we're using SP3 of SQL Server 2000. Can anyone point us in the
>>right
>>direction? Thanks!!
>>
>>a.. Error Type:
>>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space
>>for
>>object 'tblTabl31' in database 'Database1' because the 'PRIMARY'
>>filegroup
>>is full.
>>/Household.asp, line 298
>>a.. Browser Type:
>>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
>>1.0.3705)
>>a.. Page:
>>POST 700 bytes to /Household.asp
>>a.. POST Data:
>>submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&FirstName=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>>. . .
>>
>>
>|||Additionally, when we try to manually increase the size, we get the error
message:
Error 5149: MODIFY FILE encountered operating system error 112 (There is not
enough space on the disk) while attempting to expand the physical file. When
we look at the drive, there is 17GB of free space as reported by Windows.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23f2krjnLGHA.2124@.TK2MSFTNGP14.phx.gbl...
> Why would you notice this several times? If the file grow to this limit
> (and the problem occurs), then clearly you need a database size > that
> size. So just expand the database size and monitor so you have fr ee
> space. Autogrow has its issues and these things does happen (files doesn't
> autogrow -> error message), search the archives for old posts and
> technical details. So, just expand the file size manually and you will be
> fine. Oh, and don't shrink:
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:unlvTmmLGHA.3144@.TK2MSFTNGP11.phx.gbl...
>> OH yes, we've tried everything. We keep trimming out records to allow the
>> app to keep running, but over time (usually just a few days), the MDF
>> file size grows to that magical limit of around 928MB and then we see the
>> error again. The drive has 17GB of available storage.
>>
>>
>> "JXStern" <JXSternChangeX2R@.gte.net> wrote in message
>> news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.4ax.com...
>>I don't know either.
>> There are some funky things that Windows sometimes does in the way of
>> reserving disk space for virtual files, that could be involved.
>> Have you tried the simple expedient of rebooting the server?
>>
>> Josh
>>
>> On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
>> wrote:
>>We have an SQL Server app written in ASP that suddenly has an error
>>after 2
>>years of operation, and we're having trouble locating the problem. Here
>>is
>>the error message below. The reference in the Knowledgebase for this
>>error
>>doesn't seem to apply to us. There is plenty of space left on the drive.
>>I
>>believe we're using SP3 of SQL Server 2000. Can anyone point us in the
>>right
>>direction? Thanks!!
>>
>>a.. Error Type:
>>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space
>>for
>>object 'tblTabl31' in database 'Database1' because the 'PRIMARY'
>>filegroup
>>is full.
>>/Household.asp, line 298
>>a.. Browser Type:
>>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
>>1.0.3705)
>>a.. Page:
>>POST 700 bytes to /Household.asp
>>a.. POST Data:
>>submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&FirstName=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>>. . .
>>
>>
>|||> We tried to expand the size, but it won't let us type in a value larger
> than 1200MB for some reason.
What is 'it' referring to? Enterprise Manager? What happens if you run a
statement like this one:
ALTER DATABASE <db_name>
MODIFY FILE
(NAME = <logical_datafile_name>,
SIZE = 5GB);
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:eTxxNspLGHA.3960@.TK2MSFTNGP09.phx.gbl...
> We tried to expand the size, but it won't let us type in a value larger
> than 1200MB for some reason. I have no idea why since the drive has 17GB
> is free space. So our problem is that we must keep deleting records in the
> database so the MDF file won't exceed this "magical" limit.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:%23f2krjnLGHA.2124@.TK2MSFTNGP14.phx.gbl...
>> Why would you notice this several times? If the file grow to this limit
>> (and the problem occurs), then clearly you need a database size > that
>> size. So just expand the database size and monitor so you have fr ee
>> space. Autogrow has its issues and these things does happen (files
>> doesn't autogrow -> error message), search the archives for old posts and
>> technical details. So, just expand the file size manually and you will be
>> fine. Oh, and don't shrink:
>> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Dean J Garrett" <info@.amuletc.com> wrote in message
>> news:unlvTmmLGHA.3144@.TK2MSFTNGP11.phx.gbl...
>> OH yes, we've tried everything. We keep trimming out records to allow
>> the app to keep running, but over time (usually just a few days), the
>> MDF file size grows to that magical limit of around 928MB and then we
>> see the error again. The drive has 17GB of available storage.
>>
>>
>> "JXStern" <JXSternChangeX2R@.gte.net> wrote in message
>> news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.4ax.com...
>>I don't know either.
>> There are some funky things that Windows sometimes does in the way of
>> reserving disk space for virtual files, that could be involved.
>> Have you tried the simple expedient of rebooting the server?
>>
>> Josh
>>
>> On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
>> wrote:
>>We have an SQL Server app written in ASP that suddenly has an error
>>after 2
>>years of operation, and we're having trouble locating the problem. Here
>>is
>>the error message below. The reference in the Knowledgebase for this
>>error
>>doesn't seem to apply to us. There is plenty of space left on the
>>drive. I
>>believe we're using SP3 of SQL Server 2000. Can anyone point us in the
>>right
>>direction? Thanks!!
>>
>>a.. Error Type:
>>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space
>>for
>>object 'tblTabl31' in database 'Database1' because the 'PRIMARY'
>>filegroup
>>is full.
>>/Household.asp, line 298
>>a.. Browser Type:
>>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
>>1.0.3705)
>>a.. Page:
>>POST 700 bytes to /Household.asp
>>a.. POST Data:
>>submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&FirstName=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>>. . .
>>
>>
>|||This is an error thrown from the OS to SQL Server, so you need to investigate why the OS doesn't
think there is more space or allow SQL Server to use more space. Perhaps there's some kind of user
quota (the user being the SQL Server service account)? Or database files being compressed (not
supported)?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dean J Garrett" <info@.amuletc.com> wrote in message news:OROqI0pLGHA.1532@.TK2MSFTNGP12.phx.gbl...
> Additionally, when we try to manually increase the size, we get the error message:
> Error 5149: MODIFY FILE encountered operating system error 112 (There is not enough space on the
> disk) while attempting to expand the physical file. When we look at the drive, there is 17GB of
> free space as reported by Windows.
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23f2krjnLGHA.2124@.TK2MSFTNGP14.phx.gbl...
>> Why would you notice this several times? If the file grow to this limit (and the problem occurs),
>> then clearly you need a database size > that size. So just expand the database size and monitor
>> so you have fr ee space. Autogrow has its issues and these things does happen (files doesn't
>> autogrow -> error message), search the archives for old posts and technical details. So, just
>> expand the file size manually and you will be fine. Oh, and don't shrink:
>> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Dean J Garrett" <info@.amuletc.com> wrote in message
>> news:unlvTmmLGHA.3144@.TK2MSFTNGP11.phx.gbl...
>> OH yes, we've tried everything. We keep trimming out records to allow the app to keep running,
>> but over time (usually just a few days), the MDF file size grows to that magical limit of around
>> 928MB and then we see the error again. The drive has 17GB of available storage.
>>
>>
>> "JXStern" <JXSternChangeX2R@.gte.net> wrote in message
>> news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.4ax.com...
>>I don't know either.
>> There are some funky things that Windows sometimes does in the way of
>> reserving disk space for virtual files, that could be involved.
>> Have you tried the simple expedient of rebooting the server?
>>
>> Josh
>>
>> On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
>> wrote:
>>We have an SQL Server app written in ASP that suddenly has an error after 2
>>years of operation, and we're having trouble locating the problem. Here is
>>the error message below. The reference in the Knowledgebase for this error
>>doesn't seem to apply to us. There is plenty of space left on the drive. I
>>believe we're using SP3 of SQL Server 2000. Can anyone point us in the right
>>direction? Thanks!!
>>
>>a.. Error Type:
>>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for
>>object 'tblTabl31' in database 'Database1' because the 'PRIMARY' filegroup
>>is full.
>>/Household.asp, line 298
>>a.. Browser Type:
>>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)
>>a.. Page:
>>POST 700 bytes to /Household.asp
>>a.. POST Data:
>>submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&FirstName=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>>. . .
>>
>>
>|||If you have enough disk space my guess is you are possibly using another
file system other than NTFS ?
I had a client a while ago that hit this same issue they were using FAT32
and were hitting the max file size limit due to the file system maximum
which in there case i think was 4GB if i remember correctly...
Are you using NTFS?
possibly maybe also some form of disk quota for the user account ?
my 2 cents
HTH
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:usAL8etLGHA.1048@.TK2MSFTNGP10.phx.gbl...
> This is an error thrown from the OS to SQL Server, so you need to
> investigate why the OS doesn't think there is more space or allow SQL
> Server to use more space. Perhaps there's some kind of user quota (the
> user being the SQL Server service account)? Or database files being
> compressed (not supported)?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dean J Garrett" <info@.amuletc.com> wrote in message
> news:OROqI0pLGHA.1532@.TK2MSFTNGP12.phx.gbl...
>> Additionally, when we try to manually increase the size, we get the error
>> message:
>> Error 5149: MODIFY FILE encountered operating system error 112 (There is
>> not enough space on the disk) while attempting to expand the physical
>> file. When we look at the drive, there is 17GB of free space as reported
>> by Windows.
>>
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:%23f2krjnLGHA.2124@.TK2MSFTNGP14.phx.gbl...
>> Why would you notice this several times? If the file grow to this limit
>> (and the problem occurs), then clearly you need a database size > that
>> size. So just expand the database size and monitor so you have fr ee
>> space. Autogrow has its issues and these things does happen (files
>> doesn't autogrow -> error message), search the archives for old posts
>> and technical details. So, just expand the file size manually and you
>> will be fine. Oh, and don't shrink:
>> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Dean J Garrett" <info@.amuletc.com> wrote in message
>> news:unlvTmmLGHA.3144@.TK2MSFTNGP11.phx.gbl...
>> OH yes, we've tried everything. We keep trimming out records to allow
>> the app to keep running, but over time (usually just a few days), the
>> MDF file size grows to that magical limit of around 928MB and then we
>> see the error again. The drive has 17GB of available storage.
>>
>>
>> "JXStern" <JXSternChangeX2R@.gte.net> wrote in message
>> news:dk6nu1hcubrleht1nfc3u7mvcun8i0veoo@.4ax.com...
>>I don't know either.
>> There are some funky things that Windows sometimes does in the way of
>> reserving disk space for virtual files, that could be involved.
>> Have you tried the simple expedient of rebooting the server?
>>
>> Josh
>>
>> On Tue, 7 Feb 2006 17:04:50 -0800, "Dean J Garrett" <info@.amuletc.com>
>> wrote:
>>We have an SQL Server app written in ASP that suddenly has an error
>>after 2
>>years of operation, and we're having trouble locating the problem.
>>Here is
>>the error message below. The reference in the Knowledgebase for this
>>error
>>doesn't seem to apply to us. There is plenty of space left on the
>>drive. I
>>believe we're using SP3 of SQL Server 2000. Can anyone point us in the
>>right
>>direction? Thanks!!
>>
>>a.. Error Type:
>>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate
>>space for
>>object 'tblTabl31' in database 'Database1' because the 'PRIMARY'
>>filegroup
>>is full.
>>/Household.asp, line 298
>>a.. Browser Type:
>>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
>>1.0.3705)
>>a.. Page:
>>POST 700 bytes to /Household.asp
>>a.. POST Data:
>>submitAction=Save&InID=25449&SSN=531067163&FileClosedDate=&FileNumber=&FirstName=MARY&MiddleInitial=&DAP=1&LastName=TARDIN&SAT=101&ApplicationDate=02%2F06%2F2006&EffectiveDate=10%2F17%2F2003&Las
>>. . .
>>
>>
>>
>

Tuesday, March 6, 2012

"NT Authority/NetworkService" not available as a login

Just installed Server 2003 and then SQL server 2000 followed by sp3a and I'm trying to use an ASP.NET program called DNN which wants "NT Authority / NetworkService" user for access to the database. However, "NT Authority / NetworkService" is not showing
up in the database after installation.
Why is this?
How can I fix it?
Thanks
OK...finally, out of frustration, I just pasted in the name 'NT Authority/NetWorkService'
Start at:
SQL Server Enterprise Manager,
Security node,
Logins node (right click and select New Login),
SQL Server Login properties - New Login,
Paste 'NT Authority/NetWorkService' into the 'name field'
The 'NT Authority/NetWorkService' user was created and it also appears to work properly.
|||You did the correct thing, and Dot Net Nuke should now be happy.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oloooooo" <anonymous@.discussions.microsoft.com> wrote in message
news:531707DF-C146-4ED0-A845-978CECF9845C@.microsoft.com...
> Just installed Server 2003 and then SQL server 2000 followed by sp3a and
I'm trying to use an ASP.NET program called DNN which wants "NT Authority /
NetworkService" user for access to the database. However, "NT Authority /
NetworkService" is not showing up in the database after installation.
> Why is this?
> How can I fix it?
> Thanks
>

"NT Authority/NetworkService" not available as a login

Just installed Server 2003 and then SQL server 2000 followed by sp3a and I'm
trying to use an ASP.NET program called DNN which wants "NT Authority / Net
workService" user for access to the database. However, "NT Authority / Netw
orkService" is not showing
up in the database after installation.
Why is this?
How can I fix it?
ThanksOK...finally, out of frustration, I just pasted in the name 'NT Authority/Ne
tWorkService'
Start at:
SQL Server Enterprise Manager,
Security node,
Logins node (right click and select New Login),
SQL Server Login properties - New Login,
Paste 'NT Authority/NetWorkService' into the 'name field'
The 'NT Authority/NetWorkService' user was created and it also appears to wo
rk properly.|||You did the correct thing, and Dot Net Nuke should now be happy.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oloooooo" <anonymous@.discussions.microsoft.com> wrote in message
news:531707DF-C146-4ED0-A845-978CECF9845C@.microsoft.com...
> Just installed Server 2003 and then SQL server 2000 followed by sp3a and
I'm trying to use an ASP.NET program called DNN which wants "NT Authority /
NetworkService" user for access to the database. However, "NT Authority /
NetworkService" is not showing up in the database after installation.
> Why is this?
> How can I fix it?
> Thanks
>

"NT Authority/NetworkService" not available as a login

Just installed Server 2003 and then SQL server 2000 followed by sp3a and I'm trying to use an ASP.NET program called DNN which wants "NT Authority / NetworkService" user for access to the database. However, "NT Authority / NetworkService" is not showing up in the database after installation
Why is this
How can I fix it
ThankOK...finally, out of frustration, I just pasted in the name 'NT Authority/NetWorkService
Start at
SQL Server Enterprise Manager
Security node
Logins node (right click and select New Login)
SQL Server Login properties - New Login
Paste 'NT Authority/NetWorkService' into the 'name field
The 'NT Authority/NetWorkService' user was created and it also appears to work properly.|||You did the correct thing, and Dot Net Nuke should now be happy.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oloooooo" <anonymous@.discussions.microsoft.com> wrote in message
news:531707DF-C146-4ED0-A845-978CECF9845C@.microsoft.com...
> Just installed Server 2003 and then SQL server 2000 followed by sp3a and
I'm trying to use an ASP.NET program called DNN which wants "NT Authority /
NetworkService" user for access to the database. However, "NT Authority /
NetworkService" is not showing up in the database after installation.
> Why is this?
> How can I fix it?
> Thanks
>

Saturday, February 25, 2012

"Login failed for user" on external webhosting

I get the following error message when trying to access SQL server database hosted by Godaddy.com. I've enabled ASP.net 2.0 and setup SQL 2005 schema, followed their directions for the connectionstring and am using the SQL account and password I setup on Godaddy's website to access the SQL database. When I attempt to use the built in create user or login form that I created from visual studio express that works while using sql 2005 express on my localmachine, it gives the following error message:

Login failed for user 'ysatrifecta'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'ysatrifecta'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Login failed for user 'ysatrifecta'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734931
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +3612
System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +305
System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +105
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +453
System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +149
System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +17
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Can anyone help?

I had misspelled the hostname in the connectionstring...doh!

"Login failed for user" error

hi ppl,
I'm having trouble connecting to my database using ASP.NET
I have been getting the error below whenever i try open the connection using connection.open using vb.net

I have this error in when using plain text editor as and even using
the visual studio.nets data tools (sqlconnection,sqldataadapter tool.)
The strange thing is that i can easily preview the data in any table in northwind db using the connections i've created in the solution explorer using visual studio.net.

This is the connection string created by visual studio.net (i also tried to use this connectionstring manually in code)
"initial catalog=Northwind;integrated security=SSPI;persist security info=False;workstation id=COMPI;packet size=4096"

Here is the error (same error for plain text and vs.net):

Login failed for user 'COMPI\ASPNET'
...
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'COMPI\ASPNET'.
...
[SqlException: Login failed for user 'COMPI\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
BegCh12.WebForm1.Page_Load(Object sender, EventArgs e) in C:\BegASPNet\BegCh12\WebForm1.aspx.vb:153
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()...

can someone help pls
Im using sql server 7 sp3, windows xp pro.I may have miss read this so let me restate your problem.

You have an application thaat can view and access data in the NorthWind DB but not the DB your app is written for. If that is true then it sounds like your userid "ASPNET" needs to be granted access to the db in question as well as execute or Select/Delete/Update permissions of all needed objects.|||How do i do what ur saying, is it from SQL server or using Windows XP.
I have just installed sql server and havent done any changes to permission or account (not sure how)?|||Use Enterprise Manager

Open your server, expand Security and then click on Users. right click on your UserID and select properties. Under the Database Access tab click on the Permit check box next to your database. Under the Permit in Database Role, you will want to select public, and probably db_datareader/datawrite OR you can open things up a bit and select db_owner, but I wouldn't use it for very long.

Books Online covers this very well.

Monday, February 13, 2012

"Error!" msg during "setup support files" installation

Windows 2003 Server. Asp.Net 1.1. Sql Server 2000 Sp3a.
"Error!" msg during "setup support files" installation.
Unable to install Reporting Services. Found a couple of users experiencing
the same problem, but no solution :( Any ideas?
/ChrisFirst, check the error log in Event Viewer and see if you can find any
EventID number for your error. That can pinpoint what the error really is.
If it's error 25619, then check if the DTC service is running? Go check in
services.msc for "Distributed Transaction Coordinator".
Even if it says "started", it might not be. I've had some troubles with
installing RS, and the DTC was the culprit.
It's been discussed in this thread:
http://groups.google.com/groups?hl=en&lr=&threadm=89FD4D17-1F6A-4BCF-A15E-CF098C5A68D7%40microsoft.com&rnum=1
In this thread, Pitroda asks about a password for Network Service. Just
leave the password blank, at least that worked for me.
Kaisa M. Lindahl
"Chris Leaf" <ChrisLeaf@.discussions.microsoft.com> wrote in message
news:E6F567CB-08C9-4B49-8544-9DB32826CC09@.microsoft.com...
> Windows 2003 Server. Asp.Net 1.1. Sql Server 2000 Sp3a.
> "Error!" msg during "setup support files" installation.
> Unable to install Reporting Services. Found a couple of users experiencing
> the same problem, but no solution :( Any ideas?
> /Chris|||Event log says:
"Product: Microsoft SQL Server 2000 Reporting Services Enterprise Edition --
Please install SQL Server by running setup.exe."
and
"Product: Microsoft SQL Server 2000 Reporting Services Enterprise Edition --
Installation failed."
install log ends with:
<Func Name='SqlSetupFilesComp::Install'>
<Func Name='BootstrapPackageLogic'>
<Func Name='InstallBootstrapPackage'>
/I "D:\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033" /qn
<EndFunc Name='InstallBootstrapPackage' Return='1603' GetLastError='183'>
<EndFunc Name='BootstrapPackageLogic' Return='1603' GetLastError='183'>
SqlSetupFilesComp BootstrapPackageLogic() failed : (1603)
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\customcomps.cpp:565}
SCU_SetupMgr::svc() caught exception: SqlSetupFilesComp
BootstrapPackageLogic() failed : (1603)
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\customcomps.cpp:565}. SetupMgr:
state=ERROR, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=D:
QuietMode=false
Unattended=false
WorkDir=D:
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:428}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
<EndFunc Name='UpdateComponents' Return='1602' GetLastError='0'>
DTC is running..
Thanks for your response.
"Kaisa M. Lindahl" wrote:
> First, check the error log in Event Viewer and see if you can find any
> EventID number for your error. That can pinpoint what the error really is.
> If it's error 25619, then check if the DTC service is running? Go check in
> services.msc for "Distributed Transaction Coordinator".
> Even if it says "started", it might not be. I've had some troubles with
> installing RS, and the DTC was the culprit.
> It's been discussed in this thread:
> http://groups.google.com/groups?hl=en&lr=&threadm=89FD4D17-1F6A-4BCF-A15E-CF098C5A68D7%40microsoft.com&rnum=1
> In this thread, Pitroda asks about a password for Network Service. Just
> leave the password blank, at least that worked for me.
> Kaisa M. Lindahl
> "Chris Leaf" <ChrisLeaf@.discussions.microsoft.com> wrote in message
> news:E6F567CB-08C9-4B49-8544-9DB32826CC09@.microsoft.com...
> > Windows 2003 Server. Asp.Net 1.1. Sql Server 2000 Sp3a.
> >
> > "Error!" msg during "setup support files" installation.
> > Unable to install Reporting Services. Found a couple of users experiencing
> > the same problem, but no solution :( Any ideas?
> >
> > /Chris
>
>

Monday, March 19, 2012

"User does not have permission to perform this action." problem

Friday, March 16, 2012

"Timeout expired" error occuring while fetching the data with SQL Server 2000

"Timeout expired"

Sunday, March 11, 2012

"SQL Server does not exist or access denied." after installing XP SP2

"SQL Server does not exist or access denied" error message

"Sql server does not exist or access denied"

"Server Application Unavailable" error on generating PDF reports

Thursday, March 8, 2012

"query contained only ignored words "?

"PRIMARY" filegroup is full

"PRIMARY" filegroup is full

"PRIMARY" filegroup is full

Tuesday, March 6, 2012

"NT Authority/NetworkService" not available as a login

"NT Authority/NetworkService" not available as a login

"NT Authority/NetworkService" not available as a login

Saturday, February 25, 2012

"Login failed for user" on external webhosting

"Login failed for user" error

Monday, February 13, 2012

"Error!" msg during "setup support files" installation

sql error

Blog Archive

About Me