Can I Access MSDE On A Remote Machine With Enterprise Manager?

Sep 22, 2007

We just installed an application, WhatsUpGold, to monitor our servers. Management won't let me host that on my primary SQL box. So, we are using MSDE on the local machine (call that box my_netmon).

I can access the db with very basic functionality using osql while on the my_netmon machine. I've added my domain user account as a System Admin using the following commands.

exec sp_grantlogin @name
go

exec sp_addsrvrolemember @name, 'sysadmin'

But when I go to the my_sql machine and try to attach to it with Enterprise Manager I get an error that the server does not exist.

What gives??? Is it just not possible, or am I missing something here?

My goal is to just be able to see the data stored in the MSDE db. Write views, etc...

Please advise,

Marc

View 2 Replies


ADVERTISEMENT

MSDE EnterPrise Manager

Aug 12, 2004

I am using MSDE enterprise manager and when I downloaded it, I cannot log onto the SQL Server, which is on my computer, I used the server name defined in the SQL Server Service manager, and it cannot connect. I was trying to set the conection up with the ODBC manager, although I am not even sure if this is the right way. Someone please help me out.

View 1 Replies View Related

MSDE And Enterprise Manager

Dec 22, 2004

I have just installed (new clean install) of MSDE 3a. On another machine I have enterprise manager, and I thought I would be able to access it, but when I try to register it in EM it gives me the following error: SERVERNAME - SQL Server does not exist or access denied, Connection Open(Connect(). I have done this in the past with no problem. Did I forget a parameter on the install of 3a to allow other machines to access or do I have some other security issue?

View 2 Replies View Related

MSDE And Enterprise Manager?

Dec 19, 2005

I am a complete sql newbie! For the life of me I can't figure out how to get Enterprise Manager to connect with MSDE. Something about mixed mode or tcp/ip settings? But no one's ever really clear on how to do these things. I've uninstalled MSDE until I can get more info.
I just need a quick walk-through on how to install msde to work with EM. This is what I used when MSDE requested a strong password:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"
Is this correct? Any help would be appreciated.
Thanks.

View 5 Replies View Related

MSDE Upgrade And Enterprise Manager

Feb 7, 2004

I just upgraded for MDSE 1 (came with VB 6 Pro and inculded Enterprise Manager) to MSDE 2000. After the upgrade, Enterprise Manager was removed.
Is there an Enterprise Manager availble for MSDE 2000, or a similar tool out there?

Thanks for any help.
Greg

View 3 Replies View Related

Remote Restore Without Enterprise Manager

Oct 7, 2005

Hi guys, I don't own a copy of Enterprise Manager and I need to remotely restore a database on my local machine to my hosted machine, can you guys recommend an application that can do remote restores?

Or is there a way to convert a Database into a long set of Transact SQL statements that I can run on the remote server (ala MySQL's MySQLDump)?

Thanks
GP

View 1 Replies View Related

Problem Connecting To Remote Site With Enterprise Manager

Apr 22, 2004

Hi All,

Recently had to rebuild our SQLServer installation from scratch! major pain!! We had a remote server running a replicated version of the internal database system for the website. We also have a SQL DB hosted with a new ISP which is in test mode. All managed via EM.

Re-installed software, upgaded tp SP3, new MDAC. Set up the references for the two external DB's with the Client Network Utility. In EM set up a connection to DB on the new ISP, works perfectly, tried on the old DB and get 'SQL Server is not running or access denied' error message.

I confirmed the server is running, as its our live site. Cant connect using Query Analyser. I can ping the adress successfully. I've created new user logings that mach on both machines/servers, still no luck!

Can anyone suggest what the problem is/might be or how to fix... I'm flat out of ideas!

Major THANKS! for any gems...

Davej

View 4 Replies View Related

Needed To Connect Remote DB By Client Tool (Enterprise Manager)

Dec 28, 2005

Here is what I knew: usr/pwd, Domain, Server and Database.
How to set Enterprise Manager, then can I connect to DB ?

View 1 Replies View Related

Problem COnnecting Remote Database Server Thru Enterprise Manager

Sep 6, 2003

Hello Guys,

I have just put up an Webserver with SQL Server 2000. Everything is working fine on the remote machine Thru TS .. i can do every administrative things .. But i m facing problem to connect my remote databse server thru the Enterprise Manager .. It Gives me Cant Connect Database Server " Connection Failiure " when i try to connect my remote database server thru Ip address ,.. Please some one help me out to make connecting database server thru Enterprise Manager ..

Thanks

View 10 Replies View Related

Accessing Remote Sql Server 2000 ( Enterprise Manager Like Tool)

Jul 20, 2005

Hi all,I need to gain access to a remote SQL Server 2000 storing my data.The remote SQL machine can only be accessed via an internet connection,that is - it is not part of my network.I know Enterprise Manager can do the job, but EM only comes bundled inMS SQL Server, which is not installed on the client machine.Please let me know which other (preferably free) tools can performsuch remote access.Thanks,Gilad Haimov

View 1 Replies View Related

Registering Remote Database Server With Local Dbserver Enterprise Manager

Nov 15, 1999

Hi
I amtrying to register remote database server with my local machine Enterprise Manager. It says server doesnot exist or not available.

I am putting server name,Tcp/Ip, i.p,port in Sql client configuration utility
and then trying to register it with Enterprise Manager.

Pl help me out.

Thanks

Shaurav

View 1 Replies View Related

SQL Server Access Across A Remote Machine

Jul 24, 2006

I was just trying out Microsoft SQL Server 2000. I created a sample application which reads in 2 values from a textbox and writes it into a databse. This application works fine on my computer and the values are written to the database (In the connection string, I give my IP address as the datasource so that anyone on the internet can hit this database). However, when I copy this application to another computer and try to run it, it gives me an error "SQL Server does not exist or access is denied." I know this is a minor problem with some setting, but I haven't been able to find the solution on the internet. Can someone whose worked with Microsoft SQL Server 2000 please help me out.

View 9 Replies View Related

What Is Requirement To Make Remote Access To Other Machine ?

Jun 14, 2007

What is requirement to make remote access to other machine ?

View 5 Replies View Related

SQL Server Enterprise Manager Access

Jan 17, 2006

How do I go about accessing the SQL Server Enterprise Manager to use DTS?
 
Robert

View 20 Replies View Related

Read Only Access / DB List In Enterprise Manager

Mar 31, 2008

Hi guys,
I want to give someone read only permission to our SQL server so they can log in and look at the database structure and query a few tables. I've set up the user but the problem is that when I connect in SQL server remotley, it shows all the other DB's on the server even though it is restricting access to them. Can these other DB's be hidden so that only the DB the user has access to shows up?

Cheers for your help!

View 9 Replies View Related

Enterprise Manager - SQL Server Does Not Exist Or Access Denied

Jun 8, 2005

I've searched around google & here and can't find a solution.

I can connect to my database via a connection string on the web server
but cannot connect via Enterprise Manager or just by ODBC connection on
my local machine.

I can ping the server fine and switched off my XP firewall & my router firewall, port 1433 is also open.

Someone has tested this from another machine and it works fine (cheers).

What else can I try, this is driving me insane!

Thanks in advance

R

p.s I'm on Win XP SP2, SQL Server 2000 sp3a

View 10 Replies View Related

How Do I Give A User Access To See Jobs Via Enterprise Manager ?

May 11, 2001

Hi,

I have a user who has created several SQL7 databases and uses a VB app which schedules jobs (under the sa account) on the SQL server. How can I allow this user to view scheduled jobs on the server ? I don't want to give him too many priviledges.

Thanks,

Tim

View 4 Replies View Related

Cannot Access Clustered Disk Using Enterprise Manager SQL 2000

Jul 10, 2006

Hello,

I am running an SAP installation on clustered DELL poweredge 1850's with a shared scsi disk system. I am running Windows 2000 sp4 with sql 2000 sp4. I am trying to restore a database from a .bak file on a clustered disk. When I attempt to access the disk through enterprise manager it is not there. I only get access to the E: drive (which is clustered as well)

View 1 Replies View Related

Integration Services :: How To Access Remote System Folder In Local Machine Using SSIS

Aug 12, 2015

I have to access the remote system folder files in local machine using SSIS.

View 2 Replies View Related

Remote Access Control Manager

Mar 15, 2008

View 4 Replies View Related

SQL 2005 Enterprise Edition The Image File Setup.exe Is Valid, But Is For A Machine Type Other Than The Current Machine

Nov 28, 2006

Hi All,

I have enterprise version software CD1 and CD2 of SQL server 2005

when i try to run setup.exe..the following error pops -up

The image file Setup.exe is valid, but is for a machine type other than the current machine

MY OS version is windows 2003 32bit Operating system...

I am suspecting the binarie may be of 64bit.. How do we check the binaries are 32 bit and 64 bit software

Thanks for your Help

Mohan



View 4 Replies View Related

To Access Reporting Sevices (Report Manager, Reporting Web Services), Does One Has To Be An Admin On The Machine

Mar 12, 2007

Hi There,

Our DBA has installed reporting services on a server and now in order to access the report manager, one has to be an Admin on that Server. I am guessing that there is a mistake in the configuration of Reporting Services. Usually it should allow anybody who was added to the roles in the properties section of the Report Manager, right? I have also added the users to the DB..

Also I am using Windows Authentication to access Report Catalog items (Reporting Services is installed on Server2) from a web Application(deployed on Server1) and displaying the report using report viewer. For some reason, server1 has to be in an Admin role on Server2 to access the report catalog/report. This is kinda strange for me as I don't want everybody to be an Admin on Server2. Can anybody please point in the right direction?

Thanks.

View 3 Replies View Related

MSDE: Renaming Machine Without Reinstall Of MSDE

Mar 27, 2001

We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??

regards,

Manfred

View 3 Replies View Related

Problems Running Enterprise Manager And Service Manager

Jul 20, 2005

On one of our machines, all of the SQL Server 2000components except for the main Server component (SQL Servercore) itself were installed (Management tools, etc) a while agoand everything was running fine. Now I go and add/install theServer component and then Service Pack 3a.It seems that Service Manager won't start up (I get an hourglass cursor)and now I find that Enterprise Manager won't run as well. No errormessages appeared and I don't think I saw anything unusual inthe log file.However, I can use Enterprise Manager on a differentmachine and connect to the database (so the databaseitself seems to be running).Any suggestions as to what the problem might be and how tofix it? I like to see if I can repair this without havingto do a reinstall.Thanks.PF

View 2 Replies View Related

Help! Enterprise Manager Turns SQL Server Service Manager Off

Dec 6, 2006

IF someone can assist me. Everytime I load up enterprise manager the service manager turns off. And the enterprise manager can't connect to the local database. But everytime i turn it back on and try to connect again it shuts it off and around and around we go. Help would be appreciated. Thanks.

View 2 Replies View Related

Linked Server ( Not Able To Access Any Tables Under LINKED SERVER From My DESKTOP Enterprise Manager

Mar 25, 2002

Hi ,
On my Desktop i registered Production Server in Enterprise Manager
on that Server if i go to SecurityLinked Servers
There is another Server is already mapped, when i am trying to see the Tables under that one of the
Linked Server i am getting the Error message saying that
"Error 17 SQL Server does not exist or access denied"

if i went to Production Server location and if i try to see the tables i am able to see properly, no problems
why i am not able to see from my Desk top
i am using the sa user while mapping the Production Server on my DESKTOP using (ENTERPRISE MANAGER)

And i check the Client Network Utility in the Alias using Named Pipe only, i changed to TCP/IP still same problem
What might the Problem how can i see the Tables in Linked Server from my DESKTOP

Thanks

View 5 Replies View Related

MSDE In 98 Machine

Jan 5, 2004

Hi,

I have installed msde on a 98 machine and so far I have no problem getting the msde running. However, when I run my application, which tries to connect to the msde, it gives me two errors --

1.) Method "OpenConnection" of object "_CurrentProject" failed

2.) Couldn't find the database on the server. Object failed.

I have checked and the database name is correct. I have also installed MDAC 2.8 on that machine.

I am running out of ideas and hope that maybe somebody in the forum has seem this problem before and may be able to give me a hand.

Thanks

SHK

View 2 Replies View Related

How Do I Know If I Have Enterprise Or Standard On My Machine?

Nov 29, 2006

I go to help>About and it just says SQL Server 2005

Microsoft SQL Server Management Studio Version 9.00.1399.00

View 7 Replies View Related

Sql Express And Sql Enterprise On Same Machine

Feb 22, 2007

Is it possible to install both an enterprise instance of sql 2005 (MSSQLSERVER) and an express instance of sql 2005 (SQLEXPRESS) on the same machine?

Ryan

View 1 Replies View Related

SQL Server && MSDE On Same Machine?

Jul 23, 2005

Can an individual computer be configured contain both a SQL Serverinstance & an MSDE instance?Our software we charge separate costs depending if they are running ona MSDE or SQL Server edition, and if they already have SQL Serverrunning (which they may have installed for some other application), canwe install our MSDE instance on the same machine?And on the flip side, if they already have a machine that has an MSDEinstance, can the SQL Server install be done over top of that withoutaffecting the MSDE?Thanks for any help,GregJoin Bytes!

View 1 Replies View Related

MSDE And SQL2K On Same Machine?

Aug 16, 2006

Can I have MSDE and SQL2K installed on the same machine?



Thanks

Mary

View 4 Replies View Related

Pervasive SQL && MSDE On The Same Machine

Nov 28, 2007

Is it possible to run MSDE and Pervasive SQL on the same machine ?
If possible but not recommended I'd really appreciate the reasons why it should not be done.
If not possible I'd also really appreciate hearing why.

Thanks in advance.

View 4 Replies View Related

MSDE && SQL Server 2000 On The Same Machine !

Aug 13, 2004

Hi all,

I started learning ASP .Net using the "Teach yourself ASP.Net in 24 hours". In that book, the applications use MSDE as the database tool.

Now i have started developing some big applications and have installled MS SQL Server 2000 on my machine.

I still have databases on the MSDE.

My question is 'How do i move the old databases from MSDE to SQL Server 2000' ?

Can i uninstall MSDE safely since i already installed SQL Server 2000 ?

Please let me know.

Thank You
:-)

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved