MSDE And SQL Server Manager

Jul 29, 2004

I have installed MSDE on Windows Server 2003 along with IIS. I am having problems getting SQL SM to work. I cannot login to it.





Here's how I installed SQL SM:


setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=paswd





I cannot log in...





I have tried Windows Integrated and SQL login...

View 2 Replies


ADVERTISEMENT

What Is The Best MSDE Manager Out There

Dec 9, 2003

Hello,

I'm new to MSDE and WebMatrix.
My problem is that I can't find a way to load a MS SQL Server 2000 schema with WebMatrix.
So I guess I need a program that manages that kind of things.

What do you recommend?

Thank you!

View 1 Replies View Related

MSDE EnterPrise Manager

Aug 12, 2004

I am using MSDE enterprise manager and when I downloaded it, I cannot log onto the SQL Server, which is on my computer, I used the server name defined in the SQL Server Service manager, and it cannot connect. I was trying to set the conection up with the ODBC manager, although I am not even sure if this is the right way. Someone please help me out.

View 1 Replies View Related

MSDE And Enterprise Manager

Dec 22, 2004

I have just installed (new clean install) of MSDE 3a. On another machine I have enterprise manager, and I thought I would be able to access it, but when I try to register it in EM it gives me the following error: SERVERNAME - SQL Server does not exist or access denied, Connection Open(Connect(). I have done this in the past with no problem. Did I forget a parameter on the install of 3a to allow other machines to access or do I have some other security issue?

View 2 Replies View Related

MSDE And Enterprise Manager?

Dec 19, 2005

I am a complete sql newbie! For the life of me I can't figure out how to get Enterprise Manager to connect with MSDE. Something about mixed mode or tcp/ip settings? But no one's ever really clear on how to do these things. I've uninstalled MSDE until I can get more info.
I just need a quick walk-through on how to install msde to work with EM. This is what I used when MSDE requested a strong password:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"
Is this correct? Any help would be appreciated.
Thanks.

View 5 Replies View Related

MSDE Upgrade And Enterprise Manager

Feb 7, 2004

I just upgraded for MDSE 1 (came with VB 6 Pro and inculded Enterprise Manager) to MSDE 2000. After the upgrade, Enterprise Manager was removed.
Is there an Enterprise Manager availble for MSDE 2000, or a similar tool out there?

Thanks for any help.
Greg

View 3 Replies View Related

Can I Access MSDE On A Remote Machine With Enterprise Manager?

Sep 22, 2007

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

View 2 Replies View Related

Help! Enterprise Manager Turns SQL Server Service Manager Off

Dec 6, 2006

IF someone can assist me. Everytime I load up enterprise manager the service manager turns off. And the enterprise manager can't connect to the local database. But everytime i turn it back on and try to connect again it shuts it off and around and around we go. Help would be appreciated. Thanks.

View 2 Replies View Related

MSDE Text Datatype - Unable To Store More Than 900 Characters. (msde + Visual Studio 2003)

Jun 6, 2005

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.

View 1 Replies View Related

How Do I Change The Name Of A Computer Running MSDE With Out Reinstalling MSDE

May 27, 2000

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"

View 1 Replies View Related

MSDE: Renaming Machine Without Reinstall Of MSDE

Mar 27, 2001

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

View 3 Replies View Related

MSDE Worth Using Or Should I Invest In MySQL? (was MSDE)

Mar 9, 2005

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?

View 4 Replies View Related

A User Group Account Acting Like A Content Manager And Admin On The Report Manager????

Nov 2, 2007



A user was created with a limited privilege under the USERS group. Once this user loged in the Report Manager he is acting like an Admin and Content Manager, though he is not given even a browser role.

What do u think that this guy is acting like a Super User evenif he is restricted to a browser role on the Report Manager ????????????

I did all my best, but no luck so far

View 5 Replies View Related

SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?

Feb 13, 2008

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 4 Replies View Related

Upgrading Localized MSDE-server To The English Version Of SQL Server Express 2005?

Aug 6, 2007

Hello,

at the moment I have the following problem:
We have installed a version of the MSDE 2000 Sp3 with our software since 2005. Now we install SQL Server Express 2005 in order to use the latest version and to be compatible with Vista.
We have never had any problems with the MSDE, so it was no problem that we installed the german version (by mistake) because there never was any output at installation time.
When we now upgrade the existing MSDE installing the new version of our software, there are often problems and there are error messages, unfortunately in german, which cannot be read by most of our international users.

The problem is, that there seems to be no possibility to upgrade the existing (german) MSDE with the english version of SQL Server Express 2005.
My question is, if it is possible to upgrade the german MSDE to the english SQL Server 2005 to enable our international users to read the error messages at installation time in english?

Thanks in advance.

Best regards,
Peter

View 4 Replies View Related

Problems Running Enterprise Manager And Service Manager

Jul 20, 2005

On one of our machines, all of the SQL Server 2000components except for the main Server component (SQL Servercore) itself were installed (Management tools, etc) a while agoand everything was running fine. Now I go and add/install theServer component and then Service Pack 3a.It seems that Service Manager won't start up (I get an hourglass cursor)and now I find that Enterprise Manager won't run as well. No errormessages appeared and I don't think I saw anything unusual inthe log file.However, I can use Enterprise Manager on a differentmachine and connect to the database (so the databaseitself seems to be running).Any suggestions as to what the problem might be and how tofix it? I like to see if I can repair this without havingto do a reinstall.Thanks.PF

View 2 Replies View Related

MSDE && SQL Server 2005 Mobile Server Tools Problem

Jan 24, 2006

After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.

"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"

Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000??

View 7 Replies View Related

MSDE 1.0 And SQL Server

Jan 26, 2004

Apparently since I downloaded SQL Server SP3 and tried to install it on a computer without SQL Server in the first place, it's a bad thing.

I'm trying to get SQL Server Desktop Engine to install and I do the cmd.exe thing and it works, then 1 second before it finishes it rolls back.

All the files are still there, just missing the ones you need to run the SQL Server.

I used to have it on my 98, before I upgraded. Now I have the ASP.NET WebMatrix on my XP Home.

Is there a way to get SQL to install correctly?

John

View 2 Replies View Related

SQL Server To MSDE

Jul 23, 2004

I have created a SQL server database on my localhost. The live server that I am going to host the site does not have SQl server. I was thinking of putting MSDE on the live server. Would I have to make any changes to my SQL server database to put on the live server where i only have MSDE. Any idea what's involved with all that??

Thanks!

View 2 Replies View Related

From SQL Server To MSDE

Dec 14, 2004

I have an SQL Server .MDF and .LDF file. The files were created a while ago and backed up. Well I need to use the database again, however I can't use SQL Server. So my next solution is MSDE.

How to I create a new database in MSDE using the already created .MDF and .LDF files as the actual database?

View 1 Replies View Related

MSDE And SQL Server

Dec 22, 2004

Hi have just installed MSDE on a laptop. When I installed it I created a default account
username - sa
password - ?

With network protocols enabled and in mixed mode.

I then Created a script of a databse from are SQL server and ran that on the MSDE. So now I have an identical database on the laptop, but without any data. All going well hey.
The problem is I am now trying to copy the data across using the DTS wizard in SQL server. I can select the server from the dropdown, but it will not let me connet, it says not aurthorised or cannot find server. I am using SQL authentication, and using the user account sa. Any ideas what I'm missing. Am very new to SQL server, so any help would be very much appreciated.

View 7 Replies View Related

Sql Server 7 Vs Msde

Jan 15, 2004

I own a copy of SQL Server 7 but am not using it for anything at present. I want to convert an Access db to this Server however I'd like to have a development environment on my laptop. Can I install MSDE and manually transfer the .db files to and from the SQL Server seamlessly?

Thanks
Dog

View 2 Replies View Related

SQL Server MSDE

Jan 29, 2004

I am using SQL Server 2000 MSDE for Test Development of a site in .Net. The MSDE is installed on my workstation and the web site is depolyes on a web server. When I try to access data from the site at the development server, the connection to the SQL Server MSDE fails, saying:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied

But when I access the web site from the same box where the SQL Server MSDE is installed, everything works fine.

Here is the connection string I am using:

<add key="DBConnection" value="Data Source=<MyMSDEBoxName>; Initial Catalog=<DatabaseName>; Integrated Security=SSPI;"/>

I have tried using User Id and Passoword but it failed too!

Any help will be appreciated.

View 2 Replies View Related

MSDE And SQL Server

Feb 4, 2004

Hi,
We have developed a product in VB using MS-Sql Server200 as the DB. Now for distributing the product we have decided to use MSDE. Can any one tell me how to distribute the Product with MSDE. What should we do for that

Thanks in Advance

View 1 Replies View Related

SQL Server Express Code On MSDE/SQL Server 2000

Jun 21, 2005

hi - I am developing locally using .Net 2.0/Access but just recently started trying out SQL Server Express. I have deployed my application to a host who provides 2.0 but as would be expected only MSDE/SQL server 2000. Now if I'd switch completely to SSE, would my SQL queries (which are pretty simple) work on MSDE or SQL server 2000? The only thing I see as more sophisticated sql queries would be the built-in 2.0 Roles/Membership functions... Do you think they would run smoothly on MSDE/SQL 2000?Finally... since the database is already done locally, is there any way (a stored procedure for example) to copy it's scheme if I'd create a new DB on my host's SQL server?

View 2 Replies View Related

Move Or Upgrade MSDE To Sql Server 2000 Server

Oct 26, 2006

We have 3 MSDE databases (3 seperate servers) which we need to make into one Sql 2000 server (new server). How is this done? Can't find anything clear about this.

Thanks

View 3 Replies View Related

Transfer Db From MSDE To SQL Server

Dec 9, 2003

Hi

I think I must operate a similar system to the rest of you here, where I have a Shared SQL Server Database on the web for my website and since I cant afford the full SQL Server to develop on I'm developing on the MSDE that comes with VS.net(I think thats where I got it longtime ago). Anyway my point is since in the database project on VS.net I cant generate Create Table SQL Code against MSDE, Apparently you need the full SQL Server to do that. Whats the best way for me to transfer any changes from my dummy development database to my production database on a real SQL Server.

Any help would be appreciated I'm still rather new to SQL Server(been using cheap MySQL) so could do with some pointers.

Thanks

Andy

View 2 Replies View Related

Can MSDE Work As SQL Server?

May 30, 2004

I plan on replacing a SQL2000 database with MSDE for lowering budget.
Can we script up the SQL database (with SPs, triggers, and UDFs) and recreate it in MSDE?
Thanks.

View 3 Replies View Related

MSDE Link Server

Mar 11, 2005

Is it possible to link MSDE to another server through ODBC? I want to do this like you can in Access, where you get external data by linking tables. Any ideas? Thanks!

View 1 Replies View Related

Exporting From MSDE To SQL Server

Apr 20, 2005

Hi All,
I recently created my entire site before even starting to look at hosting providers. It's a very complex ASP.NET e-Commerce site built on SQL Server. I've (nearly) got it to a point where I want it to go live.
I found a host that caters for all my needs and is a good price. What I need to do now is migrate all my data, as well as all my tables and stored procedures, into the database with my host.
Is there an easy wy to go about this?
- Mina
 

View 2 Replies View Related

MSDE To SQL Server Express

Feb 25, 2006

Hi - I have an MSDE database running on my server - I'd like to port my asp.net 1.1 app to asp.net2, and make use of SQL 2005 Express.How do I transfer my data from an MSDE database to SQL Server Express, keeping intact all of my unique ID fields, indexes, and SPs (I don't have any functions or views)Thanks for any help,Mark

View 4 Replies View Related

@@Version - Same For Both MSDE And SQL Server

Aug 28, 2000

During the install of a product, we need to know if they have MSDE or SQL Server installed and what version/service packs have been applied.
When you query the database with select @@Version, it will bring back exactly the same information....
Is their another way to determine if they are running MSDE or Sql Server?

Thanks!

View 1 Replies View Related

How To Set A Job To Run On A Remote MSDE Server?

Apr 12, 2004

3 of 100 MSDE servers' sql agent stop working with 'sqlAgent servise has marked as deleted'.

1. is there a way to fix this service could not start issue?
2. probably not. before moving all DBs to a new MSDE server, I run scripts on daily via isql to these 3 MSDE to run the daily backup and dbcc jobs. The problem is I could forget to run.

I tried to run following:
backup database remote1.db1 to Backup_db1 with init
so that I could run a job from my server on scheduling time. but it did not work.
Any idea to turn manual process to semi-weapon?
thanks
-D

View 1 Replies View Related







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