Showing posts with label pro. Show all posts
Showing posts with label pro. Show all posts

Friday, March 30, 2012

HELP!! i deleted services!

i have installed vs 2005 and sql server enterprise edition on an xp pro sp2 machine.but i could not connect to the mssqlexpress default database that it came with.in a moment of madness i deleted the mssqlserver services (3 of them).how do i reinstall them? i thought uninstalling the products and reinstalling them would help but it did not.

please help!

cheers OK, wait a minute. You installed the enterprise edition of the MSSQL Service on a XP prof ? This is not possible. What did you actually delete, where and what did you try to achieve ?

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

yes it it is possible, the only thing is that you do not have access to all the functionality.i have solved the prob by uninstalling and installing the work edition.

thanks

|||Sorry to correct you, but installing SQL Server services won′t be available for enterprise edition, only the client tools.

Jens Suessmeyer.

http://www.sqlserver2005.de

Monday, March 12, 2012

Help! Db-library network communications layer not loaded.

Hi,
We are using a windows application that uses MSDE 2000 on an XP Pro Machine
as a server.
Everthing was fine until last Friday. Suddenly, the XP server computer
started to give this error "Db-library network communications layer not
loaded." when we started to run application on it.
From other client computers we can succesfully connect and run the
application, but somehow the main machine does not work. I thought the
automatic update was on and it updated some MDAC drivers or may be Net
framework. I tried to install MDAC 2.7, but still no change. (I tired some
web searches but still nothing)
I really appreciate if you can give any suggestions/solutions.
Thanks.
Onur Baser
DB-Library is not part of MDAC or MSDE, so probably you had it on your other
machine because you installed the client tools or something.
Anyhow I also hope you realize that DB-Library is a dead API since the
introduction of SQL Server 7.0 in 1998 and it does not allow you to connect
to named instances for example (without using an alias or protocol prefix),
Unicode, strings longer then 255 or any of the other new data types
introduced in SQL Server 7.0 or 2000.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Onur Baser" <onur@.baserler.com> wrote in message
news:u18HnHVlEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hi,
> We are using a windows application that uses MSDE 2000 on an XP Pro
> Machine as a server.
> Everthing was fine until last Friday. Suddenly, the XP server computer
> started to give this error "Db-library network communications layer not
> loaded." when we started to run application on it.
> From other client computers we can succesfully connect and run the
> application, but somehow the main machine does not work. I thought the
> automatic update was on and it updated some MDAC drivers or may be Net
> framework. I tried to install MDAC 2.7, but still no change. (I tired some
> web searches but still nothing)
> I really appreciate if you can give any suggestions/solutions.
> Thanks.
> Onur Baser
>
|||Thank you,
I will see what I can do, but is really wierd that it just happened.
Best Regards,
OnuR
"Gert E.R. Drapers" <GertD@.SQLDev.Net> wrote in message
news:uLSRUJWlEHA.3432@.TK2MSFTNGP14.phx.gbl...
> DB-Library is not part of MDAC or MSDE, so probably you had it on your
> other machine because you installed the client tools or something.
> Anyhow I also hope you realize that DB-Library is a dead API since the
> introduction of SQL Server 7.0 in 1998 and it does not allow you to
> connect to named instances for example (without using an alias or protocol
> prefix), Unicode, strings longer then 255 or any of the other new data
> types introduced in SQL Server 7.0 or 2000.
> GertD@.SQLDev.Net
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> You assume all risk for your use.
> Copyright SQLDev.Net 1991-2004 All rights reserved.
> "Onur Baser" <onur@.baserler.com> wrote in message
> news:u18HnHVlEHA.596@.TK2MSFTNGP11.phx.gbl...
>

Friday, March 9, 2012

HELP! Can't connect to MSDE using Enterprise manger

I installed an instance (only one) of MSDE200 sp3a on one of the desktop machine (XP pro sp1), I would like to manage it by using the enterprise manager installed on another machine on the same network. I was getting the "SQL server does not exist or acce
ss denied" error. I am sure I have enter the proper login info and the MSDE is running.
Is there any configuration need to be done on the MSDE? any expert here can help me on this?
Thanks
Henry
hi Henry,
"Henry" <henryli1222@.msn.com> ha scritto nel messaggio
news:6AB45DD1-DA80-440E-B338-EA8F5467358F@.microsoft.com...
> I installed an instance (only one) of MSDE200 sp3a on one of the desktop
machine (XP pro sp1), I would like to manage it by using the enterprise
manager installed on another machine on the same network. I was getting the
"SQL server does not exist or access denied" error. I am sure I have enter
the proper login info and the MSDE is running.
> Is there any configuration need to be done on the MSDE? any expert here
can help me on this?
>
probably you installed the remote MSDE instance with the default parameter
which disable network protocols for it, not allowing remote connections to
that server...
please run svrnetcn.exe (Server Net Utility) on that server to verify the
desired network protocols are enabled...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, it works. It's possible to enable the network protocals for the MSDE 2000 installation?
|||Hi Henry,
You can do this by executing svrnetcn.exe.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:773EC08B-D846-4AB5-AA82-35034BD9375F@.microsoft.com...
> Thanks, it works. It's possible to enable the network protocals for the
MSDE 2000 installation?