Automatic Fix For Tempdb Error Related To 'ASPStateTempSessions'?
Dec 1, 2010
As per this how-to, I've successfully configured IIS on my XP-SP3 dev box for SQL Server 2008 Express to save ASP.NET session state information. I'm just using SQL Server because otherwise on every recompile, I was losing the session state which was obnoxious (having to re-login). But, I'm facing an annoying issue in that every time I restart SQL there's this error, and sometimes one or two other very similar friends:The SELECT permission was denied on the object 'ASPStateTempSessions',database 'tempdb', schema 'dbo'.To fix the error, I just open Management Studio and edit the User Mapping for the login/dbo I'm using on the ASPState db, and re-add tempdb to that user with all but deny permissions. Apparently, once the right permissions are there, ASP.NET is able to automatically create the tables it uses. It just can't run that CreateTempTables sproc until the right security is there.HE QUESTION...Is there a way to not have to re-do this on every restart of the SQL Server?I don't really care right now about keeping the temp data across restarts, but I would like to not have to go through this manual step just to get my web app working on localhost, which uses session state variables throughout. I suppose one could resort to some kind of stored procedure within SQL Server to accomplish the task for this machine when the service starts, to not have to do it manually. I'd accept such an answer as a quick fix. But, I'm also assuming there's a better recommended configuration or something. Not seeing an answer to this on the how-to guide or elsewhere here on StackOverflow.
View 1 Replies
Similar Messages:
Feb 25, 2010
am a vb.net programmer. I created following stored procedure on SQL Server 2000:-
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[sp_GetLocations]
-- Add the parameters for the stored procedure here
(
@loc_required int
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
declare @gaps table (id int identity(1, 1),Lct varchar(10), locid int)
insert into @gaps(Lct, locid)
select location, id from location where filled =0 order by id
declare @templocation table(from_cell varchar(10),to_cell varchar(10),no_of_free_cells int)
insert into @templocation
select g1.Lct as 'from cell', g2.Lct as 'to cell' , [number of free cells] from
(select min(locid) as 'from_cell' , max (locid) 'to_cell' , count(Lct) as 'number of free cells' from @gaps
group by left(lct, 1), locid-id ) x
inner join @gaps g1 on x.from_cell = g1.locid
inner join @gaps g2 on x.to_cell = g2.locid
declare @finallocation table(from_cell varchar(10),to_cell varchar(10),no_of_free_cells int)
insert into @finallocation
select * from @templocation where no_of_free_cells >= @loc_required order by no_of_free_cells,from_cell
select top 1 * from @finallocation
END
GO
And now me application gives me following error:-
Exception type: System.Data.SqlClient.SqlException
ExceptionMessage: Warning: Fatal error 9001 occurred at Feb 24 2010 9:27PMက催՛ꁄ ꀸ ꁸ 灴Ʋꁄ ꀸ . Note the error and time, and contact your system administrator.
Source: .Net SqlClient Data Provider
StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Location.findlocations(Int32 loc_required) in D:InetpubwwwrootAssemblyPartsApp_CodeLocation.vb:line 23
at RotorAssemby.gvRotor_RowCommand(Object sender, GridViewCommandEventArgs e) in D:InetpubwwwrootAssemblyPartsRotorAssembly.aspx.vb:line 263
It seems like my stroed procedure is corrupting tempdb database. It was just my guess. I wanted to make sure from SQL experts. Please help me here, it is blow up my whole sql server. I had to restart it.
View 2 Replies
May 25, 2010
I am REALLY stuck with this and need a solution in the next 24 hours .i I have uploaded my asp.net web application to the web and have the database and connection strings functioning and reading the data from the database. But when I try to write to the DB
I get the following error :
Server Error in '/' Application.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that
SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
The wierd thing about this is the connection strings work from the local machine when I run from Visual Studio and I can write to the DB there, I just cannot write to the DB from the URL.
I am pretty new to asp.net but I am sure it has to be something to do with the web.config.
View 5 Replies
Sep 8, 2010
I am trying to create a simple login page in ASP.NET C# but am getting some error.
I googled about the error, and tried all the solutions but to no avail.What am I doing wrong? The error is:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
I think it's something to do with my connection string which is as follows:
<add name="cn"
connectionString="server=HCL;DataBase=GS;Integrated Security=True" />
"HCL" is another machine connected to my PC through the LAN and this database, "GS", resides on it. Is the problem with the value I am giving in "Server" attribute of the above code? If not what else may I be doing wrong?
View 5 Replies
Apr 22, 2010
Following is the error I am getting while accessing some of the pages on my website.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
It is trowing an exception and giving the about mentioned error.
View 5 Replies
Feb 28, 2010
i get error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
View 4 Replies
Sep 23, 2010
I've created a small website with a simple sqlite database using vwd 2010 .net 4. In dev and test envionments everything works fine, however when i promote to my hosting provider i receive the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I've been configuring the connection strings (autogenerated from entity framework and attached db) but unable to get it working on the hosting provider, I'm assuming it's related to permissions but not entirely sure how to resolve - here's the web.config as it stands:
<add
name="ApplicationServices"
connectionString="data [code].....
For info the environments are set up as follows:
- Dev environment is vwd express 2010 with sqlite mdf attached
- Test environment is windows 7 server, iis 7 with appdomain identity set to network service
View 6 Replies
Sep 3, 2010
I have a class like this
public class MyClass
{
public MyClass()
[code]...
but in my view i keep having this eror
"The value 'System.Collections.Generic.List`1[MyEnum]' is not valid for Enumlist"
I did not specify any validation attribute for the property EnumList, so i don't why the automatic error.
View 2 Replies
Jun 2, 2010
I have the folloing sql server error from my ASP.NET website.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
This seems to be a network related issue. But on the same machine where IIS is running, I have another C# application running that is not experiencing this problem. This happens after the website has been running for a few weeks. Will this be because the database connections are opened but not closed properly?. I wrote a test web page where i just open connection but not close it and I got Time out error when connection pooling is maxed out. Is this memory issue? Memory that are allocated are not deallocated in timely fashion?..
Everything is working fine for a few weeks and after that I get the above network error.
View 2 Replies
Nov 6, 2010
I recently did an OS reinstall and tried to use my previously-working projects. I found that there was trouble connecting to the database for my aspnetdb.mdf. I have also tried a new project and adding a database to the project but I get the error 'a network related or instance specific...' error. I have tried reinstalling sql server 2005 express but still no luck. When I fire up sql server management studio i see the server name is the same as my computer name. I remember before the os reinstall that the server name was 'sqlexpress'.Anybody got any ideas as to how I can create databases inside of visual web developer again?
View 2 Replies
Nov 9, 2010
I've searched for about a day and a half and have not been able to find an explanation that I can understand, so please forgive me if this is something you have seen/answered before.
I have a web site that uses the App_Code folder. There are several CS files and classes in that folder. All of this works fine up to this point. However, I wrote an extension method with its own class and file. This fails with the following ambigous reference error (the app is in C#):
Compiler Error Message: CS0121: The call is ambiguous between the following methods or properties: 'GSGeneral.ExtensionMethods.IsNumeric(string)' and ''GSGeneral.ExtensionMethods.IsNumeric(string)'
If I change the extension to a plain static class, there are no problems with it. Based on that, it seems like this is related to it being an extension method.Now I know a work around is to move the file out of the App_Code folder - I've tried it and it works. My question is why does this have issues when all of the other items in the App_Code folder do not.
View 9 Replies
Oct 6, 2010
am format my system and re install every things before installation i am copy my websites from "C:Documents and SettingsAlphaMy DocumentsVisual Studio 2008WebSites" after installation i am just replace "My DocumentsVisual Studio 2008WebSites" folder with my old "My DocumentsVisual Studio 2008WebSites" folder now i am try to run my website locally its make following error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
View 2 Replies
Jul 7, 2010
I have an appliaction that works fine and connect to the database.but when view the event log I can see that every minute I get this:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)
On web.config yo can find:
[Code]....
View 2 Replies
Dec 14, 2010
I am getting following error ...when trying to do any operation....
"The transaction log for database 'MyDatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc
column in sys.databases"
I tried to shirnk file log file using ...
dbcc shrinkfile(EMRSET_log,1) But still same issue....And its show ...
DBName 4 ACTIVE_TRANSACTION (log_reuse_wait, log_reuse_wait_desc) ...
What steps i do to resolve this issue. Using MS SQL 2008
View 2 Replies
Jul 16, 2013
When I load the asp.net config tool in vs2010 it loads the page up fine but as soon as I click on security I get the following error:-
Code:
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may diagnose the problem: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. I have tried a blank project with a login control on but get the same.
View 3 Replies
Nov 23, 2010
I just installed sql server 2008 R2 on my computer. I am trying to connect to sql server throught my C# code and everytime I run the C# program,
I get this error "A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
The connection string that I used in my web.config file is
[Code]....
I am not sure what am I doing wrong, but I followed this article below step by step and still I am getting the same error
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
My instance name is MSSQLSERVER and the server that I am using is on my local machine and it has my computer name in it.
View 10 Replies
May 21, 2010
I am using Asp.Net MVC 2.0 for creating a user and assigning properties to the user at the same time. I am using my Windows account to access database on my local computer. I am using pre-installed MVC code o create a user with unique user name and password. User is created OK. Then I want to add profile properties like First and Last name at the same time.
I am creatingProfileBase object:
ProfileBase profileBase = ProfileBase.Create(profileInformation.UserName);
where profileInformation is a RegisterModel and has user info.
When I am trying to:
profileBase.SetPropertyValue(.....);
I am getting the following error # 2147467259 A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)"}
Why is my connection string works fine the first time and not working now? And how to configure connection to use TCP-IP?
I have SQL Server Browser running ander Local account and openned port in my Firewall.
View 4 Replies
Mar 13, 2011
I try to login to SQL Server Management Studio, using Windows Authentication and I get the error message:
Cannot connect to L-VAIOsqlexpress.
------------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider:
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
View 1 Replies
Aug 4, 2010
I am using Sql Server 2008 to connect to a Remote Server. Everything was working fine for the last couple of months, and i was successfully connecting to the remote server. Today it suddenly stopped connecting to the remote server. note that i did not alter any configuration settings. Did my isp block Sql Server. My ISP is using ISA SERVER? The error details are:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider) I am using Microsoft Firewall Client For ISA Server for opening ports. But today nothing is working.
View 1 Replies
May 20, 2010
in vb.net while entering a new entry i want to assign a record a unique id like in case of numeric i do this way
[code]....
in this case m using itemid as a unique id and the format is 1,2,3... and m finding out the max and assigning to a new record but how to assign if the previous id is of the a00001,a00002,a00003,a00004...so on. how i do i produce a unique id in this case
View 2 Replies
Jun 4, 2010
The short version of this question is "is there a way to gracefully accommodate automatic field binding & database insertion for an object that has a many-to-many field that has been set up in a partial class?" Apologies if it's been asked before.
Example Suppose I have a typical MVC setup with the tables:
Posts {PostID, ...}
Categories {CategoryID, ...}
PostCategories {PostID, CategoryID, ...}
As far as I know, there's no way to do many-to-many relationships in Linq-to-SQL right now so I have to shoehorn it in by adding a partial Post class to the project to add that functionality. Something like:
public partial class Post{ public IEnumerable<Category> Categories{ get { ... } set { ... } }}
So I can now create a "Create" view that automatically populates a "Categories" UI item. It even handles like any other field- fun!
So here's my problem:
How does all of this get exposed to views like "Create" and "Index" and still get to use automatic object model binding? The goal is to a) have the view and automatic model binder treat this as if it were native functionality of the object and b) have the Post object gracefully handle creating PostCategory table entries on submission into the database.
View 1 Replies
Mar 3, 2011
Is there a was to automatically write a tables contents to a .txt file? For example, a table 'deals' has the columns [id], [col1] and [col2]. Another table called 'customs' has the columns [id], [info] and [details]. both [ids] relate to one another. In 'deals', the col1 and col2 data will change, but when the [col1] = [col2] id like the corresponding [id]'s on the other table to be identified and [info] and [details] data be written to a .txt file.
View 2 Replies
Feb 7, 2011
Actually I want to send an automatic mail through sql
server 2005 at 17:00(hr) daily please guide me in detail
I'm using the following code
Declare @MailID varchar(60)
Declare @mailbody varchar(200)
Declare @MailSendTime datetime
set @MailSendTime='2011-02-07 14:15:07.700'
[code]...
Error is :Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
No global profile is configured. Specify a profile name in the @profile_name parameter.
View 3 Replies
May 7, 2010
I have a web page which generates a .CSV file based on some user input. When this file is downloaded by the user, the file is being automatically converted to .XLS. Any idea how I can prevent this?
For example, I am redirecting the user to the URL of the generated file, like below URL:
http://localhost/reports/Work/aa.csv
But the download window appears to download "aa.xls"!
View 6 Replies
Dec 14, 2010
I have a website that basically allows customers to build a cart with an item that can be configured. A user will pick an item, and they'll be prompted to pick the first option they want, they get sent to the second step where they pick their second option, etc. The number of steps and the number of options are variable, as they are defined by the client. Usually the item only has 2-3 steps with 5-10 options. However, in order to make it faster for the customer, if there is only one option available for the given step, it will automatically be chosen and the user will be sent to the next step.
A client decided to set up an item with 10+ steps with only one option for each step. This results in the entire process automatically choosing everything. FireFox doesn't like this, as it gives the error Firefox has detected that the server is redirecting the request for this address in a way that will never complete. I haven't checked IE or Chrome, although it probably gives similar errors).
What's the best way to fix this? Right now the process is basically User picks item user picks option if there is more than one option available. Otherwise the website does step 3 itself. POST to add the option to the cart Redirect to Page.aspx?step=# repeat step 2-4 as many times as necessary
Is there any change I can make to the code or page so that FireFox doesn't think I'm in an endless loop?
View 2 Replies
