|
Administering MSDE with Enterprise Manager
Can I administer SQL 2000 MSDE Release A from SQL Server's Enterprise
Manager (EM) located on another machine on the same network?
When I try to do this the EM setup wizard locates the host running MSDE but
it cannot connect either with Windows authentication or the strong password
created during MSDE's insta ...
Mon, 20 Sep 2004 13:42:59 -0500
|
Timeout when inserting BLOBs
I have a problem with a system developed for a client. The aplication is
adding jpg images as BLOBs to rows in a table in SQL2000. However, the system
has failed twice as the application cannot insert records to the table.
Other tables that don't contain BLOBs can still be written. If I alter the
stored p ...
Mon, 20 Sep 2004 08:37:06 -0700
|
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link
Hi, when using EM to open any table or diagram from a particular database I
get the following message (no error number)
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
Ib ve run DBCC CHECKDB and everything seems ok.
I sometimes use ms access to view the data and I get a connect ...
Mon, 20 Sep 2004 00:41:03 -0700
|
Unable to Connect to SQL Server 2000
I got an extremely serious problem with SQL Server 2000 now. Without
it, I couldn't start SQL and continue my programming work in SQL CE(I need
both). Please kindly give me some help concerning the problem below:
1. When my pc starts, sometimes the SQL Server and the SQL Server Agent
doesn't start. ...
Sun, 19 Sep 2004 12:05:28 -0700
|
I tried it ,even now same problem
Hi
I tried it even now I am experiencing the same
problem.Actually the problem was I have make this sql
server as additional dc for the domain and disjoined from
domain .now it's on the same domain
Regards
Chris ...
Sun, 19 Sep 2004 23:19:43 -0700
|
Problem with ASP & SQL ODBC connection
Hi everyone, I need your expert advice. I have a w2k AD service with mssql on
it. and I setup another w2k server with IIS on it as webserver. my website
works on NT servers, but when I moved the website to the w2k server, it
doesn't work. It saids:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0 ...
Sun, 19 Sep 2004 18:23:07 -0700
|
Unable to register new server in Enterprise Manager
I've been looking at this problem for hours and hours - any help most
gratefully received!
I'm trying to set-up a test scenario between my desktop running SQL Server
2000 and my laptop (also running SQL Server 2000). Both machines are
connected to a Netgear DG834G router, although if I hard-wire the two
...
Sun, 19 Sep 2004 18:02:06 +0100
|
Unable to open Enterprise manager
Hi
While I am trying to open enterprise manger it's showing
the error login failed to the user,Even I am trying to use
domain adminacct I am unable to open it.My sql server
agent also not starting
Chris ...
Sun, 19 Sep 2004 05:28:58 -0700
|
Installation/Connection problems with MS Desktop Engine
Actually, it appears to install fine. I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with X ...
Fri, 17 Sep 2004 22:35:43 -0400
|
UDL no longer working on ONE PC
Forgot to add the error i'm getting is:
"Login Failed. Catalog Information cannot be retrieved".
This is after getting a successful "test Connection
succeeded."
thanks
>-----Original Message-----
>My Data Link (udl) files stopped working on just one of
>my pcs. The pc has been updated with mdac 2.8. ...
Fri, 17 Sep 2004 13:45:21 -0700
|
UDL no longer working on ONE PC
My Data Link (udl) files stopped working on just one of
my pcs. The pc has been updated with mdac 2.8. I cant
figure out what could have caused the 'corruption'? but
i've tried creating a new one and get the same error.
Any suggestions besides making sure MDAC is up to date?
thanks
joan ...
Fri, 17 Sep 2004 13:18:56 -0700
|
AS400 ODBC connection
I was able to successfully create a linked server to AS400 box without
any problem. But now, due to some reason the following query does not
return any data (0 rows)
Select * from openQuery(CWBIS800, 'select * from lib.tb where cmln =
10001001')
whereas the following query does return the correct record.
...
17 Sep 2004 12:47:53 -0700
|
Use a Trusted Connection With OPENROWSET?
Has anybody, anywhere figured out a way to use a trusted connection (Windows
authentication) with OPENROWSET? The first two queries below used to work
just fine because they use SQL authentication. The four queries after that
are various sad, sad (and unworking) attempts I've made at using Windows
authenticat ...
Fri, 17 Sep 2004 09:59:45 -0500
|
SQL Server and Windows XP SP2 - problems recognizing user in trusted connection
Hi,
I have SQL Server 2000 SP3a installed on Windows 2003 server.
Client is Windows XP machine. Up to today I have no problems connecting to
SQL Server - my Windows ID is assigned as SQL administrator.
This morning I installed Windows XP SP2. I logged in to windowx XP using my
usual userID (lets say): myDoma ...
Fri, 17 Sep 2004 11:00:09 -0400
|
Starting, connecting to MSDE from command line
I am trying to start and connect to an MSDE instance on my PC using a
sqlservr.exe and osql but I have no success. Anybody knows how to do this
(the documentation does not say much on this). When I connect to the server
through the Enterprice Mgr then the rest of the batch file (attaches db,
creates login a ...
Fri, 17 Sep 2004 00:23:05 -0700
|