Remote Management Of Sql Server 2000
One of my clients is upgrading to Sql 2000. I currently administer her server using a SQL 7 interface but I will need to upgrade that interface to sql 8 now to be able to give her the same level of support. How do I go about installing the required clients on my desktop in such a way as to not interfere with my own installation of MSDE?
I use Windows NT workstation 4. If I have a choice do I install developer's edition of SQL2000 or personal edition?
We also have pcanywhere access but this is too slow and unsure for my money.
Thank you,
Bo Graham
View Complete Forum Thread with Replies
Related Forum Messages:
Remote Management Of A SQL Server 2005
Hello, One thing I noticed is that Network connections to SQL Server 2005 databasees, updates and other thinks like Insert, Delete via remote are never covered, especially for new programmers. You see, new programmers like myself need special attention. The simplest thing is a big thing to the new programmer. This is why I would like to see a Forum or Topic that looks after the new programmer for remotely connecting to SQL Server 2005 from VB.Net or C#. Thanks.
View Replies !
SQL Server Express Database.mdf - Remote Management
Hi, I have installed an ASP.NET 2.0 application which uses a SQL Server Express database file on a client's network. I am able to connect to my client's network remotely over the internet. I would like to know if there's a way - and if so, how - to manage the Database file remotely. I have VWD Express, SQL Server Manager Studio Express and a trial version of SQL Server 2005 on my development machine. Thanks very much. Regards Gary
View Replies !
SQL Server - Remote Command Line Management
As a Sys Admin, I was wondering - if I have admin rights to a Win2k machinethat is hosting SQL Server 2000, do I have the ability using anycommand-line tools such as OSQL or ISQL to add, delete, or change accountsregistered in SQL Server for the various databases if I don't have access toa specific account within SQL Server?I ask, because the question that came up was - what if we have a DBA leaveunder less than amicable circumstances? Could I, someone who has adminrights on the machine, be able to log into that machine remotely and somehowvia command line (I don't maintain active SQL clients centrally), change theSA password, remove an account, and/or add an account with sysadmin rights,etc?Thanks in advance for any help -
View Replies !
Secure Remote Management On Shared SQL Server
I am trying to get my hosting company to provide a way to make secure encrypted connections from my desktop (where I am using Enterprise Manager and Aqua Data Studio) to their shared MS SQL Server. I've seen some references to SSH, but I don't understand how this works or how the host would implement it. I also read that an SSL certificate can be installed on SQL Server, but it doesn't seem as if EM or ADS can make SSL connections to SQL Server. (In case it makes any difference for either of these solutions, the hosting company has port 1433 open, and will not close it because some clients connect to the DB server from web apps on their own intranets.) Finally, if a web-based admin is used instead (like phpMyAdmin for MySQL), then which machine is the software installed on? Can it be on a web server that makes a local connection to the DB server or does it have to be on the DB machine? E.g., if I had a VPS or dedicated server at the same hosting company would I be able to install web-based admin software which would then connect to the host's shared SQL Server? Anyway, my host is giving incomprehensible (to me) objections to all of these ideas. Is there a reasonably simple way to do this on a shared DB server?
View Replies !
Error Connecting To Remote Server Using Microsoft SQL Server Management Studio Express
Dear All, I am trying to connect to a remote sql server 2005. So I have install the Microsoft SQL Server Management Studio Express. When I try to connect I get the error below. 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53). Can some one please help. I have even port no 1533 on my pc. Thanks.
View Replies !
Vista Business ODBC/DSN To Remote Windows 2000 Server / SQL 2000
Hi, Just upgraded some development desktops to Vista Business. However we need to still connect to some older remote windows 2000/SQL 2000 servers. Trying to setup an ODBC system DSN on our Vista Business local desktop we get the following errors - -START ERROR WINDOW- Connection Failed: SQLState: '01000' SQL Server Error: 772 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (SECDoClientHandshake()0. Connection failed: SQLState: '08001' SQL Server Error: 18 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security Error -END ERROR WINDOW- Any help greatly appreciated as this is stopping us from making database/table connections etc. We've checked the firewall setup and all is well there. PS - we can still connect fine using XP or windows 2000 desktops and their local DSNs.
View Replies !
SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server. Questions: 1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server? 2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC. Any expected problems when running both 2000 and 2005 SQL Server at the same database server? 3. What is the best configuration for running SQL Server 2005 when we have old 2000 databases? Upgade or not upgrade? TIA, Jeffrey
View Replies !
Management Studio With SQL Server 2000
Hello, This is a bit of a beginner questions... I need to start managing an SQL server 2000 using SQL server management studio (2005). I've heard there may be an issue with backwards compatibility, which might cause error when creating new tables or stored procedures... could someone please list the pros and cons on this? Thank you all in advance
View Replies !
Creating A SQL Server 2000 Compatible .BAK File From SQL Server Management Studio Express
Hi,My webhost (1and1) is running SQL Server 2000 and their web tool supports the import of .bak files. However, when I try to import my .bak files created in SQL Server Management Studio Express I get the following error:"The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. RESTORE FILELIST is terminating abnormally."I have Googled this error and learnt that 2005 .bak files are not compatible with 2000 .bak files. I'm just wondering if there are any work arounds to this or alternative tools that I can create 2000 compatible .bak files from from 2000/2005 .mdf files.Thanks in advance.
View Replies !
Remote SP In SQL Server 2000
I am facing problem when "Calling a remote stored procedure from inside a local stored procedure" in SQL Server 2000, but the same works fine in SQL 7.0. Here are the details: Server A:- Having SQL 2000 installed Here we are executing a stored procedure "getPlan" with parameters '3129 ','1834 ' This sp, in turn calls another sp on server B and the result of that is inserted into a temporary table. For e.g.: insert into #temp1 exec ServerB.Database1.dbo.StoredProcedure1 '3129 ', '1834 ' Server B:- Having SQL 2000 installed Has the SP StoredProcedure1 in Database1. Both of them is being accessed with the same user id and password. Note:- These SP works fine in SQL Server 7.0. This does not give any error but keeps on running in loop.
View Replies !
Remote Management
Hello! My login is dbo for a database located at a remote server(SQL server7.0).Can I run the stored procedures of that database by accessing remotely.Also I have to manage that database from here,what limitations that I will have if I am not an SA for that server?Any help is appreciated.I am operating from NT workstation4.0.
View Replies !
SQL Server Management Studio Can't 'see' The 2005 Engine?? But Can See 2000 ?!?
Hello,I had SQL2000 server running fine on the windows 2003 box. I then installedSQL 2005 Express. They both worked together fine. I then uninstalled SQL2005 Express and installed SQL 2005 Server. But when I open SQL ServerManagement Studio, I can only connect to the SQL 2000 engine. In the Objectexplorer, it says v8.0.2039 (which I think is SQL 2000 Server, because I cansee the existing SQL 2000 databases).How can I get SQL Server Management Studio to 'see' the SQL 2005 databaseengine so I can create tables? I *think* its running because there is the'sqlservr.exe' process running, and during installation there is no issues.When I open SQL Server Management Studio, I choose 'Database Engine', thenmy local Servername with Windows Authentication. How do I connect to the SQL2005 instance?Thanks,Jack.
View Replies !
How To Stop / Start Sql Server 2000 Using Management Studio
Hi I have upgraded my local to sql server 2005, but still need to access the remote instance which is still at version 2008/8.0. Enterprise Manager has been removed (by the SQL server 2005 installation) Does anyone know how I can restart older version of SQL server instance (ie 2000/8.0) using SQL server Management Studio? I don't have admin access on the server which the sql remote instance is hosted. Can get around it by asking the sys admin guy to do it for now but would prefer to continue to be able to do it myself. SQL Server Configuration Manager can only manage SQL server 2005 versions - a nice little caveat! Is there a way to stop/start remote services using 'net stop/start'? - without having to write code.... I'll continue to search for a solution, but if someon can point me in the right direction, I'd be most greatful. hien
View Replies !
SQL Server 2000 - Remote Installation
Hi all, We recently aquired a Win 2003 dedicated server hosting account through a web hosting company. I am trying to figure out how to install SQL Server 2000 remotely. I tried to install it remotely using my local box running Windows XP but it wont allow installation since XP is not a server OS. Basically, if I use a box running win 2003 is it even possible to install SQL Server 2000 on the remote dedicated server by selecting remote installation and the ip, login, pass? Any information regarding this would be extremely helpful. Thanks DMC
View Replies !
SQL 2000 Remote Server Problem
i 've tried to run this part of query it gives a problem like : unauthorised trasaction in Databasename errors At Server1 Use DatabaseName1 BEGIN TRAN INSERT into Server2.Database2.dbo.TableName2 SELECT * FROM Server1.Database1.dbo.TableName1 END can anybody help me ?
View Replies !
RS 2000: Cannot Connect To Remote SQL Server
Hi there, I have two hosted servers. Server 1 is a w2k3 server which we want to use as our web server. Server 2 is a w2k server with sql 2000 installed. On Server 1 i'm trying to install SQL Reporting Services 2000. When i get to the Report server database setup, I put the Server 2 name in the sql server instance. I leave report server as the default name and in the credentials I use a sql login account that I setup on Server 2 with dbo rights. When I click next, I always receive the following: Cannot connect to the sql server instance. I have the right ports open, I can setup a odbc connection using the same credentials. I can't seem to figure it out. Any suggestions please? I have named pipes and tcp protocols enabled on my sql server. I have only one instance of sql installed on my Server 2.
View Replies !
MS SQL Server 2000 Installation For Remote
I installed MS Sql server 2000 having Typical type setup. I choosed Local system account in service setting & mixed mode authentication mode. I choose default Tcp/Ip port 1433 which is free. After successful installtion i tried telnet localhost 1433 But gaves the error : "Could not open connection to host on port 1433" Connection failed. So should i do for remote or telnet connection. Please help me!
View Replies !
Error Connecting To Remote SQL 2000 Server
I'm experiencing a problem connecting to a SQL 2000 server through my ASP code. My connection string is as follows: <add name="TheConnectionString" connectionString="driver={Sql Server};provider=MSDASQL;server=10.0.1.42;database=dbname;uid=*********;pwd=*********" providerName="System.Data.Odbc" /> The problem doesn't occur when I run my ASP code from my workstation using VS.NET's builtin webserver. It makes the connections and executes the CRUD commands successfully. However, when I publish my site to the webserver (which resides on 10.0.1.16) it fails out with the following error: System.Data.Odbc.OdbcException: ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.ERROR [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). I've verified that the webserver can talk to the DB server by connecting to the remote DB server through SQL Enterprise Manager running locally on the webserver. If I try to do this with a DSN I get the same results. I get the same error from any other webserver on the internal network. The difference between my workstation and the internal network is that I'm using a VPN to connect to our internal network while the webservers are physically connected to it. Firewalling isn't the issue in this case because the webservers and DB server are on a trusted network. I've seen other ways of connecting to the DB server including using Named Pipes (which I would rather not do because I don't want to setup a named pipe on the production db server). I'm relatively new to ASP.NET 2.0, so the above connection string is an adaptation of some old ASP code. If anybody has any suggestions on a better way to construct this connection string, please let me know. I've been racking my brains trying to get this to work outside of the devel env.
View Replies !
SQL Server 2000 Enable Remote Connections
Hi guys Apologies if this is the wrong place to be posting this but I have posted on a few forums and have not had any usable answers to this question, so I am hoping you guys will be able to help me. I have 2 servers that are on the same domain. My ASP.NET application is running off the first which has .NET 2.0 installed, and I have an SQL Server 2000 db on the other. Whenever I try to connect I get the following error: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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The connection works when I run the project in VS Development Server on my work computer, but as soon as I upload to the server I get this error. I have scoured Google but all of the sites I come across are for SQL Server 2005 and are just not suitable for solving the issue on 2000. Any help would be greatly appreciated as I cannot continue my current project until this issue is resolved. Hermiod
View Replies !
Error Connecting To Remote SQL Server 2000 From ASP.NET 2.0
My environment is Windows Server2003, ASP.NET 2.0, SQL Server 2000 using SQL authentication (names of DB's, sql id's, passwords are identical on both servers) My web application successfully connects to my database the web app and the DB are both on the same server (10.144.25.9).This connection string works: <add name="DefaultDataTierConnectionA" connectionString="Data Source=10.144.25.9,1433; Network Library=DBMSSOCN; Initial Catalog=9D_SQL; User ID=******; Password=******" providerName="System.Data.SqlClient"/> PROBLEM: The problem occurs when the DB is mpved to the remote SQL Server (10.144.25.10). I use almost the identical connection string except for the IP address which is changed to the remote machine. The db name, user, password is same on remote machine as on the local, so everything should work but does'nt. This connection string fails: <add name="DefaultDataTierConnectionA" connectionString="Data Source=10.144.25.10,1433; Network Library=DBMSSOCN; Initial Catalog=9D_SQL; User ID=******; Password=******" providerName="System.Data.SqlClient"/> error (odd error in that I'm connecting to SQL 2000?) - 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.) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: 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.) There is no DBA on this project, I'm not sure this is a SQL Server set up problem?
View Replies !
Issue Connecting To A Remote SQL Server 2000
I get the following error message in quotes. I have a web application written in ASP.NET 2.0 through which I am trying to connect to a remote SQL Server 2000. My operating system is Windows Vista . I looked at many different sites to find a solution for this but without any luck. I am sure someone would have seen this issue here and I expect them to shed some light. 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server). The connection string is located in my web.config file which looks like <add name="AMSConn" connectionString="Data Source=xxxx;Initial Catalog=testdb;User ID=sa;Password=xxxx" providerName="System.Data.SqlClient" /> I want to get this issue resolved and I need you guys help. Please let me know if you need any more information. Thanks Bharat
View Replies !
Remote SQL Server 2000 Perfmon Not Working
I have a SQL Server 2000 cluster running on x64 OS. I found the threads in the forum to run perfmon locally by using the x86 version of perfmon (mmc /32 perfmon). However, I cannot run a perfmon remotely from another machine and see the SQL Server perfmon data on any of the nodes in the cluster. The remote perfmon picks up all of the other perfmon variables but no SQL. I found another thread where somebody asked this question but it wasn't answered. Thanks in advance. Mark
View Replies !
SQL Server Management Studio For SQL Server 2000
I purchased SQL Server 2000 standard. Does the Management Studio a separate purhase? I saw a free download for SQL Server Management Studio Express but this is for SQL Express. Will this work on the SQL Server 2000? Appreciate any input. Thanks, --dan
View Replies !
SQL Server 2005 And Management Studio Driving Me CRAZY -Im UPGRADING To 2000
Is it just me, or are features missing in Management Studio? I mean, where is the "Export Objects" option when exporting data? Why is it so difficult to register a remote server? Why do the object views suck? And most important, why is the documentation the worst software documentation I have EVER SEEN?! Things that were easy in Enterprise Manager with Client Network Utility and Query Analyzer seem impossible, difficult, or maybe just hidden in Management Studio. If it is there, the documentation sure doesnt tell you how to find it. Please someone tell me that it's just me. Tell me that the features are there but Im not doing something right. I feel like putting my head in between my door opening and banging the door against it.
View Replies !
Install SQL Server 2000 SP4 Via Remote Desktop On The Cluster.
Hello. Has anyone attempted and successfully installed SQL Server 2000 SP4 via remote desktop on the cluster. The reason I am asking is that SP4 readme file has this: "... 4.3 Systems Management Server Distributed Installation You cannot install Database Components SP4 from a remote location. ..." Currently SQL Server has SP3a installed. Thank you in advance.
View Replies !
Local Management Studio Cannot Connect To Remote IS
I am not able to connect my local SQL Server Management Studio to a remote server hosting our Integration Services. I get the infamous "Access Denied". I have walked through Kirk Haselden's howto at: http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx but the problem persists. Thanks for any help. Keehan
View Replies !
Add/Edit/Delete Records With Remote SQL Server 2000 Database
Using ASP.net 2.0 or Visual Web Developer Edition 2005 I could not find a single example with Datagrid Control or Form View Control, to achieve the basic functionality ofAdd/Edit/Delete Records with Remote SQL Server 2000 Database. When I searched for these examples I found many videos and examples using local database and in learning path of Visual web express editions, very goodexamples and videos using local SQL Server 2005 database, BUT not with the remote database. My question Is it possible to get the basic functionality of Add/Edit/Delete Records with Remote SQL Server 2000 Database using ASP.Net 2.0 Datagrid and FormView controls? This question looks like, a lazy developer question!! but, in my learning path I found GREAT videos in Visual Studio Web Developer Express edition and learned simple way of drag and drop the controls assign create local database and their connections, and few clicks to add/edit/delete records using datagrid and formview controls. In real life those are not much useful because many of web interfaces are with sql server 2000 and we need to convert them into ASP.Net. Similarly I wanted to drag and drop couple of controls and less coding etc. and accomplish basic functionality of add/edit/delete records using remote database sql server 2000. If possible please help me out. Wondering is it possible to get the functionality of add/edit/delete records using datagrid/formview with remote sql server 2000, the way they explained in bigginers learning videos ... I am referring to (http://msdn2.microsoft.com/en-us/express/aa700802.aspx) If possible and you think it is possible please guide me to that URL where I can learn the great functionalty n implement..!!
View Replies !
Accessing Remote Sql Server 2000 ( Enterprise Manager Like Tool)
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 Replies !
&&"Database Name (6.5 Compatible)&&" Under Management Studio Viewing Sql 2000 Server
I never noticed it before, but I am now using Management Studio to administer our sql databases and the issue became apparent. One of the databases located on a sql 2000 server, says "6.5 compatible", when viewed from Management Studio (but not from Enterprise Manager). What are the step needed to upgrade the database? (I think I need to run the Sql 2005 Upgrade Advisor first, fix any errors found, then manually change compatibility mode (to 80) from the sql 2000 server where the database is located. ) TIA, Barkingdog
View Replies !
Restoring A Sql 2000 Db In Sql 2005 Express Db With Sql Server Management Studio Express
As I said in the subject I've a problem trying to restore a backup of a previous db created in sql 2000 server When I try to do it I recive the following message: ____________________________________________________________________________________ System.Data.SqlClient.SqlError: Il set di backup include il backup di un database diverso dal database 'musica2007' esistente. (Microsoft.SqlServer.Express.Smo) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476 ------------------------------ Program Location: in Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages) in Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries) in Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv) ____________________________________________________________________________________ What should I do? What's the probem? I've already tried to look for the solution in other messages but I didn't find anything..... Thanks for help,,, by Luke
View Replies !
SQL Server Management Express Studio Management Tools
I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.
View Replies !
|
TRACKER
