Not able to connect EM & QA...



  • 1. multiple server update
    hello, Suppose i have a transaction which updates multiple tables on multiple servers,how do I get the confirmation that the update on a specific server is complete? I can use @@error , but even if it is zero it is not necessary that the update has happened. is there any other way? thanks, regards, harshal.
  • 2. Replication Problem
    Dear Professional I have created the replication b/w two servers and when I do alter the table then it gave me an error that to can't drop the table b/c it 's being used for replication, I am altering the table on Publication Server. Regards Waiting for your reply !
  • 3. Use openrowset with Oracle
    How can I execute a select with OPENROWSET and extract only the record that I request with the WHERE clause? For example: SELECT a.* FROM OPENROWSET('MSDAORA','DBORACLE'; 'USER'; 'PWD', 'select * from TABELLA' ) AS a WHERE a.Cognome like @Cognome With this SQL statement, SQLServer extract first all the record of TABELLA (500.000 records) and than apply the WHERE clause, while I want to apply the WHERE clause in Oracle. Does Someone known the right statement? Thanks in advance
  • 4. BCP -R option
    Hi all, I m trying to use BCP utility to upload a huge text file. As per microsoft documentation, -R is used to specify the regional settings. My computer (client) and the sql server (running in a network machine) has dd/mm/yyyy as the regional settings. The incomming text file also has date in dd/mm/yyyy format. But when i execute BCP with -R option, i still get an invalid date format error message. I went through a few microsoft support information, that told me that SP1 should solve this problem. I got SP3a installed (both in client and in the server). So what am i missing here??? I m sure some of u here should have also faced the problem. Any type of help is greatly appreciated. thanks and regards, s.ravi sankar

Not able to connect EM & QA...

Postby Farhan Iqbal » Thu, 14 Aug 2003 18:30:23 GMT

 I am not able to connect my SQL Server 2000 Machine, from client, EM & QA
both are giving following error.

A connection could not be established to [Server Name]
Reason: Data source name not found an dno default driver specified.

I am not able to understand before few minutes I was connected from same
client and now it's giving error  plz help .

Re: Not able to connect EM & QA...

Postby Michiel Wories [MS] » Sun, 12 Oct 2003 00:29:12 GMT

Still have that problem? It looks like a corruption of your settings
(registry). I have seen a fix for it but it's not straightforward. Let me
know if you still need it.

Michiel Wories, SQL Server PM

This posting is provided "AS IS" with no warranties, and confers no rights.

Similar Threads:

1.not able to connect to MSDE A server on workstation with EM

I have installed MSDE A on W2K Pro with the following command line:

c:\msderela\setup.exe sapwd= mypassword securitymode=SQL

This works.

I can then setup ODBC using the named instance successfully.
I can start/stop the server using the SQL Server manager utility.
I can connect to the server using Query Analyizer.

I cannot connect to the server using a local EM. I get the following error
    "SQL Server does not exist or access denied"

I was able to successfully acomplish this when I had MSDE 1 (7.0) setup.

Any suggestion?


2.SQL 2000 Developer - Login Failed using SQLOLEDB, QA and EM have no problem connecting

Hi all,

I've installed the following on my staging server (pretty fresh
- Windows XP SP1
- SQL 2000 Developer Edition
- Uses TCP/IP in standard port and Named Pipes in standard folder.

Security is set to:
- Service account: System Account
- Authentication: SQL Server and Windows
- SA has a password assigned

I created the following database, with no tables (other than system,
of course) for login testing purposes:
- Database: MYDATABASE

Misc. info:
- Server has two IPs assigned, and One of
them runs a proxy, the other a mail server.


- Trying to connect to the database from within my ASP and VB
applications returns "Login failed for user 'sa'.".
- Connection string is as follows: 
  "Provider=sqloledb; Data Source=; Network
Library=DBMSSOCN; Initial Catalog=MYDATABASE; User ID=sa;


- I can connect with no problems with both Query Analyzer and
Enterprise Manager using MYSERVER as data source.
- That very same connection string works perfectly when connecting to
the production server (running SQL 7.0 on XP) on another IP.
- SQL Server 7.0 was working just fine on this very same machine prior
to a complete format and reinstall.

Failed workarounds:
- I've also tried using and MYSERVER as Data Source.
- I've created a new user and login with ownership over MYDATABASE.
Same problem arises.
- I've updated to MDAC 2.8.


- Server must be running under XP.
- SQL Server must use it's own login (Windows Authentication is not

I'll apreciate any help you can provide on solving the problem. Hope
you like the report-style format.

Thanks in advance.

3.EM does not display table created using QA

4.Query working in EM and QA but not in Store proc

5.SQL EM can not Delete and Restore database but SQL QA can, need he

Hi All
   We upgrade the program which update Database 'THER' and it hang, at that 
time we upgrade again to 'THER2' and this time is success, we expect we can 
use the new backup of 'THER2' to restore to 'THER' by SQL EM, now we have the 
problem we can not use EM to delete or restore with 'THER' (Backup,detach is 
OK) , SQL EM will hang both at local Server and remote EM (check to confirm 
no user in 'THER' at that time), all use 'sa','xxx' as loginname and 
password. This will have no problem for 'THER2' on the same server.  We 
detached 'THER' and rename 'THER2' to 'THER' the database is work fine, but 
the new 'THER' fall to the same pattern can not delete or restore. We found 
that 'THER' can be deleted and restored by SQL QA with use 'sa','xxx' as the 
same as EM connection. Would you please help to correct this problem? I still 
have no clue but I beleive nothing wrong with EM because remote and local 
have the same problem just only 'THER' database.  Thanks you in advance.

6. Not able to generate XML from DSO nor able modify DSO from existing XML

7. not able to connect sqlserver in windows 2003

8. not able to connect to sqlserver



Who is online

Users browsing this forum: No registered users and 54 guest