MSDE Issue

MSDE Issue

Post by Zelm » Sun, 19 Sep 2004 03:35:36


Hi,
I'm trying to connect to an instance of MSDE through
Installshield, and it gives the following error :
"Could not connect to SQL Server (local)\Instancename.
{DBNETLIB][connection open(connect())] SQL Server Not
found."

Also, I have another instance running on the same computer
and there is no error for the first instance.

Please advise. I have already emailed Installshield and
still have not heard back.
Thanks
-Zelma
 
 
 

MSDE Issue

Post by Sm9iIExvd » Wed, 06 Oct 2004 20:31:03

Can a client easily register an instance of MSDE using any third party GUI
or EM and get hold of our data structure? How can I over come this issue, if
I am installing MSDE on client computer?

thanx

 
 
 

MSDE Issue

Post by Andrea Mon » Thu, 07 Oct 2004 01:33:53

hi,
"Job Lot" < XXXX@XXXXX.COM > ha scritto nel messaggio


a MSDE instance can be easly registered as a linked server or in EM, from
remote (as long as the required network protocols are enabled) or local pc,
or using third party tools... as long as login privileges are set to the
logged user or a valid SQL Server login is known...
to access the databases, another issue must be granted (quite easy), that's
to say the logged user (login) is mapped to a valid database user...
if the login (both NT [trusted connections] or SQL Server [requiring "user"
and "pwd" credentials]) is member of WinNT administrators group (and thus)
or sysadmins server roles, he/she can actually do whatever he/she wants as
that membership grants illimitate privileges...
this design is part of the SQL Server security and can not be cut... so you
have to grant minimal privileges (server side) to logins in order to allow
only to specific logins the ability to access you databases..
a good article about security model is presented at
http://www.yqcomputer.com/
http://www.yqcomputer.com/
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.yqcomputer.com/ ://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
 
 
 

MSDE Issue

Post by Sundar » Tue, 26 Oct 2004 19:45:06

Hi,

I have a strange issue. We have a DataTable in MSDE with
800 columns. The column name strings are very long.. about
200 characters or more.

When we try to do BULK INSERT into this table, MSDE
results in a General Network error.

We use SQLDataAdapter.

I am working against a very extreme scenario.

Any help?

Regards
Sundari.
 
 
 

MSDE Issue

Post by Norman Yua » Wed, 27 Oct 2004 04:58:39

It is impossible to have column in a table with its name being longer than
128 characters. SQL Server/MSDE does not allow column name longer than 128
characters.
 
 
 

MSDE Issue

Post by vbnetde » Thu, 30 Nov 2006 20:17:46

When I install my instance of NETSDK MSDE I am trying to get it to appear as
the instance shown in the MSDE Explorer in the task bar. No other instance
is installed. How can I do this?
All I get right now is it saying it "not connected". It needs to show this
reference in the task bar explorer. Right now the icon is there but all it
shows is a white circle.
 
 
 

MSDE Issue

Post by Andrea Mon » Thu, 30 Nov 2006 20:40:14

hi,


try having a look at
http://www.yqcomputer.com/ ;EN-US;814132
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.yqcomputer.com/ http://www.yqcomputer.com/
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
--------- remove DMO to reply
 
 
 

MSDE Issue

Post by vbnetde » Thu, 30 Nov 2006 21:49:48

No dice but thank you. All services related to this instance go at startup
and run fine. They just are not showing up in the Explorer for some reason.