I installed MSDE on a pc with no problems, but now I realise I want to create another instance and set DISABLENETWORKPROTOCOLS=1 so I can use Enterprise Manager over the network from another PC.
If I create another instance of MSDE on the PC, can I remove / uninstall the first instance?
Is it any big deal if I leave the first instance?
and last but not least...
If I create a new instance will it see the database I created on the first instance?
told you so...
Can anyone recomend some good literature to explain about instances please :D
So I installed an instance of SQL for an application (WSUS) and all waswell. Having read in many places that I could install multiple instances ofMSDE on the same box, I started the second install today (Live CommunicationServer). The MSDE install portion of LCS gets almost completed and then itrolls itself back and fails with Event ID: 11708. Now when I go back intothe SQL Server Service Manager it says not connected and there are noServices available in the drop down list, including the one that should bethere for WSUS. Should I just reinstall WSUS again (hopefully I won't haveto reconfigure all of the updated approval/deny settings). Any thoughts onwhy the second instance fails? Thanks in advance.
Himy first post in the data access forums, I really hope, someone can enlighten me here...I have a windows server 2003 running with 15 MSDE instances. No I would like to upgrade to SQL Server 2000 without crashing the existing instances... My perfect scenario woudl be- install sql server as new instance- move existing databases via detach / attach to the new instanceWill that work?
I have installed two mssql 2000 MSDE sp4 instances on WinXP SP2. I can connect both instances from local machine. But when I try from remote PC, I can only connect to one with default instance name and can't connect to another one ComputerNameInstanceName.
I set the windows firewall off in WinXPSP2. But still can't connect.
I also try with mssql2000 MSDE sp3 instances. It is same ask sp4. Please help!!!!!!
I installed SQL 2005 Standard Edition first, then MSDE plus its SP4. Both instances are named (MC05WXPPROSQLMC for 2005 and MC05WXPPROUCTO for MSDE). I inadvertently had not allowed the TCP/IP protocol for MSDE during the installation, so I did it manually later, through SVRNETCN.exe which also ships with SQL 2005.
Now: I CAN connect to the MSDE instance with any SQL2005 tools through shared memory. But I CANNOT connect to it through TCP/IP. I guess that this is because wrong port binding for the SQL2005 instance, MSDE instance and SQL Server Browser, but I'm not sure.
Just wondering. On some workstations and a couple of servers we have apps each running an instance of MSDE so these machines each have anywhere between 2 - 5 instances of MSDE each.
Would it be benificial from a resources point of view (not to mention a patching one) if we set up one instance of Express to replace the multiple MSDE ones?
When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances." I am currently using SQL server 2005 Express. What do I need to do, to create an SQL database? Thanks in advance.
I had a server with SQL Server 7.0 I installed a named instance of SQL Server 2000 and then i passed all my DB of the 7.0 instance to the 2000 instance. Then i removed the 7.0 instance, that was the default instance. So at the moment there is only the 2000 version, but it isn't the default instance Can the 2000 instance become the default instance? (So that clients can connect to it simply through computer name, and not creating an alias)
Hi, I want to list the instances SQL server in the network and their corresponding database. I found an API which list the server names in the network, but only for the main SQL server it is connecting and listing the database. For others it times out and gives run time error [DBNETLIB] Connection Open () SQL server doesn¡¯t exist or access denied could anyone help on this
I have a database in the SQL 2005 default instance and a report server in a named instance. The database has a symmetric key for decrypting one of the columns. When the report server queries the database I get this error: "Cannot find the symmetric key 'key', because it does not exist or you do not have permission." I know the symmtric key is there because it works when queried from the same instance. Should the database and report server be in the same instance? Or is there a way to change the permissions so that the report server can access the symmetric key in the other instance? I might note that the report server is able to access unencrypted data in the other instance. The error only occurs when I try to decrypt data using the symmetric key.
I have a 2012 AlwaysOn DB Mirroring environment set up with two nodes. Both have 5 installs of SQL named instances.
The issue we are having is when we patch one server and fail everything over, some of the applications will error. Some of the applications had to have their web.config files updated with hostinstance name because it seems to not work with DNS.
I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them. But I should still be able to switch over to sql 2005?!?!?!?
Or... is there a way to attach the databases to SQLExpress manually?
Hi, I am trying to install multiple application services on 1 sql server database. Is this possible? I do not know how to install anything but the default application services settings for the membership, roles, etc.
Hi, i have created a database in business contact manager which is currently been used by five toher employees. I was trying to move that database to my server. Well I found this tool online called "Business contact manager 2007 database tool". I am trying to run it on the server but it is giving me a following error:
"Cannot retrive the list of SQL Server instances. Please make sure that SQL Server 2005 or SQL 2005 Express is installed and that the service is running."
I have SQL 2005 installed on my computer and I dont have any idea how to resolve this issue. It would be great if someone could help me.
Hi all,Here is my situation.I have an application that uses SQL 2000. The client has a programthat uses MSDE. The client MUST have the MSDE version of the Database.What I have done is to create a SQL 2000 Database that is exactly likethe MSDE version. What I wish to do, is at regularly scheduledintervals, update the SQL 2000 Data with the newest MSDE Data.On my clients server, they have both MSDE and SQL 2000 installedthe msde has a user name and password to access it, whereas the SQL2000 uses authenticated mode to access it.What I'm trying to do is to write a bunch of SQL Queries, that I canrun that will copy over the new Data, but I'm having problems accessingthe msde database in query analyzer from the SQL DatabaseCan anyone give me hints on the best way to try thisThanksScott
I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which the company says works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get an error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Or... is there a way to attach the databases to SQLExpress manually?
Downloaded and installed MSDE and just finished creating a website using the Community Starter Kit. I'm used to working with Access Databases and this is my first experience with anything SQL. Can someone provide my with some guidance as to what I need to do to upload the MSDE Database to a server. Can I just upload the files like an Access Database or is this more involved. Thanks for you help.
I'm using Visual Studio.Net enviroment, i have SQL desktop Engine installed and everything is working great. I have a problem that whenever i create a new database connections i can NOT delete it. I know that i have to select the node containing the connection and then press the DEL Key, but it seems that the delete option is not valid!
Hi, I am new to .net, I installed .net sdk and framework. now I downloaded MSDE and installed it, I got this directory : C:MSDERelA but when I double click in the setup file nothing happened, please help me on what should I do . thanks
I installed MSDE and the sample databases with it. They work fine.
Well I am using the server explorer of visaula studio standard 2002. I can see all the sample databases there and connect to them as well.
1. -------------------------------------------------------------------- Now i created a new database named "testDb" and in a similar fashion i am using windows login thingy.
When i write my connection string in the program now it doesnt work
I'm running Windows 2003 .NET server (1 year trial) and I have the latest version of MSDE installed. I have WebMatriX II installed. I want to create an MSDE database I can use with a DSN so can use in .ASP or APS.NET. I've successfully created a test database (in Webmatrix II) via Windows Authentication security and have created a DSN via ODBC/Windows Authentication security but don't know how to access in ASP or ASP.NET web page. All the SQL databases I use in .ASP have a DSN, User, Password as connection parameters. I want to continue this process. I ran the command list: setup SAPWD=**secret** SecurityMode=SQL after setting up MSDE SP3. I log into the server as "Administrator" with a password. Question: 1. What am I supposed to use as a ID and Pass if I want to setup a MSDE database in WebMatrix II using SQL Server authentication? Everything I try fails. I was never asked to provide a beginning ID and Pass for SQL(MSDE) Server. 2. What does the connection string look like to access the database in ASP.NET for Windows Authentication security? Like this: ConnectionString= "server='localhost'; trusted_connection=true; database='ichapter_test'". 3. What would it look like in .ASP? Thanks in advance! JurekWorks
HiI am just starting my first .NET project using the web matrix and an MSDE database. I am pretty much at the limit of my knowledge - all very interesting. I have some data in an Access spreadsheet (6 columns and 365 rows) which in the past I have copied and pasted into an Access database table. How do I get it into a MSDE database table? This process does not need to be automated/programmed as I will only have to do it once a year. Any ideas on the easiest way forward would be much appreciated.Thanks in advance.Mike
I'm trying to build a record update form and I'm going off the "Build Your Own ASP.NET Website" book. I'm not getting any compilation errors; the database just doesn't update.
I have installed the MSDE from Office 2002 CD and MSDE is running. I can see the SQL Server Icon in tray with green arrow. CAn ne body help me how to create database in the MSDE. I am new to this. Is there any query manager or entrprise tool by which I can create database and table in it. Also I am not able ro install the Starter Kit .Please help me in this.
I have MSDE installed on my machine to support off-line use of a web application.
The database (MDF) file in question is stored on an encrypted area of my hard drive, which must be unlocked each time the machine starts up by the user entering a password.
Unfortunately, by this time the SQL Server service has already started, and although it still lists the database along with master, etc, it cannot access it. I believe the error mentions that some files are unavailable.
Stopping and restarting SQL Server using Service Manager fixes this problem. However, this can only be done when logged in as Administrator. I need to find a solution for normal users without Admin privileges.
Is there any other way of making the now-unlocked MDF file available to SQL Server? I thought about using SQLDMO to Refresh databases, but no joy.
This is a real show stopper for my application, which I've spent three years developing! It goes without saying that I'm writing this message with a long face. If anybody has any suggestions I would be very happy to hear from you!
We can install the enterprise manager, but cant get the maintenance plans to work. (fields stay empty and setting dont get saved) I've searched a bit, but couldn't fix it.
No problem, i created a job, with 12 T-SQL commands, and the backups are working perfect.
Now we wanne backup with a history (we take a backup every 4 hours of the day), because now they always get overwritten.
So im trying to change my transactSQL to create dynamic files.
The code i'm using right now :
BACKUP DATABASE PW0001A00 TO DISK = 'C:SQLBACKUPPW0001A00.BAK' WITH INIT, NOUNLOAD, NOSKIP, STATS=10, NOFORMAT
I've tried different things like
BACKUP DATABASE PW0001A00 TO DISK = 'C:SQLBACKUPPW0001A00' + DATEPART(month, GETDATE()) + '.BAK' WITH INIT, NOUNLOAD, NOSKIP, STATS=10, NOFORMAT
but nothing worked.
so basically I wanne be able to create dynamic filenames in the above command.
I have installed MSDE into my system, in which SQL Server is not installed. I have followed the installation instructions and installed MSDE. How can i connect to the database? I have the .MDF file of the database (already created in sqlserver) in the Data Folder. How can i connect to the database from Visual Basic 6?
I have a vb application that uses sql server database , I want to move from sql server to msde file , wanna be able to attach msde file with vb app ,and run setup program It looks like there is not much good info how to start with it can anyone guide me ? Thanks
I have a MSDE database on a laptop and need to copy it to another machine in order to use Access 2000 to inspect the tables and view the data using an Access project adp file.
Could someone please tell me how to do this and whether there are any relevant issues/problems.
I have a MSDE database on a laptop and need to copy it to another machine in order to use Access 2000 to inspect the tables and view the data using an Access project adp file.
Could someone please tell me how to do this and whether there are any relevant issues/problems.
Hi,How to copy database diagram (all data) to other server using only MSDEserver and VS.Net Proffesional? I have no Enterprice manager. I have tomove database (create on my machine) to my customer server. Is somepossibilities?--*Pozdrawiam,*Klaudiusz Bryja
