MSSQL 2005 - Connection Limitation?

Aug 29, 2007

I've searched the forums and found posts stating that there is no connection governer in the 2005 edition, but I am getting connection limitation errors. I have Standard Edition with 25 CALs.

------
A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.

-----

How can this be?


Thanks!



View 3 Replies


ADVERTISEMENT

ADO Connection To MSSQL Server 2005... Need Help

Oct 8, 2006

Hi,

at first a few things about my system:
I use Visual Studio 2005 Pro on WinXP SP2 and I have recently installed MSSQL Server 2005 Express on my system.

I want to establish a connection to the MSSQL Server from C++ (not .NET) using ADO.

For this I use the following connection String:

Open(L"Provider=SQLNCLI;Server=FREECASTLE;Integrated
Security=SSPI;DataTypeCompatibility=80;MARS
Connection=True;",L"",L"",ADODB::adConnectUnspecified);



This works. But this is not exactly that what I wanted, because here
just my Windows Authentication is used. I want to be able to pass
username and password for users that are allowed to access the SQL
Server. Here my first confusion begins: I have the option to pass the username and password into the connection string (User Id and Password) or I guess that I can pass them also as parameter 2 and parameter 3. But with trying both of these options I get always a connection error that my specified Username is not be trusted ( I don't know how the message looks in the English version, because I have the german version), but I suppose you know what I mean.

Of course I have to create such accounts in the SQL Server before trying to login with them. I guess that I made something wrong when doing this. I started the Server Manager Studio and there I navigated into the Object Explorer. In the folder Security I created a new account for testing (using SQL Server Authentication). But I cannot use that account for logging in.

I have to admit that I am very new to the SQL Server thing, so I hope someone can help me or can give me hints on what to do better. I am very thankful for every reply...

View 3 Replies View Related

MSSQL Server 2005 Remote Connection Problme

Nov 8, 2007




I am using MSSQL Server 2005 Express Studio and tryig to connetch to the remore server but does not work.

I get this 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.


Though I have read like child and made changes according to it.

http://support.microsoft.com/kb/914277

Still says same error.

I am clueless how to do it.

Do any one know web based mssql editor where i can connect mssql?


Thanks in advance.

View 2 Replies View Related

SSIS XML Connection Limitation

Jan 12, 2006

Hi,

I came accross this and spend a significant amount of time on it.  Thought I'd posit it for all.  I looks like 2005 SSIS has a limitation on the number of simultaneous transformations it can pull from an XML file using "XML source" as a dataflow.  I've got an XML / XSD that will load 20 tables.  I cannot put more than 13 into my data flow task.  If I do I get the error message below.  I've tried adding multiple OLE DB transformations to the same server/db and spreading my feeds accross the OLEDB destination connections and it still fails with the same error.  Despite the error pointing to the network I see no evidence of that.  I've tried everything and it consistently goes away when I have only 13 transformations and comes back as soon as I go up to 14.  I've not seen this documented as a limitation so I can only assume it's a bug.

BTW -- to get around the problem you can just add multiple data transfer tasks to the same SSIS project and that works fine.

Error: 0xC0202009 at Package, Connection manager "server1.conn1": An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.".

Error: 0xC020801C at Data Flow Task, OLE DB Destination 13 [12709]: The AcquireConnection method call to the connection manager "server1.conn1" failed with error code 0xC0202009.

View 2 Replies View Related

Slow Connection. ASP Page Querying A Linked Server On MSSQL 2005

Dec 28, 2006

Creating a web application.  Running a simple query "SELECT username FROM vwCustomer"

vwCustomer is a view built on top of an Access DB which is set up as a linked server.  Within SQL Server that view responds immediately.  But when I try to access it from an ASP page it takes over 20 seconds to respond.

Used the following to create the linked server:

EXEC sp_addlinkedserver 'DBName', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:databasesdatabase.mdb'

GO

EXEC sp_addlinkedsrvlogin 'DBName', FALSE, NULL, 'Admin', ''

GO

The view is simply(this works fine in SQL Server):

SELECT * FROM DBName.db.dbo.customer

The ASP page:

SELECT * FROM vwCustomer

Can anyone give me a hint as to where the bottleneck is?  Or how I can figure that out using SQL Profiler or something?

Please help!

View 3 Replies View Related

PHP5, Apache 2.2, MSSQL 2005 Express - Intermittant DB Connection Problem?

Feb 20, 2008

Hi all.

I've had a web service developed in PHP5 running on an Apache webserver for the last 9 months. It handles a lot of XML requests and stores/reads from an MSSQL Server 2005 DB (Express, if that matters).


Occasionally, I will come across the error 'Could not connect to database'. Refreshing the page works 99% of the time removes the error and the system continues as normal. I'd say this is happening about 1/100 requests at the moment, and my client is steadily becoming more irritated by it.


As far as I know, the system settings are mainly stock. It was set up by another developer.


I'm out of ideas with regards to debugging this problem.
Can anybody shed some light, or some possible solutions?




Kind Regards,
Jomn

View 9 Replies View Related

Deploying MSSQL 2005 Express DB To MSSQL 2005 WKGP Errors

Sep 29, 2006

DB is developed on local computer with MSSQL 2005 Express. My host is on MSSQL 2005 workgroup. Are they compatible, because I am getting errors? Is my approach wrong?

I have tried several approaches.

A) I created a backup of database on my local, then placed a copy on the server. Then I tried to restore through Server Management Studio. I get this error.

TITLE: Microsoft SQL Server Management Studio

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

ADDITIONAL INFORMATION:

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.

RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)

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

------------------------------

BUTTONS:

OK

------------------------------



B: I also have tried copying the database. I put it in the same path as the other databases that can be read with server management studio on the server. Then, tried to get to it through server managements studio and it did not appear. So I tried to attach it. Then I received this error:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Attach database failed for Server 'MROACH1'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

Could not open new database 'LodgingDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

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

------------------------------

BUTTONS:

OK

------------------------------

C: I have also tried opening the Database, and back up file through Server Management Studio. without success.

D: I also tried Windows and Software update at microsoft update, but no updates were recommended for Version on Server.

I'm surprised this is so hard. My original data base was created in same family of software. 2005 MS SQL Express. I could use some direct help from someone experienced with this. Am I doing it wrong or are the DB versions incompatible.

Mark Roach





View 5 Replies View Related

Is SQL 2005 Memory Limitation &&<= OS Memory Limitation?

Nov 13, 2006

If I install SQL 2005 Standard on Windows 2003 Standard, is SQL limited to 4 gigs of physical RAM?

I'm planning a new system that will run SQL 2005 Standard edition on a Windows 2003 Standard platform. The spec calls for 8 GB of RAM. My experience would lead me to suspect I need to install Windows 2003 Enterprise to take advantage of all the installed memory.

View 3 Replies View Related

SQL Agent Limitation (SQL 2005)

May 17, 2006

Hello everybody,

Can someone tell me if there are any limitation in SQL Server Agent of SQL Server 2005?

I have a Windows 2003 Enterprise R2 with 16GB RAM and SQL Server 2005. However my SQL Agent log say:

"Message
[310] 4 processor(s) and 4096 MB RAM detected"

Any KB related?

thanks a lot

View 1 Replies View Related

SQL Server 2005 Database Size Limitation

Apr 2, 2007

HI Everyone,
I understand that there is a 4GB size limitation on SQL Server Express edition. right?
What I want to know is what if a database file created in SQL Express is hosted with SQL Server 2005 will the file still have the 4 GB size limitations?
Thanks

View 9 Replies View Related

SQL Express 2005 Data Storage Limitation

Sep 5, 2007

Hello,
I am designing a program for work with SQL Server express 2005. But I don't know what is the data storage limit in this version of SQL Server.
What i want is storing about 30000 records in a table of the database.
Hasn't SQL Server express 2005 any problem or restrictions for storing the data?
Please advice in this regards,
Thank you,
Mona 
 

View 3 Replies View Related

FlatTextFile Licence Limitation With SQL 2005 Standard

Oct 12, 2006

I have developped a package that loads a flat text file into DB.

Runs OK from SQL BI Studio.

When I run it from SQL IIS, I have the following error message

"Erreur, le niveau de produit est insuffisant pour composant <<file IN>>"

that let me think this FLATTEXT ConnectionManager is only in SQL 2005 Enterprise version?

Can you help?

View 4 Replies View Related

Developer Limitation Under SQL 2005 Under Vista Ultimate 64 Bit

Aug 4, 2007

Just to be clear, I would like to know if a problem I face is due to an error on my part or a limitation on Microsoft's. In my experience (several hours-long installations, removals, reinstallations, using the skuupgrade=1 parameter from the command line, ad nauseum) I have concluded that the best one can do installing SQL Server 2005 Developer Edition from the Visual Studio 2005 Professional Edition package is to get the Express Edition, (actually styled MSSMLBIZ). In particular, what I'm hoping to be able to do is program to a test database that I have from my client, which I was able to do on my XP Professional machine. But on my new Vista Ultimate 64 bit machine (which will only let me install the x64 version of SQL Server 2005), I get an instance that is characterized as SQL Server Express and generates the following error message when I try to attach to the same MDF file to which I was able to attach under my prior, XP-Pro based configuration:


TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'ZAPHOD42MSSMLBIZ'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

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

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft SQL Server, Error: 1827)

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

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

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


===================================================================================
The following is the Help obtained when clicking on the button on the error msg and the references in the error msg:
===================================================================================

Details
ID: Attach database Server
Source: Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText

We're sorry
There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.


--------------------------------------------------------------------------------


Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.


Currently there are no Microsoft Knowledge Base articles available for this specific error or event message. For information about other support options you can use to find answers online, see http://support.microsoft.com/default.aspx.

==================

Details
ID: 1827
Source: MSSQLServer

We're sorry
There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.
Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.

==========End of reproduction of error messages and help text ====================================

The Developer Edition, of course, is supposed to enable us to program to all levels of the database, and I would hate to think it is really crippled in this way, but after uninstalling everything, reinstalling multiple times (devoting several days to the process), it sure beats me how I can overcome this problem short of going back to my old machine. Any definitive answers on this apparent limitation, or useful procedural advice on installation quirks, would be appreciated (and, yes, I've spent a lot of time going through the installation/setup forum -- if the answer is there I can't find it).

View 5 Replies View Related

1 GB Memory Limitation For SQL 2005 Express Edition

Mar 17, 2006

Question:

Can the SQL 2005 express edition can be installed on a machine that has more than 1 GB memory?

If so, is the SQL 2005 express edition will be using memory upto 1 GB?

 

 

View 3 Replies View Related

Server Configuration For MSSQL 2000 And MSSQL 2005

Sep 6, 2006

Does enabling/disabling Data Execution Prevention have a performanceimpact on SQL 2000 or SQL 2005?For SQL best performance - how should I configure for:Processor Scheduling:Programs or Background servicesMemory Usage:Programs or System Cache

View 9 Replies View Related

Creating Index In MSSQL 2000 From MSSQL 2005

Mar 24, 2008

Hi,

I am a bit new to the MSSQL server. In our application, we use so many SQL queries. To imporve the performance, we used the Database enigine Tuning tool to create the indexes. The older version of the application supports MSSQL 2000 also. To re-create these new indexes, I have an issue in running these "CREATE INDEX" commands as the statements generated for index creation are done in MSSQL 2005. The statements include "INCLUDES" keyword which is supported in MSSQL 2005 but not in MSSQL 2000.

Ex:-

CREATE INDEX IND_001_PPM_PA ON PPM_PROCESS_ACTIVITY

(ACTIVITY_NAME ASC, PROCESS_NAME ASC, START_TIME ASC, ISMONITORED ASC)

INCLUDE

(INSTANCE_ID, ACTIVITY_TYPE, STATUS, END_TIME, ORGANIZATION);


Any help in creating such indexes in 2000 version is welcome.

Thanks,
Suresh.

View 2 Replies View Related

Generating Script For MSSQL 2000 From MSSQl 2005?

May 3, 2008

Hello
We are using SQL 2005 and now we are planning to use SQL 2000. what are the ways to do the process.

We taken the script spcificall for 2000 and run it in SQL 200. But we are getting the error in SCRIPT?

Could you please give me the step to do?

Thanks,
Sankar R

View 6 Replies View Related

SQL Server 2005 Limitation: Having Many Attributes For Neural Network

May 21, 2007

Hello,

Say that I have 100,000 attributes/feature selections for my SQL Server Neural Network Algorithm.

Customer Attr1 Attr2 Attr3 ..... Atr100000
==============================
Jack 1 0 1 ..... 1
Sam 0 1 1 ...... 0
Mary 1 1 0 ...... 1

Knowing the fact I can't fit those info on a table and SQL Server's Neural Network does not support table prediction . What's an alternative to use Neural Network in SQL Server 2005 to solve my problem?

Please assist!


Mary

View 5 Replies View Related

Migrate MSSQL 2005 Express -&&> MSSQL 2005 Srv

Apr 25, 2006

Hi!

What is the best way to migrate MSSQL 2005 Express -> MSSQL 2005 Srv?

View 4 Replies View Related

MSSQL Express 2005 Vs. MSSQL 2000

Jun 15, 2006

Ben writes "I have a sql script that doesn't function very well when it's executed on a SQL 2000 server.

The scrpt looks like this:


---------------------------------------------------------------------------------------------------
USE [master]
GO
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'SSDBUSERNAME')
EXEC sp_addlogin N'SSDBUSERNAME', N'SSDBPASSWORD'
GO
GRANT ADMINISTER BULK OPERATIONS TO [SSDBUSERNAME]
GO
GRANT AUTHENTICATE SERVER TO [SSDBUSERNAME]
GO
GRANT CONNECT SQL TO [SSDBUSERNAME]
GO
GRANT CONTROL SERVER TO [SSDBUSERNAME]
GO
GRANT CREATE ANY DATABASE TO [SSDBUSERNAME]
GO
USE [master]
GO
If EXISTS (Select * FROM master.dbo.syslogins WHERE loginname = N'SSDBUSERNAME')
ALTER LOGIN [SSDBUSERNAME] WITH PASSWORD=N'SSDBPASSWORD'
GO
GRANT ADMINISTER BULK OPERATIONS TO [SSDBUSERNAME]
GO
GRANT AUTHENTICATE SERVER TO [SSDBUSERNAME]
GO
GRANT CONNECT SQL TO [SSDBUSERNAME]
GO
GRANT CONTROL SERVER TO [SSDBUSERNAME]
GO
GRANT CREATE ANY DATABASE TO [SSDBUSERNAME]
GO
USE [master]
GO
IF EXISTS (select * from dbo.sysdatabases where name = 'ISIZ')
DROP DATABASE [ISIZ]
GO
USE [SurveyData]
GO
exec sp_adduser 'SSDBUSERNAME'
GRANT INSERT, UPDATE, SELECT, DELETE
TO SSDBUSERNAME
GO
USE [SurveyManagement]
GO
exec sp_adduser 'SSDBUSERNAME'
GRANT INSERT, UPDATE, SELECT, DELETE
TO SSDBUSERNAME
---------------------------------------------------------------


I need to be converted to a script that can be executed on both MSSQL 2000 and MSSQL 2005.

I was wondering if somebody there could help me with this problem?!

Thanks,
Ben"

View 1 Replies View Related

Migration MSSQL 2000 32-bit To MSSQL 2005 64-bit

Nov 17, 2007

I've been tasked to move our production databases on MSSQL 2000 to 2005. I've supported MSSQL since version 6.5 and performed migrations to successor versions.

Current Environment is MSSQL 2000 32-bit with current Service Packs.

I've performed mock migrations on Test servers upgrading all Production instances simultaneously from MSSQL 2000 to 2005 32-bit. The Test environment is identical to Production minus server name, IP etc. Also I have a separate server with MSSQL 2005 installed where I use the DETACH / ATTACH and BACKUP / RESTORE method for migration / acceptance testing. There are approximately 30 databases totaling 70 GB. This has gone as expected and fairly successful. Vendors have been coordinated with to update code and staff for acceptance testing.

I'd prefer going directly to MSSQL 2005 64-bit instead if possible due to memory benefits etc. This is where I'd like some feedback prior to borrowing a 64-bit server for testing.

Upgrade options:

1. Is it better to migrate from MSSQL 2000 32-bit to 2005 64-bit via:
a. DETACH / ATTACH
b. BACKUP / RESTORE
c. Is one method more advantageous relating to the end result?
2. Regarding XP clients, have issues been experienced with the default SQL Server driver or is an alternate recommended for XP clients to connect to a MSSQL 64-bit server databases?
3. If you have performed this migration and have relevant experience please pass them along.

View 3 Replies View Related

MSSQL Connection

Feb 8, 2006

Hi all,

Why doesn't my connection to ms sql server 2005 work?

Get this error...
Error connecting to server. Server says: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I set up a DSN which is working.(tested ok anyway)
What do I need to do?
Thanks.


PHP Code:




// Configure connection parameters
$dsn = "localhost";
$username = "training";
$password = "training2";

// Connect to DB
$db_link = odbc_connect($dsn, $username, $password)
   or die('Error connecting to server. Server says: '.htmlspecialchars(odbc_errormsg()));

// Select Database
mssql_select_db('training_dub') or die('Error connecting to Database. Server says: '.htmlspecialchars(odbc_errormsg())); 

View 2 Replies View Related

Mssql Database Connection

Sep 8, 2005

I've come from the asp world into .NET and I have looked all over the web for the proper way to make a database connection to a MSSQL server and all I have found is samples of connections to Access databases. Can anyone point me in the direction of how to create a db connection for microsoft sql server.thanks

View 1 Replies View Related

MSSQL ADO Connection Problems

Jul 9, 2007

I am connecting to the mssql database using ADOdb. It states that the connection was successful however, none of the query functions are working....

I get the following error:
[unixODBC][Driver Manager]Data source name not found, and no default driver specified

Any helped would be greatly appreciated.

Thanks



Code:


<?php

require_once('config.inc.php');
include('/usr/local/adodb/adodb.inc.php');

ADOLoadCode("ado_mssql");

$spevent = $_POST['spevent'];
echo $spevent."<br>";

$db = ADONewConnection('odbc_mssql');
$dsn = "Driver={SQL Server};Server=SPSERVER;Database=SPDATABASE";
$db->Connect($dsn,SPUSER,SPPWD);

if($db) {
echo "Connection Successful<br>";
$sql = "Select ID from tblEvent where ID = '26622'";
$rs = $db->Execute($sql);
if(!$rs){
echo "Bad<br>";
echo $db->ErrorMsg();
}
else{
echo "Good<br>";
}
}
else{
echo "Error in connection";
exit;
}
?>

View 2 Replies View Related

MSSQL Connection Problem

Feb 17, 2007

I am new to MSSQL but have some experience with MySQL. Now, I am trying to connect to a recently installed MSDE 2000 SP3 on my box, using dbManager Professional, (a 3rd party manager) but all attempts to connect have failed.

The first error message when I start dbM is:

Connection failed:
SQLState: '42000'
SQL Server Error: '18456'
Login failed for user 'Administrator'

(There are no passwords assigned.)

There are successive error messages if I keep forcing the issue, with additional error indicators.

MSSQL is running and the .ini file contains these 2 lines:

BLANKSAPWD=1
SECURITYMODE=SQL

I have searched the web for solutions for all of the above messages, and implemented some logically sound advice, but these solutions, which worked for others, don't solve this problem for me.

The OS is XP Professional SP2
AMD 64 Sempron 1800+
1GB of RAM.

Any suggestion is greatly appreciated.

ineuw

View 2 Replies View Related

[MSSQL + VS.NET] Connection - Sleeping

Jul 20, 2005

HelloI've prepared a small aplication in VS.NET and I use SqlConnection class.Everything is ok, but when I'm trying to disconnect from server usingif (cnSQL->State != ConnectionState::Closed) cnSQL->Close()there is still connection do server present. I have to close connectionbecause I'm trying to drop this database.Have you ever heard about this kind of problem??Trociu--Plain-text over all!!!/**********/write me : trociu@autonom ict pwr wroc plsearch me : gg: 1382729

View 1 Replies View Related

Conversion Of MSSql 2000 Database To MSSQL 2005 Database

Jan 18, 2008

How to convert a database in MSSQL 2000 to MSSQL 2005 database.Is there any tool or documentation available for this?

View 3 Replies View Related

How Can Upload And Connection My Mssql Database My Site

Jan 12, 2007

I make a site in my computer it's work localhost I make mssql connection in localhost but ı don't know how i make mssql connection on website
 

View 5 Replies View Related

Error 40: Could Not Open A Connection To Mssql Server

Mar 22, 2007

Hi,I'm using  sql server 2005 express edition. I have created a database using sql server management studio express edition. Now I'm trying to connect it in visual studio 2005. It show following error. An error has occurred while establishing a connection to the server. When connections to SQL 5erver 2005, this failure may be caused by the fact  under the server's 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 enables named pipes from Sql services configuration manager.

View 1 Replies View Related

Connection Problem MSSQL SERVER && PWS Same Machine

Jun 14, 2004

Im getting an error when i try to connect to my MS SQL database

0x80040e21 .... multiple-step ole db operation generated errors ....check each ole db status value

this code works connecting to database via web hosting, only things i changed was to replace the server with "(local)" [also tried ip no joy there either] and add integrated security to the connection string

ms sql server and IIS, personal web server all on same laptop, i can access the same database with same details no problem to login it gives up on the subsequent login

code (generally)

Set objconn=Server.CreateObject("ADODB.Connection")
objconn.ConnectionString="SERVER=(local);Database=blah;uid=blah1;pwd=blah2;Integrated Security=true;"

objconn.open


can anybody help

ta, b

View 5 Replies View Related

Extremely Slow Client Connection To MSSQL

Jan 26, 2007

Hallo

i'm experiencing an extremely slow connection from a WXPP Sp2 client to a MSSQL2000 running on a W2k server. The client is running a VB6 application that connect with Windows authentication: every form requesting data opens with a long delay at the first launch; next attempts run normally fast.

In the same LAN there are some others identical clients, all running fine.

Every other network activity from that client is ok.

Where should i start to investigate from?

View 3 Replies View Related

MSSQL ODBC (SQL) Connection Issue (sqlstate 2800)

May 27, 2006

I am trying to make an ODBC connection to a MSSQL 2K server on a remote machine. I am using the SQL Server driver and can see the server in the drop down list when asked which server I would like to connect to. I am using SQL authentication over TCP/IP.

The error occurs when ODBC tries to connet to SQL server to obtain the default settings. The error I receive is as follows:

Connection Failed;
sqlstate '28000';
sql server error: 18456;
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'XXXX'

I have tried setting up alternate SQL Server users with varying security rights on the server but am not able to setup the ODBC connection.

I am setting the ODBC connection up on a windows XP SP2 machine.
The remote server is running Windows server 2003 (patched upto date) and MS SQL server 2K (SP3). The connection is over a LAN and does not pass through any firewalls (hardware or software). I can create the ODBC connection without issue locally on the server.

This is my first time creating an ODBC connection to a Windows 2003 Server and I am wondering if there is some additional config I may have missed out.

Many thanks.

View 3 Replies View Related

Mssql 2000 Kill All User Connection For Restore

Apr 22, 2004

i need a sql statment or procedure to kill all user connection to one database.
And Deny new connection for a little time.
So i can a restore this database from a dump.

I can this do only in exclusiv modus. without any other connection.

Can anybody help me??

thanks and best regards from Berlin, Germany

View 4 Replies View Related







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