Connect to MSDE 2000 from SQL 2000 Ent. Manager

With SQL 2000 Ent. Manager I was able to connect to MSDE on another box. I
now have MSDE 2000 installed on the box. When I try to connect with SQL
2000 Ent. Manager I get the error "SQL Server does not exist or access
denied". I get the same error when I created an ODBC connection using the
same settings. I am however able to connect locally on the box using
Microsoft SQL Web Data Administration.
Any thoughts?
have you granted to permissions to the account on the other machine?
"Bishop" <kwayne@.new.rr.com> wrote in message
news:#vzRSOULEHA.2736@.TK2MSFTNGP11.phx.gbl...
> With SQL 2000 Ent. Manager I was able to connect to MSDE on another box.
I
> now have MSDE 2000 installed on the box. When I try to connect with SQL
> 2000 Ent. Manager I get the error "SQL Server does not exist or access
> denied". I get the same error when I created an ODBC connection using the
> same settings. I am however able to connect locally on the box using
> Microsoft SQL Web Data Administration.
> Any thoughts?
>
|||Verify that you have installed the network protocols to enable the remote
access.
To do that, use the tool on the box you installed MSDE2000.
Thierry
"Bishop" <kwayne@.new.rr.com> a crit dans le message de
news:%23vzRSOULEHA.2736@.TK2MSFTNGP11.phx.gbl...
> With SQL 2000 Ent. Manager I was able to connect to MSDE on another box.
I
> now have MSDE 2000 installed on the box. When I try to connect with SQL
> 2000 Ent. Manager I get the error "SQL Server does not exist or access
> denied". I get the same error when I created an ODBC connection using the
> same settings. I am however able to connect locally on the box using
> Microsoft SQL Web Data Administration.
> Any thoughts?
>
|||Hi, Where the tool network protocols?
Thanks, I have the same trouble
|||hi,
"aramgt" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:208EAA99-4E4F-4598-9415-7F443FB13297@.microsoft.com...
> Hi, Where the tool network protocols?
> Thanks, I have the same trouble
locate svrnetcn.exe on the server hosting your MSDE instance and execute
it...
eanble the desired network protocols...
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
|||Hi,
I completed all these steps and I can't connect using
server IP, just server name like server\machine.
Any ideas?

>--Original Message--
>hi,
>"aramgt" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:208EAA99-4E4F-4598-9415-7F443FB13297@.microsoft.com...
>locate svrnetcn.exe on the server hosting your MSDE
instance and execute
>it...
>eanble the desired network protocols...
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||To connect with <SERVERNAME>, you need to install MSDE
from the command prompt with the "default" option, rather
than the "instancename" option.
[vbcol=seagreen]
>--Original Message--
>Hi,
>I completed all these steps and I can't connect using
>server IP, just server name like server\machine.
>Any ideas?
>
scritto[vbcol=seagreen]
>nel messaggio
7F443FB13297@.microsoft.com...
>instance and execute
>http://italy.mvps.org
>MSDE 2000 a visual
>.
>
|||Hi,
I'm working on a Windows 2000 Server and can't locate
svrnetcn.exe on it. Is there another way of setting the
required network protocols so that I can connect to MSDE
2000 remotely?
thanks

>--Original Message--
>hi,
>"aramgt" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:208EAA99-4E4F-4598-9415-7F443FB13297@.microsoft.com...
>locate svrnetcn.exe on the server hosting your MSDE
instance and execute
>it...
>eanble the desired network protocols...
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||hi,
"kman" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:7a4701c43155$c4bf9e90$a401280a@.phx.gbl...
> Hi,
> I'm working on a Windows 2000 Server and can't locate
> svrnetcn.exe on it. Is there another way of setting the
> required network protocols so that I can connect to MSDE
> 2000 remotely?
if you have SQL Server installed on that server, you have to find it.. it's
the Server Network Utility listed in the SQL Server program group...
on client side, it's corresponding tool is the Client Network Utility,
cliconfg.exe
<Only for information>
you coul'd do i t manually editing the registry,
in the HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Su perSocketNetLib
ProtocolList = tcp
for TCP/IP network protocol
BUT THIS IS NOT THE BEST WAY, please do it with the appropriate tool, the
Server Network Utility, where you can specify all your desired setting...
</Only for information>
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
sqlsql

Connect to database without showing the "Connect to Server" dialog box?

Is it possible to configure the SQL Server Management Studio to behave like good old Enterprise Manager, so that it automatically connects to my configured servers without showing the "Connect to Server" dialog box every time upon startup?

After successlessly searching Google and these forums, I still found no suitable answer to this question (maybe beside this one).

Thanks
Uwe

You ae right this is not possible, perhaps you can suggest that as a feature request on connect.microsoft.com ?

HTH, Jens Suessmeyer.

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

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=180590

Thanks, Jens .|||You got my vote.

-Jens.|||Strange - they marked the ticket as "closed" and "solved", but no further comments.

Anyone knows what this actually means? IS it already present and I did not found it? Or will it be implemented in a further version?

Thanks
Uwe

connect to AS2000 cube error

Here is my setup: I have Reporting Service and SQL Server 2000 in one box
(Box A), and IIS and Analysis Service in another box (Box B), which has
couple of cubes based on the database in Box A, using SQL Authentication and
Allow save password. Create AS2000 data source at Reporting Project, then
create a report, I can preview the report fine in VS.2003. But I got the
following error after deploying the report to the reportserver and browse the
report:

Cannot create a connection to data source 'Cube'. (rsErrorOpeningConnection)
Get Online Help
Database 'Cube' does not exist.
Do I miss anything?

Thanks

Reporting services and Analysis Services only support Windows authentication.

Another problem with your setup is that even if you use windows authentication you cannot validate users between to servers without using Kerberos and account delegation.

Its possible to use standalone servers and maintain the same windows accounts on the separate machines manually.

Regards

Thomas Ivarsson

sqlsql

Configuring mail for SQL Server Agent - Problem with Exchange and Outlook on same machine?

I would like to configure e-mail alerts on my SQL Server 2000 box.
However, we also run Exchange on the same machine. I've been told there
could be conflicts/issues having Outlook on the same machine as
Exchange; and apparently, one needs Outlook to configure a mail profile
for SQL Server Agent.

Is there, in fact, anything to worry about? If so, are there any
work-arounds beside moving Exchange to another server? (we've only got
one server, so this is not an option for us at this time).
Thanks.

- Dana<dananrg@.yahoo.com> wrote in message
news:1106142898.187937.44340@.z14g2000cwz.googlegro ups.com...
> I would like to configure e-mail alerts on my SQL Server 2000 box.
> However, we also run Exchange on the same machine. I've been told there
> could be conflicts/issues having Outlook on the same machine as
> Exchange; and apparently, one needs Outlook to configure a mail profile
> for SQL Server Agent.
> Is there, in fact, anything to worry about? If so, are there any
> work-arounds beside moving Exchange to another server? (we've only got
> one server, so this is not an option for us at this time).
> Thanks.
> - Dana

SQL Mail can sometimes be tricky to set up - you can check the MS Knowledge
Base for detailed articles on setup and troubleshooting. This is one
alternative approach:

http://www.karaszi.com/sqlserver/info_no_mapi.asp

I don't know if there are any problems with Exchange and Outlook on the same
box (you might want to ask in an Exchange group), but moving Exchange (or
MSSQL) to a separate server might be a good idea anyway, to avoid possible
resource conflicts. Although if you've been running both together for a
while, presumably that's not an issue for you right now.

Simon

Configuring a Report Server for E-Mail Delivery

Bruce
I am pretty much in the same boat I have setup a test reporting
services instance on a Windows 2003 box. I now want to setup the
WIndows SMTP server and make reporting services send emails to the
SMTP server running on Windows.
Your help would be highly appreciated if you can specify the steps in
setting up Windows 2003 SMTP server and making reporting services talk
to it.
Thanks
KarenI have not setup the SMTP server. I use Reporting Services ability to be a
client and have it send to an existing SMTP server. There should be no
difference with the setup for Reporting Services, it just needs a SMTP
server, regardless of where it is. So what you need to know is how to
install and setup Windows SMTP server. Two different things, Report Services
SMTP client support and SMTP server. One option once you have the SMTP
server working is you can have RS deposite the report in a directory that
then the SMTP server picks up and emails or you can have it send the report
to the SMTP server which then forwards it on its way. For SMTP Server help I
would check out a Windows 2003 newsgroup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0501062053.763b670e@.posting.google.com...
> Bruce
> I am pretty much in the same boat I have setup a test reporting
> services instance on a Windows 2003 box. I now want to setup the
> WIndows SMTP server and make reporting services send emails to the
> SMTP server running on Windows.
> Your help would be highly appreciated if you can specify the steps in
> setting up Windows 2003 SMTP server and making reporting services talk
> to it.
> Thanks
> Karen

Configure SQL Server 2000 Standard Edition RAM

Hi,
Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
2000 Standard Edition (sp3 applied) in our production box? The operation
system is Windows Server 2003 Standard Edition.
Regards,
-ChenUnfortunatly Standard edition can only support up to 2 gb (see
http://www.microsoft.com/sql/evalua...iew/default.asp)
To get it up to that amount in Enterprise Manager...
Right Click on the Server
Properties
Memory
And put the slider up to whatever you want to.
Peter
"Chen" wrote:

> Hi,
> Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Serv
er
> 2000 Standard Edition (sp3 applied) in our production box? The operation
> system is Windows Server 2003 Standard Edition.
> Regards,
> -Chen
>|||Thanks!
-Chen
"Peter Nolan" wrote:
[vbcol=seagreen]
> Unfortunatly Standard edition can only support up to 2 gb (see
> http://www.microsoft.com/sql/evalua...iew/default.asp)
> To get it up to that amount in Enterprise Manager...
> Right Click on the Server
> Properties
> Memory
> And put the slider up to whatever you want to.
> Peter
>
> "Chen" wrote:
>

Configure SQL Server 2000 Standard Edition RAM

Hi,
Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
2000 Standard Edition (sp3 applied) in our production box? The operation
system is Windows Server 2003 Standard Edition.
Regards,
-ChenUnfortunatly Standard edition can only support up to 2 gb (see
http://www.microsoft.com/sql/evaluation/overview/default.asp)
To get it up to that amount in Enterprise Manager...
Right Click on the Server
Properties
Memory
And put the slider up to whatever you want to.
Peter
"Chen" wrote:
> Hi,
> Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
> 2000 Standard Edition (sp3 applied) in our production box? The operation
> system is Windows Server 2003 Standard Edition.
> Regards,
> -Chen
>|||Thanks!
-Chen
"Peter Nolan" wrote:
> Unfortunatly Standard edition can only support up to 2 gb (see
> http://www.microsoft.com/sql/evaluation/overview/default.asp)
> To get it up to that amount in Enterprise Manager...
> Right Click on the Server
> Properties
> Memory
> And put the slider up to whatever you want to.
> Peter
>
> "Chen" wrote:
> > Hi,
> >
> > Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
> > 2000 Standard Edition (sp3 applied) in our production box? The operation
> > system is Windows Server 2003 Standard Edition.
> >
> > Regards,
> > -Chen
> >

Configure SQL Server 2000 Standard Edition RAM

Hi,
Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
2000 Standard Edition (sp3 applied) in our production box? The operation
system is Windows Server 2003 Standard Edition.
Regards,
-Chen
Unfortunatly Standard edition can only support up to 2 gb (see
http://www.microsoft.com/sql/evaluat...ew/default.asp)
To get it up to that amount in Enterprise Manager...
Right Click on the Server
Properties
Memory
And put the slider up to whatever you want to.
Peter
"Chen" wrote:

> Hi,
> Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
> 2000 Standard Edition (sp3 applied) in our production box? The operation
> system is Windows Server 2003 Standard Edition.
> Regards,
> -Chen
>
|||Thanks!
-Chen
"Peter Nolan" wrote:
[vbcol=seagreen]
> Unfortunatly Standard edition can only support up to 2 gb (see
> http://www.microsoft.com/sql/evaluat...ew/default.asp)
> To get it up to that amount in Enterprise Manager...
> Right Click on the Server
> Properties
> Memory
> And put the slider up to whatever you want to.
> Peter
>
> "Chen" wrote: