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
Have reinstalled MSDE using Command Prompt Installation and received Errors.
Then I proceeded with a Batch.file installation and that seemed to work for the most part.
This is what I used for the Batch.file
setup.exe SAPWD=somename INSTANCENAME=somename SECURITYMODE=SQL
The Problem I ran into is - I can't seem to get the (SQL SERVER SERVICE MANAGER) to connect. I've entered the server name & instancename but so far no luck.
Ive checked - Control Panel/Administive Tools/Services - to make sure that it was installed & Yes it is there. So I Proceeded to start it up. Next I tried to Connect Via SERVER MANGER with no luck.
Then I did a c:>osql -E check with the Command Line Prompt which returned the following message:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.
Tried again with c:>osql -E -S
returned the same message.
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.
Not sure what to do at this point any help/advice. Thx/TIA
(MSDE Version: sql2kdesksp3)
OS = XP Pro
I had MSDE installed on my machine, but I had problems making it work. I installed the Visual Studio 2005Beta2, and it apparently installed MSDE 2005. I deinstalled MSDE 2000, then tried to make MSDE 2005 work. After lots of hair pulling I finally found the instance name, reset the authenitcation method, and reset the SA password. Then I found out all my sql tools don't work with it. No enterprise manager or query analyzer. So off MSCE 2005 came from my machine. I reinstalled MSCE 2000, but I cannot login. I am not sure if I don't have the proper instance name, or password for the sa account. I have not really found any good into on setting up the msce 2000 software. I think it found the old username/password info because whtn I started it, it did not ask me for any of that information.
View 1 Replies View RelatedHi! I'm trying to rename tables in a msde database, without succeeding. Simple question, I guess, but I can't find out how to do this. I know this doesn't work though:--- Dim connectionString As String = "server='(local)'; trusted_connection=true; database='GustafTest1'"Dim cn As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
cn.Open()
Dim queryString As String = "RENAME TABLE table1 TO table2" '"ALTER TABLE [table1] RENAME TO [table2]"
dbCommand.CommandText = queryString dbCommand.Connection = cndbCommand.ExecuteNonQuery()---The reason to why I want to do this is that I'm updating the information of my system, and store the new data in a temporary table during update, in case something goes wrong. If the storing goes alright, the newly loaded the old table is renamed to backup_table and the temporary table is renamed from updating_table to active_table.That is a good solution, right?Thanx,Jon Engström, Sweden
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
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 RelatedCan I have MSDE and SQL2K installed on the same machine?
Thanks
Mary
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.
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
:-)
Hi everyone,
I have MSDE install on my machine with Office 2000. I have a sql script(db.sql) that create the database(db1) and its objects. I would like to run this script on this machine. Is there a utility like SQL ISQL.exe in the MSDE version?
Thanks in advance...
Thanks...
cobenho@my-deja.com
I have a local install of MSDE on my workstation. I have also defined alinked server with another SQL Server on our network. I accepted all thedefaults when I installed MSDE and the server got named my machine name.Everything is working great.Our IT department now needs to change my machine name. What effect willthis have on my current SQL installation?Help and suggestions appreciated.Thanks,Frank*** Sent via Developersdex http://www.developersdex.com ***
View 1 Replies View RelatedI have the following command in a .bat file
osql -E -S localhost sp_grantlogin 'GREGASPNET'"
What I would like to do is replace GREG with the name of the local computer this .bat file is being run on.
Is there any string for this... i.e [LOCALMACHINE]ASPNET or something like that?
Greg
Hi guys,
I'm just wondering if the MSDE & SQL Server 2005 Express can run on the same machine(winxp) without conflicts. Because I need both the reporting services & the publication functionality of replication.
Thanks in advance.
Hi I would like to ask If its possible to have installed MSDE 2000 and SQL 2005 Express on the same machine. My computer uses MSDE 2000 for one application and I would like to install SQL 2005 Express for my own application. I would like to ask it will be a problem before I install it.
thanks a lot
Martin Molnar
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
Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters.
I'm trying to setup a news database for my website, which will populate
the information into a datagrid. To test, I manually added a news
item in the database through the visual studio 2003 gui. I
immediately noticed a problem as the I was getting an error after a
long news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column. As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.
My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"
I'm not sure if this is the correct forum for this this question but I'll give it a shot.
The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?
I looking for some guidance here. I have database which has exceeded the 2 gig limit. I deleted some old tables in an attempt to acquire some space. This worked out. However when I look at the size of my *.mdf it still appears in excess of the 2 gigs . I know this isn't true since I deleted 500 megs of stuff. How do i reclaim the space (get the file size to report correctly) or do I need to even worry about it.
Andy
Hi
I have visual studio .net and i recently installed MSDE specific for visual studio.
The name of my server is FRANKNETSDK.
String strConnection ="server=FRANK\NETSDK;database=Northwind;integrated security=true";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
objConnection.Close();
I created an instance which is NETSDK
I created a password
I don't know why my server choose the name FRANK i was expecting local.
I have to use FRANKNETSDK or else i can't get my server to Start.
This is the error: Login failed for user 'FRANKASPNET'.
[SqlException: Login failed for user 'FRANKASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
sqlconnect.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootsqlconnectwebform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Any help would greatly be appreciated.
Hi
For quite some time nowI have been trying to give user rights to my MSDE , needless to say the fruits of my labor have turned up very little success.
So far i have tried using the osql commands to grant user access to my database. I have run the stored procedures(sp_grantlogin ,sp_grantdbaccess ) but to little avail!
So now i have taken a new approach i installed the Enterprise Manager. I have just a minor problem with this new strategy , i don't know how to use it!!
This is what i have prensently installed on my system: Visual studio.Net ,Microsoft SQL(MSDE)
and finally the Enterprise Manager.
My Servername is FRANK.
I have created an instance which is NetSDK (FRANKNETSDK)
My SAPWD is Kildare
I have Mixed Mode
Can anyone please tell me how i can use the Enterprise Manager to grant access to MSDE.
I am sure you have all realized from all these insipid post that i have no experience.
So please be explicit in all your details.
My email roti@videotron.ca
Thank you
Frank
Having Problem connecting to Database with WebMatrix
When I try to ADD Database in WebMatrix through Sql Connection & enter USERNAME & PASSWORD it fails. Is there a way to create New USERNAME & PASSWORD? Perhaps through
the Command Line Prompt?
Any Help/Advice TIA
Tristen
I have never done anything with databases, so I am a newbie. My goal is to install an ASP.NET forum, but I need MSDE installed. I downloaded MSDE from the Microsoft website. When I run the setup.exe file, I get an error. It says:
A strong SA password is required for security reasons. Please use SAPWD switch to supply
same. Refer to readme for more details. Setup will now exit.
I looked at the documentation but could not find anything usefull, what do I have to do to install it. Thanks in advance for responses.
How does MSDE handle data mangement? Does it come with sql analyser or some sort of database manager?
Thanks.
Hi,
I am newbie in ASP.NET and MSDE arena. I understand that MSDE has no GUI and I need to have MSDE tools to work with it. I have already installed ASP.NET 1.1 and Microsoft.NET SDK 1.1 and MSDE in my Windown Professional 2000 PC and I have run and tested for .aspx and its working perfectly. But I want to use MSDE to create some database driven web applications.
Could you please help me how I can do that? BTW, I installed Microsoft SQL Web Data Administrator and its giving me SQLWebAdminStart.exe Application error and asking for debugging while opening the program. I am stranded what to do now?
I really appreciate your help.
regards,
Peter-Toronto
(Linux, PHP, MySQL)
I just installed MSDE off of disk that came with teach yourself asp.net in 24 hours. To get the program started you must go to run and type cmd and wait for the C prompt. I get this far, but I can't get a C prompt. It always comes up C:sql2ksp3> How do I get a C prompt from here. I know it must be something easy that I am just overlooking or forgot.
Thanks
Del Dobbs
Hi ,
I m trying to install MSDE database at my machine to Test my queries and page so i can upload them. I did changed the Path and added osql. and all that things. Its still giving me an error. Which is
" Server Error in '/QuickStart/aspplus/samples/grocertogo/VB' Application.
SQL Server does not exist or access denied.
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. "
not sure what exactly to do. Also if have SQL server runing on remote machine is there any other way i can check my pages. Any help wikk be greatfull. Many thanx in advance
KHan
Hi all,
I have a web application that uses SQL Server. I have 6 clients that all use the same SQL Server database structure.
I know have a new client who is using MSDE as there Database. The Database should have the same table structures as the SQL ones.
So my questions are this:
1. I have a backup of the new clients data. How do I attach it to SQL Server?
2. Does MSDE have stored procedures?
3. Can I write stored procedures in a SQL Database, that reference tables in an MSDE database.
4. Can someone point me in a direction, that can walk me through this?
Thanks
Scott
Hi,
Well i want to ask, Is this true that
We can use the MSDE on commercial basis for a limited usagage with out paying.
The limited usage means that may be upto 20 - 25 concurent users can be use the Engine at a time.
thx for the comments
I installed MSDE 2000 in my system. There is no icon & gui screen. How can i create/alter database using MSDE without using any programming language? from where can i get stored data in msde? How can i take backup for this data?
View 2 Replies View RelatedHello,
Is it possible that i have my webapplication on a webserver and my database on another server?The database is MSDE.Thanks for your respond
I want to connect to the MSDE database and create database and tables etc.., I am successful in creating the database and tabels etc.., as shown below:
string ConnString;
ConnString = "data source=(local);" +
"database=;integrated security=sspi";
SqlConnection SqlConn = new SqlConnection(ConnString);SqlConn.Open();
SqlCommand SqlCmd = new SqlCommand("Create DATABASE dbase1", SqlConn);SqlCmd.ExecuteNonQuery();SqlConn.Close();
but Instead of connecting to the MSDE without giving any database name,canI create the instance of MSDE on the fly and connect to it. Like creating a MSDE OBject to start the MSDE and then connect to it using Windows NT authentication
How do you deal with MSDE on a W98 machine since it can not run as a service?
View 1 Replies View Related