Having trouble connecting to MSDE

I have a very basic workgroup at home. I have three
computers, two of them on XP Pro (the ones I'm using MSDE
with). I was able to install MSDE and I see the icon on
my system tray. Now, I was reading how to upsize an
Access database from this page
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnmsde/html/msdeforvs.asp
I choose to create a new database after starting the
Upsize wizard. Then I choose the server, which shows up
in the drop down box. Then it asks me for a username and
password that has "CREATE DATABASE" privileges on the
server. So I put my administrator user name and password
in, then choose the name of my new MSDE database, but it
won't connect. I then tried using no username or
password and I get another error message. What's going
on?
This is a link to my errors.
http://www.neolinkcomputers.com/stuf...tion_errors.ht
m
Thanks
hi,
"Culbert" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:9fc901c47908$3cad5bf0$a501280a@.phx.gbl...
> I have a very basic workgroup at home. I have three
> computers, two of them on XP Pro (the ones I'm using MSDE
> with). I was able to install MSDE and I see the icon on
> my system tray. Now, I was reading how to upsize an
> Access database from this page
> http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/dnmsde/html/msdeforvs.asp
> I choose to create a new database after starting the
> Upsize wizard. Then I choose the server, which shows up
> in the drop down box. Then it asks me for a username and
> password that has "CREATE DATABASE" privileges on the
> server. So I put my administrator user name and password
> in, then choose the name of my new MSDE database, but it
> won't connect. I then tried using no username or
> password and I get another error message. What's going
> on?
> This is a link to my errors.
> http://www.neolinkcomputers.com/stuf...tion_errors.ht
> m
> Thanks
the reported errors indicate :
a) you instance is set to only allow Windows NT (trusted) connection, which
is the default when installing MSDE on Windows NT platform... in order to
allow SQL Server authenticated connection, please have a look at
http://support.microsoft.com/default...b;en-us;285097 for further
info in order to change this behaviour both at install time and later...
b)you windows account you are using to connect to that MSDE instance is not
granted login provileges...
you have to login with a sysadmin login, usually part of
builtin\administrators of SQL Server, and grant that windows account login
privileges using sp_grantlogin system stored procedure
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
_sp_ga-gz_8dri.asp) and then grant database access to that login for all
desired databases using sp_grantdbaccess system stored procedure
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
_sp_ga-gz_290z.asp)
for your convenience, you can have a look at a free prj of mine at the link
following my sign., which provides a user interface similar to Enterprise
Manager, which provides these functionnalities too in a viusal way..
further free and/or commercial tools for managing MSDE can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||
>--Original Message--
>hi,
>"Culbert" <anonymous@.discussions.microsoft.com> ha
scritto nel messaggio[vbcol=seagreen]
>news:9fc901c47908$3cad5bf0$a501280a@.phx.gbl...
MSDE[vbcol=seagreen]
http://www.neolinkcomputers.com/stuf...tion_errors.ht
>the reported errors indicate :
>a) you instance is set to only allow Windows NT (trusted)
connection, which
>is the default when installing MSDE on Windows NT
platform... in order to
>allow SQL Server authenticated connection, please have a
look at
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;285097 for further
>info in order to change this behaviour both at install
time and later...
>b)you windows account you are using to connect to that
MSDE instance is not
>granted login provileges...
>you have to login with a sysadmin login, usually part of
>builtin\administrators of SQL Server, and grant that
windows account login
>privileges using sp_grantlogin system stored procedure
>(http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/tsqlref/ts
>_sp_ga-gz_8dri.asp) and then grant database access to
that login for all
>desired databases using sp_grantdbaccess system stored
procedure
>(http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/tsqlref/ts
>_sp_ga-gz_290z.asp)
>for your convenience, you can have a look at a free prj
of mine at the link
>following my sign., which provides a user interface
similar to Enterprise
>Manager, which provides these functionnalities too in a
viusal way..
>further free and/or commercial tools for managing MSDE
can be found at
>http://www.microsoft.com/sql/msde/partners/default.asp and
>http://www.aspfaq.com/show.asp?id=2442
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
Incredible! I haven't tried this yet, but I'm confident
that this will work. Thank you for such a great response!!
>
|||Hi,
Maybe I should start a new thread, but my problem is the same, except that I know that the problem is my TCP/IP Access is disabled to MSDE.
I have no Enterprise Manager, any idea wich registry key I need to modify to enable TCP/IP Access?
(Similar to the SQL/Windows Authentification problem?)
Thanks!|||hi,
"uritsukidoji" <uritsukidoji.1aq8cb@.mail.mcse.ms> ha scritto nel messaggio
news:uritsukidoji.1aq8cb@.mail.mcse.ms...
> Hi,
> Maybe I should start a new thread, but my problem is the same, except
> that I know that the problem is my TCP/IP Access is disabled to MSDE.
> I have no Enterprise Manager, any idea wich registry key I need to
> modify to enable TCP/IP Access?
> (Similar to the SQL/Windows Authentification problem?)
> Thanks!
have a look at Server Network Utility (svrnetcn.exe) for server side
settings, and ClientNetwork Utility (cliconfg.exe) fro client side part
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

have WMSDE, need MSDE

Hi.
I'm about to install an MSI-packaging software, which needs either MS SQL
(we don't have it) or MSDE. I already have WSUS running and it uses WMSDE.
Can I install install MSDE (distributed with the software) without screwing
up WSUS/WMSDE?
Antti
hi Antti,
Antti wrote:
> Hi.
> I'm about to install an MSI-packaging software, which needs either MS
> SQL (we don't have it) or MSDE. I already have WSUS running and it
> uses WMSDE. Can I install install MSDE (distributed with the
> software) without screwing up WSUS/WMSDE?
>
yes you can... just intall a separate named instance of MSDE... up to 16
instance of SQL Server 2000 and MSDE can be installed on the same machine..
each instance will have it's own binaries, memory space, registry entries
and the like..
they will only share the shared components at the highes service pack level,
like SQL-DMO... you can find shared components in \Program Files\80 filder
and subfolders..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:48a98fFj70h1U1@.individual.net...
> yes you can... just intall a separate named instance of MSDE... up to 16
> instance of SQL Server 2000 and MSDE can be installed on the same
> machine.. each instance will have it's own binaries, memory space,
> registry entries and the like..
and thanks, it worked fine.
Antti
sql

Hardware needed??

I'm currently running a msde 2.8 server on a pentium 4 2.4 with 512 megs of memory and it is slow for client computers. What would you suggest for a server Memory, processor, mirror hard drives?

The software I am running is a Point of sale software package. The server is currently running on one of the registers and I'm plan on installing a back office server. Any advise would help greatly.All you can get?

Without knowing a LOT more about what you are doing, what problems you've had, what you want to add, etc, we're pretty hard pressed to give you simple answers!

-PatP|||The current problems that I am having is. When a item is scanned it takes 30 seconds to come back with a product. I am wanting to run a windows 2003 server running msde and in the future switch it to sql 2005. My database is around 130 megs and growing. In 2 years it will be around 1gig or larger. I have 2 clients currently but may grow up to 5 clients.|||Typically the fetch of an SKU (roughly the same thing as what you are doing) takes about 275 ms using a full blown copy of SQL Server. It shouldn't be a bunch slower for MSDE unless you are running into connection throttling somehow (MSDE only permits at most 5 running threads at one time).

Are you certain that the delay is really happening inside MSDE, and not somewhere else in your system?

-PatP|||All you can get?

Without knowing a LOT more about what you are doing, what problems you've had, what you want to add, etc, we're pretty hard pressed to give you simple answers!

-PatP

That never stopped us before...

Let's see...the database is 130mb...you have 512mb...

I would say the whole damn thing is in memory...

SO...if you eliminate the fact that there's probably no I/O, AND I'm assuming that the thing is indexed properly....

I'd go with the thought that the code sucks...

oh...hold on...what else is running on the box?|||There is nothing else running on the system. The point of sale software is also running on the machine. I would like to adventually have that machine act as a virus server.|||Poke around in the Task Manager a bit. See if anything there attracts your attention. Be sure to check to see how much memory various processes are using, how much memory the machine has used, and how busy the CPU is.

Are you familiar with Performance Monitor? It can help a bunch trying to diagnose this kind of problem.

-PatP|||SQLserver uses 150 - 200 megs of memory. Not much cpu usage.|||If that is the case, it looks like SQL Server isn't your culprit. If it was, the CPU would be higher (for CPU bound tasks), or both the CPU and the RAM would be higher (for disk bound tasks).

My guess is that the problem lies either in the application itself, the network (especially likely if modems or wireless is involved), or on the client machine.

We still haven't nailed down the culprit, but I don't think that MSDE is your weak link in this case.

-PatP|||Well I just tested it by scanning some items. It uses about 30%-70% of the processor. This is running on a windows 2003 with sql server 2000. The hardware is a xeon 2.4 512 megs of memory. This machine is very effecient and works like a wal-mart. It comes up as fast as you can scan. But uses a lot of the processor. My other sites like I said our pentium 4 with 512 running xp pro and msde 2.8.

Thanks for all the help so far|||So the question is what should I roll out for a server to replace the desktop p4 machines? Also is there something I should be looking at in sql itself? The % of processor was with only 2 machines scanning items which is not very uncommon.|||The biggest problem is that MSDE is intended to be a run-time package for applications developed with Microsoft Visual Studio. You are sorely hampered trying to figure out what your performance problem is due to an almost total lack of tools.

The official gospel from Microsoft is that you need to report the problem to your application vendor, and have them either re-tune your database for you or sell/re-sell you the tools to allow you to tune it yourself. Once you get a full copy of SQL Server (even the BackOffice version which is somewhat limited compared to the full-featured versions), you'll be much better equipped to deal with this kind of problem.

Right now you are kind of like the merchant that buys a vending machine that is serviced by the seller... You have no keys, no tools, no access to the inside of the machine, and all you can do is report malfunctions to your vendor... A nice, simple, black-box arrangement where you can't monkey with things even should you want to!

-PatP|||REally?

With that said, I wonder how many developers deploy this solution...

I was just starting to head down this path as well...

What about MS Access and MSDE?|||MSDE gives the end user OSQL.EXE and BCP.EXE, but not much more... No Enterprise Mangler, no Query Analyzer, no Profiler. This is plenty for the folks who want a "data appliance", but doesn't give you much in the way of tuning tools.

I'm pretty sure that the Developer Edition of MS-Access allows run-time distribution of MSDE, but I haven't checked the licensing on it lately.

-PatP|||a 130MB database.. is much of it in only a few tables? I'm wondering if it really is indexed properly.. A product lookup is basically just a 'select' query right? maybe a few joins or such..

Also, there are some free management utilities for people without enterprise manager.
Check out http://www.aspfaq.com/show.asp?id=2442
Some cost money, but not nearly as much as any real version of sql server.|||It is only a simple query. SKU, Product description, and In store upc. I just don't understand why my processor on my servers are hit so hard