Suddenly Cannot Connect

Jan 9, 2008

I'm running SQL Server Express 2005 on Windows XP.

I've been using SQL Server Express for the past month or so, and I've always been able to connect. Now all of a sudden I can't connect, it's giving me error 26.

I've always used Windows authentication with no need for a password.

View 7 Replies


ADVERTISEMENT

Suddenly Getting STRANGE Error...

May 11, 2006

I've been building a simple test application and things have been working all day. Suddenly, about a half an hour ago - I started getting this error every time I attempt to go to the main web page:
System.Data.SqlClient.SqlException: 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 have no idea what changed... Can someone help me figure this out please?
Thanks!~A~

View 3 Replies View Related

SP Suddenly Started Timing Out

Jul 6, 2007

Simple (4 lines) stored procedure was working, now is timing out.

Profiler shows hundreds of lines and a lot of time doing:

EventClass: SQLTransaction

ObjectName: Cache Coherency

What are these lines profiler is capturing?

Why is the server doing this, and how can I stop it?



Thanks!



View 1 Replies View Related

Connetion Fails Suddenly

Apr 9, 2008

I've had this connection used for months and months. The setupQL Express + VS2008. In that particular app I use only one DB Connection but there are about 10 other Sql Server Dbs that I connect to in other apps.

I am still in a development stage.

Today I've decided to connect also via the Server Explorer in VS2008. All connections were established easy. Immediately after that a connection.Open ( ) statement failed with the error message

System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.

At the Open statement I did a break and with Ctrl + Alt + E got all exceptions. They are too numerous to show in here. One of the messages I found was that the failure occured in System.dll.

Any ideas as to why it happened?

I disconnected (deleted) the DB in question--no change. I deleted ALL DB connections from the server explorer in VS2008 - no change. I see the only option now and that is to reinstall the VS2008. I am kind of sick and tired of doing it.

Also I've been trying to move on to Linq and it is my understanding that in order to do Linq I have to establish connections via VS2008 not just connection strings. Is it right? Perhaps I am mistaken?

This particular connection is not that crutial. I can survice without it with this app but for others it would be impossible to continue development.

Any help will be appreciated.

Thanks.

P.S.

Some additional information has transpired. I checked Sql Server Object Explorer and immediately determined that the DB in question lost ALL its tables. There was just an empty shell: the name, no tables, no system tables, no Programmability, nothing.

I "deleted" this DB and reconnected it. The connection with my app miraculously restored itself. Now I could run the app with no problem and the connection to this DB could be Opened in the app. However, when I tried to set up the connection again in the Server Explorer of VS2008 the same thing promptly happened. Now I got this exception back.

It is not the way VS2005 behaved. Is it normal?

Thanks.

View 39 Replies View Related

SQL Mail Stopped Suddenly !! Help Required.

Feb 15, 2002

Hi Everybody !!

I have a problem with SQL mail on SQL 6.5 with SP 5a . I have created a job called as mailtest and is scheduled to run every morning .
The task was running successfully till last week when suddenly it stopped responding on some of the SQL 6.5 Servers .

When i stop the SQL Mail and start again through the Enterprise Manager , and then run the task , it shows as successful .
Every morning i have to do it to check whether the mailtest is O.K .

But the automated mailtest task has stopped suddenly . I have checked the MAPI profile and is correct as the same is configured on other servers on which my mailtest runs successful.

Can somebody guess what the problem could be ?

Thanks for your help in advance .

Regards
Ashish.

View 2 Replies View Related

All Replication Publications Suddenly Disappear

Jan 8, 2007

Hi:

Did you have any experience that all publications and their related jobs suddenly disappear?

I had a transactional pull replication between two servers, and distributor and subscriber in the same box; publisher was an AA cluster server.
The schedule of pulling was once a week.

Last Friday morning everything was working perfectly, but I found all publications and their related jobs disappear around 5pm

I checked with the sysadmin and he said nothing was changed on that period.

Did you have any idea about it?

Did you have any idea that I can prevent this happen again or any alert I can set up to monitor who drop it, when it was dropped and so on?

It is a SQL 2000 box and system table doest not take trigger.

Thanks in advance

Theresa

View 2 Replies View Related

Management Studio Is Missing Suddenly

Nov 20, 2007

Hi all,

This issue is on PRODUCTION.


The server is in use almost a year now, but suddenly this afternoon , i saw that Management Studio is missing in start --> Sql Server 2005 --> Management Studio is missing here. ( SQL Server 2005 , Standard Edition, 32-bit, SP1 )


Could somebody tell what could be the reason and how to fix it.


What i need to do , so that i get back the management studio & where should i go & investigate what file is missing.


Any help is greatly appreciated.


Thanks.

View 8 Replies View Related

SQL 2005 - Why Do Databases Suddenly Think They Are Replicated?

Nov 10, 2007



Hello All

I hope somebody can help. This is the second time I've seen this issue. The first time I thought it was a one off, but now I'm getting concerned.

I have two clients - one had Merge replication set up on a database that had a log log file that just grew and grew. The database was set to SIMPLE recovery. I could understand the log file growing if it was set up for transactional replication, but it wasn't transactional, just merge. Looking in sys.databasese the log_reuse column was set to REPLICATION.

I ran the sp_repldone stored proc on this database and all was well - I could shrink the log file down to a reasonable size. This server was SQL Server 2005, Service Pack 2.

Now I have yet another client who has a growing transaction log file. Low and behold the log_reuse for the database is set to REPLICATION again. This server has never had any type of replication set up at all!!!! The log file is still growing and DBCC OPENTRAN indicates undistributed transcations. This particular server is SQL Server 2005 Service Pack 1.

Can someone PLEASE shed some light on what's going on here? Is there some kind of bug that I don't know about? Searching Goolgle Groups seems to indicate that other people have had this problem, and they have have to set up replication and run sp_repldone to resolve it, but that's surely uncalled for on a database that has never seen replication?

Thanks

SQLGal2

View 2 Replies View Related

Suddenly SQL Server 6.5 Stops Responding For 4 Minutes

Apr 9, 2002

Can anyone help me?
My brand new installation of SQL Server 6.5 running on Windows 2000 suddenly stops working for about 6 minutes, in this periods no one can use SQL 6.5 services because it stops responding. My logs is show below:


2002/04/08 15:50:22.60 ods Error : 17832, Severity: 18, State: 0
2002/04/08 15:50:22.60 ods Unable to read login packet(s).
2002/04/08 15:50:24.50 ods Error : 17832, Severity: 18, State: 0
2002/04/08 15:50:24.50 ods Unable to read login packet(s).
2002/04/08 15:50:26.79 ods Error : 17832, Severity: 18, State: 0
2002/04/08 15:50:26.79 ods Unable to read login packet(s).
2002/04/09 07:10:21.48 ods Error : 17832, Severity: 18, State: 0
2002/04/09 07:10:21.48 ods Unable to read login packet(s).
2002/04/09 07:53:33.76 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:53:33.76 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname '2M_ROSANNA'.
2002/04/09 07:53:33.76 ods OS Error : 232,
2002/04/09 07:53:33.78 spid75 Error : 1608, Severity: 21, State: 2
2002/04/09 07:53:33.78 spid75 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
2002/04/09 07:53:41.10 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:53:41.10 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'CE_SANDRA'.
2002/04/09 07:53:41.10 ods OS Error : 232,
2002/04/09 07:53:41.10 spid80 Error : 1608, Severity: 21, State: 2
2002/04/09 07:53:41.10 spid80 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
2002/04/09 07:55:42.20 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:55:42.20 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'CE_SANDRA'.
2002/04/09 07:55:42.20 ods OS Error : 232,
2002/04/09 07:55:42.20 spid53 Error : 1608, Severity: 21, State: 2
2002/04/09 07:55:42.20 spid53 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
2002/04/09 07:57:09.40 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:57:09.40 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'FE_FERTILIDAD'.
2002/04/09 07:57:09.40 ods OS Error : 232,
2002/04/09 07:57:09.40 spid91 Error : 1608, Severity: 21, State: 2
2002/04/09 07:57:09.40 spid91 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
2002/04/09 07:57:09.40 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:57:09.40 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'SF_ROSA'.
2002/04/09 07:57:09.40 ods OS Error : 232,
2002/04/09 07:57:09.40 spid11 Error : 1608, Severity: 21, State: 2
2002/04/09 07:57:09.40 spid11 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
2002/04/09 07:57:36.04 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:57:36.04 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'CE_MILAGROS'.
2002/04/09 07:57:36.04 ods OS Error : 232,
2002/04/09 07:57:36.04 spid60 Error : 1608, Severity: 21, State: 2
2002/04/09 07:57:36.04 spid60 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.


The problems begin on 2002/04/09 at 7:53am. and it respond again at 7:57, there's no need to restart the service.

I will appreciate some help here.

View 1 Replies View Related

Clustered Sql Server 2005 Restarted Suddenly

Nov 4, 2007

Hi EveryOne,

WIndows 2003 sp2 and sqlserver 2005 standard edition -sp2.

Found following erors in The cluster and event logs.

error: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect
failed

error: [sqsrvres] OnlineThread: QP is not online.

error: [sqsrvres] printODBCError: sqlstate = HYT00;
native error = 0; message = [Microsoft][ODBC SQL Server
Driver]Timeout expired

[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

[sqagtres] SvcStop: service did not stop; giving up.
[sqsrvres] OnlineThread: asked to terminate while waiting for QP.


SQL Server is terminating in response to a 'stop' request from Service Control Manager



Earlier we had sudden Sql agent restart but this time sql server services were restarted .

What could be he reasons for this.

This machine has 64 GB ram and sql server has been alloted 30 Gb.
I found 30 Gb Usage in the dump file of Sqlserver

Can a memory Starved sql server could be a rason why sql server would have restarted

Thanks,
Gautham.R

View 1 Replies View Related

Suddenly Stored Procedure Takes Too Much Time?

Jul 17, 2015

I have a sp that was taking very little time (about 34 sec). But suddenly is stacked. It is running and running and running but not LOCKED neither SUSPENDED. It is always RUNNABLE. I have made Index and statistics optimization but nothing. I looked into execution plan but everything seems ok. All the time is in 3 indexes that are Index Seek and not Table Scan!!! So why is stacked... I do not know how much time it takes because I have to stop it. (SQL SERVER 2008 R2, the database was migrated from SQL SERVER 2000)

View 6 Replies View Related

Can't Open Destination Flat File Suddenly?

Jun 6, 2007

Attempting to write to a flat file, I get the following Warning then Errors:

~~~~~~~~~~~~~~~~~~
Warning: 0x80070005 at Data Flow Task, Detail to dat File Writer [54]: Access is denied.

Error: 0xC020200E at Data Flow Task, Detail to dat File Writer [54]: Cannot open the datafile "DetailOutWhat_1.dat".

Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "Detail to dat File Writer" (54) failed the pre-execute phase and returned error code 0xC020200E.
~~~~~~~~~~~~~~~~~~~

There should be no reason that this project can't open DetailOutWhat_1.dat, as it has successfully done it earlier today...

UNRELATED: Is it possible to comment out a transform or destination file while in the Designer View?

Thanks!

Jim Work

View 4 Replies View Related

Scheduled Backup Suddenly Started Giving Errors

Oct 19, 2007



Hi,

I have scheduled full backup daily at morning 6:00. It was running fine till yesterday. Suddenly today morning it failed giving following error....

I have executed maintenance plan manually and again it gave same error....

10/19/2007 11:03:10,FullDBBackup.Subplan_1,Error,1,*****,FullDBBackup.Subplan_1,Subplan_1,,Executed as user: ****SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:03:10 AM Error: 2007-10-19 11:03:10.98 Code: 0xC0010018 Source: Back Up Database (Full) Description: Error loading a task. The contact information for the task is "Back Up Database Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. End Error Error: 2007-10-19 11:03:11.25 Code: 0xC00291EC Source: {C7FB73D1-ADF1-42C0-B3D5-9F8014CC206B} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2007-10-19 11:03:11.25 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DT... The package execution fa... The step failed.,00:00:01,0,0,,,,0




Pls help me as daily backups are very crucial to me...

View 9 Replies View Related

Replication Monitor Bug - Subscription Names Suddenly Not Displaying?

Apr 23, 2007

This is strange.



We use Merge (pull) replication to get data from the "mother ship" updated to the laptops of 15 sales reps before they head out into the field, where they work disconnected. At end of day, they all reconnect and all the data is once again shared.



We've been having problems with the replication, but that's another topic.



This morning, I logged onto the server to check the replication monitor, and found that all of the subscriber names for that particular subscription are blank! They show the open/close bracket ( [] ) followed by the database name. This is under the My Publishers >> [server name] >> [publication name] node in the explorer tree. If I try to double-click on one of the subscribers to get their detail, I get tne message, "Replication Monitor could not open the Detail Window." and "Specified cast is not valid".



If I look at the publication in SQL Server Management Studio, all of the subscriber names show up just fine. But they do NOT show up under Replication Monitor.



No one touched the database over the weekend, and this was working just fine on Friday afternoon.



Has anyone seen this before? What to do?

View 3 Replies View Related

SQL 2005 Merge Repl Suddenly Stopped Working

Mar 28, 2006

Hello...

We have had Merge Replication working for the past few months (SQL 2005 to SQL Mobile) and suddenly today the replication URL that points to the SqlCESA30.DLL does not work. I have tried re-running the SQL Mobile virtual folder wizard a few times....resetting IIS and even a re-boot...and still the URL is not available.

Is there anything that might provide some clue as to why this has unexpectedly failed?

thanks for any help!

- will

View 3 Replies View Related

SQL Tools :: Lost All Objects Suddenly Only Remains Name Of Database No Backups Available

Nov 8, 2015

I recently installed a trial version of Sql12k on my laptop. Since 1st of November I've been creating tables without problems (15) and different schemas.I would like to emphasize that both mdf and ldf files are allocated in my USB3 portable disk. is that a problems for Sql12K? SSMS had stuck just for 20 sec or so. Then, system itself kill the task. A huge surprise when I restarted again... all the databases including the last one.. without objects. I mean, user databases...

Where are my logins? Where are my tables and schemas? Jesus christ.Sql logs inform the following (in all the moment my USB hardisk was properly connected)

11/08/2015 16:00:30,spid19s,Unknown,The operating system returned error 21(El dispositivo no está listo.) to SQL Server during a read at offset 0x000000 00140000 in file 'f:enriccopia_de_bbbb.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency

[code]....

View 4 Replies View Related

Getting The Operation Could Not Be Completed. (WinMgmt) Error Suddenly In SSMS For RS Connection

Feb 7, 2008

suddenly I'm getting a connect to server error dialogue box that says...

Cannot connect to serverinstance name
Additional information
The operation could not be completed. (WinMgmt)


...when trying to connect to RS2005 Server in Management Studio. I can reach Reporting Manager thru IE and run my reports.

Is it possible that my setting IIS to basic authentication (and turning off Windows Integrated) might be preventing me from connecting in MS, perhaps because MS has to go thru the RS service and doesnt know what basic auth is?

I'm temporarily unable to set IIS back to Windows Auth cuz the server is being used by users to test reports.

View 3 Replies View Related

SQL Server 2008 :: Full-text Search Suddenly Returning Error

Jul 8, 2015

This morning, when I look at my error logs, the following appears;

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

If I remove the contains() part from the SQL Stored Procedure, it stills runs. So, in other words, suddenly contains() started making the query crash.

I'm running SQL Server 2008 R2.

View 0 Replies View Related

Oracle 9i -&&> SQL Server 2005: Snapshot Agent Aborts Suddenly Uninterrupted

Jun 14, 2006

Hi - I hope some of you can help me with this problem.

I'm trying to run the snapshot agent for 77 published tables, but the agent stops suddenly uninterrupted. It stops in the middle of taking a snapshot of a table containing 81,719,531 rows. The error message is pasted below.

Message
2006-06-14 05:33:33.53 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57200000 total rows copied)
2006-06-14 05:34:12.57 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57300000 total rows copied)
2006-06-14 05:34:51.23 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57400000 total rows copied)
2006-06-14 05:35:29.99 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57500000 total rows copied)
2006-06-14 05:36:09.82 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57600000 total rows copied)
2006-06-14 05:36:49.38 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57700000 total rows copied)
2006-06-14 05:37:28.56 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57800000 total rows copied)
2006-06-14 05:37:35.36 [89%] The replication agent was shut down in response to an abort request.


Does anyone know what is causing this error and how I can possibly solve it?

Best Regards,
JB Plum

View 14 Replies View Related

SQL 2012 :: Applications Cannot Connect Because Logins Cannot Connect To Their Default Databases

Oct 17, 2014

I designed the AlwaysOn wrong, but every time we fail over from primary server to another server, my applications cannot connect because the sql logins cannot connect to their default databases. Once I run the command to link the login with the user in the default database then the users are able to connect. Did I do something wrong when designing AlwaysOn?

View 9 Replies View Related

Connect To Object Explorer But Cannot Connect To Integration Services.

Mar 9, 2006



I try to import my SSIS packages which are created using the Business Intelligent studio into SQL server 2005 but I cannot do that.

I am running SQL server 2005 enterprise edition.

Also when i tried to connect to Integration services using Object explorer, it only prompt me for server name. I cannot change the username and password which is disabled.

Then how am i supposed to connect to Integration services on a server in this case?

View 4 Replies View Related

Cannot Connect W/ Java App But Can Connect W/ .Net App - SQL Server Express 2005

Dec 12, 2006

I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).

The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.

SQL Server Express 2005 is installed in mixed mode.

Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.

These are my values in my Java app web.xml -

<init-param>
<param-name>DBDriver</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
</init-param>
<init-param>
<param-name>DBURL</param-name> <param-value>jdbc:sqlserver://localhostsqlexpress:1055;databaseName=CORNERS</param-value>
</init-param>
<init-param>
<param-name>DBUser</param-name>
<param-value>sa</param-value>
</init-param>
<init-param>
<param-name>DBPwd</param-name>
<param-value>myPasswd</param-value>
</init-param>.

And yes, the port is 1055 - I checked to find it.

I am using Microsoft SQL Server 2005 JDBC Driver 1.0 (sqljdbc_1.0.809.102).

Does anyone have any idea what is wrong so that the login fails in the Java application but works in the .Net application?

View 7 Replies View Related

Connect By DSN

Sep 5, 2006

Hi, how can i connect MSSQL through System DSN. i know how to create DSN. but i don't know how to code the connection string. regards, 

View 1 Replies View Related

Connect To The DB??

Nov 21, 2007

Hi,
I am a beginner in asp.net so sorry for my question ..
I want to make the event for the button when clicked , inside this event I will be transfer the value of dropdownlist into the DB by use ( WHERE ) condition ..
My question is :
- how I write the connection to the DB ?? is this a connection statement in the web.config ?? or what ?? because it generate an error by this code.. SqlConnection sqlConnection1 = new System.Data.SqlClient.SqlConnection("Data Source=-SQLEXPRESS;Initial Catalog=2C2Mdb;Integrated Security=True");
SqlCommand cmd = new SqlCommand();cmd.CommandType = System.Data.CommandType.Text;cmd.CommandText = "INSERT Meeting (mSessionNO) VALUES (" + DropDownList2.selectedvalue + ") WHERE [HijriYear]=" + DropDownList1.SelectedValue ;
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery ();
sqlConnection1.Close();
 
 
What is the proplem ???

View 3 Replies View Related

Best Way To Connect Sql

Apr 28, 2008

HI,
May i know which is fastest and best way to connect sql with asp.net.I mean web.config appsetting or creat a class.vb throught public shared.
Thanks with best regards,

View 3 Replies View Related

CANNOT CONNECT

Jun 13, 2008

I have atlast installed SQL Server 2005 on Vista. However, when I try to connect using Database Engine as Server type, I get this message:===================================Cannot connect to MY-MACHINE-NAME.===================================Login failed for user 'My-Machine-NameUsername'. (.Net SqlClient Data Provider)------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476------------------------------Server Name: MY-MACHINE-NAMEError Number: 18456Severity: 14State: 1Line Number: 65536

View 1 Replies View Related

How To Connect?

Jun 21, 2008

I have created DSN connection for sql server database. Now How do I connect to database through code and open the table for retriving and saving records?

View 3 Replies View Related

I Don't Know How To Connect With Ms Sql

Jan 2, 2006

Hello,

View 1 Replies View Related

Can&#39;t Connect

Aug 20, 2001

I need help on SQL Server 7.0 on connection to the server. The error message is "General Network error, Check your network documentation, ConnectionOpen(Connect)" when I try to add SQL server registration.

I was able to the server but occasionally I couldn't able to connect to the server. Does anyone knows what I should do to fix the problem?

Thanks,
Neal

View 1 Replies View Related

Cannot Connect To SQL

Jan 20, 2000

When trying to connect to SQL Ent. Mgr., got an error message:

A connection could not be established to [servername] - cannot open user default database '<ID>'.
Using master database instead.
Please verify SQL Server is running and check your SQL Server registration properties...

I have not seen this message before. There is one server and 4 PCs. All worked fine before.
Now one PC connects, three - don't. Did not see anything unusual with the registration properties;
All users show in [servername]/security/logins. Did not notice anything relevant in the
"DBA survival guide".

Will appreciate any advice

View 1 Replies View Related

Connect With Asp

Feb 21, 2008

how to connect ASP with sql server

View 1 Replies View Related

Cannot Connect.

Nov 7, 2001

Hi there,
We just upgraded our webserver from NT4 to W2K and I now cannot connect from my desktop SQL Server client to the new SQL Server 200 in order to export data to the new database.
I just get the error "timeout expired".
What things should I be looking at to resolve this problem?

View 1 Replies View Related

Can't Connect To DB Using ASP

Oct 19, 2004

I am trying to connect to a SQL Server 2000 database using VBScript on an active server page, but I can't connect. I think my SQL Server may be set up wrong in the security settings.

I have my authenication set to Windows Authenication Only, and I have an "sa" account with a password.

Here is my code:


Code:



<%
dim objConn
dim sqlCmd
dim FromWebPage as string
FromWebPage = "FromWebPage"

'create connection
objConn = Server.CreateObject("ADODB.Connection")

'connect to the SQL Server db (local machine)
objConn.ConnectionString = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=(local);DATABASE=SteelBoard;UID=sa;PWD=password;"
objConn.Open

sqlCmd = "insert into TestTable (FirstName) values ('" & FromWebPage & "')"

'put data into database
objConn.Execute(sqlCmd)

'close the connection
objConn.Close
objConn = nothing
%>

View 1 Replies View Related







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