SQL 2000 Server ASP.NET Error (Urgent)

Jan 7, 2007

Hello All,

I am not sure what is going on, but ever since I installed my ASP.NET shopping cart I keep getting the following error message in my Event Viewer under Application.

If anyone out there has any idea why this is happening please let me know because it seems to be crashing my other sites on my web server.

I have a Web Server which connects to a separate SQL 2000 Server. This error message is on my Web Server.

Thank you all in advance for your help!

Error:
--------------------------------------------------------------------------------------------------------------------------

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/6/2007 1:07:17 PM
Event time (UTC): 1/6/2007 6:07:17 PM
Event ID: 518a9db199214e3e807dd676e85f3d5a
Event sequence: 103
Event occurrence: 6
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1309570491/Root-1-128125656181152736
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:InetpubStoreV7
    Machine name: CDMLWEB
 
Process information:
    Process ID: 2376
    Process name: w3wp.exe
    Account name: NT AUTHORITYNETWORK SERVICE
 
Exception information:
    Exception type: SqlException
    Exception message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 
Request information:
    Request URL: http://www.bestpricetags.com/default.aspx
    Request path: /default.aspx
    User host address: 207.38.200.139
    User: c2e1ff27-e0ea-4c7f-ac61-5b1716651d3b
    Is authenticated: True
    Authentication Type: Forms
    Thread account name: NT AUTHORITYNETWORK SERVICE
 
Thread information:
    Thread ID: 10
    Thread account name: NT AUTHORITYNETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at AspDotNetStorefrontCommon.DB.GetRS(String Sql)
   at AspDotNetStorefrontCommon.DB.GetSqlN(String Sql)
   at AspDotNetStorefrontCommon.AppLogic.IPIsRestricted(String IPAddress)
   at AspDotNetStorefront.Global.Application_AuthenticateRequest(Object sender, EventArgs e) in C:InetpubStoreV7App_CodeGlobal.asax.vb:line 103
   at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

View 7 Replies


ADVERTISEMENT

Error During V7 To 2000 Upgrade. It's URGENT

Dec 14, 2004

I launch an installatino of SQL Server 2000 on a server, upgrading the V7 original datbase but it failed with error :
"the ordinal 105 could not be located in the dynamic link library opends60.dll"

And the SQL server services cant' start.

Can someone help me ?
It's urgent.

View 4 Replies View Related

Needs Urgent Help Sql 2000+replication+error No 20598

May 10, 2004

Hi,

I am getting an error while replicating the sql 2000 database.
The error no is 20598...It stopped replicating the database...

Can any body tell me what is this pls....

Tks in advance...

Joyce

View 5 Replies View Related

Sql Server 2000--urgent

Jun 16, 2007

i want to create fulltext search for that i have started Microsoft Search component but when i am tring to open SQL server Enterprise manager, i am getting sql server group but it showing "no items" not any database or any other data. what to do.

please help me out.

View 1 Replies View Related

Urgent: SQL Server 2000 Bogging Down On XP

Feb 17, 2008

Hi Experts,

I have an urgent situation expecting your advice. I have a .net front end application running against SQL 2000 DB in a XP box, it has been working fine for two years, recently when the .Net app starts, it works still ok getting data from sql database on the first form (dislpay data retreived from a table and view in a master-client grid), while I often get timeout error when I proceed with other processes that need sql database and I noticed that the HD light on SQL server machine (XP) kept flashing when timeout error occured, seems it kept reading/writing disk. I could not even close enterprise manager from SQL Server box when the HD was busy, and it also took a considerable long time to reboot the machine. sometimes I just shut down the machine (power off) and turn on the power again, then the sql server came back to life and could work stable for a couple of days.

Do I need reindex? reinstall sql server? or might it be relating to hardware issue?

Thanks so much!

Eric

View 13 Replies View Related

Replication Using SQL Server 2000 (SP4) .. Urgent...

Mar 1, 2007

Hi,

We have few branches with individual dbs are sitting in the branches itself. Periodically all the data need to be updated to a single HQ database. At the moment, all the tables's primary key are unique and each branch will have branch ID's in the transaction tables.

e.g. Branch1 data need to be updated to HQ db. However, HQ db records which are related to Branch 1 data only need to be updated back to Branch 1. other branch records should not goto Branch1.

Similaryly other branch records need to be updated/replicated back to HQ database. And only records related to the particular branch need to be updated from HQ (if any changes made)..

At the moment, i can do simple replication from one db to another db only... Can anyone guide/give suggestions on how to go about doing this?? If possible, please give steps involved...

TX





View 1 Replies View Related

Sum Of Time Field In SQL Server 2000 - Very Urgent

Feb 13, 2007

Hello all. I have a nvarchar field in the format dd:hh:mm:ss I need to get a sum of these fields in the same format. So for example if the values are 01:23:00:00 and 00:01:00:00 then the sum of these fields should be 02:00:00:00. Can someone help me? Thanks.

View 12 Replies View Related

Urgent, Dot Net 2005 Cannot Connect To SQL Server 2000

Oct 19, 2007

I am using VS .net 2005 to  develop a web application with sql server 2000, but the SQL servrer 2000 is setup on other computer,so, my web server is setup on A machine and SQL servr is setup on B machine.I got a problem when i try to connect to SQL server through the Web form as following error."An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
I had try to  setup the MDAC 2.8 on my Web Server, but i got a setup error sth like "MDAC 2.8 cannot install on your machine because it is not support your windows version.........."
Why i can't connect to SQL 2000 through the Web server??? 
It is a urgent case, Please help thx a lot.

View 3 Replies View Related

Reporting Tools To Use With SQL Server 2000... HELP URGENT !!!

May 22, 2001

Hi,

I am currently working on a project which requires reports that need multi-pass queries. I am currently using Crystal Report 8.5 and am not sure how to use multi-pass queries.

Here's some explanation about what I need :

A report has 10 different columns (counters). However, to get the values in all the columns, the filters (WHERE clause) are different for all the columns.
The only way I can think of doing this in Crystal Reports 8.5 is using Sub-reports (that will kill my performance) or then write stored procedures to populate an intermediate table on which the report will be based on.

Is there any reporting tool in the market that will help me pass multiple queries (with different WHERE clauses) in the same report.

I would appreciate your help on the above the earliest.

Thank you.

-- Parag

View 2 Replies View Related

Sql Server 2000 DTS Problem Urgent Help Needed Pls

May 14, 2006

Hi every one
I am new meber of this community with an urgent new problem with SQL server DTS process:) pls HELP!
PROCESS DETAILS:

My data base(db) is on main frame(flat file with hierarchical db format) I used vb script to get that db and split it in to three files so processing is easy after this I use dts PROCESS WITH EXECUTE SQL TASK in combination of some bulk insert scripts to pick these files from server directory and import it in to sql server tables. I know I could have use bulk insert task in dts but my formate file was giving me a problem while I try to develop it through that process so I ended up using tsql bulk insert statment with formate file in the EXECUTE SQL TASK .

PROBLEM :
My problem is I have to manually activate VB script where as I want this to be part of my DTS packet so it can be automated.

I know there is Active x scripting task in DTS but have not used it can some one please tell me if this script can be put in to Active X scripting task with or with out any modifications and also what are the modifications I need to do so it can run before other DTS task (which picks the file and insert it in three different tables after format file application.

this is the VB SCRIPT:Const

ForReading = 1,ForWriting = 2
Dim fso, SourceFile, TargetFile, retstring,Level1No, Level2No, Level3No, Level1Str, Level2Str, Level3Str

Level1No = 0
Level2No = 0
Level3No = 0

Set fso = WScript.CreateObject("Scripting.FileSystemObject")

'Set SourceFile = fso.OpenTextFile("C:SourceWGEE.NONX.GMM220D.UNLOAD.G00178888V00", ForReading)
Set SourceFile = fso.OpenTextFile("C:SourceDataNotepad.txt", ForReading)

set l1 = fso.OpenTextFile("C:SourceLevel1.txt", ForWriting,True)
set l2 = fso.OpenTextFile("C:SourceLevel2.txt", ForWriting,True)
set l3 = fso.OpenTextFile("C:SourceLevel3.txt", ForWriting,True)


Do While SourceFile.AtEndOfStream <> True
retstring = SourceFile.ReadLine

if Instr(1,retstring,"PACM",0) > 0 then
Level1No = Level1No + 1
Level1Str = Rpad(Level1No," ",10)
l1.WriteLine(Level1Str & retstring)
End if

if Instr(1,retstring,"PACPRS",0) > 0 then
Level2No = Level2No + 1
Level2Str = Rpad(Level2No," ",10)
l2.WriteLine(Level1Str & Level2Str & retstring)
End if

if Instr(1,retstring,"PACACC",0) > 0 then
Level3No = Level3No + 1
Level3Str = Rpad(Level3No," ",10)
l3.WriteLine(Level1Str & Level2Str & Level3Str & retstring)
End if

Loop

Function Rpad (MyValue, MyPadChar, MyPaddedLength)
Rpad = MyValue & string(MyPaddedLength - Len(MyValue), MyPadChar)
End Function

THANKS ALL

View 4 Replies View Related

URGENT - Link Server 2005 To 2000

Jul 18, 2006

I've a database in 2000 which needs to be accessed from 2005 via linkedserver. I've tried the GUI options and it is failing. One thins is that ourboth servers have hyphen('-' not underscore, could that be a problem) in thenames, like 2k-srv and 2k5-srv as hosts, but the instances are default.Can anyone give me the steps please.TIANasir

View 4 Replies View Related

Urgent: Finding Sessions In SQL Server 2000

Feb 9, 2006

Hi,

Can you help me how to find out sessions in SQL Server 2000.

Also is there any way to see the outstanding sessions for a database?



Thanks in advance,

Vasu.

View 4 Replies View Related

Urgent Login Problem With 2000 Server

Nov 6, 2007



I was using detach & attach method to move few 2000 databases to the instance 2005 on the same server...After moving a couple of databases which worked fine...Now i am not able to log into 2000 database...i guess the default database which i was connected had been moved at so its not letting me in to 2000 server..

TITLE: Connect to Server
------------------------------

Cannot connect to SQL-CENTRAL-DEV.

------------------------------
ADDITIONAL INFORMATION:

Cannot open user default database. Login failed.
Login failed for user 'test est'. (Microsoft SQL Server, Error: 4064)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

how do i fix the problem
thanks

View 5 Replies View Related

Urgent : DB-Library Error 10007: General SQL Server Error: Check Messages From The SQL

Jul 20, 2005

DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh

View 1 Replies View Related

Help Needed Urgent. Delete Is Not Working MFC And MS SQL Server 2000

Jul 21, 2004

Hi

if i try to delete data via MFC from Microsofts SQL Server 2000
i get following message: Data can be read only.. Weird i can write and read already. do i have to setup anything in Micrsofts SQL Server 2000 ??

please help its urgent.

Greets
Indian

View 1 Replies View Related

URGENT Plz ! Pivot Rows To Columns In SQL Server 2000

May 16, 2007

Hi,

I have the following data in a table called "Products" :

Product Qty LHinging RHinging
-------- ----- -------- --------
Panel_1 1 R
Panel_1 1 L
Panel_1 1 R
Panel_1 1 R
Panel_2 1
Panel_2 1 L


I need to group this data like this :

Product Qty LHinging RHinging
-------- ----- -------- --------
Panel_1 3 L R
Panel_2 1
Panel_2 1 L


How can I do that ???

Thanks !

View 3 Replies View Related

Urgent : Sql Server Data Trnsfer From 2000 To 2005

May 31, 2008

Hi there,

I got a shared web hosting server with sql server db which is 2k, and now ive got dedicated with godaddy where i installed sql 2005 express edition, now my shared hosting ppl gave me db bkup which i cant restore , so i copied all data from asp.net web based enterprise manager into an excel sheet and am trying to copy that data into sql2005 management studio express, however it doesnt let me do that.

I am trying to use openrowset, but my knowledge in sql is minimal so cant run that either.

can you please please please tell me how to do this asap, its very urgent as my contract runs out with shared hosting on 31 and ive to switch this site live by tomorrow.

please let me know asap wat to do, i can pay also for this job?

amit
amitsharma1977@gmail.com

View 7 Replies View Related

Automation Error, SQL Server Error-MSSqlserver-urgent

Oct 13, 2000

I have three problems related to Sql Server

a.I am developing a database application using VB5/VB6, SQL server 7 and Crystal reports.When I try to generate reports I get the message 'Automation error'. Please help-urgent.

b. I am using temperorary tables to generate reports.ie Table is created by user.Tables are generated runtime ie created as well as deleted. Sometimes
Sometimes i get the message 'SQLServer error' What should I do.What are the rights to be assigned to LOGINS?.

c.Is there precaution while installing SQLserver in WIN98.

View 1 Replies View Related

Urgent!: Upgade MSDE 2000 To Sql Server Express - Authentication Issue

Jul 31, 2006

I am trying to do a unattended upgrade of an MSDE 2000 named instance, say MyInstance, to a SQl Server Express Advanced edition. The set up is Mixed Mode Authentication. ( I can't use Windows Authentication for business reasons).
The error I get is

SQL Server Setup Cannot Upgrade the specified instance by using SQL Server
Creditial. You must use Windows Authentication creditial for the upgrade.

Details are as follows:
OS: Windows XP Prof (SP2).
Original install: MSDE 2000
Instance name: MyInstance
Authentication: SQL
Registry Entry: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMyInstanceMSSQLServer
Key LoginMode has a value of 2 ( corresponding to Mixed Mode Auth)

Upgrade attempted to: SQL Server Express Adv.
Command Line: start /wait setup.exe /qn LOGNAME=C:setup.cab /settings E:Sql2005SqlTemplate.ini

SqlTemplate.ini Contents:
[OPTIONS]
INSTANCENAME=MyInstance
SECURITYMODE=SQL
UPGRADE=SQL_Engine
UPGRADEUSER=sa
UPGRADEPWD=My$Password

The error I get in Summary.txt:
Machine : xxxxxXP
Product : SQL Server Database Services
Error : SQL Server Setup cannot upgrade the specified instance by using SQL Server credentials. You must use Windows Authentication credentials for the upgrade.


Can't I use SQL Authentication? I could not find a definitive answer on this one. Here's one thread that seem to indicate the same issue

http://groups.google.com/group/microsoft.public.sqlserver.msde/browse_thread/thread/90fb4b7182a55d54/f3128b447585f29d%23f3128b447585f29d

My questions:
- Can I use SQL Authentication?
- Where am I going wrong?
- I know the error message says to use Windows Authentication but I don't understand why I am I forced into using that.

Any insightsopinions will be highly appreciated.

Best
LW.

View 6 Replies View Related

HOW To Pull Merge Subscriptions In SQL Server 2000 Using Stored Procedures ??? (URGENT)

Dec 15, 2005

I've successfully carried out pull subscription using Wizard in SQL server 2000.

But NOW its the time to deploy the project & I've to do it programatically........

i tried to use the default stored procedures like "sp_addmergepullsubscription ", "sp_addmergepullsubscription_agent  ", "sp_reinitmergepullsubscription ", with respective parameters.

Then using replmerge.exe i tried to execute the batch file But could not succeed......

Can anyone guide me from the Basics ??? (i knw the Replication Architecture its heirarchy....but have NO idea of performing it Programatically......!!!!!!!!)

by BASICS, i mean......how should i execute the resp. stored procedures with what parametes & the order i should follow in order to successfully pull a merge subscription in SQL server 2000.

 

if a Sample code is mentioned as example, would be better for me to understand....

 

Thanking all of you in anticipation...........

 

Mandar

 

View 1 Replies View Related

Sql Server Error (urgent)

Jan 8, 2004

How can i solve this problem ???

Error: QueryEngine encountered error: Call SQLExecDirect got SQL_ERROR
[37000:1101: on HSTMT] [Microsoft][ODBC SQL Server Driver][SQL Server]Could
not allocate new page for database 'TEMPDB'. There are no more pages
available in filegroup DEFAULT. Space can be created by dropping objects,
adding additional files, or allowing file growth.

Error in Process method of Component: QueryEngineServer, Project 11, Job
14797, Error Code= -2147212544.

I already saw the growth and it is correct, i have already set it to 96%.
I have disk space.

How can i solve this problem

Thanks.

View 14 Replies View Related

SQL Server Agent Error - Very Urgent

Jun 6, 2001

I get the following error in the SQL Agent log file


Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: Logon failure: the user has not been granted the requested logon type at this computer)


Does anhbody know why this happens.

Let me know.
Thanks
Cynthia

View 6 Replies View Related

SQL Server Agent Error- Urgent

Jun 15, 2001

Hi,
I have question. My SQL Server Agent Log has the following error messages logged. Does anyone know why this happens. It happens everyday when I back up a 40 GB Database. Let me know. I Appreciate the help.

Thanks,
Cynthia

6/14/01 9:30:58 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:30:59 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:01 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:30:58 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:30:59 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:00 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:01 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:02 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:03 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)

6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)

View 1 Replies View Related

Sql Server Backup Error(urgent)

Sep 25, 2001

Hi,
I have Sqlserver 7.0 cluster configured with Omniback 3.5. My backups were fine till yesterday.We moved the database to another node and bacups are failing with error in sql server error log.
backupVirtualDeviceset::Intialize:open failure on backup device 'Omniback_II_msdb' operating system error -2147024894(The system cannot find file specified)
I greatly appreciate if any one can help to solve this
thanks
Mohan

View 2 Replies View Related

IIS SQL Server Connection Error (urgent)

Mar 23, 2004

I keep getting this error when I try to connect to my SQL Server DB

Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.

when I installed SQL Server I set username and password to windows default which is Administrator and no password

the asp files are on IIS (localhost)

connstr = "Provider=SQLOLEDB;" &_
"Data Source=(local);" &_
"Initial Catalog=ShotWatcher;"&_
"User ID=Administrator;"&_
"Password="

shouldn't this work?

Please Help

Justin

View 3 Replies View Related

Error Message &#39;Specified SQL Server Not Found&#39; Urgent

Apr 26, 2002

Hi there,
I access to server SQL by an application on web,I configured the ODBC box for using TCP/IP and the server use also the TCP/IP.
I have this message :

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.
/medecin/IdentificationAcces/membre_enregistrer.asp, line 108

I don't know why there is Named Pipes in message.

Please help me
thanks in advance
Jalal

View 1 Replies View Related

SQL Server 2005 Express Error. URGENT HELP NEEDED!

Jun 5, 2006

I get the following error when I try to access the database from my web application
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
The application works when I run it on my local machine, but when I move the application to a remote server, I get the above error.
Below is the connection string section in my web.config file.
 <connectionStrings>  <remove name="LocalSqlServer"/>  <add name="LocalSqlServer"        connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CiaaASPNETDB.MDF;user instance=true;Integrated Security=True;Initial Catalog=CiaaASPNETDB;Integrated Security=True;user instance=true;Connection Timeout = 0"       providerName="System.Data.SqlClient"/>  <!--Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CiaaASPNETDB.MDF;user instance=true;Integrated Security=True;Initial Catalog=CiaaASPNETDB --> </connectionStrings>
Can anyone help me with this.

View 1 Replies View Related

Connecting To Sql Server 2000 On Godaddy Error: (provider: Named Pipes Provider, Error: 40 - Could Not Open A Connection To SQL Server)

Mar 5, 2007

Facts:1. I am using my account on Godaddy trying to connect to my sql server db.2. I can get into my db using user id and password.3. Godaddy's help file shows this for a connection string: connectstr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE="
&db_name & ";UID=" & db_username & ";PWD=" &
db_userpassword4. My connection string: "Server=whsql-v09.prod.mesa1.secureserver.net;uid=dbasolutions;pwd=***;database=DB_87972;"  & _                    "Trusted_Connection=False providerName=System.Data.SqlClient"{password **** out}5. Get error message  An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) I tried to email Godaddy's help desk with this information. There first response: We do not allow remote connections to our sql server database.There second response was to read the help file!Does anybody have any suggestions?  Thanks in advance,bswanson     

View 1 Replies View Related

URGENT.Sql Server Does Not Recognise MAPI , Or Profile Name URGENT

Oct 26, 2000

hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed

I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.

I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.

My next question, How to configure MAPI in Sql server if what I did was wrong.

View 1 Replies View Related

Urgent, Urgent !! My Sql Server Refused To Start Due To Encrypton

Mar 23, 2001

Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed.
I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment.
The error is:
19015: The encrypton is required but no available certificat has been found.

Please help me to start sql server.

Thanks.

Michel

View 4 Replies View Related

Urgent: ASP.NET 2.0 And SQL 2000

Jan 27, 2006

When using Form authentication, can we not use SQL SERVER 2000? When I am working with the ASP.NET Web Site Administration Tool Wizard, it tells me that:

Your application is currently configured to use:
Advanced provider settings

How can I use my existing database on SQL SERVER 2000?

Please help.

View 5 Replies View Related

Sql 2000 - URGENT HELP NEEDED

Apr 5, 2001

What is the process for using sp_attach_db to restore a sql server 2000 database as a sql server 7 database? Article references? Thanks

View 1 Replies View Related

Sql Mail In 2000 Urgent

Jan 28, 2002

I can't find the start option and the check box which says auto start when sql agent starts in 2000.

In sql 7.0 it was pretty simple to configure the mail.

First configure the MAPI, then restore the same in sql agent test it then go to suport service then right click on sql mail and select the profile and click start button there before this test the profile i know we had options such as auto start sqlmail when sql agent starts as well as start and stop in support service..

My problem is i don't see either of these information nor can i find the same..i tried everywhere but they seem to be lost some where..Can some let me know what exactly is the process to start and stop sqlmail in 2000.

I appreciate your help.

Thanx,

Harry

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved