Not able to connect EM & QA...

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
instancename=myinstanceName

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
message:
    "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?

Thanks.

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

Hi all,

SETUP
-----
I've installed the following on my staging server (pretty fresh
installs):
- Windows XP SP1
- SQL 2000 Developer Edition
- Server MYSERVER
- 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, 192.168.0.2 and 192.168.0.11. One of
them runs a proxy, the other a mail server.


PROBLEM
-------

- 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=192.168.0.2; Network
Library=DBMSSOCN; Initial Catalog=MYDATABASE; User ID=sa;
Password=mypassword;"


FACTS
-----

- 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 192.168.0.11 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.


LIMITATIONS
-----------

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





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