Showing posts with label logs. Show all posts

Monday, March 19, 2012

Access violation

Hi,
I'm having a problem with a particular address location.
I'm using MS SQL Server 2000
I checked the server logs and I see some stack dumps now and then.
I checked the stack dumps and all of them seem to have the same problem.
* BEGIN STACK DUMP:
* 06/14/05 23:18:37 spid 0
*
* Exception Address = 258B6EF6
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 77BEC370
All the stack dumps shows error reading the address 77BEC370
Is this because of a faulty memory?
DanielAccess violations are usually down to one of three things:
1) Faulty hardware
2) Buggy drivers
3) A bug in SQL Server
You would be best advised to call Microsoft Support to discover the
cause, if it's a bug in SQL Server you will get your support call refunded.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>|||so it has nothing to do with buggy programming? As i am using the db with
ASP.
Thanks,
Daniel
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:OrotFVYcFHA.1392@.TK2MSFTNGP14.phx.gbl...
> Access violations are usually down to one of three things:
> 1) Faulty hardware
> 2) Buggy drivers
> 3) A bug in SQL Server
> You would be best advised to call Microsoft Support to discover the cause,
> if it's a bug in SQL Server you will get your support call refunded.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
>> Hi,
>> I'm having a problem with a particular address location.
>> I'm using MS SQL Server 2000
>> I checked the server logs and I see some stack dumps now and then.
>> I checked the stack dumps and all of them seem to have the same problem.
>> * BEGIN STACK DUMP:
>> * 06/14/05 23:18:37 spid 0
>> *
>> * Exception Address = 258B6EF6
>> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>> * Access Violation occurred reading address 77BEC370
>> All the stack dumps shows error reading the address 77BEC370
>> Is this because of a faulty memory?
>> Daniel|||"Daniel Chen" <lifehalo@.yahoo.com.sg> wrote in message
news:d8orha$tli$1@.nobel.pacific.net.sg...
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
Yes ;)
This is internal SQL Server error, the causes Mark Allsion give in previous
post|||*This time* it's not your buggy programming, but could be your buggy
drivers or faulty hardware, or MS's buggy programming. ;-)
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
>|||alright. thanks for your help. :)
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:ua59M$YcFHA.2840@.TK2MSFTNGP14.phx.gbl...
> *This time* it's not your buggy programming, but could be your buggy
> drivers or faulty hardware, or MS's buggy programming. ;-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
>> so it has nothing to do with buggy programming? As i am using the db with
>> ASP.
>> Thanks,
>> Daniel|||I recently had an issue similiar to this where the developers introduced a
READPAST hint into several code bases. I was getting this access violation
and Support recommended a patch (which I couldn't do because I had 36
clusters and couldn't afford to have something different on a few) or put a
clustered index instead of a non-clustered index on the table where the
READPAST hint was being used. That worked like a charm. Don't know if
that's your issue, but thought I'd mention it.
"Daniel Chen" wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
>

Access violation

"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:ua59M$YcFHA.2840@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> *This time* it's not your buggy programming, but could be your buggy
> drivers or faulty hardware, or MS's buggy programming. ;-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
|||I recently had an issue similiar to this where the developers introduced a
READPAST hint into several code bases. I was getting this access violation
and Support recommended a patch (which I couldn't do because I had 36
clusters and couldn't afford to have something different on a few) or put a
clustered index instead of a non-clustered index on the table where the
READPAST hint was being used. That worked like a charm. Don't know if
that's your issue, but thought I'd mention it.
"Daniel Chen" wrote:

> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
>

Access violation

"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:ua59M$YcFHA.2840@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> *This time* it's not your buggy programming, but could be your buggy
> drivers or faulty hardware, or MS's buggy programming. ;-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:|||I recently had an issue similiar to this where the developers introduced a
READPAST hint into several code bases. I was getting this access violation
and Support recommended a patch (which I couldn't do because I had 36
clusters and couldn't afford to have something different on a few) or put a
clustered index instead of a non-clustered index on the table where the
READPAST hint was being used. That worked like a charm. Don't know if
that's your issue, but thought I'd mention it.
"Daniel Chen" wrote:

> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
>

Sunday, March 11, 2012

Access to SQLServer Database from Visual C# app and ASP.NET app

I've created a visual C# GUI that logs data over a LAN. The GUI is for Admin purposes only so it logs data and stores it (plus some admin stuff). The data that is logged is supposed to be served up to anyone on the network as a web app. I've got an instance of SQLServer running and the GUI works great but I can't seem to get the web app to connect to the database to read and display the data for general users?

I'm new to ASP.NET and SQL Server so a little extra explanation or steps that I'm missing wouldn't hurt me if you have the time to spare.

I get an error that says "Cannot get web application service" in Visual Studio when I try and drag and drop a SQLDataSource onto my pages and configure it. It then asks me to Choose My DataConnection from the drop down and there's no connection there...

I tried setting it up in the code behind page like I would in Visual C# (small code example below) by adding in using System.Data.SqlClient; etc.. and it throws me a nasty notice (see below). Obviously it doesn't like this user but how do I fix this so I can server up my DB to work for both my GUI and ASP apps? I noticed when looking at my DB that the owner is TUDOR\Windows is there a way to have multiple owners to a DB if this is what's wrong?

String conn = @."Server=TUDOR\sqlexpress;" +

"Integrated Security=True;" +

"Database=ATSDB";

// Specify SQL Server-specific connection string

SqlConnection dbconn = new SqlConnection(conn);

// Create DataAdapter object

SqlDataAdapter dbadpt = new SqlDataAdapter("SELECT FirstName FROM tblPersonInfo WHERE FirstName = 'Kim'", dbconn);

// Create CommandBuilder object to build SQL commands

SqlCommandBuilder dbcmd = new SqlCommandBuilder(dbadpt);

// Create DataSet to contain related data tables, rows, and columns

DataSet dbset = new DataSet();

// Fill DataSet using query defined previously for DataAdapter

dbadpt.Fill(dbset, "tblPersonInfo");

Server Error in '/ATS' Application.

Cannot open database "ATSDB" requested by the login. The login failed.
Login failed for user 'TUDOR\ASPNET'.

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: Cannot open database "ATSDB" requested by the login. The login failed.
Login failed for user 'TUDOR\ASPNET'.
Source Error:

Line 32: Line 33: // Fill DataSet using query defined previously for DataAdapter Line 34: dbadpt.Fill(dbset, "tblPersonInfo"); Line 35: } Line 36: }

Source File: c:\Inetpub\wwwroot\ATS\text\Default2.aspx.cs Line: 34 Hi there,

ASP.NET web applications, by default, will run under their own account. In your case, this account seems to be TUDOR\ASPNET.

The problem seems to be that this account is not set up as a login in SQL Server. You need to create a login for TUDOR\ASPNET for your SQL Server and give it access to the required databases.

You can do this by (sorry if you already know this bit):

1) Open Management Studio Express (I presume from reading your code that you are using SQL Server Express Edition) and connect to your SQL Server Instance

2) Expand the node for your SQL Server instance and you will see a node labelled "Security"

3) Right click on the "Security" node and select "New > Login" from the context menu that appears

4) A new dialog window will appear. Enter "TUDOR\ASPNET" as the user and make sure that the Windows Authentication radio button is selected. Set the default database as required (in your case this will probably be ATSDB)

5) In the dialog, on the left hand side there should be an item called "Server Roles". Click on this and then define whatever server roles (e.g. sysadmin) TUDOR\ASPNET will have....What roles the user'll have is entirely up to you

6) In the dialog, on the left hand side there should be an item called "User Mapping". Click on this and then select which databases TUDOR\ASPNET will have access to (in your case, most definately select ATSDB). Also, select what database role (e.g. dbowner) the account will have....Once again, this is up to you to determine

7) Nothing else is particularly interesting so just click OK to finish the process

After you have given access to TUDOR\ASPNET to your SQL Server, you should be able to use your ASP.NET application without getting that error.

Hope that helps a bit, but sorry if it doesn't
|||That sounds like exactly what I need to do. I am using Sql Server Express, from what I've read that is what comes with Visual Studio 2005 but I can't find Management Studio Express? Is that something that only comes with Express Edition software? When I was asked to do this I went out and bought some O'Reilly books but I also bought a couple Express Edition books so I could get up and going fast so if the code looks unelegant that might be why or maybe it was the /SQLExpress that gave it away. Thanks for all the notes I didn't know how to do all that and if I can find Management Studio Express that would definetly solve all my problems. Is it under something else in Visual Studio 2005 Pro Edition?|||Hi there,

Management Studio Express is a seperate download. You can get it from the below link.

SQL Server Express Edition Downloads

After you download & install it, you should be good to go. When Management Studio asks you to connect, your server name, by reading your code should be TUDOR\SQLEXPRESS.

Using Management Studio Express you can connect via SQL Server Authentication (using an account like "sa") or Windows Authentication. If you connect via Windows Authentication but find you can't modify users then your account probably does not have the required privileges. If you switch to the "sa" account you should be fine.

Hope that helps a bit.
|||Thanks so much for your help and your explanations. That's a lot of typing to do to help out someone you don't know. Much appreciated. Works great.

Access to SQL Server System Logs

I'm a developer and mostly develop Service Broker applications for my company. I do have logging for my application but unforseen errors will normally show up in the SQL Server System Logs. What would be a good way to give a developer access to read the SQL Server logs without giving away the keys to kingdom. Would that be through xp_readerrorlog or is there a better way of accomplishing this?Hi,

no this is the most common way to do this.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Thursday, February 16, 2012

Access Logs

Hi all,
In our win2k3 event viewer there are hundreds of failed logon attempts
for our SQL Server. Unfortunately, this log doesn't supply any
connection specific information which is what we need. Are there any
other logs that MSSQL 2000 keeps on it's own? I want to keep a record
of these attempts just in case something does happen we maybe will have
something to go on. Thanks!
--
Regards,
TroyHi,
It will be there in SQL Server Error logs as well. The location of the files
will be in \Program files\Microsoft sql server\server name\Log directory.
or you can execute XP_READERRORLOG from query analyzer .
Thanks
Hari
MCDBA
"Troy" <poster@.designguide.com> wrote in message
news:MPG.1a9d757e7936be5a98968e@.msnews.microsoft.com...
> Hi all,
> In our win2k3 event viewer there are hundreds of failed logon attempts
> for our SQL Server. Unfortunately, this log doesn't supply any
> connection specific information which is what we need. Are there any
> other logs that MSSQL 2000 keeps on it's own? I want to keep a record
> of these attempts just in case something does happen we maybe will have
> something to go on. Thanks!
> --
> --
> Regards,
> Troy

Monday, March 19, 2012

Access violation

Access violation

Access violation

Sunday, March 11, 2012

Access to SQLServer Database from Visual C# app and ASP.NET app

Server Error in '/ATS' Application.

Cannot open database "ATSDB" requested by the login. The login failed.
Login failed for user 'TUDOR\ASPNET'.

Access to SQL Server System Logs

Thursday, February 16, 2012

Access Logs

SQL Alert

Blog Archive

About Me

Monday, March 19, 2012

Access violation

Access violation

Access violation

Sunday, March 11, 2012

Access to SQLServer Database from Visual C# app and ASP.NET app

Server Error in '/ATS' Application.

Cannot open database "ATSDB" requested by the login. The login failed.Login failed for user 'TUDOR\ASPNET'.

Access to SQL Server System Logs

Thursday, February 16, 2012

Access Logs

SQL Alert

Blog Archive

About Me

Cannot open database "ATSDB" requested by the login. The login failed.
Login failed for user 'TUDOR\ASPNET'.