Managing SQL 2000 Databases On Vista...
Feb 23, 2007
I have one database at an ISP running on a SQL 2000 server. Under Windows XP Pro, I installed SQL 2000 administrative tools then I could use the database manager as well as the query tool to manage my database.
I have upgraded my machine to Windows Vista Ultimate. SQL 2000 client services won't install under Windows Vista.
Under Windows Vista, I was able to create an ODBC component that connected successfully to the SQL 2000 remote database, but I no longer have a transaction tool or a gui to manage the tables.
My goals are simple: I want to be able to view/add/drop tables and data using some sort of GUI. I would also like to have some sort of SQL transaction client. I don't need to do any high level database management, just view/change/add/delete tables in the one database that I own on that server.
My isp is NOT going to upgrade their SQL. I do not own Microsoft Access or Microsoft Excel. What FREE software options do I have, given my goals?
View 7 Replies
ADVERTISEMENT
Nov 7, 2007
Hi,
I have just installed SQL 2005 client tools and management studio to register SQL 2000 databases. Although it registers the servers successfully , I can't see any activity monitor on the SQL 2000 registered server . Is it something more that I have to install to see what's happening ?
Thanks in advance.
View 4 Replies
View Related
Jun 6, 2000
Hello everyone,
I have a question about how to efficiently develop on a development version of a database and get those changes over to the production database without loosing live data, etc.?
Here is how we are trying it:
1 Export production database to temp database(exact copy)
2 Delete production database
3 Export development database (definition only, no data) to new database with production database's name
4 Export production (temp) database (data only) over to new production shell
We are having truncate errors due to FK constraints.
Is there a better way?
Thanks for all help
Kevin
View 1 Replies
View Related
Aug 21, 2002
Scenario:
1. Access to database objects is based on database roles.
2. Application administrators handle the assignment of users to database roles. Application administrators are first line managers, typically; they are not DBA's and not Help Desk staff.
Question:
What products are available to simplify the management of user access to databases in the aforementioned scenario?
TIA to all respondents.
--
Peter
View 2 Replies
View Related
Oct 9, 2006
Hi,
I have to manage many SQL Server databases on several servers. How can I manage the jobs, backups and the space on the disc without going to each and every server and database and job? Is there any script to run this? It will be very helpful if you can provide me the sample script or point me to any web site where I can get the info/script for this. Thanks in advance...
View 6 Replies
View Related
Mar 28, 2008
I have a windows 2003 server which has SQL 2005 Express with advanced services installed on it. Then a few weeks back the company purchased SQL server Standard Edition which comes with SQL Server Management Studio (which has more features than SQL Server Management Studio Express currently installed on the server where sql express is running)I have been trying to schedule a maintanance plan on the SQLExpress Instance database from the SQL Server Management Studio that came with the standard version of sql but i have not been able to have all SQL Server Management Studio functionality available when connected to the SQLExpress instance. So is there a way i can connect to the Express Instance from management studio(that comes with the standard edition of sql) and have all its functions available when working with a SQL express database. Or i must upgrade the express database?
View 5 Replies
View Related
Jul 10, 2007
I currently use Enterprise Manager 8.0 with several SQL 2000 servers. I'm ready to work with my first SQL Server v 2005. Can I use EM 8.0 along side the new Management Console until I'm through the learning curve? I understand you cannot register a 2005 server with EM 8.0, but I assume you can register a 2000 server from the new Management Console without any problem.
View 1 Replies
View Related
Jan 25, 2008
Looking for a way to manage reports on both 2000 and 2005. Over the past couple years many reports were created/modified by different people (some no longer available) and we are working on consolidating eveything on a "new improved, bigger, better" 2005 server. I know some reports are duplicated or nearly duplicated on the two systems and are in several different projects/solutions. I want to find a way to collect/consolidate a list of all the projects/solutions, reports, date created/modified, data sources, etc. to help determine how best to procede. I looked through the forum and other documentation but couldn't find a method to do this. Basically I need a report on my reports. Thanks, al.
View 1 Replies
View Related
Aug 1, 2007
Doing some testing with Vista and SQL Server Express 2005..
I'm logging into Vista under a Windows admin account, UAC turned on. If I run SSMSE, log into my default server via Windows Authentication, thus using my Windows admin account, I'm unable to attach a database to the server. I'm getting the error message - Unable to open the physical file...Operating system error 5: Access is denied (error 5120), etc.
My Windows admin user is a member of the sysadmin server role for my server instance, and I'm running SP2.
To get around the problem, I can either choose to launch SSMSE with "Run as administrator", or give the Windows Users group full permissions on the database file. Detaching, deleting, etc is no problem with this admin user (e.g. do not need to select "Run as a administrator" on SSMSE launch).
Any ideas, or is this is behaving as expected? Thanks
View 4 Replies
View Related
Oct 8, 2007
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 8 Replies
View Related
Apr 14, 2008
Hello,
I have SQL Server 2000 and 2005 running on the same server. My current system is in SQL Server 2000 and the new system is in SQL Server 2005. My users will be using SQL Server 2000 for the most part, But for the part the processes that have been migrated to 2005, they will be using SQL Server 2005 as well. The database schema is different on both servers eventhough the data will be similar in most respects.
Is there is a way through which any data that is inserted/updated in SQL Server 2000 via content Management System/ manually/ via a batch job, the data is automatically populated in SQL Server 2005 tables or vice versa?
Please advice at the earliest.
Thanks.
View 2 Replies
View Related
Jan 24, 2006
I just restored my SQL server 2000 database on the SQL server 2005. after this i ran the Service broker sample ("Hello World") on this database by changing the AdventureWorks name to the new database name. The "setup.sql" runs fine. When i run the "SendMessage.sql" i was not getting any rows in the output (The message was not getting inserted into the queue). I checked the Service broker is enabled on this databased using the query "select is_broker_enabled from sys.databases where name = 'newdbname' " It was 1. I even tried the ALTER DATABASE SET ENABLE_BROKER. but it didnt work.
When i tried the sample on a newly created database it worked fine.
Is there any solution to make the restored database to work for service broker.
Thanks
Prashanth
View 3 Replies
View Related
Apr 30, 2008
I have to merge the data from two databases, one is in SQL Server 2005 format, one is in 2000. The merged data will then reside on a SQL Server 2000 platform. Is there an easy way to do this through Management Studio or Enterprise Manager? Or will we have to export the data from the 2005 database to a flat file and import it into a new 2000 database. And then do the merge?
TIA
View 4 Replies
View Related
Jan 28, 2007
Trying to transfer databases from MSDE to SQL. When I use SQLEnterprise Manager - DTS - import or export, it works for the firstdatabase, but then fails for the others. I select the to and fromdatabases using DTS - Import - 'MS OLE DB Provider for SQL Server',then select 'Copy objects and data between SQL Servers'. It failswith the generic error message: 'Copy objects failed', nothingfurther. I tried to just copy data, and it doesn't work totally. Ontwo databases, it said that it copied everything, but when I go inunder Enterprise manager, some of the tables are incomplete, i.e. nodata, table shows up in the list, but if you try to look at it, itsays that it is missing or empty. Also, one table was not evencopied. In the other two cases, I get errors, does not copy alltables. I get errors, like insert fails, but the column it referencesfor the table does not even exist in that table. Any suggestionswould be appreciated.
View 2 Replies
View Related
Mar 6, 2008
A user upgrades her machine to Vista
She was able connect a sql server which is 2000 version but unable to connect another server which is also running in 2000 version
Please help to find solution
View 11 Replies
View Related
Mar 13, 2007
A client just purchased a new notebook, pre-installed with Vista. He says he is having trouble installing SQL Server 2000 (database and client tools). I am not certain (yet) if this is the standard edition or the desktop version.
What, if any, are known compatibility issues between SQL 2000 and Vista?
View 5 Replies
View Related
Nov 6, 2007
Dear All
I have just purchased this new laptop and it comes with Vista Ultimate Edition. Our office network is on SQL 2000. When I tried to connect my new laptop with SQL 2000, it keeps giving me weird run time error. Can someone please tell me, is SQL 2000 compatible with VISTA Ultimate or not, if yes, how can I connect without getting this error. If not, do I need to upgrade SQL 2000 to SQL 2005?
Kindly suggest.
Regards,
Faysal Jamil
View 1 Replies
View Related
Mar 11, 2008
Dear All,
My office computer just had Vista installed on it and I have now encountered a problem in SQL Server 2000 sp4. (Yes, I know it's old and has comparability issues with Vista, but I don't have the option to upgrade at this point.) I have two servers to register. One works fine, but the other won't register and returns the error "SQL Server does not exist or access denied. ConnectionOpen (Connect())". I was able to register this one server that isn't working while previously running XP on my office computer and even as a test on another server running Windows Server 2003. This leads me to believe the problem is isolated with my installation on Vista and not with any permissions, etc. I have been scouring different forums looking for a fix for this, but have come up empty handed. Does anyone have any suggestions on how to fix this problem?
Thank you!
View 14 Replies
View Related
Jul 18, 2007
I am having difficulty connecting to SQL Server 2000 on one of ourservers via a VB6 program on Vista. I can connect fine to a differentserver, but it gives me the following error with the server inquestion:"Unable to connect to database. Please check your internet connectionError# -2147467259[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist oraccess denied"Using the program, I am able to access the database just fine whilerunning on Windows XP, but when I run the program on Vista, it givesme that error message for that server. If I change the connectionstring to a different server address, it works fine on Vista. Whatdifferences in the servers might cause this?Here is my connection string:"driver={SQL Server};Server=ipaddress;Uid=userID;Pwd=pwd;databa se=db"
View 7 Replies
View Related
Jan 17, 2008
Hey
Ive read on some pages that it is in fact possible to install and run SQL Server 2000 on Vista. In my university, SQL Server 2000 is still used to teach us about databases and how to administrate them. The computers run Windows 2000 Professional. I need to be able to use 2000 so I can not only have compatibility but also know the steps and all possible conditions and solutions to problems.
Would installing and running SQL Server 2000 on Vista be possible or am I better off using 2005? Is there much difference between these 2 versions?
View 11 Replies
View Related
May 30, 2006
Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308).
The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem?
Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308)?
Thanks in advance.
View 4 Replies
View Related
Jan 30, 2008
I want to view the sample databases within Access 2003. When I try to view them an error message appears saying I need MSDE 2000 but this will not run on Windows Vista which is my operating system. What do I need to view the sample database as well as develop applications within Access using SQL server?
View 1 Replies
View Related
Mar 13, 2007
I am using two almost idential laptops, one with XP and one with Vista, the only differences is that the XP laptop has 1G of RAM and running Office XP and the Vista has 2G RAM and is running Office 2007.
I have a MS Access database that has linked tables to a SQL Server 2000 database. The performance of the Access database on Vista is 5-10 times slower on the Vista machine. Just flipping through records or opening forms can take 5 - 15 seconds on the Vista machine while the XP machine takes 1 sec or less.
What gives? I looked at the CPU performance and the network performance while the Access database was busy flipping through records, the network traffic was < 2% and the CPU would spike to 40% on one of the CPUs (dual core) but would remain under 5% most of the time.
I also previously had Office XP installed on the Vista machine and it had the same performance issue so bought and install Office 2007 on the Vista machine and it did not solve the problem.
It seems that Vista is doing something that is slowing down Access with linked tables. Is this a issue between Vista and using an ODBC connection to SQL Server?
Thanks in advance for any help on this
View 1 Replies
View Related
Nov 26, 2006
hi there - I'm praying someone here can shed some light on this - after many google and web searches, I have found users with similar issues, but have yet to find a solution.
Problem: I have recently upgraded my desktop from Windows XP to Windows Vista Ultimate (clean install) and have migrated my local machine to SQL Server 2005. However I have a number of .Net projects that access databased on another server running SQL Server 2000 - prior to my upgrade to Vista, I was running SQL Server 2000 on my desktop as well. During the install, everything seemed to go well, and I also installed the SQL Server 2005 Service pack as instructed via the MSDN site. However, when attempting to test my .net projects on my desktop pc (ie visit http://localhost), I encounter the 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)
note that the server I am attempting to connect TO is the old SQL 2000 server - NOT 2005. I specify my connection info in the web.config - and it points to an external ip address on the web.
Can anyone shed some light on this? I've tried enabling remote access on my local SQL 2005 install, but I'm fairly sure thats for servers that want to connect to my desktop, rather than my desktop attempting to connect to external servers. Any help is greatly appreciated - I'm pulling my hair out over trying to figure this out! :)
To summarize my setup (if it helps)
Desktop PC:Windows Vista (Ultimate)SQL Server 2005Visual Studio 2005II 7.0.Net 2.0 (ASP.Net Application)
External Server (co-located at a datacenter)Windows Server 2003SQL Server 2000IIS 6.0.Net 2.0 (ASP.Net Application)
Much appreciated,
Ted
View 5 Replies
View Related
Jul 23, 2005
We have a three tier application running on two tiers. 1&2 running onone server and a seperate server for the databases. On the databaseserver we are running Windows 2000 Server with 3Gb of RAM and Dual1.8GHz Xeon Processors and SQL Standard 2000.The memory for the SQL server never seems to go above 1.8Gb. Doesanyone have some suggestions about this or does anyone have someinformation on how many Db's can be run on one server. Most of themare relatively small with low activity.Thanks a lot..
View 4 Replies
View Related
Jan 7, 2002
Hi all,
Please let me know if SQL Server 2000 databases be held in RAM inorder to improve performance.
Thanks in advance
Praveena
View 2 Replies
View Related
Jun 17, 2002
Hi,
I am preparing to move from sql7 to sql2000 and and considering the copy database wizard to move the databases. The thing that I am concerned with is this passage from BOL
"A database with the identical name on both source and destination servers cannot be moved or copied"
This to me says that the database name cannot be the same on source and destination servers. Yet, you would want the database name to be the same from an application point of view (developers get real nasty when you change database information on them).
Does this mean I cannot use the copy database wizard? Must I use sp_attatch_db?
Thanks in advance
View 2 Replies
View Related
Jun 17, 2002
I would like to know if its OK to restore a SQL 7 user database to SQL 2000.
I have looked into Books On Line, with no success.
Anyone know where I might find some documentation on this topic?
Many thanks in advance.
Gary Andrews
View 1 Replies
View Related
Jun 20, 2004
Hi
I need to retrive data from multiple tables which are in two databases. How do i connect to both of them at a time and query the tables with some criteria.
Thank you
View 3 Replies
View Related
Feb 20, 2002
Hi,
Microsoft listed 32,767 as the max # of databases for a SQL 2000 instance but I am curious what is the comfortable # of databases we should have before running into issues such as performance degrading etc.
Thank you very much!
-thinh
View 3 Replies
View Related
Jan 17, 2005
I am planning on upgrading one of my SQL 7 servers to SQL 2000. This server is currently and will continue to replicate with a SQL 7 server.
I want to view our current replication jobs & schedules in plan text so I can check when I recreate the replication that I haven't missed anything. Does anyone know if this is possible?
Jon
View 4 Replies
View Related
Aug 19, 2006
I need to move our production database to a brand new machine on our LAN.Both machines are running SQL2K. I'd like to place the production databasein a directory on the destination machine with a slightly different pathname than the source SQL server.How can I shrink the transaction log to the minimum size before I try themove? What is the best way to move the database to the new machine? Wehave Veritus Backup Exec.Regards,Charles MacLean
View 1 Replies
View Related
Jul 20, 2005
We are moving all databases from a SQL version 7 server to a version 2000server. Which of the following is the preferred method?1) Detach the DB on the version 7 server, move it to the new server viaWindows Explorer and reattach it there.2) Use SQL Enterprise Mananger with the DTS Export Wizard to "copy objects &data between SQL server databases" from the version 7 server to the 2000server.With the changing of the version, I thought maybe option 2 is best. Thoughts?--Mike CzizekIowa Network Services, Inc.Join Bytes!
View 1 Replies
View Related
