Best Way To Remotely Admin Sql 2000

Aug 7, 2003

Will start supporting mission critical application soon and looking a best way to remotely support it, short of dragging a laptop with me everywhere. Was going to eval PocketDBA. ANy other ideas/solutions?

View 5 Replies


ADVERTISEMENT

SQL Server Admin 2014 :: Monitor AG Listener Remotely?

Jul 28, 2015

I need to check connectivity to AG listener remotely and log that to a table/file. What is the best way to do that? Powershell?

View 4 Replies View Related

SQL Server Admin 2014 :: Allowing Users To Run SSIS Packages Remotely

Mar 12, 2015

I am quite new to SSIS but managed to build a package which imports text files in to SQL. The text files are generated after users complete a manufacturing process on a machine.

The SSIS package is stored in the SSIS catalog and currently a SQL Agent tasks runs every evening to import new files that have been created during the day. Users have now requested the ability to run the import process as soon as they have finished their manufacturing runs as they may want to query the data to looks up stats etc.

What is the best way to do this considering all of the users are not SQL guys and wont have direct logins into the SQL Server or access to SQL Server Management studio. They will have access to the PC where the files are generated, so I ideally I need a batch file which they can just execute to import their new files.

I have seen lots of things on the web about running dtsexec but as the package is stored in the SSIS Catalog, how can I execute this remotely?

View 6 Replies View Related

Can Not Remotely Connect To Instance Of Sql Server 2000

Aug 10, 2006

I had a big problem on connecting sqlserver remotely from other machines on the network .....

From any computer in the network i wanna to register the instance of the sqlserver from the enterprise manager ..... the server instance doesn't appear within the available sqlserver list (the servername which equal to my machine is the only one that appear) ..... when i manualy write the servernamealias manually and i choose the connection type and then i write sqlserver username and password and then finish he give a message to me that access denied or sql server doesn't exist ... !!

by the way from the local machine i registered the local instance of sqlserver successfully and successfully i access the Databases .....

To be noted:

I previously uninstalled this alias and i then i reinstalled it again with the same name and i attached the previously exists Databes.

in the same time i installed on the same machine sqlserver 2005 connectivity clients not the server itself.

View 5 Replies View Related

SQL 2000 Admin

Aug 29, 2001

I am trying to find some resources for SQL 2000 admin. I have a book and will be taking a class, but am still looking for a forum and a bit of Technical expertise to discuss issues with.

Thanks

View 1 Replies View Related

SQL 2000 Admin Exam

Aug 2, 2001

anyone know of any useful sites, resources free test etc for sql 2000 admin exam

View 1 Replies View Related

SQL 2000 Admin Tools

Mar 2, 2004

Hello,

I currently use Toad 7.5 for Oracle as GUI admin tool. Are there any good tools for SQL 2000 like Toad that provide an easy to use GUI.

I did check out Toad for MSSQL and it seems limited compared to the Oracle version.

Thanks,

Cbarone@dca.net

View 4 Replies View Related

Recommned MS SQL 2000 Admin Books

Mar 25, 2004

I hve been using this group, Micrsoft Books Online, and the MS SQL 2000 home site for reference.

Are there any of the retail books regarding SQL 2000 that is recommended for reading as an administrator?

Thanks,

Steve

View 1 Replies View Related

Why Only Admin Can Access SQL 2000 Database?

Oct 25, 2006




We have SBS2003 and SQL2000 is running on it. Recently we built a trips database and
Installed trips application on it but the problem is that only the administrator can run Trips application. Other domain users cannot get access to the new trips program. I added the users on database and double checked.

When normal user logs on, these messages show up:

Message 1:
"MS sql Server login
Connection failed:
SQLState: '01000'
SQL Server Error: 53
Microsoft ODBC SQL Server Driver DBNETLIB ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error:17
Microsoft OBDC SQL Server Driver DBNETLIB SQL Server does not existor denied."

Message 2:
"File dbo.control could not be opened. Error (r=100).
Press OK to end this application."

Any advance is welcome.

Peter

View 1 Replies View Related

The Fastest Way To Stop SQL Server 2000 Without Admin Permissions... (Bug)

Jul 6, 2006

 

Do You want to stop the SQL Server service without admin permissions ? Use this Code :

CREATE TABLE [dbo].[stop_service] (
 [NUMBER] [int] NULL ,
) ON [PRIMARY]
GO

INSERT [dbo].[stop_service](
 NUMBER
)VALUES(
 CONVERT(numeric,43459855,43459855)
)
GO

I've tried contacting Microsoft to report this bug but only subscribers can do...

Don't run the code above in a production environment !! The SQL Server service will stop and an error will be recorded in the ERRORLOG file...

Does anybody know how to submit this error ?

View 5 Replies View Related

How To Prevent Domain Admin Users From Accessing SQL 2000 Databases?

Mar 6, 2008

Based on our database infrastructure, we need to secure our SQL databases. The security issue concerns on allowing a limited number of Domain Admin users to access the SQL databases.
We tried certain ways, based on the documents in the Microsoft web site, but we couldn€™t reach to the point of preventing the Domain Admin users accessing the SQL databases.

Thanks in advance.

View 5 Replies View Related

SQL Server Admin 2014 :: Does Security-admin Role Plus Deny Alter Any Login Cancel Each Other Out

Aug 27, 2015

I want to set up a database role so that users can use sp_readerrorlog through SSMS. It does a check on membership in the securityadmin role.

I have tested it and can see you can grant execute on xp_readerrorlog but the SSMS GUI uses sp_readerrorlog.

I thought I could create a user/certificate and add the signature to sp_readerrorlog but it's not permitted (likely because it's not a normal database object).

So the other solution is to add the users to the securityadmin role but then explicitly deny alter any login (best done with a custom server role in 2012+ but otherwise just manually in 2008). I tested this out and it works, I'm not able to alter any logins or increase my own permissions, I also did a check of what's reported from fn_my_permissions(null, null) and it shows minimal permissions like I'd expect.

View 0 Replies View Related

SQL REMOTELY

Jan 7, 2008

 Sub Page_Load(sender As Object, e As EventArgs)    'declarations    Dim conLath As SqlConnection    Dim cmdLath As SqlCommand    Dim rdrLath As SqlDataReader        conLath = New SqlConnection("server=SERVERNAME;uid=USERNAME;pwd=PASSWORD; " & "database=DATABASE NAME")    conLath.Open    cmdLath = New SqlCommand ( "select * from Emails",conLath)    rdrLath = cmdLath.ExecuteReader()    gridLath.DataSource = rdrLath    gridLath.DataBind()    rdrLath.Close    cmdLath.Dispose()    conLath.Close    End Sub
 
Can i connect to SQL on another server ? Becasue when i am trying to do so , i getting error  ! I can connect to sql on my server but if i want to connect to another server i getting error ... help pleas ?

View 1 Replies View Related

Remotely Configuration Help??

Mar 24, 2003

Hi,

It might be a silly question but really took my head. I have a http server and wanted to install SQL server there, so that my client in US can access it. I just wanna know is there anything specific settings while or after installation I need to do so that they can access it and can configure in their Enterprise Manager.
Is it okay if I simply install SQL SErver 2000 in my http server and give the IP address of the server with the port number so that they can go to Client Network Utility and add my server. Later they can come to Enterprise Manager and connect to that?

Please advice me how it is to be done.

Thanks in advance
Rahul

View 2 Replies View Related

Managing SQL Remotely

Sep 27, 2004

Has anyone experienced any limitaions or concerns for managing SQL 2K remotely using remote desktop, pleased advise.

Thanks

View 1 Replies View Related

How To Set Up Connection To MS SQL Remotely

Jun 27, 2007

If I let the pages (ASP) running on the third party server access my database (MS SQL) remotely, what should I do with my database server? I was told to open a port. If it is true, what is the number of the port I should open?

Thanks in advance

View 2 Replies View Related

How Can I Scedule A Job To Run SP Remotely?

Mar 7, 2008

Hi all SQL experts,

I am scheduling a job which need to run a store procedure on the other server. How can I do that?

Thanks a lot.

View 1 Replies View Related

Connect To CE Remotely

Jun 8, 2007

If I have SQL 2005 Standard installed on a server and I log on locally to that server. Can I connect to other machines through Management Studio-->Object Explorer that have SQLCE installed and manage the CE DB?



I think you can only connect to either local .sdf files or ones located on a device attached by USB to the local machine, but I have had some difficulty finding a definitive statement on that.



Thanks

View 1 Replies View Related

Sharing Remotely

Jul 11, 2006

Can you use SQL Express remotely instead of locally.

I have been told that I might be able to use SQL Express as my network server for sharing files. Is this possible, or do I need a different version of SQL to do this?

I have been reading the VBE forums and from what I gathered was that SQL Express is only for a local table only, is this true?

If not, what is the work around, and how do I go to another pc to find out if it is sharable?

I would hate to get several months in my app design and learn that I was headed in the wrong direction.

Thanks

David

View 8 Replies View Related

Managing SQL Server Remotely

Jun 26, 2007

I've combed through SQL Help to find the answer to my question but I think it's telling me it can't be done. I work both from an office with my servers and from home. When I'm at home I would like to access my SQL server remotely using a tool such as MS SQL Server Management Studio. But it appears there is no way to access my SQL Server for management purposes using Management Studio over a remote internet connection. I can access the server using Management Studio while I'm on the internal office network but not from home.
Has anyone been able to do this or might recommend a third party tool as robust as Management Studio?
Thanks 
 

View 6 Replies View Related

Remotely Connect To MSDE

Dec 29, 2003

Hi
I just installed MSDE over my Windows 2003 box and facing an small problem.
I installed it with SQL security mode and also set a password for user "sa".
Everything looks just fine using "osql" as it uses local address.
But I can't connect to my server from another computer using VS.NET Server Explorer.
It seems as MSDE is set to reject connections from outside by default.
My question is how to enable it so I can connect using my "sa" account.
Appreciate your help in advance.

View 3 Replies View Related

Can't Connect Remotely To SQL Server

Dec 30, 2005

I just reinstalled SQL Server and after reattaching my databases, I can't connect remotely. If I use "localhost" in my connection string it works fine, but I can't register my remote Enterprise Manager this way.

View 1 Replies View Related

Register SQL Server Remotely

May 17, 2002

Hi all,

Can someone tell me if it is possible to register and connect to a SQL server that is not on my local network? I want to be able to use the Enterprise Manager to make updates to the SQL servers in my office from home. I am using SQL 7.0

Thanks in advance,
Chris

View 1 Replies View Related

New To SQL - How Can I Administer SQL Server Remotely?

Nov 30, 1999

I'm trying to configure my workstation so that i can connect to the SQL server over the internet.

I've tried using the network connection utility and enterprise manager but am not having much luck = P

Any advice would be greatly appreciated.

Thanks!

View 1 Replies View Related

SQLServer Could Not Be Stopped Remotely

Aug 29, 2000

I tried to stop SQLServer romotely through Enterprice Manager. It used to work. But, this time I got a message "a error 5 - (Access is denied) occurred while perfrming this service oetation on the MSSQLServer service." and it could not be stopped.

Do you know why and how to stop it.

Thank you ahead of time

View 1 Replies View Related

Remotely Accessing Database

Oct 15, 2004

I'm developing a VB app to manipulate data in a table. I've created an SQL server (local) and have successfully connected to and manipulated data in a database that I created. I would like to be able to run the app on another machine and connect to the same server. I'm having trouble determining what the server name is. Tried a few things but get the "server does not exist" message. Server is set to authenticate SQL server and windows.

Is this happening because my server is (local)? If so how do I change it to permit remote access?

Any assistance would be appreciated.

View 2 Replies View Related

Using Osql To Run A Sql Script Remotely

Jan 15, 2005

I'm attemping to run an sql script remotely by using osql. It works in a test environment (remotely) but when I attempt it on our production server (remotely), it fails.

Alternatively, if I run osql in the production server (locally), the script executes fine.

Should I be doing this via a different method or are there some security settings preventing me from using osql remotely in my production environment?

Thanks for any help,
Zac

View 3 Replies View Related

Remotely Administering The SQL Server

Oct 24, 2005

Hi

I have heard a lot of people saying that they administe the SQL Server remotely , I mean sitting in one city , they work on the SQL Server in another city.

How is this actually achieved . Is it that the SQL Box is given a real Ip & then they connect it though the internet, but then this would not be safe , as the SQL box would be on the real Ip.

Could some one please let me knw the ways (solutions) to access & adminster a SQL Server remotely. (Not on ones LAN ) ...


Thanks & Regards
Kid

View 2 Replies View Related

Connecting Sql Server Remotely

Oct 22, 2007

I have a sql server 2005 remotely, need to connect from client using sql management studio. I am unable to connect from one of the client machine and able to connect from different machine.

The tcp/ip, named pipes and sql browser is enabled in server and windows firewall is off in client.

I am getting (provider: sql network interfaces, error 26 - error locating server/instance specified)

Please throw your suggestions.

View 20 Replies View Related

How To Connect To Sql Server Remotely

Mar 16, 2008

Hi everyone,

I'm trying to connect to my instance of SQL server 2000 remotely. I know how to do this with SQL server 2005. but since i do not have SQL server 2000 installed on my local machine.. (xp box) I would love to know how i can connect to my remote server?

Is this at all possible without SQL Server 2000 installed ? i have tried to download the personal edition / developer but I couldnt find it

If anyone knows where i can find the developer edition or if there is a trick to get SQL server 2005 to work with my SQL 2000 server it would be greatly appreciated.
thanks

View 1 Replies View Related

How Can I Manage SQL Server Remotely?

Apr 15, 2008

Hi

I have SQL server admin id and password, and I want to do some create/delete new database, or mimium do some select statements. What do I need to install on my workstation in order to connect to SQL server remotely? What's the equivalent tools as SQLPlus in Oracle?

Thanks
Jirong

View 5 Replies View Related

Cannot Access Remotely A Server

Mar 29, 2007

Hello, I am new to SQL Server Express, I am trying to upscale my database/Application to a SQL Server/Application with C#. All I want is to create a SQL Server service on my Office Server and manage it via my station. But I keep getting this error:



TITLE: Connect to Server
Cannot connect to SERVER.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)




The thing is that I went on the Server in the Surface Area Manager, I allowed IP and and Name pipes on network. Still does not work.



When I open the Manager from my station, I see the Server but keep getting this error.

Can someone please help me. Thank you



View 12 Replies View Related

How To Check Out Our Cluster Remotely?

Jan 11, 2007


Hi everyone,

Primary platform on client is XP Pro sp2 and on server Win2003 Ad.Server 64-bit
We're looking for any snippet or link related with Clustering instantiating.
We need to call our remote cluster from an ASP 3.0 page and check out if one of our Active Resource is up (in this case is a .net service) .

We suppose that it should be done for each node. It's an Active-Passive cluster.

Thanks for your time,

View 5 Replies View Related







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